PDA

View Full Version : XX001 error message. Database and reports not working.



Teahupoo
01-17-2010, 04:45 AM
Hey there.

While opening my cash game reports page, I got the following error message.

"ERROR: XX001: could not read block 2 of relation 1663/16403/16662: read only 0 of 8192 bytes"

The first time I tried it said I only had one hand recorded, then the second time it seems the reports page froze and the cursor is stuck on the 'loading' circle.

The HUD works fine and still shows previous stats. I have updated to the latest beta version.

Cheers in advance.

netsrak
01-17-2010, 07:43 AM
Your database is corrupt and your harddisk can be damaged too.

You should first try to fix it with a reindex via pgadmin -> maintenance.

Run chkdsk on your harddisk too.

And i would recommend to do backups and save the original handhistories and export all hands as backup too.

Teahupoo
01-17-2010, 08:30 AM
Thanks for the quick reply. I have done both and nothing much has changed unfortunately, except for the fact that it is recording new hands into my reports. When I click on 'this year' it has started recording hands since I did the re-index, but I still get the error message when I click on 'all hands' and my reports are empty. These were the last few lines after the re-index. Any recommendations for further lines of action?


reindexedNOTICE: table "playerhandsflop" was reindexedNOTICE: table "playerhandsturn" was reindexedNOTICE: table "playerhandsriver" was reindexedNOTICE: table "players" was reindexedNOTICE: table "playervsplayer" was reindexedNOTICE: table "pokerhands" was reindexedNOTICE: table "compiledplayerresults" was reindexedNOTICE: table "compiledplayerresultspositionaction" was reindexedNOTICE: table "postflopactions" was reindexedNOTICE: table "compiledresults" was reindexed
ERROR: invalid page header in block 0 of relation "compiledplayerresults_month"

ERROR: invalid page header in block 0 of relation "compiledplayerresults_month"

fozzy71
01-17-2010, 02:12 PM
Try a new DB.

*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/afmviewfa
q.aspx?faqid=21

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



If that doesn't work, you will probably have to try reinstalling postgresql.

Please reinstall PostgreSQL using these steps - http://forums.holdemmanager.com/showthread.php?t=20755