P29G8_PAYLOAD_SCOPE=PASS P29G8_SAFE_PENDING_TOP_UP_RESELECTION_SOURCE_CONTRACT=PASS P29G8_GENERAL_INFLIGHT_GUARD_SOURCE_CONTRACT=PASS NO_SCHEMA_MIGRATION_IN_TARGET_PACKAGE=PASS RESULT=PASS_P29G8_BACKEND_CONTRACT INFO [alembic.runtime.migration] Context impl PostgresqlImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. P29G8_BACKEND_AND_DB_HEALTH=PASS P29G8_OPENAPI_UNCHANGED=PASS P29G8_SOURCE_SEMANTICS=PASS Traceback (most recent call last): File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1943, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1180, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.12/site-packages/psycopg/cursor.py", line 117, in execute raise ex.with_traceback(None) psycopg.errors.CheckViolation: new row for relation "billing_accounts" violates check constraint "billing_accounts_paid_through_shape" DETAIL: Failing row contains (0b7e78fc-a0ed-4676-ae1d-b81f75e3959e, 152ef5c8-7ee8-4bd0-928b-c8a102302071, 093502fc-9842-4ba2-be23-e6769ba0139f, 310ddec6-c82c-5484-ad28-8ecee170bc1d, active_paid, manual, 3, 1, 2026-09-27 12:07:36.395326+00, 2026-11-04 12:07:36.395326+00, null, null, f, null, 2026-09-27 12:07:36.395326+00, 2026-09-27 12:15:05.735009+00, 2026-09-27 12:07:36.395326+00, 2026-10-04 12:07:36.395326+00, 2026-09-28 13:22:49.533819+00, 2026-10-29 13:22:49.533819+00). The above exception was the direct cause of the following exception: Traceback (most recent call last): File "", line 69, in File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4536, in flush self._flush(objects) File "", line 2, in _flush File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned return fn(*args, **kwargs) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4679, in _flush with util.safe_reraise(): ^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 166, in __exit__ raise exc_value.with_traceback(exc_tb) File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4640, in _flush flush_context.execute() File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute rec.execute(self) File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 643, in execute util.preloaded.orm_persistence._save_obj( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 84, in _save_obj _emit_update_statements( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 916, in _emit_update_statements c = connection.execute( ^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1448, in execute return meth( ^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 533, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1668, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1822, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1962, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2332, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1943, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1180, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.12/site-packages/psycopg/cursor.py", line 117, in execute raise ex.with_traceback(None) sqlalchemy.exc.IntegrityError: (psycopg.errors.CheckViolation) new row for relation "billing_accounts" violates check constraint "billing_accounts_paid_through_shape" DETAIL: Failing row contains (0b7e78fc-a0ed-4676-ae1d-b81f75e3959e, 152ef5c8-7ee8-4bd0-928b-c8a102302071, 093502fc-9842-4ba2-be23-e6769ba0139f, 310ddec6-c82c-5484-ad28-8ecee170bc1d, active_paid, manual, 3, 1, 2026-09-27 12:07:36.395326+00, 2026-11-04 12:07:36.395326+00, null, null, f, null, 2026-09-27 12:07:36.395326+00, 2026-09-27 12:15:05.735009+00, 2026-09-27 12:07:36.395326+00, 2026-10-04 12:07:36.395326+00, 2026-09-28 13:22:49.533819+00, 2026-10-29 13:22:49.533819+00). [SQL: UPDATE billing_accounts SET pending_period_start=%(pending_period_start)s::TIMESTAMP WITH TIME ZONE, pending_period_end=%(pending_period_end)s::TIMESTAMP WITH TIME ZONE WHERE billing_accounts.id = %(billing_accounts_id)s::UUID] [parameters: {'pending_period_start': datetime.datetime(2026, 9, 28, 13, 22, 49, 533819, tzinfo=datetime.timezone.utc), 'pending_period_end': datetime.datetime(2026, 10, 29, 13, 22, 49, 533819, tzinfo=datetime.timezone.utc), 'billing_accounts_id': UUID('0b7e78fc-a0ed-4676-ae1d-b81f75e3959e')}] (Background on this error at: https://sqlalche.me/e/21/gkpj)