Thanks for your help, Marc. We don't use zebra-daemon, as I think it's deprecated (are we wrong?). But I still forward your message to our server guy, maybe it will give him some clues.
Cheers, Sonia. > From: mtomp...@hotmail.com > To: sossola...@hotmail.com > CC: koha@lists.katipo.co.nz > Subject: Re: [Koha] SQL queries to delete records from the database? > Date: Mon, 23 Jul 2012 13:37:48 +0800 > > Greetings, > > Did I hear someone say 'recurrent index problems'? > I think this means I should repaste my indexing journey here. > This was on an Ubuntu 10.04 LTS VM with only 512MB of memory. As such, your > mileage may vary. And if there is something wrong in here, someone can > comment and correct me. > > --- BEGIN POST FROM ZEBRA LIST --- > Greetings, > > I am sharing this in hopes that this helps people who are frustrated trying > to figure out why Zebra indexing is not working for them. > > When I initially did a standard install, I ran the full reindex as root. > This was a mistake! This created a whole bunch of files with root.root as > the owner.group in the subdirectories of the /var/lib/koha/zebradb/ > directory. I corrected this problem with: > > adminuser$ sudo chown –R –v koha.koha /var/lib/koha/zebradb > > This, however, did not solve the problem. It was then suggested that I > restart the koha-zebra-daemon (Thanks to jcamins): > > adminuser$ sudo service koha-zebra-daemon restart > > This corrected the problem temporarily, and everything was running as koha > (the crontab to do a full reindex, etc.) > > adminuser$ sudo cat /etc/cron.d/koha > [it had ‘koha’ in the ‘run as this user’ column] > adminuser$ ps aux | grep zebra > koha 11635 0.0 1.3 99632 7192 ? S 10:40 0:00 > /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml > koha 12563 0.0 0.1 18296 584 ? Ss Jun29 0:00 > daemon --name=koha-zebra-ctl.kohadata > --errlog=/var/log/koha/koha-zebradaemon.err > --stdout=/var/log/koha/koha-zebradaemon.log > --output=/var/log/koha/koha-zebradaemon-output.log > --verbose=1 --respawn --delay=30 -- /usr/bin/zebrasrv -v none,fatal,warn -f > /etc/koha/koha-conf.xml > adminuser 12722 0.0 0.1 6160 680 pts/0 S+ 11:49 0:00 > grep --color=auto zebra > > However, our VM was running low on memory (512MB total) and full indexes > were triggering out of memory problems. I found that stopping the apache > server, doing the full reindex, restarting the koha-zebra-daemon and then > starting the apache server allowed for a successful reindex and searching to > work properly. > > adminuser$ sudo service apache2 stop > adminuser$ sudo su – koha > koha$ cd /usr/share/koha/bin/migration_tools > koha$ echo $KOHA_CONF > [this better be set correctly] > koha$ echo $PERL5LIB > [this better be set correctly] > koha$ ./rebuild_zebra –b –a –r –v > [long indexing/exporting output which could take several hours – DO THIS > AFTER HOURS!! – unless it is currently broken] > koha$ exit > adminuser$ sudo service apache2 start > > How did I know we were having memory problems? I opened a secondary window > and watched while reindexing, and I noticed some errors in the logs > adminuser$ free –m –s 1 > [output snipped] > ^C > adminuser$ cd /var/log/koha > adminuser$ grep memory * > [you’ll recognize the problem when you see the output] > > If you don’t have swap and can turn it on, do so. This is left as an > exercise for sysadmin administrators. > > I don’t know why I have to restart the koha-zebra-daemon after a > full-reindex, but I’m hoping to get a memory bump to 1GB from 512MB, and > then not have to stop apache. We sadly, can not turn on swap. > > Anyways, I hope this helps someone somewhere. Also, if someone can explain > why I need to restart the koha-zebra-daemon after a full reindex even as > koha, that would be appreciated too. I was thinking that perhaps the daemon > has filehandles open when the files are deleted, and so the filehandles it > has are stale? > > GPML, > Mark Tompsett > --- END POST FROM ZEBRA LIST --- > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha