[Halld-offline] Farm jobs should use SQLite form of the CCDB

Mark Ito marki at jlab.org
Tue Sep 26 16:21:24 EDT 2017


I have updated a section of the wiki page on the SQLite form of the CCDB 
. Find the updated section is reproduced below.

  - Mark


    Nightly generated SQLite files

An new SQLite database is created at midnight. The latest version is 
available for download from the web at

https://halldweb.jlab.org/dist/ccdb.sqlite  .

This file is on the disk at JLab at

/group/halld/www/halldweb/html/dist/ccdb.sqlite .

To use the file with your JANA-based program at JLab

setenv JANA_CALIB_URL sqlite:////group/halld/www/halldweb/html/dist/ccdb.sqlite

for C-shell and

export JANA_CALIB_URL=sqlite:////group/halld/www/halldweb/html/dist/ccdb.sqlite

for Bourne shell. *Using the SQLite form of the CCDB is important when 
you run multiple farm or grid jobs.* Otherwise the MySQL database server 
gets overwhelmed (too many connections).

Older versions of the CCDB can be found at JLab in 
/group/halld/Software/calib/ccdb_sqlite . See the section below 
on archiving old versions for more details on what is stored there.

Mark Ito, marki at jlab.org, (757)269-5295

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20170926/bc373aba/attachment.html>

More information about the Halld-offline mailing list