Hello Amit,
08.10.2026 06:58, Amit Langote wrote:
On Wed, Oct 7, 2026 at 10:02 PM Amit Langote <[email protected]> wrote:
On Tue, Oct 6, 2026 at 3:20 PM Amit Langote <[email protected]> wrote:
...
Barring comments, would like to push the attached slightly updated
version (comment, commit message fixes) tomorrow after committing the
patches in [1] because I rebased these over those other patches.
I've pushed these.
I've accidentially discovered that a test case added with 061065e28 can
produce a new assertion failure with just:
- UPDATE fp_pk_cid SET v = v + 1 WHERE id OPERATOR(pg_catalog.=) $1;
+ UPDATE fp_pk_cid SET id = id + 1 WHERE id OPERATOR(pg_catalog.=) $1;
TRAP: failed Assert("entry->data.lockmode == BUFFER_LOCK_UNLOCK"), File:
"bufmgr.c", Line: 5941, PID: 2303915
ExceptionalCondition at assert.c:51:13
BufferLockAcquire at bufmgr.c:5948:2
LockBufferInternal at bufmgr.c:6631:3
LockBuffer at bufmgr.h:340:1
_bt_lockbuf at nbtpage.c:1072:1
_bt_getbuf at nbtpage.c:839:2
_bt_getroot at nbtpage.c:380:13
_bt_search at nbtsearch.c:113:8
_bt_search_insert at nbtinsert.c:385:1
_bt_doinsert at nbtinsert.c:170:10
btinsert at nbtree.c:225:11
index_insert at indexam.c:235:9
ExecInsertIndexTuples at execIndexing.c:450:4
ExecUpdateEpilogue at nodeModifyTable.c:2372:20
ExecUpdate at nodeModifyTable.c:2754:19
ExecModifyTable at nodeModifyTable.c:4801:12
ExecProcNodeFirst at execProcnode.c:470:1
...
2026-11-18 07:06:47.374 EET postmaster[2302673] LOG: client backend (PID
2303915) was terminated by signal 6: Aborted
2026-11-18 07:06:47.374 EET postmaster[2302673] DETAIL: Failed process was
running: INSERT INTO fp_fk_cid VALUES (1);
Could you please have a look?
Best regards,
Alexander