Re: error in vacuum

From: Dave Peticolas <dave(at)krondo(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: error in vacuum
Date: 2018-09-02 00:28:33
Message-ID: CAPRbp05cyASFuieDrcQvYCTJM_TWBS2SBzPqDRf5t2S+akJV8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Peticolas 2018-09-02 00:53:04 Re: locate DB corruption
Previous Message Adrian Klaver 2018-09-02 00:10:22 Re: error in vacuum