[Halld-offline] [EXTERNAL] Proper CCDB hygiene

[David Lawrence]

I don’t think diss is going away. Just the version.xml files are no longer going to be copied there.
The ccdb.sqlite file will still be there as I understand it.

Regards,
-David

-------------------------------------------------------------
David Lawrence Ph.D.
Staff Scientist, Thomas Jefferson National Accelerator Facility
Newport News, VA
davidl at jlab.org<mailto:davidl at jlab.org>
(757) 269-5567 W
(757) 746-6697 C


On Feb 20, 2020, at 10:46 AM, Sean Dobbs <seandobbs at gmail.com<mailto:seandobbs at gmail.com>> wrote:

Good question!

What you describe is very good practice.  That SQLite file is regenerated at midnight every night.  If your friends needs a fresher version, you have to make your own.

The wiki page to refer to is this one:
https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database

---Sean

On Thu, Feb 20, 2020 at 10:38 AM Colin Gleason <gleasonc at jlab.org<mailto:gleasonc at jlab.org>> wrote:
Last email got bounced back due to wrong email. Resending:

Hi All,

Asking for a friend- how does one build their own private ccdb so we can modify and test calibrations with out altering the master? I see this link https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB<https://urldefense.com/v3/__https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-95zMz_Z5w$> on the wiki, but the instructions are not clear and I think one ends up using the master ccdb. My friend seems to run into this same problem every 6 months when calibrations are due. This person's work around in the past was to copy the master sqlite file ( /group/halld/www/halldweb/html/dist/ccdb.sqlite) to a private directory, then put this in their environment file:

setenv JANA_CALIB_URL sqlite:///<private directory>/ccdb.sqlite
setenv CCDB_CONNECTION sqlite:///<private directory>/ccdb.sqlite

Is this proper etiquette/form? Should my friend go about this another way? Can clear instructions be added to the wiki so this doesn't happen in the future (if the above way is good form, I can add a section to the wiki)?

On Thu, Feb 20, 2020 at 10:36 AM Colin Gleason <gleasonc609 at gmail.com<mailto:gleasonc609 at gmail.com>> wrote:
Hi All,

Asking for a friend- how does one build their own private ccdb so we can modify and test calibrations with out altering the master? I see this link https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB<https://urldefense.com/v3/__https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-95zMz_Z5w$> on the wiki, but the instructions are not clear and I think one ends up using the master ccdb. My friend seems to run into this same problem every 6 months when calibrations are due. This person's work around in the past was to copy the master sqlite file ( /group/halld/www/halldweb/html/dist/ccdb.sqlite) to a private directory, then put this in their environment file:

setenv JANA_CALIB_URL sqlite:///<private directory>/ccdb.sqlite
setenv CCDB_CONNECTION sqlite:///<private directory>/ccdb.sqlite

Is this proper etiquette/form? Should my friend go about this another way? Can clear instructions be added to the wiki so this doesn't happen in the future (if the above way is good form, I can add a section to the wiki)?

On Wed, Feb 19, 2020 at 5:05 PM Sean Dobbs <sdobbs at fsu.edu<mailto:sdobbs at fsu.edu>> wrote:
Dear Offliners,

PLEASE exercise caution when modifying the master CCDB - this goes for
new users and old alike.  If you think you are working with an SQLite
copy, while it is good to check the value of the CCDB_CONNECTION
environment variable, it doesn't hurt to use "ccdb -i" to boot the
CCDB CLI into interactive mode and check what output you see there.
Especially if you have something like 50 terminal windows open, as
many of us do.

Thanks for your consideration,
Sean
_______________________________________________
Halld-offline mailing list
Halld-offline at jlab.org<mailto:Halld-offline at jlab.org>
https://mailman.jlab.org/mailman/listinfo/halld-offline<https://urldefense.com/v3/__https://mailman.jlab.org/mailman/listinfo/halld-offline__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-96qE7u2iA$>


--
Colin Gleason
Postdoctoral Fellow
Indiana University
Department of Physics


--
Colin Gleason
Postdoctoral Fellow
Indiana University
Department of Physics
_______________________________________________
Halld-offline mailing list
Halld-offline at jlab.org<mailto:Halld-offline at jlab.org>
https://mailman.jlab.org/mailman/listinfo/halld-offline

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