why am i starting to get error that has already been fixed in previous commits or so.

2026-05-15 15:05:36,568 - services.pending_sessions_manager - ERROR - [reprocess_session] Failed: (pymysql.err.OperationalError) (1206, 'The total number of locks exceeds the lock table size') [SQL: DELETE FROM raw_data WHERE prepare_coppa_uuid = %(uuid)s LIMIT 5000] [parameters: {'uuid': 'b34b0f98-a1b8-464d-8f2d-e290a3154c78'}] (Background on this error at: https://sqlalche.me/e/20/e3q8) Traceback (most recent call last): File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute cursor.execute(statement, parameters) File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 575, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 826, in _read_query_result result.read() File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 1203, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 782, in _read_packet packet.raise_for_error() File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1206, 'The total number of locks exceeds the lock table size')

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "E:\coppahrvbaseline\CoPPA\backend\services\pending_sessions_manager.py", line 587, in reprocess_session r1 = db_session.execute(q1, {'uuid': old_uuid}) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\orm\session.py", line 2365, in execute return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\orm\session.py", line 2260, in _execute_internal result = conn.execute( ^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 1419, in execute return meth( ^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\sql\elements.py", line 526, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 2355, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute cursor.execute(statement, parameters) File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 575, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 826, in _read_query_result result.read() File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 1203, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\connections.py", line 782, in _read_packet packet.raise_for_error() File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "C:\ProgramData\anaconda3\envs\coppa\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1206, 'The total number of locks exceeds the lock table size') [SQL: DELETE FROM raw_data WHERE prepare_coppa_uuid = %(uuid)s LIMIT 5000] [parameters: {'uuid': 'b34b0f98-a1b8-464d-8f2d-e290a3154c78'}] (Background on this error at: https://sqlalche.me/e/20/e3q8) 2026-05-15 15:05:36,589 - werkzeug - INFO - 127.0.0.1 - - [15/May/2026 15:05:36] "POST /api/pending-sessions/reprocess/4 HTTP/1.1" 404 -