On Wed, 1 Jul 2026 at 07:24, Japin Li <[email protected]> wrote: > > While testing the v5 patch, I encountered a lock wait. > > 2026-07-01 14:18:43.603 CST [1486593] LOG: process 1486593 still waiting for > AccessExclusiveLock on relation 16384 of database 5 after 1000.106 ms > 2026-07-01 14:18:43.603 CST [1486593] DETAIL: Process holding the lock: > 1486484. Wait queue: 1486593. > 2026-07-01 14:18:43.603 CST [1486593] CONTEXT: waiting for > AccessExclusiveLock on relation 16384 of database 5 > 2026-07-01 14:18:43.603 CST [1486593] STATEMENT: SELECT * FROM gtt_delete; > > To reproduce: > > Session 1: > > CREATE GLOBAL TEMPORARY TABLE gtt_delete (id int) ON COMMIT DELETE ROWS; > BEGIN; > INSERT INTO gtt_delete VALUES (1); > > Session 2: > > SELECT * FROM gtt_delete; ---> blocked > > Is this expected?
Thanks for testing! This is fixed in v6. Regards, Dean
