Koha slows and searches fail

classic Classic list List threaded Threaded
3 messages Options
cjf
Reply | Threaded
Open this post in threaded view
|

Koha slows and searches fail

cjf
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
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]> 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
> [hidden email]
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
cjf
Reply | Threaded
Open this post in threaded view
|

Re: Koha slows and searches fail

cjf
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
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha