<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Chris Cormack wrote:<br>
<blockquote type="cite" cite="mid20040128085615.GN2920@katipo.co.nz">
<blockquote type="cite">
<pre wrap="">for T. Kotula :</pre>
<blockquote type="cite">
<pre wrap="">BD::mysql::st execute failed: MySQL server has gone away at
/usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136.
</pre>
</blockquote>
<pre wrap="">No, I don't know why this happends. I sometimes (rarely) had this
problem, and haven't found a solution yet.
</pre>
</blockquote>
<pre wrap=""><!---->You could try setting your mysql connection timeout higher.
<a class="moz-txt-link-freetext" href="http://www.mysql.com/doc/en/Server_parameters.html">http://www.mysql.com/doc/en/Server_parameters.html</a>
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.
</pre>
</blockquote>
/me agree.<br>
I was investigating too, & have another idea :<br>
The line 107 <br>
my $dbh = C4::Context->dbh;<br>
connects only once to the DB.<br>
<br>
The while(1) loop never checks or reconnect.<br>
<br>
Please, copy the line 107 after the while(1), on line 131, just after <br>
print "starting loop\n";<br>
and tell us if it fixes the problem.<br>
<br>
(with this patch, the connection is done every 10 seconds)<br>
<br>
thanks<br>
<pre class="moz-signature" cols="72">--
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre <a class="moz-txt-link-freetext" href="http://www.koha-fr.org">http://www.koha-fr.org</a>)
</pre>
</body>
</html>