Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unable to open database file - Error in db.py in __init__ sqlite3.OperationalError #1733

Open
jevarlet opened this issue Oct 13, 2022 · 4 comments
Open

Unable to open database file - Error in db.py in __init__ sqlite3.OperationalError #1733

jevarlet opened this issue Oct 13, 2022 · 4 comments

Comments

@jevarlet
Copy link

Error opening db.py when running scans

Python 3.10, SpiderFoot 4.0.0. Spiderfoot master branch, but issue also appears in stable branch installs. All dependencies are up to date.

Exception (OSError) in module sfp_alienvault.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,384 [ERROR] sflib : Exception (OSError) in module sfp_alienvaultiprep.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,385 [ERROR] sflib : Exception (OSError) in module sfp_base64.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,385 [ERROR] sflib : Exception (OSError) in module sfp_arin.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,386 [ERROR] sflib : Exception (OSError) in module sfp_archiveorg.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,386 [ERROR] sflib : Exception (OSError) in module sfp_azureblobstorage.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,387 [ERROR] sflib : Exception (OSError) in module sfp_badpackets.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,388 [ERROR] sflib : Exception (OSError) in module sfp_bgpview.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,389 [ERROR] sflib : Exception (OSError) in module sfp_binaryedge.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,389 [ERROR] sflib : Exception (OSError) in module sfp_bingsharedip.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,391 [ERROR] sflib : Exception (OSError) in module sfp_bingsearch.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,393 [ERROR] sflib : Exception (OSError) in module sfp_binstring.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,394 [ERROR] sflib : Exception (OSError) in module sfp_bitcoin.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,394 [ERROR] sflib : Exception (OSError) in module sfp_blocklistde.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,395 [ERROR] sflib : Exception (OSError) in module sfp_bitcoinabuse.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,395 [ERROR] sflib : Exception (OSError) in module sfp_bitcoinwhoswho.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,396 [ERROR] sflib : Exception (OSError) in module sfp_botscout.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,397 [ERROR] sflib : Exception (OSError) in module sfp_blockchain.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,397 [ERROR] sflib : Exception (OSError) in module sfp_botvrij.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,397 [ERROR] sflib : Exception (OSError) in module sfp_builtwith.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,398 [ERROR] sflib : Exception (OSError) in module sfp_c99.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,399 [ERROR] sflib : Exception (OSError) in module sfp_callername.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,399 [ERROR] sflib : Exception (OSError) in module sfp_censys.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,400 [ERROR] sflib : Exception (OSError) in module sfp_cinsscore.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,400 [ERROR] sflib : Exception (OSError) in module sfp_certspotter.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,401 [ERROR] sflib : Exception (OSError) in module sfp_cleantalk.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,401 [ERROR] sflib : Exception (OSError) in module sfp_circllu.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,402 [ERROR] sflib : Exception (OSError) in module sfp_cleanbrowsing.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,403 [ERROR] sflib : Exception (OSError) in module sfp_citadel.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,403 [ERROR] sflib : Exception (OSError) in module sfp_clearbit.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,404 [ERROR] sflib : Exception (OSError) in module sfp_cloudflaredns.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,404 [ERROR] sflib : Exception (OSError) in module sfp_coinblocker.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,405 [ERROR] sflib : Exception (OSError) in module sfp_commoncrawl.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,405 [ERROR] sflib : Exception (OSError) in module sfp_comodo.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,407 [ERROR] sflib : Exception (OSError) in module sfp_cookie.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,408 [ERROR] sflib : Exception (OSError) in module sfp_company.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,408 [ERROR] sflib : Exception (OSError) in module sfp_creditcard.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/plugin.py", line 505, in threadWorker
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 360, in init
OSError: Tried to set up the SpiderFoot database schema, but failed

2022-10-13 15:15:44,409 [ERROR] sflib : Exception (OSError) in module sfp_countryname.Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 353, in init
sqlite3.OperationalError: unable to open database file

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 408, in create
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 358, in init
File "/Users/jevarlet/spiderfoot/spiderfoot/db.py", line 422, in create
OSError: SQL error encountered when setting up database
@secretrobotron
Copy link

Seeing something really similar running fresh 4.0.0 install on osx 12.6. I can see that the ~/.spiderfoot/spiderfoot.db file exists and has lots of data in it (including, for some reason, python tracebacks from this very error...).

@secretrobotron
Copy link

It looks like this problem can be mitigated by selecting a subset of modules. I'm guessing the RLock for the DB doesn't work as expected when loading a billion of them all at once.

@bcoles
Copy link
Contributor

bcoles commented Apr 20, 2023 •
edited
Loading

A user reported on Discord that they encountered this issue on Mac OSX 13.3 with Python 3.11.2 and the latest version of SpiderFoot from master branch.

As suggested, it is likely an issue with threading/locking in relation to SQLite.

I have not been able to reproduce this issue on Linux.

@UriZafrir
Copy link

getting the same error on macos Ventura 13.4.1

@bcoles bcoles mentioned this issue Dec 11, 2023
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@secretrobotron @bcoles @UriZafrir @jevarlet