Re: page is uninitialized?
От | Brendan Duddridge |
---|---|
Тема | Re: page is uninitialized? |
Дата | |
Msg-id | 3F9A6583-E5A4-4D7A-BDA7-AD09E17B23CB@clickspace.com обсуждение исходный текст |
Ответ на | Re: page is uninitialized? (Brendan Duddridge <brendan@clickspace.com>) |
Список | pgsql-general |
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@clickspace.com
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9
http://www.clickspace.com
____________________________________________________________________
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: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 unexpectedlyThis probably means the server terminated abnormallybefore 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.comOn 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 --- fixingWARNING: relation "category_product" page 128980 is uninitialized --- fixingWARNING: relation "category_product" page 128981 is uninitialized --- fixingWARNING: relation "category_product" page 128982 is uninitialized --- fixingCould that be due to updates occurring at the same time as vacuuming? There was a heavy process runningat 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 по дате отправления: