date: 2026-11-06T07:33:52Z  commit: 1212c562d23fefe35efad0c20c479b476fd73140
environment: {"NO_PROXY": "localhost,127.0.0.1,::1"}
$ .venv/bin/pytest -q --tb=short student-tests/api/test_job_returning.py
F                                                                        [100%]
=================================== FAILURES ===================================
_______________ test_claim_returning_is_stable_across_hash_seeds _______________
student-tests/api/test_job_returning.py:57: in test_claim_returning_is_stable_across_hash_seeds
    assert child.returncode == 0, f"seed={seed}: {errors.decode()}"
E   AssertionError: seed=0: Traceback (most recent call last):
E       File "asyncpg/protocol/prepared_stmt.pyx", line 175, in asyncpg.protocol.protocol.PreparedStatementState._encode_bind_msg
E       File "asyncpg/protocol/codecs/base.pyx", line 251, in asyncpg.protocol.protocol.Codec.encode
E       File "asyncpg/protocol/codecs/base.pyx", line 153, in asyncpg.protocol.protocol.Codec.encode_scalar
E         self.c_encoder(settings, buf, obj)
E       File "asyncpg/pgproto/codecs/int.pyx", line 60, in asyncpg.pgproto.pgproto.int4_encode
E     OverflowError: value out of int32 range
E     
E     The above exception was the direct cause of the following exception:
E     
E     Traceback (most recent call last):
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 550, in _prepare_and_execute
E         self._rows = deque(await prepared_stmt.fetch(*parameters))
E                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/asyncpg/prepared_stmt.py", line 177, in fetch
E         data = await self.__bind_execute(args, 0, timeout)
E                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/asyncpg/prepared_stmt.py", line 268, in __bind_execute
E         data, status, _ = await self.__do_execute(
E                           ^^^^^^^^^^^^^^^^^^^^^^^^
E             lambda protocol: protocol.bind_execute(
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E                 self._state, args, '', limit, True, timeout))
E                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/asyncpg/prepared_stmt.py", line 257, in __do_execute
E         return await executor(protocol)
E                ^^^^^^^^^^^^^^^^^^^^^^^^
E       File "asyncpg/protocol/protocol.pyx", line 176, in bind_execute
E       File "asyncpg/protocol/prepared_stmt.pyx", line 204, in asyncpg.protocol.protocol.PreparedStatementState._encode_bind_msg
E     asyncpg.exceptions.DataError: invalid input for query argument $4: UUID('01a1afc7-4658-75c3-bfaf-f371b77688... (value out of int32 range)
E     
E     The above exception was the direct cause of the following exception:
E     
E     Traceback (most recent call last):
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
E         self.dialect.do_execute(
E         ~~~~~~~~~~~~~~~~~~~~~~~^
E             cursor, str_statement, effective_parameters, context
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
E         cursor.execute(statement, parameters)
E         ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 585, in execute
E         self._adapt_connection.await_(
E         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
E             self._prepare_and_execute(operation, parameters)
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
E         return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
E                ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
E         value = await result
E                 ^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 563, in _prepare_and_execute
E         self._handle_exception(error)
E         ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 513, in _handle_exception
E         self._adapt_connection._handle_exception(error)
E         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 797, in _handle_exception
E         raise translated_error from error
E     sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.Error: <class 'asyncpg.exceptions.DataError'>: invalid input for query argument $4: UUID('01a1afc7-4658-75c3-bfaf-f371b77688... (value out of int32 range)
E     
E     The above exception was the direct cause of the following exception:
E     
E     Traceback (most recent call last):
E       File "<string>", line 25, in <module>
E         asyncio.run(main())
E         ~~~~~~~~~~~^^^^^^^^
E       File "/Users/artemkostylev/.local/share/uv/python/cpython-3.14.5-macos-aarch64-none/lib/python3.14/asyncio/runners.py", line 204, in run
E         return runner.run(main)
E                ~~~~~~~~~~^^^^^^
E       File "/Users/artemkostylev/.local/share/uv/python/cpython-3.14.5-macos-aarch64-none/lib/python3.14/asyncio/runners.py", line 127, in run
E         return self._loop.run_until_complete(task)
E                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
E       File "/Users/artemkostylev/.local/share/uv/python/cpython-3.14.5-macos-aarch64-none/lib/python3.14/asyncio/base_events.py", line 719, in run_until_complete
E         return future.result()
E                ~~~~~~~~~~~~~^^
E       File "<string>", line 22, in main
E         await asyncio.gather(claim(), claim())
E       File "<string>", line 17, in claim
E         claimed = await uow.jobs.claim(job, uuid4(), timedelta(seconds=5))
E                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E       File "<repo>/src/messenger/attachments/infrastructure/postgres.py", line 565, in claim
E         await self._note(claimed, "claimed")
E       File "<repo>/src/messenger/attachments/infrastructure/postgres.py", line 477, in _note
E         await self._session.execute(
E         ...<7 lines>...
E         )
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/ext/asyncio/session.py", line 449, in execute
E         result = await greenlet_spawn(
E                  ^^^^^^^^^^^^^^^^^^^^^
E         ...<6 lines>...
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn
E         result = context.throw(*sys.exc_info())
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/orm/session.py", line 2351, in execute
E         return self._execute_internal(
E                ~~~~~~~~~~~~~~~~~~~~~~^
E             statement,
E             ^^^^^^^^^^
E         ...<4 lines>...
E             _add_event=_add_event,
E             ^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal
E         result: Result[Any] = compile_state_cls.orm_execute_statement(
E                               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
E             self,
E             ^^^^^
E         ...<4 lines>...
E             conn,
E             ^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1306, in orm_execute_statement
E         result = conn.execute(
E             statement, params or {}, execution_options=execution_options
E         )
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
E         return meth(
E             self,
E             distilled_parameters,
E             execution_options or NO_OPTIONS,
E         )
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection
E         return connection._execute_clauseelement(
E                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
E             self, distilled_params, execution_options
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
E         ret = self._execute_context(
E             dialect,
E         ...<8 lines>...
E             cache_hit=cache_hit,
E         )
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
E         return self._exec_single_context(
E                ~~~~~~~~~~~~~~~~~~~~~~~~~^
E             dialect, context, statement, parameters
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
E         self._handle_dbapi_exception(
E         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
E             e, str_statement, effective_parameters, cursor, context
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception
E         raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
E         self.dialect.do_execute(
E         ~~~~~~~~~~~~~~~~~~~~~~~^
E             cursor, str_statement, effective_parameters, context
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
E         cursor.execute(statement, parameters)
E         ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 585, in execute
E         self._adapt_connection.await_(
E         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
E             self._prepare_and_execute(operation, parameters)
E             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E         )
E         ^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
E         return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
E                ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
E         value = await result
E                 ^^^^^^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 563, in _prepare_and_execute
E         self._handle_exception(error)
E         ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 513, in _handle_exception
E         self._adapt_connection._handle_exception(error)
E         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^
E       File "<repo>/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 797, in _handle_exception
E         raise translated_error from error
E     sqlalchemy.exc.DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.DataError'>: invalid input for query argument $4: UUID('01a1afc7-4658-75c3-bfaf-f371b77688... (value out of int32 range)
E     [SQL: INSERT INTO job_events (job_id, attachment_id, kind, attempt, detail) VALUES ($1::UUID, $2::UUID, $3::VARCHAR, $4::INTEGER, $5::JSONB) RETURNING job_events.id]
E     [SQL parameters hidden due to hide_parameters=True]
E     (Background on this error at: https://sqlalche.me/e/20/dbapi)
E     
E   assert 1 == 0
E    +  where 1 = <Process 13137>.returncode
=========================== short test summary info ============================
FAILED student-tests/api/test_job_returning.py::test_claim_returning_is_stable_across_hash_seeds
1 failed in 2.40s
exit_code: 1  elapsed_seconds: 3.236
