Postgres Pro
Downloads
Home   >   mailing lists

Re: page is uninitialized --- fixing - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: page is uninitialized --- fixing
Date
Msg-id 20080326193746.GL29730@alvh.no-ip.org
Whole thread Raw
In response to page is uninitialized --- fixing  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-general
Tree view 
Brad Nicholson wrote:
> We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
> switch out while it was under load), which caused the DB to crash.  It
> started up fine, when I vacuumed the DB, I saw the following messages.
>
> WARNING:  relation "my_table" page 652139 is uninitialized --- fixing
> WARNING:  relation "my_table" page 652140 is uninitialized --- fixing
> WARNING:  relation "my_table" page 652940 is uninitialized --- fixing
> WARNING:  relation "my_table" page 652941 is uninitialized --- fixing
>
> That sort of looks like it could be data loss, can someone explain what
> happened?

It means someone extended the table, but didn't get around to actually
putting tuples on it and committing.  Four transactions were doing this
when the system crashed.  No committed data was lost.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Next
From: Alvaro Herrera
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)