Sudden random and giant sql reads that cause system freeze?

Comments

8 comments

  • Avatar
    Marc

    PS I'm currently on build 17.1 and will be updating it to 17.4 when I do the new drive change.

     

    0
    Comment actions Permalink
  • Avatar
    Chris Muench

    I would recommend posting to dba.stackexchange.com and post your server specs and my.ini file

     

    you might want to consider Linux also

    0
    Comment actions Permalink
  • Avatar
    Marc

    I went ahead and changed out the hard drive first for the new Samsung 883 DCT and have not seen a freeze yet in several days so far.  fingers crossed.

    0
    Comment actions Permalink
  • Avatar
    Chris Muench

    I think I found issue. It was garbage collector on app files. It gets triggered once out of 1000 queries. In latest 17.4 it has been fixed (phppos.com/downloads.php)

    0
    Comment actions Permalink
  • Avatar
    Marc

    Awesome! so just replacing that file in my 17.4 build from the current download build should fix it?

     

    0
    Comment actions Permalink
  • Avatar
    Chris Muench

    yes

    0
    Comment actions Permalink
  • Avatar
    Marc

    Thank you!  I'll let you know

     

    0
    Comment actions Permalink
  • Avatar
    Marc

    Wanted to give a good long test period.  We have not seen the freezes since updating. Thanks!

    0
    Comment actions Permalink

Please sign in to leave a comment.