Closed TintypeMolly closed 8 years ago
[ERROR] 2015-12-23 13:26:20 - resource.reply : [Failure instance: Traceback: <class 'sqlalchemy.exc.OperationalError'>: (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: u'SELECT article.uid AS article_uid, /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/http.py:1436:dataReceived /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/http.py:1694:_finishRequestBody /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/http.py:1757:allContentReceived /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/http.py:823:requestReceived --- <exception caught here> --- /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/server.py:183:process /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/server.py:234:render /home/yuzuki/workspace/Yuzuki/helper/resource.py:14:render /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/twisted/web/resource.py:250:render /home/yuzuki/workspace/Yuzuki/helper/resource.py:48:_render_wrapper /home/yuzuki/workspace/Yuzuki/resource/reply.py:47:render_POST /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:237:__get__ /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:578:get /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/state.py:474:_load_expired /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py:664:load_scalar_attributes /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py:219:load_on_ident /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py:2528:one /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py:2571:__iter__ /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py:2586:_execute_and_instances /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914:execute /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323:_execute_on_connection /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010:_execute_clauseelement /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146:_execute_context /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341:_handle_dbapi_exception /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199:raise_from_cause /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1139:_execute_context /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py:450:do_execute /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py:205:execute /home/yuzuki/workspace/Yuzuki/env/local/lib/python2.7/site-packages/MySQLdb/connections.py:36:defaulterrorhandler ]
이런 에러 나고 자꾸 죽는데 eu를 알 수가 없다.
내가 예전에 ㅁㅂㅍㅌㄹ에서 일할 때에도 이 connection 오래들고 있으면 이런 에러 떠서
복구 정책을 세웠던 것 같은데
비슷한 복구정책을 세워야되지 않나 싶음.
http://docs.sqlalchemy.org/en/rel_1_0/faq/connections.html#mysql-server-has-gone-away
pool_recycle 시간을 8시간 이하로 주면 해결된다는 듯하다. 8시간동안 아무도 풀씨에 접속을 안한거란 건가!? OTL 망한동아리
pool_recycle
ㅋㅋㅋㅋㅋ...
이런 에러 나고 자꾸 죽는데 eu를 알 수가 없다.
내가 예전에 ㅁㅂㅍㅌㄹ에서 일할 때에도 이 connection 오래들고 있으면 이런 에러 떠서
복구 정책을 세웠던 것 같은데
비슷한 복구정책을 세워야되지 않나 싶음.