zvtvz / zvt

modular quant framework.
https://zvt.readthedocs.io/en/latest/
MIT License
3.09k stars 845 forks source link

ERROR MainThread (sqlite3.OperationalError) too many SQL variables #116

Closed ranglang closed 3 years ago

ranglang commented 3 years ago

Platform: centos 7

sqlite version: 3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f149766

 File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2995, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
    context)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
@                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @                                                                                                                                                                                                                 @
2020-10-25 12:14:11,710  ERROR  MainThread  (sqlite3.OperationalError) too many SQL variables [SQL: 'SELECT dividend_financing.id AS dividend_financing_id, dividend_financing.entity_id AS dividend_financing_entity_id, dividend_financing.timestamp AS dividend_financing_timestamp, dividend_financing.provider AS dividend_financing_provider, dividend_financing.code AS dividend_financing_code, dividend_financing.dividend_money AS dividend_financing_dividend_money, dividend_financing.ipo_issues AS dividend_financing_ipo_issues, dividend_financing.ipo_raising_fund AS dividend_financing_ipo_raising_fund, dividend_financing.spo_issues AS dividend_financing_spo_issues, dividend_financing.spo_raising_fund AS dividend_financing_spo_raising_fund, dividend_financing.rights_issues AS dividend_financing_rights_issues, dividend_financing.rights_raising_fund AS dividend_financing_rights_raising_fund \nFROM dividend_financing \nWHERE dividend_financing.code IN (?,
ranglang commented 3 years ago

upgrade sqlite version