可以找到解决此错误mysqldb._exceptions.programmingerror ：（ 2014，'commet'now now now sync; t''命令;

发布于 2025-02-09 09:54:46 字数 741 浏览 1 评论 0原文

事先表示歉意，我将无法提供代码示例。

我所能显示的只是我不理解的追溯错误：

Traceback (most recent call last):
  File "/home/mydbapp/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 983, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/home/mydbapp/venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 682, in do_rollback
    dbapi_connection.rollback()
MySQLdb._exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now")

我已经阅读了很多有关此错误的问题，但不幸的是，我无法复制任何解决方案。

您认为问题可能来自哪里？

是否可能与SQLalchemy或MySQLDB版本有关？（mySqlClient == 2.1.0，pymysql == 1.0.2，sqlalchemy == 1.4.35）

我也想知道是否有一种方法可以更准确地调试代码中的错误，而哪个命令完全在哪里发生”不同步？

谢谢

原文

I apologize in advance that I will not be able to provide a code example.

All what I can show is the traceback error that I don't understand:

Traceback (most recent call last):
  File "/home/mydbapp/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 983, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/home/mydbapp/venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 682, in do_rollback
    dbapi_connection.rollback()
MySQLdb._exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now")

I've read a lot of SO questions about this error but without being able to reproduce any solution unfortunately.

Where do you think that the problem could come from ?

Is it possible that it's related to a problem of SQLAlchemy or MySQLdb version ? (mysqlclient==2.1.0, PyMySQL==1.0.2, SQLAlchemy==1.4.35)

Also I would like to know if there is a way to debug more precisely where the error happen in the code and which command exactly is "out of sync" ?

Thanks

分享到QQ

分享到微博