[Koha] Rebuild-zebra stops working very often...

[Sonia P.]

Hi there

Here is what our technician said in relation to your message :
<< If Zebra cannot connect to the database, Koha itself will not work. 
    The database connection error is unrelated to the Koha search
    problem.

    The Zebra logs are located under /var/log/koha/library, I
    have looked at the zebra-output.log file contained within
    the directory, there is nothing in it and it hasn't been written to
    since April 24.  The zebra-error.log in the same directory
    hasn't been written to since the computer was installed. >>

So I don't know what to do... We are stuck.  I can't restart zebra every two hours.  Would reinstalling everything help?  Wouldn't it take two weeks to set up and fix everything?
If you have any idea about what's going on... 

Cheers,

Sonia.



Subject: Re: [Koha] Rebuild-zebra stops working very often...
From: chrisc at catalyst.net.nz
Date: Sun, 24 Jun 2012 13:10:41 +1200
To: sossolapro at hotmail.com
CC: koha at lists.katipo.co.nz

Ahh that is not the zebra error log. But the rebuild zebra one. I think you may be confusing zebra with the job to rebuild the zebra indexes, they are 2 quite different things.



However not being able to talk to the database is a fatal error for the rebuild zebra script. The database failing will also cause all sorts of other errors. I would get your tech people to look at your database set up. Something very bad is going wrong there.



Chris

"Sonia P." <sossolapro at hotmail.com> wrote:

Dear all

Thanks again for your help.
Here is (below) the content of the zebra error file.  Would you please have a look at it and tell me if there are things which could explain why zebra-rebuild stops working now and then?  There is that DBIconnect error, but I am not sure it's related.  And there is no time & day in the error file, so I can't check what happened when zebra rebuild doesn't work properly.  (I have removed all the multiple duplicates...)

Cheers,

Sonia.




Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96.
DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc
al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm lin
e 692
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l
ib/C4/Context.pm line 692.
DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc
al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm lin
e 692
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l
ib/C4/Context.pm line 692.
DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc
al MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
692
Can't connect to local MySQL server throu
 gh
socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib
/C4/Context.pm line 692.
error retrieving biblio 12126 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
error retrieving biblio 11493 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
error retrieving biblio 13829 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.
$ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket
$ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692
error retrieving biblio 14703 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.
$ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket
$ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692
$ error retrieving biblio 14703 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.
$ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket
$ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692
$ error retrieving biblio 14
 703 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.


 		 	   		  

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha