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