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.
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 |