PDA

View Full Version : database problem - erro r57014



CF23
01-11-2013, 06:12 PM
Hi HEM support
hoping you can help with this database issue.
yesterday i didn't shut down my computer properly (Windows Vista) and today when booting it recovered OK, after a while that is. computer is doing OK. then i started playing poker and noticed my HEM database seems to have been damaged!
i saw all stats for the regs on my tables in the HUD, but the number of hands on them said something super low.

so i tried a database optimisation, and then i saw this. it says cancelling due to user request, but i didn't do anything!


[11/01/2013 21:51] Reading databases . . . .done
[11/01/2013 21:52] Starting optimization
[11/01/2013 21:52] Optimizing HoldemManager...[11/01/2013 22:07] error: ERROR: 57014: canceling statement due to user request[11/01/2013 22:07] 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()[11/01/2013 22:07] Error...please contact support@holdemmanager.com

Sarek
01-12-2013, 01:30 PM
This feature in HM1 works only with postgres 8.4
You can do DB mainternance via PGadmin
http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+
Vacuum (full) frist, then Reindex also