error when puring observed HH
Results 1 to 7 of 7
  1. #1
    Senior Member
    Join Date
    Aug 2010
    Posts
    201

    Default error when puring observed HH

    hello
    I have the latest version of HM
    I have a really bigged DB with alot of mined hands, and just started to try to optimize it for performance. >So my plan was to purge observed HH at first step, then rebuild index and analyze vacuum and such..

    but when i try to purge observed HH I get this after a long while of nothing happening:

    There was an error during the Purge: A timeout has occured. If you were establishing a connection, increase Timeout value in ConnectionString. If you were executing a command, increate the CommandTimeout value in ConnectionString or in your NpgsqlCommand object.

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Which SQL version are you using?
    Read:
    http://forums.holdemmanager.com/mana...ease-tips.html
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  3. #3
    Senior Member
    Join Date
    Aug 2010
    Posts
    201

    Default

    ihave 8.4
    Ive read those performance tips.
    I even searched the forums and found that u should try it on a smaller sample if u have a large database. I did, still didnt work.
    i run HEM as admin as well.

  4. #4
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Edit the postgresql.conf file assigning more RAM to SQL. Make sure NO program (i.e firewall/antivirus) is monitoring the SQL server.

    So add postgres.exe and port 5432 to the Windows Firewall exceptions list.. and add the ENTIRE postgreSQL (and HoldemManager) folder to the anti virus exception list.


    Try to update your SQL to 8.4.7 from PostgreSQL: The world's most advanced open source database.
    You get no errors when you vacuum/reindex the database in pgadminIII?


    If you do get ANY error:
    As a test, install PostgreSQL 9.0.3 to port 5433.
    Only import a couple of handshistories (both observed HH + hands containing a hero) to check if you still get the error when purging hands.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  5. #5
    Senior Member
    Join Date
    Aug 2010
    Posts
    201

    Default

    I have 768mb assigned to postsql through the omptimise guide.
    I get no errors when database vacuum and analysing
    I have now added it in windows firewall as well but honestly doubt that would change anything. no other antivirus or firewall active during processes either..

    the only thing left is to update postgres:
    Download PostgreSQL | EnterpriseDB

    since I have win64, does that mean i should go for the Version 9.0.3-1 directly?

  6. #6
    Senior Member
    Join Date
    Aug 2010
    Posts
    201

    Default

    Ohh wait.. now it worked for some reason..
    the solution was either that I made a psql vacuum/analyze of the database.
    or that I allowed postgres.exe through windows firewall manually..

    dont know which one was doing the magic..

    thank you
    Last questions are to be sure:
    1. purging observed handhistory: does it work to choose an alias for "do not delete hand histories played by" ?
    2. if I purge from here. stats should not go away from peoples HUD when I sit down with them, even though I purge all hands I mined with them in? only difference is I cannot open replayer and watch the hands right? but it still registered n the databse and show in the HUD that htey played checkraise on turn on 10 of the pruged hands for example..?


    cheers

  7. #7
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,718

    Default

    1. Alias works
    2. Yep

Similar Threads

  1. Replies: 2
    Last Post: 07-04-2010, 06:49 AM
  2. Error when purging observed HH
    By luking in forum Manager General
    Replies: 1
    Last Post: 02-22-2010, 12:05 PM
  3. FTP observed HHs
    By asaspades in forum Manager General
    Replies: 1
    Last Post: 08-05-2009, 02:23 PM
  4. Observed HHs
    By Ryanowski in forum Manager General
    Replies: 4
    Last Post: 07-27-2009, 06:43 AM
  5. observed HH
    By ASH22 in forum Manager General
    Replies: 1
    Last Post: 07-16-2009, 04:25 AM

Posting Permissions

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