PDA

View Full Version : Manual Vacuum : "failed to re-find parent key"



Ggrognon
01-25-2009, 01:58 PM
Hi all,

I know this is not the pgadmin support forum here, but you may be able to help me. I run a manual vacuum. At the end of the process I had this sentence :

ERROR: failed to re-find parent key in index "playerhandsflop_pkey" for split pages 3229/3230


Is it something I should worry about ? Or is it OK and my base is vacuum-ed and I can continue with HEM ?


Thx for helping

morny
01-25-2009, 02:39 PM
Sounds like theres something wrong with one of the indexes, folow this FAQ and see if it repairs it http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168 and if not then I think you should probably export the HH from the database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and then reimport the hands

Ggrognon
01-25-2009, 05:36 PM
You are so helpful ! Thanks for all what you do.

I applied exactly what was explained in the link to rebuild the concerned index, and now everything is ok, vacuum ended successfully.


That is a support, believe me !