PDA

View Full Version : Error in new DB



JPonline
06-09-2011, 01:50 PM
Hi.

when doing the "optimize full" i get the error below.

I am running Windows7 x64. (latest updates done yesterday)
Postgres version "postgresql-9.0.4-1-windows_x64"
HEM version 1.11.06g. (all necessary files are set to be run as admin)
Changes in postgresql.config: shared_buffers is set to 768MB and Effective_cache:size to 1536MB. Logging collector is off. no other changes.
All postgres and HEM files (even the complete folders) are added in the exceptions of a) Antivirus b) Windows firewall (which is turned off anyway).
No further software installed, that monitors/filters[etc] network traffic, or HDD throughput.


This is a brand new postges install.
The Database is completely new (around 5GB). I only imported my HMArchive and some bought HHs (little, max 300k)

help please :)

Kind Regards Julius





[09.06.2011 19:16] Reading databases .done
[09.06.2011 19:16] Starting optimization
[09.06.2011 19:16] Optimizing upswing...[09.06.2011 19:36] error: FEHLER: 57014: storniere Anfrage wegen Benutzeraufforderung[09.06.2011 19:36] error: bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
bei Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
bei Npgsql.NpgsqlConnector.ReleaseRegisteredListen()
bei Npgsql.NpgsqlConnector.ReleaseResources()
bei Npgsql.NpgsqlConnectorPool.UngetPooledConnector(Np gsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleasePooledConnectorI nternal(NpgsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleasePooledConnector( NpgsqlConnection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnectorPool.ReleaseConnector(Npgsql Connection Connection, NpgsqlConnector Connector)
bei Npgsql.NpgsqlConnection.Close()
bei HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
bei HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[09.06.2011 19:36] Error...please contact support@holdemmanager.com

Patvs
06-09-2011, 06:42 PM
The optimization tool only works with SQL 8.4.

If you want to perform maintenance on your SQL 9.0 database use pgadminIII instead.

JPonline
06-09-2011, 06:49 PM
Oh, ok. thank you.