Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: found xmin from before relfrozenxid - Mailing list pgsql-performance

From Adrien NAYRAT
Subject Re: ERROR: found xmin from before relfrozenxid
Date
Msg-id a8d0a631-1dae-beb8-afe0-392f5b2ab1a2@anayrat.info
Whole thread Raw
In response to Re: ERROR: found xmin from before relfrozenxid  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: ERROR: found xmin from before relfrozenxid
List pgsql-performance
Tree view 
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 by date:

Previous
From: "ldh@laurent-hasson.com"
Date:
Subject: Re: Zero throughput on a query on a very large table.
Next
From: Mariel Cherkassky
Date:
Subject: Re: ERROR: found xmin from before relfrozenxid