literate-perfunctory
Poker Software
Results 1 to 6 of 6
  1. #1
    Senior Member
    Join Date
    Feb 2009
    Posts
    217

    Default Note creation hanging with message 'saving notes to database..'

    I have one database with about 250,000 hands where note creation works fine.

    I have added another database on the same machine where I have about 100k hands. On this database I was able to create all the notes on the first occasion. I then changed some definitions, reset all notes, and wanted to re-create, but now it gets stuck about 40k hands in.

    I have re-tested on the other database and on there it still completes the process fine after a reset.

    Any idea how I can debug why it is seemingly hanging? Hand importing is off atm, but I can see that holdemmanager.exe is taking 5-10% cpu in task manager, so it is clearly doing something. Just seems weird that it should suddenly take 30 minutes plus to do a save... The machine is powerful, plenty of available cpu, lots of memory, etc. I am running the 64 bit version of postgres, but I have done so without problems for 3+ years already.

  2. #2
    Senior Member
    Join Date
    Feb 2009
    Posts
    217

    Default

    Update on this... after an hour or so of showing 'saving to database' it continued on and made its way to the end of the processing of the 100k hands, however, again it gets stuck on the save operation at the end.

    After waiting for a long time I restarted HM2 and it restarted the processing around the 50k hand mark, made its way to the end but again never completed the saving operation.
    Last edited by tlukasha; 10-11-2017 at 06:18 PM.

  3. #3
    Senior Member
    Join Date
    Feb 2009
    Posts
    217

    Default

    Quote Originally Posted by tlukasha View Post
    Update on this... after an hour or so of showing 'saving to database' it continued on and made its way to the end of the processing of the 100k hands, however, again it gets stuck on the save operation at the end.

    After waiting for a long time I restarted HM2 and it restarted the processing around the 50k hand mark, made its way to the end but again never completed the saving operation.
    For what it is worth, I can see in the resource monitor that Postgres is writing to disk, but for some reason an operation that should take 10 minutes is taking multiple hours and in fact does not seem to complete at all.

  4. #4
    Senior Member
    Join Date
    Feb 2009
    Posts
    217

    Default

    Quote Originally Posted by tlukasha View Post
    For what it is worth, I can see in the resource monitor that Postgres is writing to disk, but for some reason an operation that should take 10 minutes is taking multiple hours and in fact does not seem to complete at all.
    The process did not complete overnight, but took 4-8 hours rather than the 4-8 minutes it took the previous day. What could cause such extreme degradation in performance?

  5. #5
    Senior Member
    Join Date
    Feb 2009
    Posts
    217

    Default

    Quote Originally Posted by tlukasha View Post
    The process did not complete overnight, but took 4-8 hours rather than the 4-8 minutes it took the previous day. What could cause such extreme degradation in performance?
    It 'DID' complete overnight I attempted to say..

  6. #6
    NoteCaddy sreticentv's Avatar
    Join Date
    Dec 2009
    Location
    No direction but to trust the final destination
    Posts
    6,298

    Default

    Which version of windows are you running? Windows 8+ lets you see how much of your drive drive bandwidth is being used via task manager. My guess is that should be hovering close to 100% during stalls like that. If not then there is likely some issue with hand histories causing a lot of errors. You can have a look at your notecaddy error logs which you'd find in

    C:\Users\{windowslogin}\AppData\Roaming\HoldemMana ger\NoteCaddyLogs

    If there is/are huge error log files then that's almost certainly the cause
    NoteCaddy Manual | Coaching Packs | Blog
    NoteCaddy experts: a.k.aAlso, Catalyst_Kh, Derders, karstenkloss, scoobediah (NoteCaddy Edge)

Similar Threads

  1. Replies: 8
    Last Post: 11-28-2013, 11:41 AM
  2. Replies: 3
    Last Post: 10-19-2013, 08:22 AM
  3. Note Creation Slower for New Database
    By Takezo in forum NoteCaddy
    Replies: 1
    Last Post: 10-07-2012, 08:16 AM
  4. new all database note creation no notes?
    By thekabalist in forum NoteCaddy
    Replies: 1
    Last Post: 11-29-2011, 05:14 AM
  5. Replies: 1
    Last Post: 06-07-2011, 11:08 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
  •