ArtVentureX / sd-webui-agent-scheduler

599 stars 60 forks source link

(sqlite3.OperationalError) database is locked #247

Open GentlemanII opened 1 month ago

GentlemanII commented 1 month ago

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)