PDA

View Full Version : HM doesn't start : Error XX001



pogojej
01-10-2010, 10:51 AM
After an electric cut, HM does'nt start :

"An error occurred while updating your DB (imported files) : ERROR: XX001: invalid page header in block 0 of relation «*pg_attrdef_adrelid_adnum_index*» Please close down any programs accessing the database and relaunch Holdem Manager."

Thank you for your help :)

Jerome

fozzy71
01-10-2010, 12:20 PM
Power outages and system crashes while importing are the most common cause of corrupt/damaged databases.

You can try to fix that individual index - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or you can try a general Reindex from the PGAdminIII Maintenance menu - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


If none of that helps you will have to create a new DB and/or reinstall postgresql.


*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754



If you still have problems, reinstall Postgresql - http://forums.holdemmanager.com/showthread.php?t=20755

pogojej
01-10-2010, 01:11 PM
it's good after an re-index, by pgAdminIII.
thank you