Alessandra, see reply from Marty

Begin forwarded message:

From: Marty Wise <[log in to unmask]>
Subject: RE: conditions DB down?
Date: May 31, 2018 at 16:18:06 EDT
To: "'Nathan Baltzell'" <[log in to unmask]>

Nathan,
 
Nothing super obvious. I see several connections from SLAC. The log shows some aborted/interrupted connections from INFN. The server will block further connection attempts from a client after 50 failures (a limit set in the config). This value is fairly reasonable for an externally visible server. We pretty much disable this behavior (set a high limit) for on-site servers. I just did a flush hosts on the server (the external one) to reset this. Might be worth a retry.
 
 
Which account were you failing to connect with? And, to which server? Both? You may not be able to connect to hpsdb-ext from on-site… I don’t remember how that’s set up. I can check the logs for indications.
 
During normal ops, we leave logging turned off because it fills disks so quickly. I enabled detailed logging on the external server. So, if there are further problems, I may get more indication of what might be going wrong.
 
 
Marty Wise
Jlab IT/CNI
 
From: Nathan Baltzell <[log in to unmask]> 
Sent: Thursday, May 31, 2018 3:33 PM
To: Marty Wise <[log in to unmask]>
Subject: Fwd: conditions DB down?
 
Anything up with hpsdb/hpsdb-ext?
 
Maybe unrelated, but I tried to do a mysql login with credentials that used to work, but no luck ...


Begin forwarded message:
 
From: Alessandra Filippi <[log in to unmask]>
Subject: conditions DB down?
Date: May 31, 2018 at 15:26:41 EDT
 
Hi all (sorry for the spam to thise not interested),
since this early afternoon (this morning it was ok) I'm trying to run the the reconstruction on my machine but I get this error

connection: jdbc:mysql://hpsdb.jlab.org:3306/
host: hpsdb.jlab.org
port: 3306
user: hpsuser
database: hps_conditions
2018-05-31 21:22:24 [WARNING] org.hps.conditions.database.ConnectionParameters createConnection :: Failed to connect to database jdbc:mysql://hpsdb.jlab.org:3306/ - Communications link failure

and then after few tries the process is aborted. Is the conditions DB down or is is a problem of my machine? Could you please check?
Thanks, cheers
    Alessandra

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the HPS-SOFTWARE list, click the following link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__listserv.slac.stanford.edu_cgi-2Dbin_wa-3FSUBED1-3DHPS-2DSOFTWARE-26A-3D1&d=DwIBAg&c=lz9TcOasaINaaC3U7FbMev2lsutwpI4--09aP8Lu18s&r=SyXCERKmF6ZPnHcvjvj_i035JU5-CekNtcXyMlms6kc&m=uWCKeO7gzTDPs1pfX6GE48ssqXxA3lgCIOvGocyQqWc&s=4zEfClH9Ta0PTcjMcK8g9kSq619ArIjNeonfQtOHrKM&e=



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