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
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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for your help, For the big issue: 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. I took a look at processes running and opac_search.pl (can't remember the exact name) was using a lot of power. Finally solved using this fix disabling the unix_socket: https://mariadb.com/kb/en/authentication-plugin-unix-socket/ It seemed to be creating a bottleneck eventually killing the server. No further issues since switching back to password authentication. Thanks again Christina -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
participants (2)
-
cjf -
Jonathan Druart