Re: error in vacuum

2018-09-01 Thread Dave Peticolas
On Sat, Sep 1, 2018 at 7:24 PM Andres Freund wrote: > On 2018-09-01 19:02:18 -0700, Dave Peticolas wrote: > > On Sat, Sep 1, 2018 at 6:56 PM Tom Lane wrote: > > > > > Dave Peticolas writes: > > > >>> I'm seeing this error on a table repeatedly: > > > >>> found update xid 3433096759 <(343)%20309

Re: error in vacuum

2018-09-01 Thread Andres Freund
On 2018-09-01 19:02:18 -0700, Dave Peticolas wrote: > On Sat, Sep 1, 2018 at 6:56 PM Tom Lane wrote: > > > Dave Peticolas writes: > > >>> I'm seeing this error on a table repeatedly: > > >>> found update xid 3433096759 <(343)%20309-6759> from before > > relfrozenxid 3498422955 > > > > >> This is

Re: error in vacuum

2018-09-01 Thread Dave Peticolas
On Sat, Sep 1, 2018 at 6:56 PM Tom Lane wrote: > Dave Peticolas 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 assoc

Re: error in vacuum

2018-09-01 Thread Tom Lane
Dave Peticolas 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 t

Re: error in vacuum

2018-09-01 Thread Dave Peticolas
On Sat, Sep 1, 2018 at 5:28 PM Dave Peticolas wrote: > On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver > wrote: > >> On 09/01/2018 04:47 PM, Dave Peticolas wrote: >> > I'm seeing this error on a table repeatedly: >> > >> > found update xid 3433096759 <(343)%20309-6759> >> from before >> > relfrozenx

Re: error in vacuum

2018-09-01 Thread Dave Peticolas
On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver wrote: > On 09/01/2018 04:47 PM, Dave Peticolas wrote: > > I'm seeing this error on a table repeatedly: > > > > found update xid 3433096759 from before > > relfrozenxid 3498422955 > > Where is this, your primary or the instance you are running from the

Re: error in vacuum

2018-09-01 Thread Adrian Klaver
On 09/01/2018 04:47 PM, Dave Peticolas wrote: I'm seeing this error on a table repeatedly: found update xid 3433096759  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 --

Re: error in vacuum

2018-09-01 Thread Dave Peticolas
On Sat, Sep 1, 2018 at 4:47 PM Dave Peticolas wrote: > I'm seeing this error on a table repeatedly: > > found update xid 3433096759 <(343)%20309-6759> from before relfrozenxid > 3498422955 > > What can I do to repair this table? > > This is version 9.6.

error in vacuum

2018-09-01 Thread Dave Peticolas
I'm seeing this error on a table repeatedly: found update xid 3433096759 <(343)%20309-6759> from before relfrozenxid 3498422955 What can I do to repair this table? thanks, dave