From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | 10RC1 crash testing MultiXact oddity |
Date: | 2017-09-22 15:37:54 |
Message-ID: | CAMkU=1y-TNP_7JdFg_ubXqDB8esMO280aCDGDwsa429HRtE8Lw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
0002-pg_burn_multixact-utility_v10.patch | application/octet-stream | 6.8 KB |
count.pl | application/octet-stream | 10.6 KB |
crash_REL11.patch | application/octet-stream | 12.8 KB |
do.sh | application/x-sh | 4.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2017-09-22 15:43:24 | Re: CREATE COLLATION does not sanitize ICU's BCP 47 language tags. Should it? |
Previous Message | Tom Lane | 2017-09-22 15:02:30 | Re: !USE_WIDE_UPPER_LOWER compile errors in v10+ |