DB Connection drops after being idle for a while #121
Description
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: 172.25.130.66:0 - "GET /api/v1/workflows?page=1&per_page=20&sort_by=workflow_id&sort_order=asc HTTP/1.1" 500
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: [2026-01-16 15:00:02 +0000] [201841] [ERROR] Exception in ASGI application
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: Traceback (most recent call last):
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 813, in _write_bytes
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self._sock.sendall(data)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: BrokenPipeError: [Errno 32] Broken pipe
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: During handling of the above exception, another exception occurred:
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: Traceback (most recent call last):
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self.dialect.do_execute(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: cursor, str_statement, effective_parameters, context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: cursor.execute(statement, parameters)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/cursors.py", line 153, in execute
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: result = self._query(query)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/cursors.py", line 322, in _query
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: conn.query(q)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 574, in query
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self._execute_command(COMMAND.COM_QUERY, sql)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 865, in _execute_command
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self._write_bytes(packet)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 816, in _write_bytes
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raise err.OperationalError(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: CR.CR_SERVER_GONE_ERROR, f"MySQL server has gone away ({e!r})"
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: The above exception was the direct cause of the following exception:
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: Traceback (most recent call last):
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/uvicorn/protocols/http/httptools_impl.py", line 409, in run_asgi
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: result = await app( # type: ignore[func-returns-value]
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self.scope, self.receive, self.send
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return await self.app(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/fastapi/applications.py", line 1139, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await super().call(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/applications.py", line 107, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await self.middleware_stack(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/middleware/errors.py", line 186, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raise exc
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/middleware/errors.py", line 164, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await self.app(scope, receive, _send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/middleware/cors.py", line 85, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await self.app(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/middleware/exceptions.py", line 63, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raise exc
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await app(scope, receive, sender)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await self.app(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/routing.py", line 716, in call
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await self.middleware_stack(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/routing.py", line 736, in app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await route.handle(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/routing.py", line 290, in handle
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await self.app(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/fastapi/routing.py", line 120, in app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await wrap_app_handling_exceptions(app, request)(scope, receive, send)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raise exc
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: await app(scope, receive, sender)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/fastapi/routing.py", line 106, in app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: response = await f(request)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/fastapi/routing.py", line 430, in app
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raw_response = await run_endpoint_function(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ...<3 lines>...
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/fastapi/routing.py", line 318, in run_endpoint_function
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return await run_in_threadpool(dependant.call, **values)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/starlette/concurrency.py", line 32, in run_in_threadpool
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return await anyio.to_thread.run_sync(func)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/anyio/to_thread.py", line 61, in run_sync
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return await get_async_backend().run_sync_in_worker_thread(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: func, args, abandon_on_cancel=abandon_on_cancel, limiter=limiter
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/anyio/_backends/_asyncio.py", line 2525, in run_sync_in_worker_thread
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return await future
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/anyio/_backends/_asyncio.py", line 986, in run
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: result = context.run(func, *args)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/current/api/workflow/routes.py", line 49, in get_workflows
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: workflows = services.get_workflows(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: session=session,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ...<3 lines>...
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: sort_order=sort_order,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/current/api/workflow/services.py", line 75, in get_workflows
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: workflows = session.exec(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: select(Workflow).order_by(sort_column).offset(offset).limit(per_page)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ).all()
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlmodel/orm/session.py", line 83, in exec
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: results = super().execute(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: statement,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ...<4 lines>...
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: _add_event=_add_event,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/orm/session.py", line 2351, in execute
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return self._execute_internal(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: statement,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ...<4 lines>...
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: _add_event=_add_event,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: result: Result[Any] = compile_state_cls.orm_execute_statement(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ...<4 lines>...
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: conn,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: result = conn.execute(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: statement, params or {}, execution_options=execution_options
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return meth(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: distilled_parameters,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: execution_options or NO_OPTIONS,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return connection._execute_clauseelement(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self, distilled_params, execution_options
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ret = self._execute_context(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: dialect,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ...<8 lines>...
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: cache_hit=cache_hit,
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: return self._exec_single_context(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: dialect, context, statement, parameters
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self._handle_dbapi_exception(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: e, str_statement, effective_parameters, cursor, context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self.dialect.do_execute(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~~~^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: cursor, str_statement, effective_parameters, context
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: cursor.execute(statement, parameters)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/cursors.py", line 153, in execute
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: result = self._query(query)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/cursors.py", line 322, in _query
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: conn.query(q)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 574, in query
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self._execute_command(COMMAND.COM_QUERY, sql)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 865, in _execute_command
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: self._write_bytes(packet)
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: ~~~~~~~~~~~~~~~~~^^^^^^^^
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: File "/var/app/venv/staging-LQM1lest/lib64/python3.13/site-packages/pymysql/connections.py", line 816, in _write_bytes
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: raise err.OperationalError(
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: CR.CR_SERVER_GONE_ERROR, f"MySQL server has gone away ({e!r})"
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: )
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: [SQL: SELECT workflow.id, workflow.name, workflow.definition_uri, workflow.engine, workflow.engine_id, workflow.engine_version
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: FROM workflow ORDER BY workflow.id
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: LIMIT %(param_1)s, %(param_2)s]
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: [parameters: {'param_1': 0, 'param_2': 20}]
Jan 16 15:00:02 ip-172-25-131-194 web[201841]: (Background on this error at: https://sqlalche.me/e/20/e3q8)