BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 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: /messages/by-id/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>:
Show quoted text
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