Deadlock occurred on app
Description
Seen in https://vdb.vidjil.org/_dashboard/ticket/2457259c-1bd4-4920-9294-1ce0c220b3b8
Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/py4web/core.py", line 944, in wrapper
ret = func(*func_args, **func_kwargs)
File "/usr/local/lib/python3.8/dist-packages/py4web/core.py", line 929, in wrapper
raise context["exception"]
File "/usr/local/lib/python3.8/dist-packages/py4web/core.py", line 908, in wrapper
context["output"] = func(*args, **kwargs)
File "/usr/share/vidjil/server/py4web/apps/vidjil/controllers/default.py", line 230, in run_request
res = schedule_run(request.query["sequence_file_id"], id_config, grep_reads)
File "/usr/share/vidjil/server/py4web/apps/vidjil/tasks.py", line 96, in schedule_run
db( ( db.results_file.config_id == id_config ) &
File "/usr/local/lib/python3.8/dist-packages/pydal/objects.py", line 2787, in update
ret = db._adapter.update(table, self.query, row.op_values())
File "/usr/local/lib/python3.8/dist-packages/pydal/adapters/base.py", line 586, in update
raise e
File "/usr/local/lib/python3.8/dist-packages/pydal/adapters/base.py", line 581, in update
self.execute(sql)
File "/usr/local/lib/python3.8/dist-packages/pydal/adapters/__init__.py", line 70, in wrap
return f(*args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/pydal/adapters/base.py", line 468, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 153, in execute
result = self._query(query)
File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 822, in _read_query_result
result.read()
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1200, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 772, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reproducibility ?
Hard to know what happened...
fix clue
May be try and see analyses that were started around this time 2024-02-12 12:30:17
Priority
Low while it is not reproduced?