<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Folks,</p>
<p>This morning, as I mentioned earlier, we had a problem accessing
anything from our webserver, halldweb.jlab.org. You may be aware
that other webservers and functions around the Lab were affected
including <a class="moz-txt-link-abbreviated" href="http://www.jlab.org">www.jlab.org</a>. Turns out this was due to a large number
of farm jobs trying to copy the RCDB in its SQLite form onto the
local disk of the farm node. This was being done to avoid
overloading the MySQL database server. Unfortunately, it caused
problems lab-wide.</p>
<p><b>We have decided to go back to using the MariaDB database
server (hallddb.jlab.org) as the default choice for CCDB and
RCDB, rather than the SQLite file.</b> The default is set by the
gluex_env_jlab.(c)sh script. Folks who over-ride the defaults will
continue to over-ride the defaults, of course. The change has been
made on the scripts and installed in
/group/halld/Software/build_scripts.<br>
</p>
<p>In the past we have said that farm jobs should use the SQLite
form of the CCDB and changed the default to align with that
recommendation. That got us out of the situation of farm jobs
using up all of the available connections on the database server.
This change is indeed a reversal and may expose us to such
incidents going forward. <br>
</p>
<p>The idea is to go back to the original configuration and study
problems as they arise in more detail than we have in the past.
This avoids having our farm jobs interfere with computing
activities at the Lab outside Hall D immediately. It should also
enable us to systematically craft a effective long-term fix.
Dmitry Romanov is on-site now and has agreed to help us with
solutions.<br>
</p>
<p> -- Mark</p>
<p><br>
</p>
</body>
</html>