[Koha] Need help with Koha instance that refuses to do checkouts
Franz Dietrich
dietrich at teilgedanken.de
Mon Jun 21 19:16:27 NZST 2021
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-log-in-mysql
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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
More information about the Koha
mailing list