Tornado + sqlalchemy在SAE上出现2006, 'MySQL server has gone away' 错误

Question

设计了一个定时任务，执行时间大概在30秒，在邮件收取的环节耗时较长，从日志里看大概每半小时就会出现一次MySQL server has gone away的报错。 已经按照谷歌到的建议，把sqlalchemy的pool_recycle参数重设了。 engine = create_engine(db_config, pool_recycle=5, pool_size=20) 附上我的代码： class ApplyReplyHandler(BaseHandler): def get(self): try: reply = self.session.query(func.max(Reply.mail_id).label('max_mail_id')).one() offset = reply.max_mail_id if reply.max_mail_id else 0 for mail_id, mail_addr, mail_subject, mail_body in receive_mail(offset): m = search(r'\[##(.+)##\]', mail_subject) if not m: continue apply_secret = m.group(1) related_apply = self.session.query(Apply).filter(Apply.secret_key == apply_secret).filter( Apply.mail_addr == mail_addr).first() if not related_apply: continue reply = Reply(apply_id=related_apply.id, mail_id=mail_id, mail_subject=mail_subject, mail_body=mail_body) self.session.add(reply) related_apply.status = 4 self.session.commit() self.write('success') except Exception, e: logging.exception(e) self.write('failed') BaseHandler是这样初始化和关闭MySQL连接的： class BaseHandler(tornado.web.RequestHandler): def initialize(self): self.session = DB_Session() def on_finish(self): self.session.close()

Answer 1

是两次访问mysql的间隔时间会比较长吗，如果是这样的话，我的建议是每次使用db连接时候先session.close()一下，这样连接总是重新建立的

Answer 2

貌似pool_recycle设置也不起作用，楼主后来怎么解决的