On Sat, Mar 9, 2024 at 9:48 AM Tomas Vondra <tomas.von...@enterprisedb.com> wrote: > I spent a bit of time investigating this today, but haven't made much > progress due to (a) my unfamiliarity with the smgr code in general and > the patch in particular, and (b) CLOBBER_CACHE_ALWAYS making it quite > time consuming to iterate and experiment. > > However, the smallest schedule that still reproduces the issue is: > > ------------------- > test: test_setup > > test: create_aggregate create_function_sql create_cast constraints > triggers select inherit typed_table vacuum drop_if_exists > updatable_views roleattributes create_am hash_func errors infinite_recurse > -------------------
Thanks, reproduced here (painfully slowly). Looking... Huh, also look at these extra problems later in the logs of the latest trilobite and avocet runs, further down after the short read errors: TRAP: failed Assert("j > attnum"), File: "heaptuple.c", Line: 640, PID: 15753 postgres: autovacuum worker regression(ExceptionalCondition+0x67)[0x9c5f37] postgres: autovacuum worker regression[0x4b60c8] postgres: autovacuum worker regression[0x5ff735] postgres: autovacuum worker regression[0x5fe468] postgres: autovacuum worker regression(analyze_rel+0x133)[0x5fd5e3] postgres: autovacuum worker regression(vacuum+0x6b6)[0x683926] postgres: autovacuum worker regression[0x7ce5e3] postgres: autovacuum worker regression[0x7cc4f0] postgres: autovacuum worker regression(StartAutoVacWorker+0x22)[0x7cc152] postgres: autovacuum worker regression[0x7d57d1] postgres: autovacuum worker regression[0x7d37bf] postgres: autovacuum worker regression[0x6f5a4f] Then crash recovery fails, in one case with: 2024-03-07 20:28:18.632 CET [15860:4] WARNING: will not overwrite a used ItemId 2024-03-07 20:28:18.632 CET [15860:5] CONTEXT: WAL redo at 0/FB07A48 for Heap/INSERT: off: 9, flags: 0x00; blkref #0: rel 1663/16384/2610, blk 12 2024-03-07 20:28:18.632 CET [15860:6] PANIC: failed to add tuple 2024-03-07 20:28:18.632 CET [15860:7] CONTEXT: WAL redo at 0/FB07A48 for Heap/INSERT: off: 9, flags: 0x00; blkref #0: rel 1663/16384/2610, blk 12 ... and in another with: 2024-03-05 11:51:27.992 CET [25510:4] PANIC: invalid lp 2024-03-05 11:51:27.992 CET [25510:5] CONTEXT: WAL redo at 0/F87A8D0 for Heap/INPLACE: off: 29; blkref #0: rel 1663/16384/20581, blk 0