Import stopped working

[mathrawka]

I was in the middle of an import, and then it just stopped and was unable to progress. I restarted my computer, but the import is not working anymore, via auto-import or import by file.

On my SQL server I get this error:

2009-04-19 21:53:01 JST ERROR:  canceling statement due to user request
2009-04-19 21:53:01 JST STATEMENT:  Update Settings Set SettingValue = '28160448' where SettingName = 'MaxPlayerHandID'
2009-04-19 21:53:08 JST ERROR:  current transaction is aborted, commands ignored until end of transaction block
2009-04-19 21:53:08 JST STATEMENT:  set datestyle to sql, mdy;
2009-04-19 21:53:18 JST LOG:  could not receive data from client: Connection reset by peer
2009-04-19 21:53:18 JST LOG:  unexpected EOF on client connection

Thanks.

[mathrawka]

I get this popup error as well:

"Player Hand Error: Connection establishment timeout. Increase Timeout value in ConnectionString. Please e-mail support@holdemmanager.net and let us know what version of PostgreSQL you are running."

This has been running fine for awhile, and just started tonight.

I have Hold'em Manager 1.08 beta 27.
And psql 8.3.5

Thanks.

[morny]

Can you try creating a new database http://www.holdemmanager.net/faq/afm....aspx?faqid=31 and update to http://www.holdemmanager.com/downloads/HmOmaha.exe and see if the problem persists

[mathrawka]

Hi Morny,

I did a VACUUM on my database, and after that it started working again.

Maybe put that in the FAQ?

Thanks!

Jon