Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun
R, Siva <sivasubr@amazon.com>
From: "R, Siva" <sivasubr@amazon.com>
To: Peter Geoghegan <pg@bowt.ie>,
Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2018-09-04T22:45:17Z
Lists: pgsql-hackers
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
Commits
-
Fix past pd_upper write in ginRedoRecompress()
- 35ea98f79af2 9.4.20 landed
- e950c6c9db0e 9.5.15 landed
- f9e66f2fbbb4 9.6.11 landed
- bccfd381707b 10.6 landed
- cc909ddbfb48 11.0 landed
- 5f08accdad2b 12.0 landed