[Clas_offline] clasdb and libcaldbMap

[Harut Avakian]

Hi All,
Last weeks with increased number of cores and limited number of 
connections to caldb we had problems with database access during 
simulation and cooking.
Marty  Wise (dbase manager) set up the process to kill stale idle 
connections in the event scheduler. To run the clas software accessing 
the caldb (gsim,a1,user_ana) we have to recompile it with the
new caldb/Map available from SVN (fixed by Nathan, see below), otherwise 
you may run into problem with reconnection crashes.
Harut



On 10/2/14, 9:53 AM, Nathan Baltzell wrote:
> Hi Harut,
>
> The io/caldb/Map in SVN is ready.
>
> I reverted my latest change to go back to one persistent connection instead of
> hammering the server with many connect+disconnects.  But the bugfix on the
> interpretation of mysql_ping return value will allow us to automatically reconnect
> when server kills connections that have been sleeping for a long time.
>
> -Nathan
>   
>
------- Original Message --------
Subject: 	[Clas_offline] caldb timeout/reconnect bug
Date: 	Thu, 11 Sep 2014 09:59:09 -0400
From: 	Nathan Baltzell <baltzell at jlab.org>
To: 	clas offline <clas_offline at jlab.org>



FYI Everyone,

After changes in JLab firewalls on August 16, at least a couple run groups (eg6 and eg4)
started getting new segfaults related to timeout errors in connections to the calibration
database during cooking.  While CLAS already had a mechanism in place to automatically
reconnect in such cases, it had a bug resulting in false success that led to the recent
problems.

Correctly testing the return value from mysql_ping fixes it, and it's now in svn's
trunk/io/caldb/Map/calib_connect.c (line 122), as well as cvs's
packages/caldb/Map/calib_connect.c (line 113) just in case.


This bug only (?) became relevant after a new 30 minute timeout on dormant connections
implemented in the JLab firewall on 8/16.  Maybe there will be related issues.

Regards,
Nathan


_______________________________________________
Clas_offline mailing list
Clas_offline at jlab.org
https://mailman.jlab.org/mailman/listinfo/clas_offline

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/clas_offline/attachments/20141002/dbb2f0ab/attachment.html