Re: page is uninitialized?

It turns out I had a bad index on my category_product table. I
dropped the index, then reindexed the whole table, then I was
able to successfully vacuum analyze.

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 | brendan(at)clickspace(dot)com

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

http://www.clickspace.com

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

> 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(at)clickspace(dot)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(at)clickspace(dot)com
>>
>> ClickSpace Interactive Inc.
>> Suite L100, 239 - 10th Ave. SE
>> Calgary, AB T2G 0V9
>>
>> http://www.clickspace.com
>>
>