<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>The change described below should be transparent to users, and
its effect will only be felt by some jobs running on the JLab
farm. It is going into effect sometime this afternoon. If you are
interested in the details, read on...<br>
<br>
For those of you who use gxenv (aka gluex_env_jlab.(c)sh) the
source of your CCDB information is set by the script
$BUILD_SCRIPTS/calib_url_chooser.sh. On the farm, you get one of
100 copies of the SQLite version of the CCDB, chosen randomly,
otherwise you use our standard database server, hallddb.jlab.org,
to get CCDB constants. This scheme was described in <a
moz-do-not-send="true"
href="https://mailman.jlab.org/pipermail/halld-offline/2019-April/003613.html">a
previous email</a>. <br>
<br>
This behavior is going to change this afternoon.<br>
<br>
To move traffic to the new mysql server, hallddb-farm.jlab.org, it
will now be chosen to serve CCDB constants when on the farm.
Non-farm jobs will be directed to hallddb.jlab.org as before. The
new server was described in <a moz-do-not-send="true"
href="https://mailman.jlab.org/pipermail/halld-offline/2019-September/003758.html">another
previous email</a>.<br>
<br>
If you don't use gxenv or calib_url_chooser.sh, then this change
does not affect you.<br>
<br>
If you would like to use the random SQL file scheme (the previous
default on the farm), you can give an option to the chooser
script:<br>
<br>
export JANA_CALIB_URL=`$BUILD_SCRIPTS/calib_url_chooser.sh
sqlite`<br>
<br>
This choice will be honored whether you are on the farm or not.</p>
<p>Finally, note that if we run into trouble with this change, it is
easy to reverse.</p>
</body>
</html>