Re: ERROR: found xmin from before relfrozenxid

Поиск
Список
Период
Сортировка
От Adrien NAYRAT
Тема Re: ERROR: found xmin from before relfrozenxid
Дата
Msg-id a8d0a631-1dae-beb8-afe0-392f5b2ab1a2@anayrat.info
обсуждение исходный текст
Ответ на Re: ERROR: found xmin from before relfrozenxid  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: ERROR: found xmin from before relfrozenxid  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
On 1/25/19 6:20 PM, Mariel Cherkassky wrote:
> I'm getting this issue when I try to connect to a specific db. Does it 
> matters what table I specify ? Should I just choose a random table from 
> the problematic db? If I'll dump the db and restore it it can help ?

Error message is on "db1.public.table_1", but maybe other tables are 
impacted.

If you can dump and restore your database it should fix your issue. Be 
careful to apply minor update (9.6.11 f you can).



В списке pgsql-performance по дате отправления:

Предыдущее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: Re: Zero throughput on a query on a very large table.
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: ERROR: found xmin from before relfrozenxid