moremember.pl shows high CPU usage after upgrade to 3.14
Hi all, After upgrading our system to 3.14, things are generally great, with the exception of this one issue. Loading the moremember.pl page for patrons with overdues takes upwards of 20 seconds, and top shows that the script is completely hogging the CPU. Patrons without overdues load just fine. My first thought was that it was doing some kind of crazy db query, but mysqld doesn't seem to be using any more resouces than usual while this is happening. Has anybody else experienced this? Any suggestions? -- Jason Sherman Systems Librarian University of Science and Arts of Oklahoma 405.574.1340
Hello Jason, Do you have a lot of holidays defined? If yes, try to upgrade to 3.14.2 (see bug 11112) Regards, Jonathan http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11112 2014/1/8 Jason Sherman <jsherman@usao.edu>
Hi all,
After upgrading our system to 3.14, things are generally great, with the exception of this one issue. Loading the moremember.pl page for patrons with overdues takes upwards of 20 seconds, and top shows that the script is completely hogging the CPU. Patrons without overdues load just fine. My first thought was that it was doing some kind of crazy db query, but mysqld doesn't seem to be using any more resouces than usual while this is happening. Has anybody else experienced this? Any suggestions?
-- Jason Sherman Systems Librarian University of Science and Arts of Oklahoma 405.574.1340 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Jason, On Wed, Jan 8, 2014 at 6:29 AM, Jason Sherman <jsherman@usao.edu> wrote:
After upgrading our system to 3.14, things are generally great, with the exception of this one issue. Loading the moremember.pl page for patrons with overdues takes upwards of 20 seconds, and top shows that the script is completely hogging the CPU. Patrons without overdues load just fine. My first thought was that it was doing some kind of crazy db query, but mysqld doesn't seem to be using any more resouces than usual while this is happening. Has anybody else experienced this? Any suggestions?
What version were you running before you upgraded? Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
participants (3)
-
Galen Charlton -
Jason Sherman -
Jonathan Druart