tornado+peewee过段时间报数据库链接不上

Docker安装的 mariadb:10.4.8 ，过段时间接口抛出异常500数据库链接异常。

具体报错：2022-06-20 09:10:20 ERROR web.py log_request:2243 : 500 POST /api/user/login (172.17.0.1) 8.81ms2022-06-20 09:10:21 DEBUG peewee.py execute_sql:3117 : ('SELECT 1 FROM `sys_yh` AS `t1` WHERE (`t1`.`yhm` = %s) LIMIT %s', ['smd', 1])2022-06-20 09:10:21 ERROR web.py log_exception:1793 : Uncaught exception POST /api/user/login (172.17.0.1)&nbsp; &nbsp; HTTPServerRequest(protocol='http', host='luckysheet.jschrj.com', method='POST', uri='/api/user/login', version='HTTP/1.1', remote_ip='172.17.0.1')&nbsp; &nbsp; Traceback (most recent call last):&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 3129, in execute_sql&nbsp; &nbsp; &nbsp; &nbsp; cursor.execute(sql, params or ())&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/cursors.py", line 170, in execute&nbsp; &nbsp; &nbsp; &nbsp; result = self._query(query)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/cursors.py", line 328, in _query&nbsp; &nbsp; &nbsp; &nbsp; conn.query(q)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/connections.py", line 515, in query&nbsp; &nbsp; &nbsp; &nbsp; self._execute_command(COMMAND.COM_QUERY, sql)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/connections.py", line 745, in _execute_command&nbsp; &nbsp; &nbsp; &nbsp; raise err.InterfaceError("(0, '')")&nbsp; &nbsp; pymysql.err.InterfaceError: (0, '')&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; During handling of the above exception, another exception occurred:&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; Traceback (most recent call last):&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/tornado/web.py", line 1704, in _execute&nbsp; &nbsp; &nbsp; &nbsp; result = await result&nbsp; &nbsp; &nbsp; File "/usr/src/app/admin/handler.py", line 84, in post&nbsp; &nbsp; &nbsp; &nbsp; if query.exists():&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 1898, in inner&nbsp; &nbsp; &nbsp; &nbsp; return method(self, database, *args, **kwargs)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 2182, in exists&nbsp; &nbsp; &nbsp; &nbsp; return bool(clone.scalar())&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 1898, in inner&nbsp; &nbsp; &nbsp; &nbsp; return method(self, database, *args, **kwargs)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 2160, in scalar&nbsp; &nbsp; &nbsp; &nbsp; row = self.tuples().peek(database)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 1898, in inner&nbsp; &nbsp; &nbsp; &nbsp; return method(self, database, *args, **kwargs)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 2147, in peek&nbsp; &nbsp; &nbsp; &nbsp; rows = self.execute(database)[:n]&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 1898, in inner&nbsp; &nbsp; &nbsp; &nbsp; return method(self, database, *args, **kwargs)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 1969, in execute&nbsp; &nbsp; &nbsp; &nbsp; return self._execute(database)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 2141, in _execute&nbsp; &nbsp; &nbsp; &nbsp; cursor = database.execute(self)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 3142, in execute&nbsp; &nbsp; &nbsp; &nbsp; return self.execute_sql(sql, params, commit=commit)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee_async.py", line 988, in execute_sql&nbsp; &nbsp; &nbsp; &nbsp; return super().execute_sql(*args, **kwargs)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 3136, in execute_sql&nbsp; &nbsp; &nbsp; &nbsp; self.commit()&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 2902, in __exit__&nbsp; &nbsp; &nbsp; &nbsp; reraise(new_type, new_type(exc_value, *exc_args), traceback)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 185, in reraise&nbsp; &nbsp; &nbsp; &nbsp; raise value.with_traceback(tb)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/peewee.py", line 3129, in execute_sql&nbsp; &nbsp; &nbsp; &nbsp; cursor.execute(sql, params or ())&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/cursors.py", line 170, in execute&nbsp; &nbsp; &nbsp; &nbsp; result = self._query(query)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/cursors.py", line 328, in _query&nbsp; &nbsp; &nbsp; &nbsp; conn.query(q)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/connections.py", line 515, in query&nbsp; &nbsp; &nbsp; &nbsp; self._execute_command(COMMAND.COM_QUERY, sql)&nbsp; &nbsp; &nbsp; File "/opt/pypy/lib/pypy3.8/site-packages/pymysql/connections.py", line 745, in _execute_command&nbsp; &nbsp; &nbsp; &nbsp; raise err.InterfaceError("(0, '')")&nbsp; &nbsp; peewee.InterfaceError: (0, '')解决方案重写&nbsp;RequestHandler 的&nbsp;prepare 和 on_finish 方法 打开、关闭数据库：<pre style="background-color: rgb(255, 255, 255); font-family: 宋体; font-size: 9pt;">def prepare(self): db.connect() return super(BaseHandler, self).prepare() def on_finish(self): if not db.is_closed(): db.close() return super(BaseHandler, self).on_finish()</pre>