PDA

View Full Version : Problem with importing hands, my database crashed



Krzysiek
02-25-2009, 01:28 PM
I have a problem with import hands. When i'm importing all hands are duplicate, but i playing in real time and handhistory folder is empty.

I know i can fix this by creating new database, but i lose my all imported hands. I tried to solve this problem by export hands from old database and import to the new, but when i did that there appeared:An error ocurrerd reading the hand history:invalid page header in block 652 of relation pokerhands " and next : "all histories have been exported to c:\...\hand_history_export_holdem manager5 folder" . When i started HM and press "imported from folder" (holdem manager5- which is also a name of my database with duplicate hands problem), there was being imported some hands, but i cant see this stats in cash game, i see only new stats of my opponents.

Please help, i dont want to start collecting my opponets hands from the begining

Al1
02-25-2009, 04:01 PM
Can you try to reindex "pokerhands" and tell me if it works: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Try also to move your exported hands in another folder and try to reimport.

Krzysiek
02-26-2009, 11:23 AM
reindex doest work: "index rebulding has failed ERROR XX001: invald page header in block 1001 of relation "playerhandscashkeycolumns".
The holdem manager5 folder is empty, i tried reexport again and holdem manager5 folder is still empty.

Krzysiek
02-27-2009, 04:43 PM
is there anyone who help me?

Al1
02-28-2009, 01:23 PM
is there anyone who help me?

Can you stop the postgreSQL service and reboot your computer. Then restart it, reboot your computer and try to export your Hands from your corrupted DB one more time:
http://www.holdemmanager.net/faq/afmmain.aspx?faqid=34
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Krzysiek
03-01-2009, 08:38 AM
still doesnt work, it looks like databse is damaged, but how get back all stats. I want to say thats not first time, when i lose all my hands history becouse of database crashed. Its wird becouse erevything is fine for month, and suddenly holdem maganer starts duplicate hands, and i lose all stats. its very annoying. You sholud solve this problem

morny
03-01-2009, 10:26 AM
The 2 most common causes of this problems are 1) powering off your computer or having your computer lose power while the database is doing something and 2) an old drive with bad sectors on it. Basically what happens is a small portion of a file gets slightly corrupt and then when you reboot and windows goes into that checkdsk procedure it finds the bad section and, thinking it is doing a good thing, removes it. Postgres then loads the table and a portion of it is gone so it doesn’t like that and blocks access to the entire table. Normally when this happens it is on a completely useless file that you'll never even notice is now gone and quite often it will happen to an index in the DB which can easily be rebuilt but in your case it happened to a system table.

So, to protect against this

1) keep you hands histories in case you do need to reimport
2) use a power bar and avoid hard shutdowns (when you flick the power switch on the pc)
3) if your drive is old consider replacing it with a new one. They are cheap and much faster now than even a few years ago.

Depending on how bad it is damaged you might be able to export the hands http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 and if it gives an error when you do this youll need to reimport your hands from the archive as the data in the database will be unretrievable