Re: Failures with wal_consistency_checking and 13~

2020-06-21 Thread Michael Paquier
On Sat, Jun 20, 2020 at 05:43:19PM +0300, Alexander Korotkov wrote: > I have discovered and fixed the issue in a44dd932ff. spg_mask() > masked unused space only when pagehdr->pd_lower > > SizeOfPageHeaderData. But during the vacuum regression tests, one > page has been erased completely and pageh

Re: Failures with wal_consistency_checking and 13~

2020-06-20 Thread Alexander Korotkov
On Sat, Jun 20, 2020 at 1:16 PM Alexander Korotkov wrote: > On Fri, Jun 19, 2020 at 10:34 PM Alvaro Herrera > wrote: > > > > On 2020-Jun-15, Michael Paquier wrote: > > > > > I have begun my annual study of WAL consistency across replays, and > > > wal_consistency_checking = 'all' is pointing out

Re: Failures with wal_consistency_checking and 13~

2020-06-20 Thread Alexander Korotkov
On Fri, Jun 19, 2020 at 10:34 PM Alvaro Herrera wrote: > > On 2020-Jun-15, Michael Paquier wrote: > > > I have begun my annual study of WAL consistency across replays, and > > wal_consistency_checking = 'all' is pointing out at some issues with > > at least VACUUM and SPGist: > > FATAL: inconsist

Re: Failures with wal_consistency_checking and 13~

2020-06-19 Thread Alvaro Herrera
On 2020-Jun-15, Michael Paquier wrote: > I have begun my annual study of WAL consistency across replays, and > wal_consistency_checking = 'all' is pointing out at some issues with > at least VACUUM and SPGist: > FATAL: inconsistent page found, rel 1663/16385/22133, forknum 0, > blkno 15 > CONTEXT

Re: Failures with wal_consistency_checking and 13~

2020-06-15 Thread Michael Paquier
On Mon, Jun 15, 2020 at 11:33:42PM -0300, Ranier Vilela wrote: > With Postgres 13, Windows 10 (home), msvc 2019 64 bits, > Shutting down, without interrupting the database, consistently, this log > has appeared. > > 2020-06-15 21:40:35.998 -03 [3380] LOG: database system shutdown was > interrupte

Re: Failures with wal_consistency_checking and 13~

2020-06-15 Thread Ranier Vilela
Em seg., 15 de jun. de 2020 às 10:14, Michael Paquier escreveu: > Hi all, > > I have begun my annual study of WAL consistency across replays, and > wal_consistency_checking = 'all' is pointing out at some issues with > at least VACUUM and SPGist: > FATAL: inconsistent page found, rel 1663/16385/

Failures with wal_consistency_checking and 13~

2020-06-15 Thread Michael Paquier
Hi all, I have begun my annual study of WAL consistency across replays, and wal_consistency_checking = 'all' is pointing out at some issues with at least VACUUM and SPGist: FATAL: inconsistent page found, rel 1663/16385/22133, forknum 0, blkno 15 CONTEXT: WAL redo at 0/739CEDE8 for SPGist/VACUUM