New assertion failed in lazy_scan_heap() on mereswine

On Sat, May 1, 2021 at 10:14 AM Thomas Munro <thomas.munro@gmail.com> wrote:

Hi,

TRAP: FailedAssertion("!all_visible_according_to_vm ||
prunestate.all_visible", File:
"/home/pgsql/build-farm/buildroot/HEAD/pgsql.build/../pgsql/src/backend/access/heap/vacuumlazy.c",
Line: 1347, PID: 16926)

2021-04-30 04:15:50.317 PDT [10349:18] DETAIL: Failed process was
running: autovacuum: VACUUM ANALYZE pg_catalog.pg_attribute

There is another thread[1]/messages/by-id/OS0PR01MB611340CBD300A7C4FD6B6101FB5F9@OS0PR01MB6113.jpnprd01.prod.outlook.com that has reported the same issue and also
provided a script to reproduce the issue.

[1]: /messages/by-id/OS0PR01MB611340CBD300A7C4FD6B6101FB5F9@OS0PR01MB6113.jpnprd01.prod.outlook.com

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

On Sat, May 01, 2021 at 04:43:21PM +1200, Thomas Munro wrote:

TRAP: FailedAssertion("!all_visible_according_to_vm || prunestate.all_visible", File: "/home/pgsql/build-farm/buildroot/HEAD/pgsql.build/../pgsql/src/backend/access/heap/vacuumlazy.c", Line: 1347, PID: 16926)
2021-04-30 04:15:50.317 PDT [10349:18] DETAIL: Failed process was
running: autovacuum: VACUUM ANALYZE pg_catalog.pg_attribute
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mereswine&amp;dt=2021-04-30%2006:43:27

The same assertion was reported here
/messages/by-id/OS0PR01MB611340CBD300A7C4FD6B6101FB5F9@OS0PR01MB6113.jpnprd01.prod.outlook.com
|TRAP: FailedAssertion("!all_visible_according_to_vm || prunestate.all_visible", File: "/home/pgsql/build-farm/buildroot/HEAD/pgsql.build/../pgsql/src/backend/access/heap/vacuumlazy.c", Line: 1347, PID: 16926)
|2021-04-30 04:15:50.317 PDT [10349:18] DETAIL: Failed process was running: autovacuum: VACUUM ANALYZE pg_catalog.pg_attribute

And Michael added
https://wiki.postgresql.org/index.php?title=PostgreSQL_14_Open_Items&amp;type=revision&amp;diff=35954&amp;oldid=35952

--
Justin