我正在使用SQLAlchemy编写一个带有“User”表的简单flaskwsgiweb应用程序。将此表中的用户作为对象检索时,会出现以下错误:OperationalError: (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away')
[SQL: u'SELECT users.uid AS users_uid, users.username AS users_username, users.fullname AS users_fullname, users.password AS users_password, users.score AS users_score, users.totalattempted AS users_totalattempted, users.totalcorrect AS users_totalcorrect, users.settings AS users_settings \\nFROM users \\nWHERE users.uid = %s \\n LIMIT %s'] [parameters: (11, 1)]
对于登录会话管理,我使用登录管理器加载用户方法:
^{pr2}$
然后调用我的get_user_by_uid(uid)方法:def get_user_by_uid(uid):
uid = int(uid)
return session.query(User).filter(User.uid == uid).first()
get_user_by_uid(uid)方法的目的是接受用户的ID,并将其作为易于处理的对象返回。
OperationalError是由查询逻辑中的错误引起的,还是我实际的MySQL服务器有问题?在
谢谢!在