On 2018-09-01 19:02:18 -0700, Dave Peticolas wrote: > On Sat, Sep 1, 2018 at 6:56 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > > Dave Peticolas <dave@xxxxxxxxxx> 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
