Skip site navigation (1) Skip section navigation (2)

Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby
Date: 2010-10-28 05:20:56
Message-ID: 4CC90838.2000409@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-bugs
I'm seeing this on a Pitrtools managed warm standby box that we 
periodically bring the db fully up on in order to test if the standby is 
good.

After the standby is up, then a db wide VACUUM produces:

2010-10-28 17:20:51 NZDT WARNING:  relation "node" page 248500 is 
uninitialized --- fixing
2010-10-28 17:20:51 NZDT WARNING:  relation "node" page 248502 is 
uninitialized --- fixing
2010-10-28 17:20:51 NZDT WARNING:  relation "node" page 248504 is 
uninitialized --- fixing
2010-10-28 17:20:54 NZDT ERROR:  left link changed unexpectedly in block 
21042 of index "content_node_node_type_id_inserted_idx"

I'm guessing the index error is due to the uninitialized table pages 
(the index "content_node_node_type_id_inserted_idx" is on the "node" 
table). Are the uninitialized pages cause for concern, or merely an 
artifact of log shipping?

The is 8.3.11 on Debian Lenny x86-64.

Thanks

Mark

Responses

pgsql-bugs by date

Next:From: Dharmendra GoyalDate: 2010-10-28 08:34:12
Subject: Re: BUG
Previous:From: Craig RingerDate: 2010-10-27 23:22:23
Subject: Re: BUG #5730: The database cluster initialization failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group