Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not been created yet -- apparent wraparound

From: Phil Hildebrand <phil(dot)hildebrand(at)moz(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not been created yet -- apparent wraparound
Date: 2019-01-05 15:11:57
Message-ID: CAKk9fdW51WTRdczSp1c7ddhK2+hLLe1q_a8jg8ict2jq5iMdvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks for the tip - we'll look into enabling the page checksums as well.

On Thu, Jan 3, 2019 at 1:08 PM Stephen Frost <sfrost(at)snowman(dot)net> wrote:
>
> Greetings,
>
> * Phil Hildebrand (phil(dot)hildebrand(at)moz(dot)com) wrote:
> > Data page checksum version: 0
>
> You really might want to consider fixing that and using some tool to
> regularly check the checksums of all the pages in the cluster, to
> hopefully catch something like this happening again sooner than you
> might otherwise, and while you still have backups you can go to and
> restore the data from.
>
> Thanks!
>
> Stephen

--
Phil Hildebrand
Sr. DBE @ Moz
206.696.3413

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-01-05 17:09:40 Re: BUG #15446: Crash on ALTER TABLE
Previous Message Dean Rasheed 2019-01-05 12:11:45 Re: BUG #15446: Crash on ALTER TABLE