opentuner icon indicating copy to clipboard operation
opentuner copied to clipboard
verified publisher icon jansel

Error report when run ./examples/rosenbrock/rosenbrock.py

Open Panhaolin2001 opened this issue 1 year ago • 3 comments

Panhaolin2001 avatar Jun 02 '24 04:06 Panhaolin2001

Traceback (most recent call last): File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 146, in init self._dbapi_connection = engine.raw_connection() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3300, in raw_connection return self.pool.connect() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 449, in connect return _ConnectionFairy._checkout(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 712, in checkout rec = pool._do_get() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 180, in _do_get self._dec_overflow() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get return self._create_connection() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection return _ConnectionRecord(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 674, in init self.__connect() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 901, in __connect pool.logger.debug("Error on connect(): %s", e) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 896, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 643, in connect return dialect.connect(*cargs, **cparams) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 620, in connect return self.loaded_dbapi.connect(*cargs, **cparams) sqlite3.OperationalError: unable to open database file

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

Traceback (most recent call last): File "./examples/rosenbrock/rosenbrock.py", line 85, in Rosenbrock.main(args) File "/home/haolin/project/opentuner/opentuner/measurement/interface.py", line 300, in main return TuningRunMain(cls(args, *pargs, **kwargs), args).main() File "/home/haolin/project/opentuner/opentuner/tuningrunmain.py", line 98, in init self.engine, self.Session = resultsdb.connect(args.database) File "/home/haolin/project/opentuner/opentuner/resultsdb/connect.py", line 45, in connect connection = engine.connect() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3276, in connect return self._connection_cls(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 148, in init Connection._handle_dbapi_exception_noconnection( File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2440, in _handle_dbapi_exception_noconnection raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 146, in init self._dbapi_connection = engine.raw_connection() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3300, in raw_connection return self.pool.connect() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 449, in connect return _ConnectionFairy._checkout(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 712, in checkout rec = pool._do_get() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 180, in _do_get self._dec_overflow() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get return self._create_connection() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection return _ConnectionRecord(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 674, in init self.__connect() File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 901, in __connect pool.logger.debug("Error on connect(): %s", e) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 896, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 643, in connect return dialect.connect(*cargs, **cparams) File "/home/haolin/anaconda3/envs/opentuner/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 620, in connect return self.loaded_dbapi.connect(*cargs, **cparams) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8)

Panhaolin2001 avatar Jun 02 '24 04:06 Panhaolin2001

in opentuner/tuningrunmain.py line 90 it makes a strange database path 'sqlite:///opentuner.db/yourhostname.db', so i replace the path by 'sqlite:///opentuner_yourhostname.db' and error disappears. i guess something in the search codes to be done for better results

huangshangmin0415 avatar Jun 27 '25 13:06 huangshangmin0415

You can specify --database=<filename> or args.database to tell it what filename to use. Looks like it didn't have write access to the default one.

jansel avatar Jun 27 '25 15:06 jansel