Re: error in vacuum - Mailing list pgsql-general

From Dave Peticolas
Subject Re: error in vacuum
Date
Msg-id CAPRbp047pUGj6GJLuBsJzc_YMGmSisYWmon_H_d+CE+O6XFkYQ@mail.gmail.com
Whole thread Raw
In response to Re: error in vacuum  (Dave Peticolas <dave@krondo.com>)
Responses Re: error in vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sat, Sep 1, 2018 at 5:28 PM Dave Peticolas <dave@krondo.com> wrote:
On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 09/01/2018 04:47 PM, Dave Peticolas wrote:
> I'm seeing this error on a table repeatedly:
>
> found update xid 3433096759 <tel:%28343%29%20309-6759> from before
> relfrozenxid 3498422955

Where is this, your primary or the instance you are running from the backup?

This is a primary, 9.6.8 to be exact.

>
> What can I do to repair this table?

One thing I tried on a database restored from a primary backup that exhibits the same "found update xid" error is this:

1. pg_dump the table and its referencing tables.
2. truncate the table and its referencing tables.
3. Load the dump file.

Does that seem reasonable?

pgsql-general by date:

Previous
From: Dave Peticolas
Date:
Subject: Re: locate DB corruption
Next
From: Tom Lane
Date:
Subject: Re: error in vacuum