 |
 |
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] <mailto:[log in to unmask]>> >> Subject: conditions DB down? >> Date: May 31, 2018 at 15:26:41 EDT >> To: [log in to unmask] <mailto:[log in to unmask]> >> >> 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/ <mysql://hpsdb.jlab.org:3306/> >> host: hpsdb.jlab.org <http://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/ <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= <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