[HACKERS] 10RC1 crash testing MultiXact oddity - Mailing list pgsql-hackers

From Jeff Janes
Subject [HACKERS] 10RC1 crash testing MultiXact oddity
Date
Msg-id CAMkU=1y-TNP_7JdFg_ubXqDB8esMO280aCDGDwsa429HRtE8Lw@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] 10RC1 crash testing MultiXact oddity
Re: [HACKERS] 10RC1 crash testing MultiXact oddity
List pgsql-hackers
I am running some crash recovery testing against 10rc1 by injecting torn page writes, using a test case which generates a lot of multixact, some naturally by doing a lot fk updates, but most artificially by calling the pg_burn_multixact function from one of the attached patches.

In 22 hours of running I got 12 instances were messages like this appear:

MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 681012168 does not exist on disk

This is not a fatal error, and no inconsistent data is found at the end of the run.  But the code comments suggests that this should only happen on a server that has been upgraded from 9.3 or 9.4, which this server has not been.

Is the presence of this log message something that needs to be investigated further?

Thanks,

Jeff


Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] !USE_WIDE_UPPER_LOWER compile errors in v10+
Next
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] CREATE COLLATION does not sanitize ICU's BCP 47language tags. Should it?