Timeouts

[armonica]

About every other day HM stop working while is autoimporting or it does not even open, and every time I have to reboot.
In every case I get the following error message:

''The following error occurred when trying to open the database. A timeout has occurred. If you were establishing a connection,
increase Timeout value in ConnectionString. If you were executing a command increase a CommandTimeout value in ConnectionString
or in your NpgsqCommand object.''

I am using version 1.11.04 on Windows 7, and play on FT, UB, Titan, Cake and Carbon.

I allready applied most of the tweeks suggested in the performance & speed tweeks FAQ's including:

Windows Firewall and AV exceptions
VACUUM + REINDEX database
increase shared_buffers and effective_cache_size values.

Maybe I should try to increase the Timeout value in ConnectionString and
CommandTimeout value in ConnectionString as suggested in the error message, but how do I do that?

Please help. it is really frustrating having HM working only 50% of the time +
missing a big chunk of the hands I play.

[Patvs]

update to http://www.holdemmanager.com/downloads/Hm_1.11.05_Beta.exe



For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab. Or (preferred) turn off UAC completely and reboot.

Which SQL version are you using?

Can you reset the increase shared_buffers and effective_cache_size values. values back to its original values and:


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.

[armonica]

I am using SQL 8.4 and I tried everything you suggested, but I am still getting
random timeouts that force me to reboot.

[Patvs]

Update SQL to 8.4.4


read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html


set exceptions for postgres.exe, holdemmanager.exe to the firewall.
also try creating a new empty database

[armonica]

where do I find SQL 8.4.4?

[netsrak]

PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

[armonica]

on the PostgreSQL website I could only find version 9.0 to download,
but the SQL doesn't automatically upgrade when installing the latest version of HM?

[Patvs]

EnterpriseDB: Download PostgreSQL Installers (http://www.enterprisedb.com/products/pgdownload.do#windows)

[armonica]

I installed SQL 8.4.4 but unfortunately nothing has changed, still getting timeouts.

[Patvs]

Did you create a NEW empty database?

also add exceptions for postgres.exe and holdemmanager.exe to your firewall.

[armonica]

I already added exceptions for postgres.exe and holdemmanager.exe to my firewall, and I created a new empty database.

When I start HM on the top line it shows DATABASE: MY_new database.

Whwn I open the Database Control Panel it shows 3 database:
holdemmanager (HoldemManager)
DB1 (which is the new empty database that I created)
MY_new database (HoldemManager) DEFAULT DATABASE

[Patvs]

Are some of the changes you made to postgresql.conf still in effect?

Try installing SQL to a different portnumber.
I installed SQL 9.0 RC to port 5433 yesterday (to test if 9.0 would work for HM) and so far it seems really stable.

[armonica]

The changes I made to postgresql.conf are still there:
shared_buffers = 896MB
effective_cache_size = 1792MB

I also changed to port 5433 and I will be trying it today.

I wonder if I should try to make some change to this parameter:
authentication_timeout = 1min # 1s-600s

[armonica]

Tried with port 5433 but made no difference, timeout on the first try.

How about trying to change values in this string?
authentication_timeout = 1min # 1s-600s

[netsrak]

You can try it but i don't think its the solution. Something on your computer is slowing down the connection between Postgresql and Holdemmanager.
Is your computer very old and slow?
Or is there anything else which might block network connections or use the same connections (like another database software)?

[armonica]

My computer is less than a year old and when I bought it was top of the line
with 8GB of RAM, and no I don't have any other database running.

At this point just for lack of alternatives I will try to change the timeout value, but should I increase it or decrease it?

[Patvs]

Change shared_buffers = 896MB
effective_cache_size = 1792MB

back to default