Thanks for all the pointers to potential problems :-) Here's what I've found... The mysqld database is running fine - the error in the log was an old entry. Memory is at 200MB+ free out of 1.5GB and the swap is barely touched. Our rebuild-zebra.pl has always run as root - both in the cron job and manually. It has been this way for more than a year without problems. However, I chown'ed the path mentioned and then changed my cron jobs to run as koha instead of root and this did somehow bring back the zebra index. rebuild-zebra.pl now has the following errors though...which ones should I worry about and has anyone seen them before? 10:06:40-20/09 zebraidx(9341) [warn] Missing attribute 'type' in attribute info 10:09:18-20/09 zebraidx(9341) [warn] Unknown register type: 10:09:34-20/09 zebraidx(9351) [warn] Failed to open /var/lib/koha/zebradb/biblios/register/reci-0.mf [Permission denied] 10:09:34-20/09 zebraidx(9351) [fatal] mf_write: reci error (1) 10:09:34-20/09 zebraidx(9351) [fatal] write commit block 10:09:34-20/09 zebraidx(9351) [warn] zebra_commit: failed BTW the first 2 lines 'missing attribute' and 'unknown register' have always been there as long as I can remember so I'm guessing they aren't important. However, I would have expected zebra_commit: failed to mean I wouldn't have a working index but it seems that isn't the case. Do I need to change more permissions to make every 'koha' - if so, what paths? Otherwise, anything else I'm missing? Thanks for all your help! I really appreciate it! Seth Mayo IT Technical Manager Email: smayo@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 On 20 September 2012 00:47, Mark Tompsett <mtompset@hotmail.com> wrote:
Greetings,
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]
Mason James said:
your zebra files have incorrect permissions… (you ran rebuild-zebra.placcidentally as root?)
If your /etc/cron.d/koha file says "koha" as the user, then you need to: chown -R -v koha.koha /var/lock/koha and perhaps other directories too. The -v shows you what it is doing. The -R is recursive, so subdirectories and files get fixed too.
$ sudo su - koha $ <now run the reindex, and make sure the environment variables KOHA_CONF and PERL5LIB are set properly too>
koha-zebraqueue-output.log:
DBD::mysql::db commit failed: MySQL server has gone away at /usr/share/koha/bin/zebraqueue**_daemon.pl <http://zebraqueue_daemon.pl>line 135.
Oooo. I had this, it may be a low memory problem. If your system thinks a process is going to hog too much memory, it kills it. What does "free -m" say? If you have less than 55MB free and no swap, you are seriously up a creek. You need more memory.
We were running a machine with only 512MB of RAM with no swap. Needless to say, things were mysteriously failing. If you can't give Koha a machine with at least (and I'm saying this is still not really enough) 1GB, then you can expect these sorts of problems.
GPML, Mark Tompsett