Обсуждение: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: foundxmin 598 from before relfrozenxid 68569164
BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: foundxmin 598 from before relfrozenxid 68569164
От
PG Bug reporting form
Дата:
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