[Koha] No search results?

Thu Sep 20 01:36:25 NZST 2012

So I've found a really strange problem today...

After starting work we realised that Koha would not give search results for
any record in the database today.  This includes searches in the catalogue
and in the opac.

I've seen similar things before so I checked that zebrasrv and mysqld are
running...they are...even restarted the server a few times to prove they
would start and a reboot wouldn't make a difference...

I then told it to manually rebuild zebra - it seemed to do so fine but
still no change.  (Note: we have a cron that runs every 15 minutes and does
this rebuild anyway)

Looking at the log files I get the following.  If anyone has an idea,
please let me know - I'm out of them at the moment.

koha-error_log:
[Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:06 2012] circulation.pl: Use of uninitialized value in string gt at
/usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 464., referer:
http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:06 2012] circulation.pl: Use of uninitialized value in string gt at
/usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 464., referer:
http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:06 2012] circulation.pl: Use of uninitialized value in string gt at
/usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 464., referer:
http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:06 2012] circulation.pl: Use of uninitialized value in concatenation
(.) or string at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line
644., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:23 2012] circulation.pl: Reference found where even-sized list
expected at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 97.,
referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:23 2012] circulation.pl: Use of uninitialized value $print in string
eq at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 163.,
referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:23 2012] circulation.pl: Use of uninitialized value in string eq at
/usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 168., referer:
http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:23 2012] circulation.pl: Use of uninitialized value $print in string
eq at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 175.,
referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:23 2012] circulation.pl: Use of uninitialized value in hash element
at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 644., referer:
http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl
[Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19
14:27:23 2012] circulation.pl: Use of uninitialized value in concatenation
(.) or string at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line
644., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl

koha-opac_log:
[Wed Sep 19 13:32:53 2012] [error] [client 172.16.255.175] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer:
http://tux-koha.stpeters.nsw.edu.au/
[Wed Sep 19 13:33:29 2012] [error] [client 172.16.255.226] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer:
http://tux-koha.stpeters.nsw.edu.au/
[Wed Sep 19 13:35:30 2012] [error] [client 172.16.1.12] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/
[Wed Sep 19 13:35:30 2012] [error] [client 172.16.1.12] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/
[Wed Sep 19 13:35:33 2012] [error] [client 172.16.254.94] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/
[Wed Sep 19 13:51:05 2012] [error] [client 172.16.4.222] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer:
http://tux-koha.stpeters.nsw.edu.au/
[Wed Sep 19 14:07:30 2012] [error] [client 172.16.255.175] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer:
http://tux-koha.stpeters.nsw.edu.au/
[Wed Sep 19 14:44:29 2012] [error] [client 172.16.254.230] File does not
exist: /usr/share/koha/opac/htdocs/NoImage.png, referer:
http://tux-koha.stpeters.nsw.edu.au/
[Wed Sep 19 23:03:43 2012] [error] [client 172.16.1.1] File does not exist:
/usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/
[Wed Sep 19 23:03:51 2012] [error] [client 172.16.1.1] File does not exist:
/usr/share/koha/opac/htdocs/NoImage.png, referer:
http://tux-koha/cgi-bin/koha/opac-search.pl?q=101

koha-zebradaemon.err:
20120703 17:38:53 koha-zebra-ctl.kohadb: client (pid 850) killed by signal
15, stopping
20120703 17:39:41 koha-zebra-ctl.kohadb: client (pid 848) killed by signal
15, stopping
20120712 11:27:24 koha-zebra-ctl.kohadb: client (pid 884) killed by signal
15, stopping
20120806 08:42:55 koha-zebra-ctl.kohadb: client (pid 866) killed by signal
15, stopping
20120806 09:21:50 koha-zebra-ctl.kohadb: client (pid 876) killed by signal
15, stopping
20120918 15:16:03 koha-zebra-ctl.kohadb: client (pid 864) killed by signal
15, stopping
20120918 15:42:42 koha-zebra-ctl.kohadb: client (pid 837) killed by signal
15, stopping
20120918 16:21:31 koha-zebra-ctl.kohadb: client (pid 856) killed by signal
15, stopping
20120919 11:55:14 koha-zebra-ctl.kohadb: client (pid 889) killed by signal
15, stopping
20120919 22:51:23 koha-zebra-ctl.kohadb: client (pid 899) killed by signal
15, stopping

koha-zebradaemon-output.log:
22:07:15-19/09 zebrasrv(14) [warn] ir_session (exception)
22:07:20-19/09 zebrasrv(15) [warn] zebra_lock_create fail
fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied]
22:07:20-19/09 zebrasrv(15) [warn] zebra_lock_create fail
fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied]
22:07:20-19/09 zebrasrv(15) [warn] ir_session (exception)
22:07:25-19/09 zebrasrv(16) [warn] zebra_lock_create fail
fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied]
22:07:25-19/09 zebrasrv(16) [warn] zebra_lock_create fail
fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied]
22:07:25-19/09 zebrasrv(16) [warn] ir_session (exception)
23:03:50-19/09 zebrasrv(1) [warn] zebra_lock_create fail
fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied]
23:03:50-19/09 zebrasrv(1) [warn] zebra_lock_create fail
fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied]
23:03:50-19/09 zebrasrv(1) [warn] ir_session (exception)

koha-zebraqueue.err:
20120703 17:38:53 koha-zebraqueue-ctl-kohadb: client (pid 857) killed by
signal 15, stopping
20120703 17:39:41 koha-zebraqueue-ctl-kohadb: client (pid 868) killed by
signal 15, stopping
20120712 11:27:24 koha-zebraqueue-ctl-kohadb: client (pid 911) killed by
signal 15, stopping
20120806 08:42:55 koha-zebraqueue-ctl-kohadb: client (pid 875) killed by
signal 15, stopping
20120806 09:21:50 koha-zebraqueue-ctl-kohadb: client (pid 883) killed by
signal 15, stopping
20120918 15:16:03 koha-zebraqueue-ctl-kohadb: client (pid 876) killed by
signal 15, stopping
20120918 15:42:42 koha-zebraqueue-ctl-kohadb: client (pid 852) killed by
signal 15, stopping
20120918 16:21:31 koha-zebraqueue-ctl-kohadb: client (pid 881) killed by
signal 15, stopping
20120919 11:55:14 koha-zebraqueue-ctl-kohadb: client (pid 899) killed by
signal 15, stopping
20120919 22:51:23 koha-zebraqueue-ctl-kohadb: client (pid 905) killed by
signal 15, stopping

koha-zebraqueue-output.log:
DBD::mysql::db commit failed: MySQL server has gone away at
/usr/share/koha/bin/zebraqueue_daemon.pl line 135.
DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
758
DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
758
DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
758
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/share/koha/bin/zebraqueue_daemon.pl line 124.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at
/usr/share/koha/bin/zebraqueue_daemon.pl line 125.
DBD::mysql::db commit failed: MySQL server has gone away at
/usr/share/koha/bin/zebraqueue_daemon.pl line 135.
DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
758
DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
758
DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
758

Thanks,

Seth Mayo
IT Technical Manager
Email:  smayo at stpeters.nsw.edu.au
-------------------------------------------------------
St Peter's Anglican Primary School
Howe Street
Campbelltown NSW 2560
PH: 02 4627 2990
DID:  02 8203 1368
Website:  http://www.stpeters.nsw.edu.au