PDA

View Full Version : What to do when the database is corrupt?



hemnewb
06-27-2011, 10:50 AM
I tried checking my disk to see if that fixed my import problem, now when I open HEM I get this message:

"The following error occurred when trying to open the database: ERROR: XX001: could not read block 33 of relation base/16397/2619: read only 0 of 9182 bytes."

It's not a very helpful error message.

What am I supposed to do now?

Patvs
06-27-2011, 01:36 PM
Open dbcontrolpanel.exe (in the HoldemManager folder), create a new database: Options--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager

and reimport your hands.

hemnewb
06-29-2011, 09:42 AM
Thanks.

I've done that, but get exactly the same error message when it tries to connect to the database (except this time it's block 20).

I expect I need to purge postgre and reinstall it. Are there any instructions how to do this (I don't want to leave large unused files on my system).

Patvs
06-29-2011, 09:58 AM
Which PostgreSQL version were you using?

Read: http://faq.holdemmanager.com/categories/Frequently+Asked+Questions/PostgreSQL/

First try reinstalling PostgreSQL. (the same version you were using)
If it fails install a different version to a different port, for example SQL 9.0 to port 5433 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

hemnewb
06-29-2011, 11:20 AM
Thanks.

I completely uninstalled postgresql and deleted its folder. Then installed the latest version from the web site, and set it up with the same password in the HoldEm Manager dialog.

Now everything works fine.

:)

hemnewb
06-29-2011, 11:21 AM
Which PostgreSQL version were you using?


8.0 something - the one that gets installed by the HEM combo installer. I only installed it a month or so ago when I changed PCs.

netsrak
06-30-2011, 04:32 AM
Thats 8.4 :)

hemnewb
06-30-2011, 04:39 AM
That was it. Anyway it's gone now. Now I've got 9.something and everything's working fine. Thanks for your help :)