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.

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

sqlite error: database is locked #191

Open
ulrmehdi opened this issue Nov 12, 2024 · 0 comments
Open

sqlite error: database is locked #191

ulrmehdi opened this issue Nov 12, 2024 · 0 comments

Comments

@ulrmehdi
Copy link

Hi,
I've been trying to run the example on the stock market.
I did not change anything important in the example structure, except reconfigured it to work with Azure key/endpoints.
I cannot be a problem, as I did it for my several projects with crewAI and all of them work very well with Azure.
Although I did not use tools using db, until now.
Ai am consistently getting the error:
sqlite3.OperationalError: database is locked

in run
return StockAnalysisCrew().crew().kickoff(inputs=inputs)
....
File "/python3.11/site-packages/crewai/project/annotations.py", line 85, in wrapper
task_instance = task_method(self)
^^^^^^^^^^^^^^^^^
File "python3.11/site-packages/crewai/project/utils.py", line 7, in memoized_func
cache[key] = func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "
/python3.11/site-packages/crewai/project/annotations.py", line 13, in wrapper
result = func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
/crewAI-examples/stock_analysis/src/stock_analysis/crew.py", line 99, in financial_analysis
agent=self.financial_analyst_agent(),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "
/python3.11/site-packages/crewai/project/utils.py", line 7, in memoized_func
cache[key] = func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "/crewAI-examples/stock_analysis/src/stock_analysis/crew.py", line 88, in financial_analyst_agent
WebsiteSearchTool(),
^^^^^^^^^^^^^^^^^^^
in the log before this error message, I see the lines with .../python3,11/site-packages like:
/python3.11/site-packages/chromadb/config.py", line 403, in start
/python3.11/site-packages/chromadb/telemetry/opentelemetry/init.py", line 127, in wrapper
return f(*args, **kwargs)
File "
/python3.11/site-packages/chromadb/db/impl/sqlite.py", line 100, in start
self.initialize_migrations()
File "
/python3.11/site-packages/chromadb/db/migrations.py", line 140, in initialize_migrations
self.apply_migrations()
File "
/python3.11/site-packages/chromadb/telemetry/opentelemetry/init.py", line 127, in wrapper
return f(*args, **kwargs)
^^^^^^^^^^^^^^^^^^
File "
/python3.11/site-packages/chromadb/db/migrations.py", line 165, in apply_migrations
self.setup_migrations()
File "/python3.11/site-packages/chromadb/telemetry/opentelemetry/init.py", line 127, in wrapper
return f(*args, **kwargs)
^^^^^^^^^^^^^^^^^^
File "
/python3.11/site-packages/chromadb/db/impl/sqlite.py", line 157, in setup_migrations
with self.tx() as cur:
File "~/python3.11/site-packages/chromadb/db/impl/sqlite.py", line 51, in exit
self._conn.commit()
File "/anaconda/envs/mycrewAI/lib/python3.11/site-packages/chromadb/db/impl/sqlite_pool.py", line 31, in commit
self._conn.commit()

what is the origin of this issue and how to fix this issue?

Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant