Need help with Koha instance that refuses to do checkouts
Dear Koha Community Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries. We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months. Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of the CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU. I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in the log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK. *Any advice on how to debug or fix this would be greatly appreciated.* Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help. Thanks and Best Regards, Chris Brown (Voluntary Libraries in Sheffield)
Hi Chris I don't know whether this will help (the details don't exactly match) but there was a bug posted last year (https://www.mail-archive.com/search?l=koha-bugs@lists.koha-community.org&q=subject:%22%5C%5BKoha%5C-bugs%5C%5D+%5C%5BBug+23690%5C%5D+During+checkout%2C+window+hangs+with+a+pop+up+%5C%22Loading...you+may+continue+scanning.%5C%22%22&o=newest&f=1) that made the checkout window hang with a pop up window "Loading ... you may continue scanning" - does this sound like your problem? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library@dml.vic.edu.au | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Chris Brown Sent: Monday, 21 June 2021 4:42 PM To: koha <koha@lists.katipo.co.nz> Subject: [Koha] Need help with Koha instance that refuses to do checkouts Dear Koha Community Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries. We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months. Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of the CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU. I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in the log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK. *Any advice on how to debug or fix this would be greatly appreciated.* Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help. Thanks and Best Regards, Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Sorry I'm no expert either but did you check if there are any suspicious slow queries? https://www.a2hosting.com/kb/developer-corner/mysql/enabling-the-slow-query-... By setting the time to a very low number you get almost tracing... but then again you could probably use a better way to track all queries. Am 21.06.21 um 08:42 schrieb Chris Brown:
Dear Koha Community
Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries.
We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months.
Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of the CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU.
I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in the log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK.
*Any advice on how to debug or fix this would be greatly appreciated.*
Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help.
Thanks and Best Regards,
Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
hi Chris did you try Katrin's suggestion?, it is the most likely problem https://lists.katipo.co.nz/pipermail/koha/2021-June/056338.html try loading your database into a test system, and experiment by removing likely issuing rules until you find your problematic rule cheers, Mason On 21/06/21 6:42 pm, Chris Brown wrote:
Dear Koha Community
Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries.
We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months.
Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of the CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU.
I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in the log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK.
*Any advice on how to debug or fix this would be greatly appreciated.*
Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help.
Thanks and Best Regards,
Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi James, Yes I did follow up Katrin's suggestion but found nothing that looked obviously wrong, and anyway I don't think there have been any configuration changes since well before the problem first showed up. Following another suggestion *we have cleared the browser caches on all our client machines and everything seems to be working again*. I have no idea why, and am not convinced that the problem isn't going to come back at some point. But all is well at the moment. Which leads me to a question I've been meaning to ask for a while ... *does Koha use cookies?* My thanks to all who suggested solutions. Much appreciated! Chris Brown (Voluntary Libraries in Sheffield) On Mon, Jun 21, 2021 at 10:46 AM Mason James <mtj@kohaaloha.com> wrote:
hi Chris did you try Katrin's suggestion?, it is the most likely problem https://lists.katipo.co.nz/pipermail/koha/2021-June/056338.html
try loading your database into a test system, and experiment by removing likely issuing rules until you find your problematic rule
cheers, Mason
Dear Koha Community
Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries.
We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months.
Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of
On 21/06/21 6:42 pm, Chris Brown wrote: the
CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU.
I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in the log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK.
*Any advice on how to debug or fix this would be greatly appreciated.*
Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help.
Thanks and Best Regards,
Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Chris, yes, it does. Documentation can be found here: https://wiki.koha-community.org/wiki/Use_of_Cookies Hope this helps, Katrin On 21.06.21 21:26, Chris Brown wrote:
Hi James,
Yes I did follow up Katrin's suggestion but found nothing that looked obviously wrong, and anyway I don't think there have been any configuration changes since well before the problem first showed up. Following another suggestion *we have cleared the browser caches on all our client machines and everything seems to be working again*. I have no idea why, and am not convinced that the problem isn't going to come back at some point. But all is well at the moment.
Which leads me to a question I've been meaning to ask for a while ... *does Koha use cookies?*
My thanks to all who suggested solutions. Much appreciated!
Chris Brown (Voluntary Libraries in Sheffield)
On Mon, Jun 21, 2021 at 10:46 AM Mason James <mtj@kohaaloha.com> wrote:
hi Chris did you try Katrin's suggestion?, it is the most likely problem https://lists.katipo.co.nz/pipermail/koha/2021-June/056338.html
try loading your database into a test system, and experiment by removing likely issuing rules until you find your problematic rule
cheers, Mason
Dear Koha Community
Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries.
We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months.
Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of
On 21/06/21 6:42 pm, Chris Brown wrote: the
CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU.
I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in the log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK.
*Any advice on how to debug or fix this would be greatly appreciated.*
Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help.
Thanks and Best Regards,
Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Katrin, Thanks for that. Interesting to learn about Koha's use of cookies. Doesn't that mean that Koha should present a popup to ask for a user's consent? The ICO (which monitors data protection compliance in the UK) says: "You must tell people if you set cookies, and clearly explain what the cookies do and why. You must also get the user’s consent. Consent must be actively and clearly given. There is an exception for cookies that are essential to provide an online service at someone’s request (eg to remember what’s in their online basket, or to ensure security in online banking)." Is there a feature in Koha that does this that I don't know about? Best Regards, Chris Brown (Voluntary libraries in Sheffield) Best Regards, Chris Brown On Mon, Jun 21, 2021 at 8:59 PM Katrin Fischer <katrin.fischer.83@web.de> wrote:
Hi Chris,
yes, it does. Documentation can be found here:
https://wiki.koha-community.org/wiki/Use_of_Cookies
Hope this helps,
Katrin
Hi James,
Yes I did follow up Katrin's suggestion but found nothing that looked obviously wrong, and anyway I don't think there have been any configuration changes since well before the problem first showed up. Following another suggestion *we have cleared the browser caches on all our client machines and everything seems to be working again*. I have no idea why, and am not convinced that the problem isn't going to come back at some point. But all is well at the moment.
Which leads me to a question I've been meaning to ask for a while ... *does Koha use cookies?*
My thanks to all who suggested solutions. Much appreciated!
Chris Brown (Voluntary Libraries in Sheffield)
On Mon, Jun 21, 2021 at 10:46 AM Mason James <mtj@kohaaloha.com> wrote:
hi Chris did you try Katrin's suggestion?, it is the most likely problem https://lists.katipo.co.nz/pipermail/koha/2021-June/056338.html
try loading your database into a test system, and experiment by removing likely issuing rules until you find your problematic rule
cheers, Mason
Dear Koha Community
Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries.
We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months.
Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of
On 21/06/21 6:42 pm, Chris Brown wrote: the
CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU.
I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in
On 21.06.21 21:26, Chris Brown wrote: the
log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK.
*Any advice on how to debug or fix this would be greatly appreciated.*
Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help.
Thanks and Best Regards,
Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
*> There is an exception for cookies that are essential to provide an online* *service at someone’s request (eg to remember what’s in their online basket,or to ensure security in online banking).* Those are the only cookies Koha uses by default, unless you do something like adding the Google Analytics script to your theme. Separately, the EU Cookie banners are the worst idea ever. Pretty much every site has them and shows a banner, and because every site shows the banner users are conditioned to do the first thing to just make it go away. The banners are an annoyance to users, they are annoyance to developers, and they don't provide any meaningful improvements in privacy. A complete failure at pretty much every level. Joel Coehoorn Director of Information Technology York College of Nebraska On Tue, Jun 22, 2021 at 1:41 AM Chris Brown <chris@stayawake.co.uk> wrote:
Hi Katrin,
Thanks for that. Interesting to learn about Koha's use of cookies. Doesn't that mean that Koha should present a popup to ask for a user's consent? The ICO (which monitors data protection compliance in the UK) says:
"You must tell people if you set cookies, and clearly explain what the cookies do and why. You must also get the user’s consent. Consent must be actively and clearly given. There is an exception for cookies that are essential to provide an online service at someone’s request (eg to remember what’s in their online basket, or to ensure security in online banking)."
Is there a feature in Koha that does this that I don't know about?
Best Regards,
Chris Brown (Voluntary libraries in Sheffield)
Best Regards,
Chris Brown
On Mon, Jun 21, 2021 at 8:59 PM Katrin Fischer <katrin.fischer.83@web.de> wrote:
Hi Chris,
yes, it does. Documentation can be found here:
https://wiki.koha-community.org/wiki/Use_of_Cookies
Hope this helps,
Katrin
Hi James,
Yes I did follow up Katrin's suggestion but found nothing that looked obviously wrong, and anyway I don't think there have been any configuration changes since well before the problem first showed up. Following another suggestion *we have cleared the browser caches on all our client machines and everything seems to be working again*. I have no idea why, and am not convinced that the problem isn't going to come back at some point. But all is well at the moment.
Which leads me to a question I've been meaning to ask for a while ... *does Koha use cookies?*
My thanks to all who suggested solutions. Much appreciated!
Chris Brown (Voluntary Libraries in Sheffield)
On Mon, Jun 21, 2021 at 10:46 AM Mason James <mtj@kohaaloha.com> wrote:
hi Chris did you try Katrin's suggestion?, it is the most likely problem https://lists.katipo.co.nz/pipermail/koha/2021-June/056338.html
try loading your database into a test system, and experiment by removing likely issuing rules until you find your problematic rule
cheers, Mason
Dear Koha Community
Following up my post on 12 June I am repeating my call for help as Koha is effectively unusable right now at one of our libraries.
We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha instances for some of the volunteer-run libraries in Sheffield. It has been stable and working fine for many months.
Currently we have a serious problem with one of these instances. Any attempt to check out a book hangs (never completes) and we see /usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of
On 21/06/21 6:42 pm, Chris Brown wrote: the
CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was renew.pl consuming all the CPU.
I have tried disabling plack for this instance, and have rebuilt the zebra index, but the problem persists. There is nothing obvious reported in
On 21.06.21 21:26, Chris Brown wrote: the
log files, though I may not be looking in the right places. I cannot see any obvious problems with the configuration, though again I might be looking at the wrong things. The other 4 instances are working OK.
*Any advice on how to debug or fix this would be greatly appreciated.*
Does anyone know how to turn on tracing of MySQL transactions? I was wondering if looking at the activity at the database end might help.
Thanks and Best Regards,
Chris Brown (Voluntary Libraries in Sheffield) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (6)
-
Carlos Lopez -
Chris Brown -
Coehoorn, Joel -
Franz Dietrich -
Katrin Fischer -
Mason James