ERROR:generalFolder:(MySQLdb._exceptions.OperationalError) (2006, ‘MySQL server has gone away‘)

ERROR:generalFolder:(MySQLdb._exceptions.OperationalError) (2006, ‘MySQL server has gone away’)
[SQL: SELECT info_user.create_time AS info_user_create_time, info_user.update_time AS info_user_update_time, info_user.id AS info_user_id, info_user.nick_name AS info_user_nick_name, info_user.password_hash AS info_user_password_hash, info_user.mobile AS info_user_mobile, info_user.avatar_url AS info_user_avatar_url, info_user.is_admin AS info_user_is_admin, info_user.userStatus AS info_user_userStatus, info_user.last_login AS info_user_last_login, info_user.quit_time AS info_user_quit_time
FROM info_user
WHERE info_user.mobile = %s
LIMIT %s]
[parameters: (‘18610937563’, 1)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
INFO:werkzeug:127.0.0.1 - - [06/May/2021 10:27:14] “POST /login HTTP/1.0” 500 -
ERROR:werkzeug:Error on request:
Traceback (most recent call last):
File “/usr/local/lib/python3.8/site-packages/werkzeug/serving.py”, line 306, in run_wsgi
execute(self.server.app)
File “/usr/local/lib/python3.8/site-packages/werkzeug/serving.py”, line 294, in execute
application_iter = app(environ, start_response)
File “/usr/local/lib/python3.8/site-packages/sentry_sdk/integrations/flask.py”, line 86, in sentry_patched_wsgi_app
return SentryWsgiMiddleware(lambda *a, **kw: old_app(self, a, **kw))(
File “/usr/local/lib/python3.8/site-packages/sentry_sdk/integrations/wsgi.py”, line 140, in call
reraise(
_capture_exception(hub))
File “/usr/local/lib/python3.8/site-packages/sentry_sdk/_compat.py”, line 54, in reraise
raise value
File “/usr/local/lib/python3.8/site-packages/sentry_sdk/integrations/wsgi.py”, line 133, in call
rv = self.app(
File “/usr/local/lib/python3.8/site-packages/sentry_sdk/integrations/flask.py”, line 86, in
return SentryWsgiMiddleware(lambda *a, **kw: old_app(self, *a, **kw))(
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 2464, in call
return self.wsgi_app(environ, start_response)
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 2458, in wsgi_app
ctx.auto_pop(error)
File “/usr/local/lib/python3.8/site-packages/flask/ctx.py”, line 452, in auto_pop
self.pop(exc)
File “/usr/local/lib/python3.8/site-packages/flask/ctx.py”, line 438, in pop
app_ctx.pop(exc)
File “/usr/local/lib/python3.8/site-packages/flask/ctx.py”, line 238, in pop
self.app.do_teardown_appcontext(exc)
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 2321, in do_teardown_appcontext
func(exc)
File “/usr/local/lib/python3.8/site-packages/flask_sqlalchemy/init.py”, line 858, in shutdown_session
self.session.commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py”, line 163, in do
return getattr(self.registry(), name)(*args, **kwargs)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 1042, in commit
self.transaction.commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 508, in commit
t[1].commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1762, in commit
self._do_commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1793, in _do_commit
self.connection._commit_impl()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 773, in _commit_impl
self.handle_dbapi_exception(e, None, None, None, None)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1514, in handle_dbapi_exception
util.raise
(exc_info[1], with_traceback=exc_info[2])
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise

raise exception
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 771, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 392, in connection
self.handle_dbapi_exception(e, None, None, None, None)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1514, in handle_dbapi_exception
util.raise
(exc_info[1], with_traceback=exc_info[2])
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise

raise exception
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 390, in connection
return self._revalidate_connection()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 469, in _revalidate_connection
raise exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Can’t reconnect until invalid transaction is rolled back
INFO:werkzeug:127.0.0.1 - - [06/May/2021 10:27:29] “POST /login HTTP/1.0” 200 -
INFO:werkzeug:127.0.0.1 - - [06/May/2021 10:27:30] “POST /getProList HTTP/1.0” 200 -

以上是报错信息,提示需要回滚。

解决方式:

在这里插入图片描述

db.session.rollback()
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值