Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164 - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164
Date
Msg-id 2336201528362726@web28o.yandex.ru
Whole thread Raw
In response to BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: foundxmin 598 from before relfrozenxid 68569164  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR:found xmin 598 from before relfrozenxid 68569164  (pinker <pinker@onet.eu>)
List pgsql-bugs
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.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: foundxmin 598 from before relfrozenxid 68569164
Next
From: Eyedia Tech
Date:
Subject: chkpass Major Issue - compares 'contains' and not 'equal'