Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "satish(dot)nayak(at)nmc(dot)ae" <satish(dot)nayak(at)nmc(dot)ae>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164
Date: 2018-06-07 09:12:06
Message-ID: 2336201528362726@web28o.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)1527441741%40sss(dot)pgh(dot)pa(dot)us#10046(dot)1527441741(at)sss(dot)pgh(dot)pa(dot)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(at)postgresql(dot)org>:
> The following bug has been logged on the website:
>
> Bug reference: 15231
> Logged by: satish nayak
> Email address: satish(dot)nayak(at)nmc(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eyedia Tech 2018-06-07 12:41:44 chkpass Major Issue - compares 'contains' and not 'equal'
Previous Message PG Bug reporting form 2018-06-07 05:04:36 BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164