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()