PDA

View Full Version : Postgres Problem with Optimization



Sharper Tools
12-27-2010, 02:42 PM
I uploaded a lot of hands so I wanted to optimize the DB by running the Optimization utility from your menu. I received the following "contact support" error. What should I do next?

[12/27/2010 1:09 PM] Reading databases . . . . . .done
[12/27/2010 1:09 PM] Starting optimization
[12/27/2010 1:09 PM] Optimizing HEM...[12/27/2010 1:17 PM] error: ERROR: 57014: canceling statement due to user request[12/27/2010 1:17 PM] error: at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
at Npgsql.NpgsqlConnector.ReleaseRegisteredListen()
at Npgsql.NpgsqlConnector.ReleaseResources()
at Npgsql.NpgsqlConnectorPool.UngetPooledConnector(Np gsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleasePooledConnectorI nternal(NpgsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleasePooledConnector( NpgsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleaseConnector(Npgsql Connection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnection.Close()
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[12/27/2010 1:17 PM] Error...please contact support@holdemmanager.com

netsrak
12-28-2010, 06:21 AM
Are you using 1.11.05e? http://www.holdemmanager.com/Downloads/HmUpdate.exe

What is your system configuration? OS, Postgresql Version?

It may be necessary to manually optimize your database via pgadmin->maintenance->vacuum/full and reindex
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)

Alex0r
12-29-2010, 12:22 PM
i got the same problem;


[29/12/2010 15:59] Reading databases .done
[29/12/2010 16:00] Starting optimization
[29/12/2010 16:00] Optimizing holdemmanager...[29/12/2010 16:08] error: ERROR: 57014: canceling statement due to user request[29/12/2010 16:08] error: at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
at Npgsql.NpgsqlConnector.ReleaseRegisteredListen()
at Npgsql.NpgsqlConnector.ReleaseResources()
at Npgsql.NpgsqlConnectorPool.UngetPooledConnector(Np gsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleasePooledConnectorI nternal(NpgsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleasePooledConnector( NpgsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleaseConnector(Npgsql Connection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnection.Close()
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[29/12/2010 16:08] Error...please contact support@holdemmanager.com


[29/12/2010 16:09] Starting optimization
[29/12/2010 16:09] Optimizing holdemmanager...[29/12/2010 16:17] error: ERROR: 57014: canceling statement due to user request[29/12/2010 16:17] error: at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
at Npgsql.NpgsqlConnector.ReleaseRegisteredListen()
at Npgsql.NpgsqlConnector.ReleaseResources()
at Npgsql.NpgsqlConnectorPool.UngetPooledConnector(Np gsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleasePooledConnectorI nternal(NpgsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleasePooledConnector( NpgsqlConnection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnectorPool.ReleaseConnector(Npgsql Connection Connection, NpgsqlConnector Connector)
at Npgsql.NpgsqlConnection.Close()
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[29/12/2010 16:17] Error...please contact support@holdemmanager.com

tried both full then standard optimisation using 1.11.05e.

on decent spec win7 machine, postgreSQL 8.4

netsrak
12-30-2010, 10:08 AM
Seems like your postgresql version doesn't support this optimization process.

You should do a manual vacuum/full via pgadmin