PDA

View Full Version : After 'Failed to establish' only todays hands are shown



pilz
12-14-2009, 08:26 PM
Hi,

During my session today my client Everest froze and I think it was because of HM/postgress. After rebooting HM didn't start because of 'failed to establish connections'. I did the following:

Start > Programs > PostgreSQL > 8.x > Stop Service
Start > Programs > PostgreSQL > 8.x > Start Service
----
1. Go to Start > Control Panel > Administrative Tools > Services.
2. Scroll to PostgreSQL Database Server and make sure it’s started and if not, right click on PostgreSQL Database Server and choose start as seen below and try again.

Didn't really help.

After this I restarting my PC and during startup this Defragmentation thing organized and deleted some files or so. Then I went back to HM 1.09.03. When I openend HM it said something like 'Unable to read data...' but now I could choose a DB (choose my default) and HM started normally. However I only found 400 hands (today I even played more) and obv all filters were cleared. However the Players tab shows 26k players >> Players (26000)

I'm using Windows XP and HM beta 1.10.3b, and after restart 1.09.03 when only 400 hands were shown. Using Windows Firewall and Avast (both working, however I got a quick warning that Firewall wasn't working but then I checked and it worked properly)

What to do? Do I need to reimport all my hands again (pfff)? Or can I do something else? Thanks in advance!

fozzy71
12-14-2009, 10:17 PM
It sounds like your DB was damaged when it crashed. You should still be able to export the hands from the DB. You should hopefully have most of them saved already in your \hmarchive. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=56


Try creating a new DB. If the new DB doesn't act properly, you may need to completely reinstall postgresql.


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

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


If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.