error retrieving player list: xx001: block 2465

[asherkramer@hotmail.com]

hello,

i upgraded hm yesterday and it worked fine for a few hours. however, it started
giving me the following error message:an error occured when retrieving the player list: error xx001: invalid page header in block 2465 of relation "players."

the players are all gone from the db now too.

i see no index called players, but i tried reindexing those with the word player in the name. nothing has worked. what can i do?

i also tried making a new db, which is really my least choice worthy option as i have so much manually entered info which i cant seem to retrieve off the original db.

any help appreciated. thanks.

[morny]

Im afraid the database is corrupt and i suspect it will give errors exporting the hands too but you can try http://www.holdemmanager.net/faq/afm...aspx?faqid=173 but you could also use the hands in the archive and reimport those into the new database but unfortunately youll lose manually entered info

[asherkramer@hotmail.com]

so i made a new db, imported the hands, and lost all manually entered info. now i get the same error message, and all my players are gone, again. this is obviously reallly annoying and i dont know what to do. everything was fine, and now im registered in like 30 tourneys for sunday, with another corrupt db, and not time to reimport my hands again, especially as the new db will be corrupted again.

[morny]

You can export the summaries to via the Data View column, select all the tourneys and right click and choose export summaries and results and import this into the new database

If your getting multiple corruptions thought it looks like a problem on your end. 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 one or more of the tables.

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.

I use HM almost everyday for the last year or more, i import more hands than probably anyone else as i have to test them daily for people with problems, i change versions more regularly than most people, i mine from 2 seperate computers into my database that mine 24hours a day and i also play poker regularly and ive never had a corrupt one yet using 2 different PCs so its not a problem with HM

[asherkramer@hotmail.com]

thanks for your reply. im pretty sure the answer to my question is no, but its worth a shot. is there a way to get my manually entered info (notes and tourney results) from the corrupt dbs?

[asherkramer@hotmail.com]

well it must have been the sudden powering off that corrupted my dbs as my computer just froze, and upon powering it off with the button, my newest db crashed. i have no idea why the laptop is freezing though....no viruses or stuff like that. also, do you think HM may be causing my ftp to crash? this is what ftp suggested in their reply to me.

[morny]

How often does it happen? Maybe try playing with HM off for a while, have you checked the event viewer for the times of the freeze crash might give some indication whats causing the problem, it would be easy for me to blame FTP but if this was a HM thing we would have tons of threads since FT is one of our biggest customer bases so its most likely something else or a combination of some programs on your system and the best way is to narrow it down by using only Full Tilt and test for a while, then use FT and HM, then use just FT another program you run regularly etc etc

When i say only FT and another program i mean close absolutely everything including ahk scripts, msn, firewalls and antiviruses, everything

[asherkramer@hotmail.com]

thanks...i will try your suggestion..think it might be messenger. im pretty sure the answer to my question is no, but its worth a shot. is there a way to get my manually entered info (notes and tourney results) from the corrupt dbs?

[morny]

Im not sure if it will just give errors when you try it but give it a shot

Tourneys TAB > Results > Data View > Right click all the tourneys and choose export tourney results and summaries

[asherkramer@hotmail.com]

when i tried to export the summaries from the corrupt dbs, there were no players in the list for me to choose from. and the error is something like "relation players." do you think there is a way for me to get the players to show?