Problem Postgres

[Galoper]

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]

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]

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]

Yes