Search / index problem, help... ?
Hello We have got a problem with our search engine... It doesn't find the last biblios that we have just added. If I run a report, I can find the biblio. If I try to "check-in" the biblio (using its barcode), I can find it too. We just can't find it using a normal search in the catalog. There seems to be some errors due to rebuild-zebra. The person who receives the logs by email says he receives these errors: error retrieving biblio 9413 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. error retrieving biblio 10570 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96.And he indeed receives these errors every five minutes, so I guess that means that rebuild-zebra is really working. The cronjob runs from the cron.d directory (as installed by the package) and that's it: # /etc/cron.d/koha-common # Call koha-rebuild-zebra for each enabled Koha instance, to make sure the # Zebra indexes are up to date. SHELL=/bin/sh PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin */5 * * * * root test -x /usr/sbin/koha-rebuild-zebra && koha-rebuild-zebra $(koha-list --enabled) */15 * * * * root koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/process_message_queue.pl If I run rebuild-zebra as a command line, it doesn't change anything. Do you have any suggestion for us? (I am sorry I don't have the whole picture, because we are two persons working on it: I work more on Koha and I don't know much about the server and all these files, and the other person is working on the server and he doesn't know much about Koha...) Many thanks for your help! Sonia.
Hi! On 29 January 2012 10:50, Sonia P. <sossolapro@hotmail.com> wrote:
We have got a problem with our search engine... It doesn't find the last biblios that we have just added. If I run a report, I can find the biblio. If I try to "check-in" the biblio (using its barcode), I can find it too. We just can't find it using a normal search in the catalog. There seems to be some errors due to rebuild-zebra. The person who receives the logs by email says he receives these errors: error retrieving biblio 9413 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. error retrieving biblio 10570 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96.And he indeed receives these errors every five minutes, so I guess that means that rebuild-zebra is really working.
Yeah, sounds like rebuild-zebra is working, but it's running into some bad MARC records that makes it stop before it reaches your newest records. Based on the error message, I would take a long, hard look at the records with biblionumber = 9413 and 10570, and see if they contain any odd characters etc. It might also be informative to try a full Zebra reindex, with verbose output: sudo koha-rebuild-zebra -f -v <instancename> Best regards, Magnus Enger libriotech.no
Hello Thanks for your help. I tried to find the records for these biblionumber, but there aren't any! They have obviously been deleted at some point. So why that error? error retrieving biblio 9413 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.Why is rebuild-zebra blocked by that biblio, if that biblio doesn't exist any more? As for the zebra reindex, I am sorry it's a stupid question, but what's that <instancename> you mention in the command line? Cheers, Sonia.
Date: Sun, 29 Jan 2012 16:21:07 +0100 Subject: Re: [Koha] Search / index problem, help... ? From: magnus@enger.priv.no Yeah, sounds like rebuild-zebra is working, but it's running into some bad MARC records that makes it stop before it reaches your newest records. Based on the error message, I would take a long, hard look at the records with biblionumber = 9413 and 10570, and see if they contain any odd characters etc.
It might also be informative to try a full Zebra reindex, with verbose output: sudo koha-rebuild-zebra -f -v <instancename>
Best regards, Magnus Enger libriotech.no
--- On Mon, 1/30/12, Sonia P. <sossolapro@hotmail.com> wrote:
As for the zebra reindex, I am sorry it's a stupid question, but what's that <instancename> you mention in the command line?
I think the assumption is probably that you are running Koha installed from the debian package, which allows multiple instances of Koha on the same server. If you are not running the package, you should be fine with -b -r -v i guess. Olugbenga Adara Mobile: 234 (0) 8033220288 Home: 234 (2) 8721720 Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
Thanks all for your help. So I have searched in the biblioitem database as well (biblionumber and biblioitemnumber), and these two numbers (which cause errors) doesn't exist. I don't get it... As for the <instancename>, I don't think we run multiple instances of Koha on the same server (why would we?). I have tried a few command lines like that, and it didn't change anything. I don't know what the problem is. I don't know why these biblios would cause any problem if they have been deleted. What can I do? Cheers, Sonia.
Date: Mon, 30 Jan 2012 05:07:43 -0800 From: gbengaadara@yahoo.com Subject: Re: [Koha] Search / index problem, help... ? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz
--- On Mon, 1/30/12, Sonia P. <sossolapro@hotmail.com> wrote:
As for the zebra reindex, I am sorry it's a stupid question, but what's that <instancename> you mention in the command line?
I think the assumption is probably that you are running Koha installed from the debian package, which allows multiple instances of Koha on the same server.
If you are not running the package, you should be fine with -b -r -v i guess.
Olugbenga Adara
Mobile: 234 (0) 8033220288 Home: 234 (2) 8721720 Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
Have you tried clearing the zebra indexes first and then rebuild the index? For clearing the zebra index: # Zebra Indexes $ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init $ zebraidx -c /etc/koha/zebradb/zebra-authorities.cfg -g iso2709 -d authorities init (It is possible your zebra-biblios.cfg and zebra-authorities.cfg live somwhere else, the above location is where mine are) After that, restart zebra and re-index. (rebuild_zebra.pl -b -w) I hope this helps. I have had similar issues after loading a database from a different library to test. If I do not clear the zebra index, anything from the previous library will cause errors. ________________________________ From: Sonia P. <sossolapro@hotmail.com> To: Cc: koha@lists.katipo.co.nz Sent: Monday, January 30, 2012 8:19:28 PM Subject: Re: [Koha] Search / index problem, help... ? Thanks all for your help. So I have searched in the biblioitem database as well (biblionumber and biblioitemnumber), and these two numbers (which cause errors) doesn't exist. I don't get it... As for the <instancename>, I don't think we run multiple instances of Koha on the same server (why would we?). I have tried a few command lines like that, and it didn't change anything. I don't know what the problem is. I don't know why these biblios would cause any problem if they have been deleted. What can I do? Cheers, Sonia.
Date: Mon, 30 Jan 2012 05:07:43 -0800 From: gbengaadara@yahoo.com Subject: Re: [Koha] Search / index problem, help... ? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz
--- On Mon, 1/30/12, Sonia P. <sossolapro@hotmail.com> wrote:
As for the zebra reindex, I am sorry it's a stupid question, but what's that <instancename> you mention in the command line?
I think the assumption is probably that you are running Koha installed from the debian package, which allows multiple instances of Koha on the same server.
If you are not running the package, you should be fine with -b -r -v i guess.
Olugbenga Adara
Mobile: 234 (0) 8033220288 Home: 234 (2) 8721720 Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Many thanks for your help! Clearing the zebra indexes fixed the problem (but then I couldn't restart zebra, which took lots of IRC support to solve). Cheers, Sonia. Date: Tue, 31 Jan 2012 09:52:02 -0800 From: ontariowolf64@yahoo.com Subject: Re: [Koha] Search / index problem, help... ? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz Have you tried clearing the zebra indexes first and then rebuild the index? For clearing the zebra index:# Zebra Indexes $ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init $ zebraidx -c /etc/koha/zebradb/zebra-authorities.cfg -g iso2709 -d authorities init (It is possible your zebra-biblios.cfg and zebra-authorities.cfg live somwhere else, the above location is where mine are) After that, restart zebra and re-index. (rebuild_zebra.pl -b -w) I hope this helps. I have had similar issues after loading a database from a different library to test. If I do not clear the zebra index, anything from the previous library will cause errors. From: Sonia P. <sossolapro@hotmail.com> To: Cc: koha@lists.katipo.co.nz Sent: Monday, January 30, 2012 8:19:28 PM Subject: Re: [Koha] Search / index problem, help... ? Thanks all for your help. So I have searched in the biblioitem database as well (biblionumber and biblioitemnumber), and these two numbers (which cause errors) doesn't exist. I don't get it... As for the <instancename>, I don't think we run multiple instances of Koha on the same server (why would we?). I have tried a few command lines like that, and it didn't change anything. I don't know what the problem is. I don't know why these biblios would cause any problem if they have been deleted. What can I do? Cheers, Sonia.
Date: Mon, 30 Jan 2012 05:07:43 -0800 From: gbengaadara@yahoo.com Subject: Re: [Koha] Search / index problem, help... ? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz
--- On Mon, 1/30/12, Sonia P. <sossolapro@hotmail.com> wrote:
As for the zebra reindex, I am sorry it's a stupid question, but what's that <instancename> you mention in the command line?
I think the assumption is probably that you are running Koha installed from the debian package, which allows multiple instances of Koha on the same server.
If you are not running the package, you should be fine with -b -r -v i guess.
Olugbenga Adara
Mobile: 234 (0) 8033220288 Home: 234 (2) 8721720 Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Occasionally I have had zebra not wanting to restart, but restarting the computer has always worked for me, as in, turning it off, go get a coffee and start it up again. I love easy solutions, especially if they give me a chance to get a coffee :-) Marty ________________________________ From: Sonia P. <sossolapro@hotmail.com> To: koha@lists.katipo.co.nz Sent: Thursday, February 2, 2012 9:35:12 PM Subject: Re: [Koha] Search / index problem, help... ? Many thanks for your help! Clearing the zebra indexes fixed the problem (but then I couldn't restart zebra, which took lots of IRC support to solve). Cheers, Sonia. Date: Tue, 31 Jan 2012 09:52:02 -0800 From: ontariowolf64@yahoo.com Subject: Re: [Koha] Search / index problem, help... ? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz Have you tried clearing the zebra indexes first and then rebuild the index? For clearing the zebra index:# Zebra Indexes $ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init $ zebraidx -c /etc/koha/zebradb/zebra-authorities.cfg -g iso2709 -d authorities init (It is possible your zebra-biblios.cfg and zebra-authorities.cfg live somwhere else, the above location is where mine are) After that, restart zebra and re-index. (rebuild_zebra.pl -b -w) I hope this helps. I have had similar issues after loading a database from a different library to test. If I do not clear the zebra index, anything from the previous library will cause errors. From: Sonia P. <sossolapro@hotmail.com> To: Cc: koha@lists.katipo.co.nz Sent: Monday, January 30, 2012 8:19:28 PM Subject: Re: [Koha] Search / index problem, help... ? Thanks all for your help. So I have searched in the biblioitem database as well (biblionumber and biblioitemnumber), and these two numbers (which cause errors) doesn't exist. I don't get it... As for the <instancename>, I don't think we run multiple instances of Koha on the same server (why would we?). I have tried a few command lines like that, and it didn't change anything. I don't know what the problem is. I don't know why these biblios would cause any problem if they have been deleted. What can I do? Cheers, Sonia.
Date: Mon, 30 Jan 2012 05:07:43 -0800 From: gbengaadara@yahoo.com Subject: Re: [Koha] Search / index problem, help... ? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz
--- On Mon, 1/30/12, Sonia P. <sossolapro@hotmail.com> wrote:
As for the zebra reindex, I am sorry it's a stupid question, but what's that <instancename> you mention in the command line?
I think the assumption is probably that you are running Koha installed from the debian package, which allows multiple instances of Koha on the same server.
If you are not running the package, you should be fine with -b -r -v i guess.
Olugbenga Adara
Mobile: 234 (0) 8033220288 Home: 234 (2) 8721720 Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Magnus Enger -
Marty -
Olugbenga Adara -
Sonia P.