AssertionError: InvalidRequestError: This session is in 'inactive' state, due to the SQL transaction being rolled back; no further SQL can be emitted within this transaction.

[sentry-io]

Sentry Issue: PCKT-002-PACKIT-SERVICE-930

InvalidRequestError: This session is in 'inactive' state, due to the SQL transaction being rolled back; no further SQL can be emitted within this transaction.
(9 additional frame(s) were not displayed)
...
  File "<string>", line 2, in begin

AssertionError: 
(9 additional frame(s) were not displayed)
...
  File "contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "packit_service/models.py", line 124, in sa_session_transaction
    session.rollback()
  File "sqlalchemy/orm/session.py", line 1399, in rollback
    self._transaction.rollback(_to_root=self.future)
  File "sqlalchemy/orm/session.py", line 892, in rollback
    boundary._restore_snapshot(dirty_only=boundary.nested)
  File "sqlalchemy/orm/session.py", line 672, in _restore_snapshot
    assert self._is_transaction_boundary

[lbarcziova]

From the logs, for the period when this started, the only suspicious log activity I found is:

[2024-12-12 14:18:30,557: WARNING/MainProcess] task.run_testing_farm_handler[49555b21-86ac-475e-9987-38b5b7258e70] Exception while working with database: AttributeError("'NoneType' object has no attribute '_new'")
[2024-12-12 14:18:30,558: WARNING/MainProcess] task.run_testing_farm_handler[49555b21-86ac-475e-9987-38b5b7258e70] /usr/local/lib/python3.9/site-packages/packit_service/models.py:124: SAWarning: Session's state has been changed on a non-active transaction - this state will be discarded.
  session.rollback()