Re: bug of recovery? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: bug of recovery?
Date
Msg-id CA+U5nMJz3iH2S=D3kh9-4+Def0MaZwrPsRVD7UH1GXvffGKLEA@mail.gmail.com
Whole thread Raw
In response to Re: bug of recovery?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Tue, Sep 27, 2011 at 6:54 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:

> I think you're mixing this up with the multi-page page split operations in
> b-tree. This is different from that. What the "invalid_page_tab" is for is
> the situation where you for example, insert to a page on table X, and later
> table X is dropped, and then you crash. On WAL replay, you will see the
> insert record, but the file for the table doesn't exist, because the table
> was dropped. In that case we skip the insert, note what happened in
> invalid_page_tab, and move on with recovery. When we see the later record to
> drop the table, we know it was OK that the file was missing earlier. But if
> we don't see it before end of recovery, we PANIC, because then the file
> should've been there.

OK, yes, I see. Thanks.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: bug of recovery?
Next
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] Fix Leaky View Problem