Thread: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: foundxmin 598 from before relfrozenxid 68569164

The following bug has been logged on the website:

Bug reference:      15231
Logged by:          satish nayak
Email address:      satish.nayak@nmc.ae
PostgreSQL version: 9.3.23
Operating system:   Ubuntu 16.04.4 LTS (GNU/Linux 4.4.0-97-generic x8
Description:

After upgrading postgresql 9.3.23 db to 9.6.9 , we starting getting ERROR:
found xmin 598 from before relfrozenxid 68569164.

Hello
Unfortunately this is bug. Patch is still in progress as far as I know...
You can found history in this thread:
https://www.postgresql.org/message-id/flat/10046.1527441741%40sss.pgh.pa.us#10046.1527441741@sss.pgh.pa.us
Known workaround is:
- stop database
- delete or move file $PGDATA/global/pg_internal.init
- start database and run vacuum freeze on tables with this error

regards, Sergei

07.06.2018, 08:05, "PG Bug reporting form" <noreply@postgresql.org>:
> The following bug has been logged on the website:
>
> Bug reference: 15231
> Logged by: satish nayak
> Email address: satish.nayak@nmc.ae
> PostgreSQL version: 9.3.23
> Operating system: Ubuntu 16.04.4 LTS (GNU/Linux 4.4.0-97-generic x8
> Description:
>
> After upgrading postgresql 9.3.23 db to 9.6.9 , we starting getting ERROR:
> found xmin 598 from before relfrozenxid 68569164.

I have the same problem after upgrading to 10.4.9:

2018-11-03 00:06:14 CET [41253]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:14 CET [41253]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"
2018-11-03 00:06:29 CET [41305]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:29 CET [41305]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"
2018-11-03 00:06:44 CET [41625]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:44 CET [41625]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"
2018-11-03 00:06:59 CET [41676]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:59 CET [41676]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"

your workaround helped, thank you




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html