View Full Version : Error
tontobird
05-27-2009, 04:14 AM
I just started using my HEM again a couple of days ago after over 7 months of not playing poker due to a death in the family.
I use a different computer for poker and HEM, so hadn't used the computer in months.
So my windows found and installed a bunch of updates and ran a checkdisk. After the checkdisk I am getting this error when I attempt to see a report:
The following error occurred when running this report: ERROR: XX001: could not read block 0 of relation 1663/16865/17127: read 0 of 8192 bytes.
It was handling reports fine prior to this. And I did update to v1.08.04
Thank you.
morny
05-27-2009, 05:54 PM
Looks like the database is corrupt, try doing a vacuum http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163 and if that dosent solve it please export your hands from the old 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 reimport the hands into the new database
If its too corrupt to export the hands youll need to import your archived hands instead
tontobird
05-27-2009, 06:09 PM
Thanks morny, I don't remember my password, fabio last worked on my db thru teamviewer, what password would he likely have used?
morny
05-27-2009, 06:36 PM
most likely postgrespass maybe email him to see if you uses any other ones fabio@holdemmanager.net
tontobird
05-27-2009, 08:52 PM
Thanks morny that helped, it wasn't exact but it got me trying a couple of other things.
OK so I did the vacuum and am coming up with this error:
ERROR: invalid page header in block 19825 of relation "playerhandscashkeycolumns"
Then when I hit OK, it just keeps coming back to the same error.
What do I do with this?
morny
05-28-2009, 11:52 AM
Did you create the new database yet? If so did you restore the old corrupt database to it or something because it looks like its corrupt again?
tontobird
05-28-2009, 02:05 PM
No, I haven't yet created a new db, that was a result of the vacuum.
morny
05-28-2009, 04:33 PM
Yeah theres no point in trying to vacuum the database if your going exporting the hands, when you create the new database it should solve all the issues
tontobird
05-28-2009, 04:47 PM
Yes, but you'd suggested that I try to vacuum first and I was reporting the results of it.
I'll work on creating a new db next.
tontobird
05-29-2009, 08:44 AM
In attempting to export I got an error:
Error reading data: ERROR: XX001: invalid page header in block 12282 of relation "handhistories"
tontobird
05-29-2009, 08:57 AM
OK, a note came up saying that all of the hand histories and been exported.
tontobird
05-29-2009, 01:19 PM
All done, everything looks good, thanks.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.