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
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
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
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
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
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/
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