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)