database is locked error #1
Description
I ran search_optuna_adaptive to generate search results.
But I found this error...
I've tried changing options like the timeout setting, and I've tried changing other options as well, but I keep getting the same error.
What version of optima did you use and have you ever encountered this error?
root@7a3a26c0a471:/NAS/SJ/actquant/KVTuner# python search_optuna_adaptive.py
Traceback (most recent call last):
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context
self.dialect.do_execute(
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/NAS/SJ/actquant/KVTuner/search_optuna_adaptive.py", line 278, in
study = optuna.create_study(directions=["maximize", "minimize"], study_name=study_name, storage=storage_name, sampler=sampler)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/optuna/_convert_positional_args.py", line 83, in converter_wrapper
return func(**kwargs)
^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/optuna/study/study.py", line 1249, in create_study
storage = storages.get_storage(storage)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/optuna/storages/init.py", line 43, in get_storage
return _CachedStorage(RDBStorage(storage))
^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/optuna/storages/_rdb/storage.py", line 229, in init
models.BaseModel.metadata.create_all(self.engine)
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 5924, in create_all
bind._run_ddl_visitor(
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3248, in _run_ddl_visitor
conn._run_ddl_visitor(visitorcallable, element, **kwargs)
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2455, in _run_ddl_visitor
).traverse_single(element)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 664, in traverse_single
return meth(obj, **kw)
^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 982, in visit_metadata
self.traverse_single(
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 664, in traverse_single
return meth(obj, **kw)
^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 1020, in visit_table
)._invoke_with(self.connection)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 321, in _invoke_with
return bind.execute(self)
^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1415, in execute
return meth(
^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 187, in _execute_on_connection
return connection._execute_ddl(
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1526, in _execute_ddl
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1982, in _exec_single_context
self._handle_dbapi_exception(
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context
self.dialect.do_execute(
File "/opt/conda/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL:
CREATE TABLE studies (
study_id INTEGER NOT NULL,
study_name VARCHAR(512) NOT NULL,
PRIMARY KEY (study_id)
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)