[Koha] Koha slows and searches fail

[Jonathan Druart]

Hello,

I would focus on indexer-output.log and the "Connection refused" error.
How often this error appears?

When you feel that "it is slow", did you try to `htop` and see which
processes were consuming the resources (ram and/or cpu, maybe IO as
well)?

The following error seems related to local changes (maybe OPACUserJS),
but that should not cause you performance issues (unless it appears
dozen of times per request?):
    [cgi:error]: script not found or unable to stat:
    /usr/share/koha/opac/cgi-bin/opac/Maritime law.

Regards,
Jonathan

Le ven. 8 mai 2020 à 10:26, cjf <cjf at wmu.se> a écrit :
>
> Hi,
>
> So I've installed a fresh version of koha (19.11) using the Debian package
> install instructions and then migrated over a database from another koha
> install.
>
> It seemed that it all went well but I am not noticing the respond time of
> koha dramatically slows throughout the day, and searches start to produce no
> results, both in staff and OPAC. Turning the machine off and on again seems
> to solve the issue for a while.
>
> I've checked some logs and there are no errors in zebra.log however
> opac-error.log is overflowing with the following errors:
>
> [cgi:error] AH01215: [Fri May  8 07:18:43 2020] opac-detail.pl: Use of
> uninitialized value $query_cond in concatenation (.) or string at
> /usr/share/koha/lib/C4/ShelfBrowser.pm line
> 180.:/usr/share/koha/opac/cgi-bin/opac/opac-detail.pl
>
> [cgi:error]: script not found or unable to stat:
> /usr/share/koha/opac/cgi-bin/opac/Maritime law.
> [Fri May 08 07:55:52.300494 2020] [cgi:error] AH01215:
> [Fri May  8 07:55:52 2020] opac-detail.pl: Use of uninitialized value
> $subs[2] in join or string at
> /usr/share/perl5/MARC/Field.pm line 646.:
> /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl
>
> Also this error in indexer-output.log
>
> DBI connect failed: Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (111 "Connection refused") at
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.
>
> Any pointers would be great
>
> Thanks for your help
>
>
>
>
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha