PDA

View Full Version : Unable to optimize db



kane2
01-12-2011, 06:41 PM
Made 2 attempts and both ended the same. A popup said that it was canceled at user's request(which isnt true). 1st attempt was a full and the 2nd was a standard. I just finished a 3rd attempt which was quick. The quick one worked. But would still like to do a full optimize so PLZ HELP!

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

Patvs
01-13-2011, 03:45 AM
Instead of using the optimization tool, just manually vacuum/analyse/reindex... and if necessary make edits to postgresql.conf

Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html