llmware icon indicating copy to clipboard operation
llmware copied to clipboard

sqlite3.OperationalError: unable to open database file

Open arcontechnologies opened this issue 7 months ago • 9 comments

Hi, Actually even if you setup the location of llmware_data (in my case it looks like this : LLMWareConfig.set_home("D:\\myapp\\")), it keeps looking for it in C:\users\<myuser>\llmware_data.

As consequence, I should keep 2 llmware_data folders which from point of view is lead to inconsistencies.

the issue :

Traceback (most recent call last):
  File "d:\IntellicatSearch\semantic_reranker.py", line 199, in <module>
    library = Library().load_library(library_name)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\IntellicatSearch\intellicatsearch_env\Lib\site-packages\llmware\library.py", line 266, in load_library
    library_exists = self.check_if_library_exists(library_name, account_name=account_name)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\IntellicatSearch\intellicatsearch_env\Lib\site-packages\llmware\library.py", line 349, in check_if_library_exists
    library_card = LibraryCatalog().get_library_card(library_name, account_name=account_name)
                   ^^^^^^^^^^^^^^^^
  File "d:\IntellicatSearch\intellicatsearch_env\Lib\site-packages\llmware\library.py", line 1291, in __init__
    if CollectionWriter("library",account_name=self.account_name).check_if_table_build_required():
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\IntellicatSearch\intellicatsearch_env\Lib\site-packages\llmware\resources.py", line 228, in __init__
    self._writer = SQLiteWriter(self.library_name, account_name=self.account_name, custom_table=custom_table,
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\IntellicatSearch\intellicatsearch_env\Lib\site-packages\llmware\resources.py", line 2564, in __init__
    self.conn = _SQLiteConnect().connect(library_name)
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\IntellicatSearch\intellicatsearch_env\Lib\site-packages\llmware\resources.py", line 3083, in connect
    self.conn = sqlite3.connect(db_file)
                ^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: unable to open database file

arcontechnologies avatar Jul 06 '24 12:07 arcontechnologies