API et PendingRollbackError

[revolunet]

Régulièrement le pod API se retrouve bloqué avec ce message d'erreur :

ERROR:ecosante:Exception on /v1/ [HEAD] |  
Traceback (most recent call last): |  
File "/code/api/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request |  
rv = self.dispatch_request() |  
File "/code/api/.venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request |  
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) |  
File "/code/api/.venv/lib/python3.10/site-packages/flask_rebar/rebar.py", line 135, in wrapped |  
rv = f(*args, **kwargs) |  
File "/code/api/./ecosante/api/blueprint.py", line 51, in index |  
commune = Commune.get(insee) |  
File "/code/libs/indice_pollution/indice_pollution/history/models/commune.py", line 62, in get |  
if r:= db.session.execute(cls.get_query(insee, with_joins=True)).first(): |  
File "<string>", line 2, in execute |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute |  
result = conn._execute_20(statement, params or {}, execution_options) |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20 |  
return meth(self, args_10style, kwargs_10style, execution_options) |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection |  
return connection._execute_clauseelement( |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement |  
ret = self._execute_context( |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1803, in _execute_context |  
conn = self._revalidate_connection() |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 650, in _revalidate_connection |  
self._invalid_transaction() |  
File "/code/api/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 622, in _invalid_transaction |  
raise exc.PendingRollbackError( |  
sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)

 
  Il faudrait à minima que la sonde sur /healthz renvoie une 500 dans cette situation, pour faire redémarrer automatiquement