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

(sqlite3.OperationalError) database is locked #247

Open
GentlemanII opened this issue May 18, 2024 · 0 comments
Open

(sqlite3.OperationalError) database is locked #247

GentlemanII opened this issue May 18, 2024 · 0 comments

Comments

@GentlemanII
Copy link

Exception adding task to database: (sqlite3.OperationalError) database is locked
(Background on this error at: https://sqlalche.me/e/20/e3q8)
*** API error: POST: http://127.0.0.1:7860/agent-scheduler/v1/queue/img2img {'error': 'OperationalError', 'detail': [], 'body': '', 'errors': '(sqlite3.OperationalError) database is locked\n(Background on this error at: https://sqlalche.me/e/20/e3q8)'}
Traceback (most recent call last):
File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 1148, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\default.py", line 696, in do_commit
dbapi_connection.commit()
sqlite3.OperationalError: database is locked

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

Traceback (most recent call last):
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\modules\api\api.py", line 187, in exception_handling
    return await call_next(request)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\base.py", line 84, in call_next
    raise app_exc
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\base.py", line 70, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "<enhanced_experience vendors.sentry_sdk.integrations.starlette>", line 157, in _create_span_call
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\base.py", line 108, in __call__
    response = await self.dispatch_func(request, call_next)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\modules\api\api.py", line 151, in log_and_time
    res: Response = await call_next(req)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\base.py", line 84, in call_next
    raise app_exc
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\base.py", line 70, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "<enhanced_experience vendors.sentry_sdk.integrations.starlette>", line 157, in _create_span_call
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\cors.py", line 84, in __call__
    await self.app(scope, receive, send)
  File "<enhanced_experience vendors.sentry_sdk.integrations.starlette>", line 157, in _create_span_call
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\gzip.py", line 26, in __call__
    await self.app(scope, receive, send)
  File "<enhanced_experience vendors.sentry_sdk.integrations.starlette>", line 256, in _sentry_exceptionmiddleware_call
  File "<enhanced_experience vendors.sentry_sdk.integrations.starlette>", line 157, in _create_span_call
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\exceptions.py", line 79, in __call__
    raise exc
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\middleware\exceptions.py", line 68, in __call__
    await self.app(scope, receive, sender)
  File "<enhanced_experience vendors.sentry_sdk.integrations.starlette>", line 157, in _create_span_call
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 21, in __call__
    raise e
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 18, in __call__
    await self.app(scope, receive, send)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\routing.py", line 718, in __call__
    await route.handle(scope, receive, send)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\routing.py", line 276, in handle
    await self.app(scope, receive, send)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\routing.py", line 66, in app
    response = await func(request)
  File "<enhanced_experience vendors.sentry_sdk.integrations.fastapi>", line 136, in _sentry_app
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\fastapi\routing.py", line 237, in app
    raw_response = await run_endpoint_function(
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\fastapi\routing.py", line 165, in run_endpoint_function
    return await run_in_threadpool(dependant.call, **values)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\starlette\concurrency.py", line 41, in run_in_threadpool
    return await anyio.to_thread.run_sync(func, *args)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\anyio\to_thread.py", line 31, in run_sync
    return await get_asynclib().run_sync_in_worker_thread(
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\anyio\_backends\_asyncio.py", line 937, in run_sync_in_worker_thread
    return await future
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\anyio\_backends\_asyncio.py", line 867, in run
    result = context.run(func, *args)
  File "<enhanced_experience vendors.sentry_sdk.integrations.fastapi>", line 90, in _sentry_call
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\extensions\sd-webui-agent-scheduler\agent_scheduler\api.py", line 139, in queue_img2img
    task = task_runner.register_api_task(
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\extensions\sd-webui-agent-scheduler\agent_scheduler\task_runner.py", line 314, in register_api_task
    task_manager.add_task(task)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\extensions\sd-webui-agent-scheduler\agent_scheduler\db\task.py", line 244, in add_task
    raise e
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\extensions\sd-webui-agent-scheduler\agent_scheduler\db\task.py", line 240, in add_task
    session.commit()
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\orm\session.py", line 1972, in commit
    trans.commit(_to_root=True)
  File "<string>", line 2, in commit
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\orm\state_changes.py", line 139, in _go
    ret_value = fn(self, *arg, **kw)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\orm\session.py", line 1264, in commit
    trans.commit()
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 2633, in commit
    self._do_commit()
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 2738, in _do_commit
    self._connection_commit_impl()
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 2709, in _connection_commit_impl
    self.connection._commit_impl()
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 1150, in _commit_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 2357, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\base.py", line 1148, in _commit_impl
    self.engine.dialect.do_commit(self.connection)
  File "D:\Program Files (x86)\sd-webui-aki-v4.5\python\lib\site-packages\sqlalchemy\engine\default.py", line 696, in do_commit
    dbapi_connection.commit()
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
(Background on this error at: https://sqlalche.me/e/20/e3q8)
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