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

From Brendan Duddridge
Subject Re: page is uninitialized?
Date
Msg-id 16A5FF32-F96E-4047-93B4-C10314062435@clickspace.com
Whole thread Raw
In response to page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
Responses Re: page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
Re: page is uninitialized?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Shortly after posting this message, I received the following error also:

PANIC:  right sibling is not next child in "category_product__is_active_idx"
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Are the two related in anyway? I'm starting to feel like my database is falling apart at the seams.

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com 

On Apr 19, 2006, at 2:16 AM, Brendan Duddridge wrote:

Hi,

I was doing a vacuum analyze verbose on my database today and I noticed the following message printed out:

WARNING:  relation "category_product" page 128979 is uninitialized --- fixing
WARNING:  relation "category_product" page 128980 is uninitialized --- fixing
WARNING:  relation "category_product" page 128981 is uninitialized --- fixing
WARNING:  relation "category_product" page 128982 is uninitialized --- fixing

Could that be due to updates occurring at the same time as vacuuming? There was a heavy process running
at the time that was updating the category_product table.

Thanks,


____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com 


pgsql-general by date:

Previous
From: Brendan Duddridge
Date:
Subject: page is uninitialized?
Next
From: Brendan Duddridge
Date:
Subject: Re: page is uninitialized?