PDA

View Full Version : Repeating Connection error



rickpereira7
10-07-2012, 08:12 PM
This has happened 4 times in the last month; I will turn on HEM1 and i will get a "cannot connect to 127.0.0.1.

I go through all the steps found on the forum and it fixed it once. All the other times i had to uninstall and install again making me lose all prior hands. Having to import them take me 2-3 days too so i have to play with less info. I dont understand why it keeps happening though and dont want a few dasy fix again.

Has this happened to anyone else? What can i do? Is it time to change to HEM2?

udbrky
10-07-2012, 11:41 PM
You might need to reinstall postgres. Download the same version you are running from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

Then uninstall yours and install the one you just downloaded.

rickpereira7
10-08-2012, 07:16 PM
I have done that a few times, most didnt work, but the only time that it worked, my whole database was gone and had to redo everything anyway so it was as good as nothing really.

Any idea as to why it keeps doing this, and how i can fix it?

Patvs
10-08-2012, 08:34 PM
Which Operating System, Firewall, and Anti-Virus are you using?

Which PostgreSQL version were you using?


Try installing SQL 8.2 to a new port: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
Add the port to the exceptions list of Windows Firewall.

rickpereira7
10-08-2012, 08:38 PM
Windows 7, Firewall switched off. Use AVG but have turned it off when this happens, but when it works AVG is on and with no interference.

When installing that, will i have to change the port on which HEm connects? Will this prevent future "collapses"?

rickpereira7
10-08-2012, 08:40 PM
Any specific port number i should pick?

Patvs
10-08-2012, 08:43 PM
Turn on the Windows Firewall.
Add pg_ctl.exe, postgres.exe and the portnumber (for example port: 5432) to its exceptions list.

Then try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely.
Ideally, install a different version of PostgreSQL than you were using before, installing it to a different port.
The downside of this is, you'll have to reimport all your hands into a new empty database. The upside is it will prevent this happening in the future.

Patvs
10-08-2012, 08:43 PM
5433, 5434, pick an unused port.

rickpereira7
10-15-2012, 12:49 AM
Did all this, seemed to be updating everything but now everytime i turn it on it optimzes and gives me this warning:

ERROR: XX002: index "pokerhands_pkey" is not a btree

And it doesnt keep adding the new hands of the players and i cant see the stats for a player on that table cos of this too. Some players just get stuck on 0 hands all tournament.

Sarek
10-15-2012, 02:38 PM
Which HM1 build do you use?
Latest is this
http://www.holdemmanager.com/Downloads/HmUpdate_Release_1.12.11_09Oct2012.exe

rickpereira7
10-16-2012, 08:58 AM
Which HM1 build do you use?
Latest is this
http://www.holdemmanager.com/Downloads/HmUpdate_Release_1.12.11_09Oct2012.exe

yep thats what i have got. and even if i was a few days behind on the update dont think it would stop importing, right? Also, everytime i start hem it optimizes reports for same players and gives that error above.

Sarek
10-16-2012, 12:32 PM
1) As we discovered, 09 oct build has EV bug - so is recommended to revert to 10 sept build
http://www.holdemmanager.com/Downloads/HmUpdate_Release_1.12.11_10Sep2012.exe

2) Try to uninstall (not only disable) antivirus\firewall and see what happens

rickpereira7
10-16-2012, 09:59 PM
1) As we discovered, 09 oct build has EV bug - so is recommended to revert to 10 sept build
http://www.holdemmanager.com/Downloads/HmUpdate_Release_1.12.11_10Sep2012.exe

2) Try to uninstall (not only disable) antivirus\firewall and see what happens
how will a EV bug do this. It doesnt import hands....

rickpereira7
10-16-2012, 10:04 PM
still doing the same thing fwiw

udbrky
10-16-2012, 10:50 PM
1) Please close HM

2) Please open PGAdminIII

It is in the Start -> Postgres folder.

3) Enter your postgres password. The default password is typically postgrespass.

4) Open the databases.

5) Highlight your database.

6) Right click, click maintenance.

7) Run the vacuum and analyze and reindex functions.

http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

Please try again.

Sarek
10-17-2012, 04:05 AM
how will a EV bug do this. It doesnt import hands....

This is just warning. To prevent your next post "EV do not works" :)

rickpereira7
10-17-2012, 05:17 PM
Thanks for the help Sarek