Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Thunder <thunder1(at)126(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node
Date: 2020-01-16 14:17:36
Message-ID: CAHGQGwEZVpOg_gUz-QUuy53Gekuj6bOi0gW=A=865fLLUHmQGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 17, 2019 at 2:19 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> On Mon, Dec 16, 2019 at 12:22:18PM +0900, Fujii Masao wrote:
> > > + Detection of WAL records having references to invalid pages during
> > > + recovery causes <productname>PostgreSQL</productname> to report
> > > + an error, aborting the recovery. Setting
> > > Well, that's not really an error. This triggers a PANIC, aka crashes
> > > the server. And in this case the actual problem is that you may not
> > > be able to move on with recovery when restarting the server again,
> > > except if luck is on your side because you would continuously face
> > > it..
> >
> > So you're thinking that "report an error" should be changed to
> > "trigger a PANIC"? Personally "report an error" sounds ok because
> > PANIC is one of "error", I think. But if that misleads people,
> > I will change the sentence.
>
> In the context of a recovery, an ERROR is promoted to a FATAL, but
> here are talking about something that bypasses the crash of the
> server. So this could bring confusion. I think that the
> documentation should be crystal clear about that, with two aspects
> outlined when the parameter is disabled, somewhat like data_sync_retry
> actually:
> - A PANIC-level error is triggered.
> - It crashes the cluster.

OK, I updated the patch that way.
Attached is the updated version of the patch.

Regards,

--
Fujii Masao

Attachment Content-Type Size
ignore_invalid_pages_v3.patch application/octet-stream 4.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2020-01-16 14:38:46 Re: [PATCH v1] pg_ls_tmpdir to show directories
Previous Message Georgios Kokolatos 2020-01-16 14:07:36 Re: Duplicate Workers entries in some EXPLAIN plans