qiyeboy / IPProxyPool

IPProxyPool代理池项目,提供代理ip
4.17k stars 1.3k forks source link

<class 'sqlalchemy.exc.StatementError'> at / (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: 'SELECT proxys.ip AS proxys_ip, proxys.port AS proxys_port, proxys.score AS proxys_score \nFROM proxys ORDER BY proxys.score DESC, proxys.speed'] [parameters: [{}]] #125

Open dzhyw opened 7 years ago

dzhyw commented 7 years ago

后端db用的是mysql,运行一段时间,经常会出现这个报错。求解

<class 'sqlalchemy.exc.StatementError'> at / (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: 'SELECT proxys.ip AS proxys_ip, proxys.port AS proxys_port, proxys.score AS proxys_score \nFROM proxys ORDER BY proxys.score DESC, proxys.speed'] [parameters: [{}]]

/site-packages/sqlalchemy/engine/base.py in _revalidate_connection, line 423

dzhyw commented 7 years ago

是不是 几个进程共用session,导致mysql包错乱了啊