Thread: error in vacuum
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
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 3498422955What can I do to repair this table?
This is version 9.6.
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
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
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?
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
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?
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
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.