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 -