PDA

View Full Version : Can't optimise database



Mickle
02-14-2011, 01:37 PM
I have the latest version (1.11.06a). I tried a full optimisation but got an error message stating user had cancelled the operation. I tried again with a quick optimisation. Same result. The full error message for the quick optimisation is pasted below. Please advise why this isn't working.

[14/02/2011 07:40] Reading databases .done
[14/02/2011 07:40] Starting optimization
[14/02/2011 07:40] Optimizing holdemmanager...[14/02/2011 08:31] error: ERROR: 57014: canceling statement due to user request[14/02/2011 08:31] 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()[14/02/2011 08:31] Error...please contact support@holdemmanager.com
[14/02/2011 08:31] Starting optimization
[14/02/2011 08:31] Optimizing holdemmanager...[14/02/2011 17:26] error: ERROR: 57014: canceling statement due to user request[14/02/2011 17:26] 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()[14/02/2011 17:26] Error...please contact support@holdemmanager.com

Patvs
02-15-2011, 05:59 AM
Which SQL version are you using?
Did you install it to the default installation folder?



Instead of using the optimization tool, just manually vacuum/analyse/reindex the database in pgadminIII, read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html