[Koha] Problems with Z3950 search

paul POULAIN paul.poulain at free.fr
Wed Jan 28 22:14:19 NZDT 2004


Chris Cormack wrote:

>>for T. Kotula :
>>
>>>BD::mysql::st execute failed: MySQL server has gone away at
>>>/usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136.
>>>      
>>>
>>No, I don't know why this happends. I sometimes (rarely) had this 
>>problem, and haven't found a solution yet.
>>    
>>
>You could try setting your mysql connection timeout higher.
>
>http://www.mysql.com/doc/en/Server_parameters.html
>
>It sounds like the server connection is timing out, a better fix would be
>fix the code so that if the server connection times out, we create a new
>connection.
>  
>
/me agree.
I was investigating too, & have another idea :
The line 107
my $dbh = C4::Context->dbh;
connects only once to the DB.

The while(1) loop never checks or reconnect.

Please, copy the line 107 after the while(1), on line 131, just after
        print "starting loop\n";
and tell us if it fixes the problem.

(with this patch, the connection is done every 10 seconds)

thanks

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20040128/9b9585ec/attachment-0001.htm


More information about the Koha mailing list