Unable to open database file

[ilham-bintang]

Hi, I have tried to run nboost and encounter database issue (error message: unable to open database file)

This is my step:

• setup and run elasticsearch locally (have tried to crud and works)
• clone this repo and python setup.py install, then run nboost --uport 9200 (also have try the full example on README.md -then indexing the sample file nboost-index --file travel.csv --index_name travel --delim , --id_col
• when I try to access the dashboard localhost:8000/nboost it only show the header (without config card widget)
• when I try to curl "http://localhost:8000/travel/_search?pretty&q=passage:vegas&size=2"

it returning:

{"doc":null,"msg":"('unable to open database file',)","type":"OperationalError"}

am I missing any step?

I guess this is because I did not have the nboost.db file (and I did not find it in this repo)

[Fogggy]

@nullphantom I've faced such an error. I've fixed it by creating /usr/local/lib/python3.7/site-packages/nboost/.cache folder.

[ilham-bintang]

@nullphantom I've faced such an error. I've fixed it by creating /usr/local/lib/python3.7/site-packages/nboost/.cache folder.

did you run on local or with docker?

[groupbwt-admin]

@nullphantom I've faced such an error. I've fixed it by creating /usr/local/lib/python3.7/site-packages/nboost/.cache folder.

did you run on local or with docker?

local

[ilham-bintang]

@nullphantom I've faced such an error. I've fixed it by creating /usr/local/lib/python3.7/site-packages/nboost/.cache folder.

did you run on local or with docker?

local

Still can not. My step:

• make dir on /usr/local/lib/python3.7/site-packages/nboost/.cache
• installing via pip install nboost[pt]
• turn on elasticsearch via docker
• run nboost command
• nothing changed, same error

[rajeshkp]

We are running into the above issue as well

[klasocki]

I run into the same error with the same steps, but when I made the .cache directory in my nboost folder I got a different error when trying to reach localhost:8000/nboost/status:

{"doc":null,"msg":"('no such table: searches',)","type":"OperationalError"}

Here is the traceback from the new error (after creating .cache):

Traceback (most recent call last): File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/proxy.py", line 78, in status_path stats = db.get_stats() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/database.py", line 68, in get_stats ''').fetchone() sqlite3.OperationalError: no such table: searches

And here is the old traceback, before creating .cache, since it wasn't attached yet:

Traceback (most recent call last): File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/proxy.py ", line 78, in status_path stats = db.get_stats() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/database .py", line 58, in get_stats cursor = self.get_cursor() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/database .py", line 16, in get_cursor conn = sqlite3.connect(str(self.db_file), isolation_level=None) sqlite3.OperationalError: unable to open database file

[ilham-bintang]

I run into the same error with the same steps, but when I made the .cache directory in my nboost folder I got a different error when trying to reach localhost:8000/nboost/status:

{"doc":null,"msg":"('no such table: searches',)","type":"OperationalError"}

Here is the traceback from the new error (after creating .cache):

Traceback (most recent call last): File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/proxy.py", line 78, in status_path stats = db.get_stats() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/database.py", line 68, in get_stats ''').fetchone() sqlite3.OperationalError: no such table: searches

And here is the old traceback, before creating .cache, since it wasn't attached yet:

Traceback (most recent call last): File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/proxy.py ", line 78, in status_path stats = db.get_stats() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/database .py", line 58, in get_stats cursor = self.get_cursor() File "/net/scratch/people/plgklasocki/transformers-env/lib/python3.6/site-packages/nboost/database .py", line 16, in get_cursor conn = sqlite3.connect(str(self.db_file), isolation_level=None) sqlite3.OperationalError: unable to open database file

I got same issue also when create .cache dir probably we did not have the database schema

[kaykanloo]

If I'm not mistaken, thesqlite3.OperationalError: no such table: searches error is unrelated to the sqlite3.OperationalError: unable to open database file error. Creating the .cache directory should fix the original issue. To avoid the no such table: searches error:

• Please close all your browser tabs
• Make sure your elastic search is accessible and at least one document is indexed (e.g. by running nboost-index --file travel.csv --index_name travel --delim , --id_col)
• Make sure .cache directory exist. then run nboost
• Try to at least run one search query to populate the dashboard database (e.g. open this link: http://localhost:8000/travel/_search?pretty&q=passage:vegas&size=2)
• Now if you open the dashboard link, you shouldn't get any errors