Postgres Pro
Downloads
Home   >   mailing lists

Thread: New assertion failed in lazy_scan_heap() on mereswine

New assertion failed in lazy_scan_heap() on mereswine

From
Thomas Munro
Date:
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

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mereswine&dt=2021-04-30%2006:43:27

Re: New assertion failed in lazy_scan_heap() on mereswine

From
Dilip Kumar
Date:
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] that has reported the same issue and also
provided a script to reproduce the issue.

[1]
https://www.postgresql.org/message-id/OS0PR01MB611340CBD300A7C4FD6B6101FB5F9@OS0PR01MB6113.jpnprd01.prod.outlook.com

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

Re: New assertion failed in lazy_scan_heap() on mereswine

From
Justin Pryzby
Date:
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&dt=2021-04-30%2006:43:27

The same assertion was reported here

https://www.postgresql.org/message-id/flat/OS0PR01MB611340CBD300A7C4FD6B6101FB5F9%40OS0PR01MB6113.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&type=revision&diff=35954&oldid=35952

-- 
Justin