[Koha] No search results?

[Seth Mayo]

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




On 20 September 2012 00:47, Mark Tompsett <mtompset at 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
>