From: R, Siva <sivasubr@amazon.com>
To: Peter Geoghegan <pg@bowt.ie>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun
Date: Tue, 4 Sep 2018 22:45:17 +0000
Message-ID: <1536101117759.63175@amazon.com> (raw)
In-Reply-To: <CAH2-WzneRxhYubPMh-x0L7h_1iH5kddVH5HWx2RFWKh=ELdgzw@mail.gmail.com>
References: <1536091151804.6588@amazon.com>
<CAH2-WzneRxhYubPMh-x0L7h_1iH5kddVH5HWx2RFWKh=ELdgzw@mail.gmail.com>
Hi Alexander!
On Tue, Sep 4, 2018 at 09:16 PM, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
> Do you have a test scenario for reproduction of this issue? We need
> it to ensure that fix is correct.
Unfortunately, I do not have a way of reproducing this issue.
So far I have tried a workload consisting of inserts (of the
same attribute value that is indexed), batch deletes of rows
and vacuum interleaved with engine crash/restarts.
Hi Peter!
On Tue, Sep 4, 2018 at 09:55 PM, Peter Geoghegan <pg@bowt.ie> wrote:
> I wonder how you managed to detect it in the first place. Were you
> using something like wal_consistency_checking=all, with a custom
> stress-test?
We observed this corruption during stress testing and were
able to isolate the corrupted page and WAL record changes
leading up to the corruption using some internal diagnostic
tools.
Best
Siva
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: sivasubr@amazon.com, pg@bowt.ie, a.korotkov@postgrespro.ru
Subject: Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun
In-Reply-To: <1536101117759.63175@amazon.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox