PDA

View Full Version : Optimization



allstars6
06-13-2011, 01:51 AM
Trying to do housekeeping on My HEM keep getting this

[6/12/2011 10:36 PM] Reading databases .done
[6/12/2011 10:36 PM] Starting optimization
[6/12/2011 10:36 PM] Optimizing holdemmanager...[6/12/2011 10:46 PM] error: ERROR: 57014: canceling statement due to user request[6/12/2011 10:46 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()[6/12/2011 10:46 PM] Error...please contact support@holdemmanager.com

Sarek
06-13-2011, 03:06 AM
This is a known issue with built-in optimization process (in some system configurations).
You can run a vacuum via pgadmin in the meantime http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+