Looks like a bug.
The SHOW PROCESSLIST command to mysql show that there are 949 connections to the DB right now, most of them not doing anything but connecting to the hps_conditions database. Thus, I would conclude that the conditions database code is NOT closing its connections correctly.
Jeremy, this is your code, can you please look into this?
Best,
Maurik
> On Dec 7, 2017, at 10:58 AM, Rafayel Paremuzyan <[log in to unmask]> wrote:
>
> HI, in pass7, looking into job statues, I see many jobs have several hours of wall time, while cpu time is only few minutes, or even less than a minute.
>
> I just did ccpr and asked, if they can help to investigate this,
> but also I want to make sure, if this is not related to the DB.
>
> Looking into output log files, and calculating printouts of connection openning and connection closing,
> it shows 13 connection openings and 8 closings.
>
> ifarm1402> grep -i DatabaseConditionsManager hps_005782.252_4.0.1_Recon.err | grep Opening | wc
> 13 117 1599
> ifarm1402> grep -i DatabaseConditionsManager hps_005782.252_4.0.1_Recon.err | grep Closing | wc
> 8 72 1032 ifarm1402>
>
> Can someone of experts comment on this? whether all connection close and opens are printed in the log file?
>
> You can have a look for example this log file
> /lustre/expphy/work/hallb/hps/data/engrun2015/pass7/hps_005782.252_4.0.1_Recon.err
>
> Rafo
>
> ########################################################################
> Use REPLY-ALL to reply to list
>
> To unsubscribe from the HPS-SOFTWARE list, click the following link:
> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1
########################################################################
Use REPLY-ALL to reply to list
To unsubscribe from the HPS-SOFTWARE list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1
|