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

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164
Дата
Msg-id 2336201528362726@web28o.yandex.ru
обсуждение исходный текст
Ответ на 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>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: foundxmin 598 from before relfrozenxid 68569164
Следующее
От: Eyedia Tech
Дата:
Сообщение: chkpass Major Issue - compares 'contains' and not 'equal'