<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Folks,</p>
<p>Things look nominal right now but over the past week, there have
been problems with overloading of one or the other of the mysql
servers used for farm jobs. We believe that this has been due to
jobs using an old, buggy version of CCDB. This version was
included in the version sets we used for launches we performed
over a year ago and in some cases users are using those version
sets to ensure compatibility with those launches. Other cases come
from users using private version sets with the old CCDB version
imbedded. Many of you will recall the problems that that version
created for us.</p>
<p>The problem only occurs for jobs that check <b>all</b> of
following boxes:</p>
<ul>
<li>Using a version set with CCDB 1.06.06.</li>
<ul>
<li>CCDB 1.06.07 is the current standard.</li>
</ul>
<li>Using a mysql server for the CCDB.</li>
<ul>
<li>Using an SQLite version seems to work. Running on the OSG
uses SQLite is seems therefore to be OK.</li>
</ul>
<li>Running many hundreds of jobs simultaneously using the same
mysql server.</li>
<ul>
<li>Like on the JLab farm, say.</li>
</ul>
</ul>
<p>To repeat: you need an AND of these conditions to have issues. If
any one of them is avoided, there should not be a problem. Thus
your work-around options have been described.<br>
</p>
<p>A long-term fix would be to remake version sets without the buggy
CCDB. I'm looking into feasability.<br>
</p>
<p> -- Mark<br>
</p>
</body>
</html>