Optimize Database Error
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Dec 2010
    Posts
    12

    Default Optimize Database Error

    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!

  2. #2
    Moderator RDB's Avatar
    Join Date
    Feb 2011
    Posts
    444

    Default

    Instead of using the optimization tool just manually vacuum/analyse/reindex the database in pgadminIII, read:

    http://faq.holdemmanager.com/questio...lyze+Database+

Similar Threads

  1. Cannot optimize database
    By steve_cordy@live.com in forum Manager General
    Replies: 1
    Last Post: 01-29-2011, 09:06 PM
  2. Optimize Reports Error
    By Roroelcoco in forum Manager General
    Replies: 4
    Last Post: 10-09-2008, 05:16 PM
  3. Optimize Reports Error
    By PkrPoen in forum Manager General
    Replies: 6
    Last Post: 09-29-2008, 05:51 PM
  4. ERROR: 23505 during optimize reports
    By Hooorny in forum Manager General
    Replies: 2
    Last Post: 09-27-2008, 11:54 PM
  5. optimize reports error
    By dragecq in forum Manager General
    Replies: 1
    Last Post: 09-26-2008, 03:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •