VeighNa量化社区
你的开源社区量化交易平台 | vn.py | vnpy
Member
avatar
加入于:
帖子: 3
声望: 0

concurrent.futures.process._RemoteTraceback:
"""
Traceback (most recent call last):
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 3252, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: database is locked

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/Users/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/process.py", line 246, in _process_worker
r = call_item.fn(call_item.args, **call_item.kwargs)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/process.py", line 205, in _process_chunk
return [fn(
args) for args in chunk]
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/process.py", line 205, in <listcomp>
return [fn(args) for args in chunk]
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/vnpy_ctastrategy/backtesting.py", line 1128, in evaluate
engine.load_data()
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/vnpy_ctastrategy/backtesting.py", line 187, in load_data
data: List[BarData] = load_bar_data(
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/vnpy_ctastrategy/backtesting.py", line 1074, in load_bar_data
return database.load_bar_data(
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/vnpy_sqlite/sqlite_database.py", line 285, in load_bar_data
for db_bar in s:
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 7150, in iter
self.execute()
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 1972, in inner
return method(self, database,
args, *kwargs)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 2043, in execute
return self._execute(database)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 2216, in _execute
cursor = database.execute(self)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 3260, in execute
return self.execute_sql(sql, params)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 3252, in execute_sql
cursor.execute(sql, params or ())
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 3020, in exit
reraise(new_type, new_type(exc_value,
exc_args), traceback)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 192, in reraise
raise value.with_traceback(tb)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/peewee.py", line 3252, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: database is locked
"""

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

Traceback (most recent call last):
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/threading.py", line 980, in _bootstrap_inner
self.run()
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/threading.py", line 917, in run
self._target(*self._args, **self._kwargs)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/vnpy_ctabacktester/engine.py", line 323, in run_optimization
self.result_values = engine.run_bf_optimization(
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/vnpy_ctastrategy/backtesting.py", line 529, in run_bf_optimization
results: list = run_bf_optimization(
File "/Users/xxx/Documents/code/python/vnpy/vnpy/trader/optimize.py", line 121, in run_bf_optimization
results: List[Tuple] = list(it)
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/site-packages/tqdm/std.py", line 1181, in iter
for obj in iterable:
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/process.py", line 562, in _chain_from_iterable_of_lists
for element in iterable:
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/_base.py", line 609, in result_iterator
yield fs.pop().result()
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/_base.py", line 446, in result
return self.get_result()
File "/Users/xxx/anaconda3/envs/vnpy/lib/python3.9/concurrent/futures/_base.py", line 391, in
get_result
raise self._exception
peewee.OperationalError: database is locked

Member
avatar
加入于:
帖子: 5372
声望: 326

是不是优化的时候还在别的进程操作数据库

© 2015-2022 上海韦纳软件科技有限公司
备案服务号:沪ICP备18006526号

沪公网安备 31011502017034号

【用户协议】
【隐私政策】
【免责条款】