PDA

View Full Version : Connection error



Jeffrey Lin
10-17-2009, 10:21 AM
I use the latest HM version 1.09 beta 40 . When I tried to purge hands, I met below error. I have about 1 million hands in database.

Connection establishment timeout. Increase Timeout value in ConnectionString

I used window XP and have added HM and postgreSQL in the exception list of firewall.

fozzy71
10-17-2009, 11:15 AM
Please try to purge a smaller date range.

You could also try some other basic DB maintenance to improve the overall performance, which may allow for an easier/larger purge.


I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

Jeffrey Lin
10-17-2009, 11:35 AM
All these are maintaining and improving the performance, but not directly solve my problem. I do a search and find this problem have happened many times before. How did they solve it?


Please try to purge a smaller date range.

You could also try some other basic DB maintenance to improve the overall performance, which may allow for an easier/larger purge.


I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

Jeffrey Lin
10-17-2009, 02:09 PM
I try to purge a small amount(about 100k hands), it work fine. This seem to be the issue of HM part, because the connection request and the timeout vaule was sent by HM. If the purge work can be done in sertain time, the error will not happen. Do it right?

fozzy71
10-17-2009, 03:29 PM
All these are maintaining and improving the performance, but not directly solve my problem. I do a search and find this problem have happened many times before. How did they solve it?

The solved it by purging smaller amounts.


I try to purge a small amount(about 100k hands), it work fine. This seem to be the issue of HM part, because the connection request and the timeout vaule was sent by HM. If the purge work can be done in sertain time, the error will not happen. Do it right?

I believe that timeout value has many reasons for causing the purge to not work. If you want a technical explanation I can find out the reasoning for it from the developer, but the simple solution is to do smaller chunks of work. This is also much easier on your PC.