Thread: error in vacuum

error in vacuum

From
Dave Peticolas
Date:
I'm seeing this error on a table repeatedly:

found update xid 3433096759 from before relfrozenxid 3498422955

What can I do to repair this table?

thanks,
dave


Re: error in vacuum

From
Dave Peticolas
Date:

On Sat, Sep 1, 2018 at 4:47 PM Dave Peticolas <dave@krondo.com> wrote:
I'm seeing this error on a table repeatedly:

found update xid 3433096759 from before relfrozenxid 3498422955

What can I do to repair this table?

This is version 9.6. 

Re: error in vacuum

From
Adrian Klaver
Date:
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?

> 
> What can I do to repair this table?
> 
> thanks,
> dave
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


Re: error in vacuum

From
Dave Peticolas
Date:
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?
>
> thanks,
> dave
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: error in vacuum

From
Dave Peticolas
Date:
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?

Re: error in vacuum

From
Tom Lane
Date:
Dave Peticolas <dave@krondo.com> writes:
>>> I'm seeing this error on a table repeatedly:
>>> found update xid 3433096759 from before relfrozenxid 3498422955

>> This is a primary, 9.6.8 to be exact.

This message is known to be associated with several data-corruption bugs
we've fixed recently.  You should update to current (9.6.10) sooner not
later.  I don't think that will cure existing corruption for you, but
it should prevent things from getting worse.

            regards, tom lane


Re: error in vacuum

From
Dave Peticolas
Date:
On Sat, Sep 1, 2018 at 6:56 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Dave Peticolas <dave@krondo.com> writes:
>>> I'm seeing this error on a table repeatedly:
>>> found update xid 3433096759 from before relfrozenxid 3498422955

>> This is a primary, 9.6.8 to be exact.

This message is known to be associated with several data-corruption bugs
we've fixed recently.  You should update to current (9.6.10) sooner not
later.  I don't think that will cure existing corruption for you, but
it should prevent things from getting worse.

Ok, thank you for that information I will do so. The dump/truncate/restore I mentioned in a later post seems to fix the corruption in a restored DB. Given the nature of the bug do you think that would fix that table? 

Re: error in vacuum

From
Andres Freund
Date:
On 2018-09-01 19:02:18 -0700, Dave Peticolas wrote:
> On Sat, Sep 1, 2018 at 6:56 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> > Dave Peticolas <dave@krondo.com> writes:
> > >>> I'm seeing this error on a table repeatedly:
> > >>> found update xid 3433096759 <(343)%20309-6759> from before
> > relfrozenxid 3498422955
> >
> > >> This is a primary, 9.6.8 to be exact.
> >
> > This message is known to be associated with several data-corruption bugs
> > we've fixed recently.  You should update to current (9.6.10) sooner not
> > later.  I don't think that will cure existing corruption for you, but
> > it should prevent things from getting worse.
> >
> 
> Ok, thank you for that information I will do so. The dump/truncate/restore
> I mentioned in a later post seems to fix the corruption in a restored DB.
> Given the nature of the bug do you think that would fix that table?

Yes, it's fairly likely that it does. You might even get around it by
just doing a no-op update of the whole table.  Nevertheless you need to
upgrade, or more of that corruption can occur.

Greetings,

Andres Freund


Re: error in vacuum

From
Dave Peticolas
Date:
On Sat, Sep 1, 2018 at 7:24 PM Andres Freund <andres@anarazel.de> wrote:
On 2018-09-01 19:02:18 -0700, Dave Peticolas wrote:
> On Sat, Sep 1, 2018 at 6:56 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> > Dave Peticolas <dave@krondo.com> writes:
> > >>> I'm seeing this error on a table repeatedly:
> > >>> found update xid 3433096759 <(343)%20309-6759> from before
> > relfrozenxid 3498422955
> >
> > >> This is a primary, 9.6.8 to be exact.
> >
> > This message is known to be associated with several data-corruption bugs
> > we've fixed recently.  You should update to current (9.6.10) sooner not
> > later.  I don't think that will cure existing corruption for you, but
> > it should prevent things from getting worse.
> >
>
> Ok, thank you for that information I will do so. The dump/truncate/restore
> I mentioned in a later post seems to fix the corruption in a restored DB.
> Given the nature of the bug do you think that would fix that table?

Yes, it's fairly likely that it does. You might even get around it by
just doing a no-op update of the whole table.  Nevertheless you need to
upgrade, or more of that corruption can occur.

Indeed, that does seem to fix the issue and is much simpler, thank you. I'm going to schedule this upgrade with all due haste.