ERROR: 57014 when optimizing Database

[#1ThunderFan]

I am getting the error message "ERROR: 57014: canceling statement due to user request" when trying to optimize my database. Any suggestions?

[netsrak]

We are working on a new version of the optimization process, its still a beta. Please try our latest release http://www.holdemmanager.com/downloads/Holdem_Manager_Beta.exe

[#1ThunderFan]

After upgrading from Beta 16 to Beta 17 the issue was resolved and I was able to run the optimizer successfully. Thank you.

[ash0803]

I am getting the error message "ERROR: 57014: canceling statement due to user request" when trying to optimize my database. Any suggestions?

I still get this error when using the latest release. Any ideas?

[ExConfessor]

Also some users have this error when trying to import PT3 database (HM 1.11.05a).

[netsrak]

Please add some more informations about your system configuration and security software, postgresql version etc.

[ash0803]

Please add some more informations about your system configuration and security software, postgresql version etc.

Using Windows 7 x64, MS Security Essentials, Windows Firewall, Postgres 8.4. About normally about 2-3M hands in DB before I i do a purge and optimize.

Never had any problems doing a full vacuum and analyze in pgadmin III but the HM built-in optimize has never worked for me and I have tried every time.

My db password is postgrespass as default but I my dbs have custom names but no special characters.

Let me know if there's anything else you need.

Oh, it comes up with the user cancelled request error about 10 minutes in quite consistently. No logs seemed to have been dumped

[chofw]

Also some users have this error when trying to import PT3 database (HM 1.11.05a).
I have this problem.



Please add some more informations about your system configuration and security software, postgresql version etc.
Windows XP SP2

Dr.Web Antivirus, Windows Firewall

Postgres 8.3

[gm66]

Getting error with beta 18.

[morny]

Thanks were looking into these issues, not happening to everyone so trying to narrow down whats causing it

[louiscyphre]

I have the same problem:

Win7 x64, Windows Firewall, Avast Antivirus, HEM 1.11.05a

This is the complete error message

"error: FEHLER: 57014: storniere Anfrage wegen Benutzeraufforderung[11/7/2010 1:45 PM] error: bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
bei Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
bei Npgsql.NpgsqlConnector.ReleaseRegisteredListen()
bei Npgsql.NpgsqlConnector.ReleaseResources()
bei Npgsql.NpgsqlConnectorPool.UngetPooledConnector(Np gsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleasePooledConnectorI nternal(NpgsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleasePooledConnector( NpgsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleaseConnector(Npgsql Connection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnection.Close()
bei HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
bei HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[11/7/2010 1:45 PM] Error...please contact support@holdemmanager.com"

[netsrak]

Please mail the details to support@holdemmanager.com:
- error message
- operating system
- postgresql version
- firewall
- antivirus scanner
- other security software

We are just trying to identify the source of the problem.

[louiscyphre]

I updated to 1.11.05b and I still get the same error:

error: FEHLER: 57014: storniere Anfrage wegen Benutzeraufforderung[11/15/2010 12:42 AM] error: bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
bei Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
bei Npgsql.NpgsqlConnector.ReleaseRegisteredListen()
bei Npgsql.NpgsqlConnector.ReleaseResources()
bei Npgsql.NpgsqlConnectorPool.UngetPooledConnector(Np gsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleasePooledConnectorI nternal(NpgsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleasePooledConnector( NpgsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleaseConnector(Npgsql Connection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnection.Close()
bei HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
bei HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[11/15/2010 12:42 AM] Error...please contact support@holdemmanager.com

[netsrak]

We are just collection informations from people with this problem.
Please send a mail with the error message and all informations about your installation (operating system, virus scanner, firewall, etc.) to support@holdemmanager.com
Please add a link to this thread too.

[Azalin]

I am having the same problem.

I have created a new database (postgresql 8.4) and imported 1,3 mil hands and then when I try to use optimize (full) I get same error.

I use 1.11.07a HEM, windows 7 x64 ultimate (all updates), Kaspersky Pure latest (exceptions on hem import, hem exe, hem hud).

Postgresql is already tuned. Are there any updates on this issue? Vaccuum analyze works normally using pgadmin.

[Patvs]

Vacuum/Analyse in pgadminIII is the same as "optimizing database in HM"
So just use pgadminIII instead.