View Full Version : Problem Postgres
Galoper
12-01-2009, 10:18 AM
I get the same error when i tried to vacuum or Analize or Reindex
ERROR: XX001: invalide page header in block 24674 of relation "handhistories".
This happend after i make a parcial purge hand using the option in the software.
How can i solve it?
fozzy71
12-01-2009, 12:53 PM
Your DB may have become corrupt/damaged.
You can try a Reindex in PGAdmin3's Maintenance menu.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
If that doesnt help you will probably have to rebuild the DB.
Please update to the latest version - http://www.holdemmanager.com/downloads/HmUpdate.exe
*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
Galoper
12-01-2009, 12:56 PM
Please update to the latest version - http://www.holdemmanager.com/downloads/HmUpdate.exe
I have 1.09 Beta 41
Must i make the update?
fozzy71
12-01-2009, 01:01 PM
Yes
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.