PDA

View Full Version : Optimize Database Error



mjleden
02-19-2011, 05:25 PM
Hello

Im getting an Error Message when I try to optimize my database (Standard or Full). I have copied the sequence below. Im using Windows 7 64Bit.

[19/02/2011 2:09 PM] Reading databases . .done
[19/02/2011 2:10 PM] Starting optimization
[19/02/2011 2:10 PM] Optimizing HEM 1...[19/02/2011 2:18 PM] error: ERROR: 57014: canceling statement due to user request[19/02/2011 2:18 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()[19/02/2011 2:18 PM] Error...please contact support@holdemmanager.com

Any Ideas?
Thanks!

RDB
02-19-2011, 08:09 PM
Instead of using the optimization tool just manually vacuum/analyse/reindex the database in pgadminIII, read:

http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+