Note the last line of Jeremy’s mail: please do some testing of this ASAP if you can! Tim > On Aug 21, 2018, at 11:08 AM, McCormick, Jeremy I. <[log in to unmask]> wrote: > > Hi, > > I have a basic working version of hps-java on a branch (iss320) which can load conditions from a SQLite db that I exported from MySQL. This means that you should be able to run the recon entirely offline without needing to install MySQL locally and import the conditions db. > > The issue branch is here: > > https://github.com/JeffersonLab/hps-java/tree/iss320 > > What are the next steps? Should we attempt to run it in hps-mc? > > I have only run the readout and I did not check the results carefully (just saw that it wrote out some events); perhaps we need to run & validate the recon as well before doing anything else? It is possible, for instance, that some values of conditions data might not be the same, e.g. due to rounding/precision errors. So that should be checked carefully. > > It is a fairly simple matter to run the bin jar and point to the local db file... > > java -Dorg.hps.conditions.url=jdbc:sqlite:hps_conditions.db -jar hps-java-bin.jar [...] > > The db file with the exported conditions data can be obtained from here: > > https://github.com/JeffersonLab/hps-conditions-backup/blob/master/hps_conditions_for_sqlite.sql.tar.gz > > It should be downloaded into the working directory and decompressed using 'tar -zxvf'. > > To run in hps-mc should be pretty straightforward; I think we would just need something like this passed to the JobManager in each script: > > java_args=["-Dorg.hps.conditions.url=jdbc:sqlite:hps_conditions.db"] > > We would need to either copy over the db file to each batch node and read from this relative path, symlink the file from each node, or read the file from a fixed/hard-coded NFS location. (All of these options require some relatively minor changes to the python scripts.) > > Let me know how you want to proceed and what I can do to help... > > BTW I will be leaving on a 3 month trip next Tuesday evening, and I do not plan on doing any HPS work during this time, so please get back to me ASAP on this so hopefully we can get this running successfully before I leave. > > --Jeremy > > Use REPLY-ALL to reply to list > To unsubscribe from the HPS-SOFTWARE list, click the following link: > https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1 ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the HPS-SOFTWARE list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1