Hi, Nathan.
> Ok, it seems to work now (but spits out lots of info about svt, severe error ...)
Good to hear it is working. The SVT errors can be safely ignored and are being trapped by the conditions manager.
> Also we need a command line way to print the table currently used for a given run number. E.g. "give me the gains for run 2001".
This exists already....
CommandLineTool print -t ecal_gains -r 2000
etc.
Check "print -h" for the exact syntax.
> Looks like I accidentally "added" the gains 3 times instead of once yesterday, due to all the "errors" reported. Maybe you want to delete the first two.
That's not a big deal. Can you try deleting these yourself from the mysql client? I would like to double check that hpscalibrations has permissions to do this. (It is supposed to have the delete grant.)
It would just be a simple SQL command from the terminal like...
mysql> delete from ecal_gains where collection_id = 123;
You just need to put in the collection ID there that you want to delete.
Today I'm going to look at extracting run number from the EVIO events in the new data you put out there so the monitoring app can initialize conditions properly without needing a user run number....
--Jeremy
-----Original Message-----
From: Nathan Baltzell [mailto:[log in to unmask]]
Sent: Friday, December 12, 2014 10:47 AM
To: McCormick, Jeremy I.
Subject: Re: ECAL calibrations
I checked, and the peds and gains in the db look as I expect.
-nathan
On Dec 12, 2014, at 9:15 AM, Nathan Baltzell <[log in to unmask]> wrote:
> Ok, it seems to work now (but spits out lots of info about svt, severe
> error ...)
>
> You should find now gains (collection_id=3) and pedestals
> (collection_id=4) in the db, but I'm about to run a full test,
> downloading them crosscheck that they are what I expect before announcing on the mailing list.
>
> Looks like I accidentally "added" the gains 3 times instead of once
> yesterday, due to all the "errors" reported. Maybe you want to delete the first two.
>
> Also we need a command line way to print the table currently used for
> a given run number. E.g. "give me the gains for run 2001".
>
> -nathan
>
>
>
>
> On Dec 11, 2014, at 5:52 PM, "McCormick, Jeremy I." <[log in to unmask]> wrote:
>
>> Hi,
>>
>> Okay, there was yet another bug. (Conditions system wasn't
>> initialized properly.)
>>
>> But this should work now on trunk...
>>
>> java -cp hps-distribution-3.1-SNAPSHOT-bin.jar
>> org.hps.conditions.cli.CommandLineTool -p connection.properties -v
>> load -t ecal_calibrations -f ecal_calibrations.txt
>>
>> Just pull it again from Nexus once the build is done.
>>
>> Sorry, I need to test this better after I change things....
>>
>> -Jeremy
>>
>> On Dec 11, 2014, at 2:29 PM, Nathan Baltzell <[log in to unmask]> wrote:
>>
>>> java -cp hps-distribution-3.1-20141211.202153-123-bin.jar
>>> org.hps.conditions.cli.CommandLineTool -p
>>> hpscalibrations_jlab.properties load -t ecal_calibrations -f
>>> ped4db.txt
>>>
>>> http://www.jlab.org/~baltzell/HPS/ped4db.txt
>>>
>>> (null pointer at line 483 in DatabaseConditionsManager.java)
>>>
>>> -nathan
>>>
>>>
>>> On Dec 11, 2014, at 5:19 PM, "McCormick, Jeremy I." <[log in to unmask]> wrote:
>>>
>>>> Oh and I meant to say please attach the ped.txt file in your reply as well...
>>>>
>>>>> On Dec 11, 2014, at 2:18 PM, McCormick, Jeremy I. <[log in to unmask]> wrote:
>>>>>
>>>>> Can you send again the exact command you're using and attach the file you're trying to load? I'll test it on my local dev db...
>>>>>
>>>>>> On Dec 11, 2014, at 2:08 PM, Nathan Baltzell <[log in to unmask]> wrote:
>>>>>>
>>>>>> Jeremy,
>>>>>>
>>>>>> Ok, the "add" of gains worked now.
>>>>>>
>>>>>> But now using latest snapshot (20141211.202153-123) to "load" the
>>>>>> pedestals I get an error similar to the one yesterday:
>>>>>>
>>>>>> DatabaseConditionsManager.findTableMetaData(DatabaseCondisiontMan
>>>>>> ager.java:483)
>>>>>>
>>>>>> Something wrong with these options:?
>>>>>> load -t ecal_calibrations -f ped4db.txt
>>>>>>
>>>>>> -Nathan
>>>>>>
>>>>>>
>>>>>>> On Dec 11, 2014, at 3:10 PM, "McCormick, Jeremy I." <[log in to unmask]> wrote:
>>>>>>>
>>>>>>> Hi again, Nathan.
>>>>>>>
>>>>>>> Okay, this should work fine now. I tested on my local dev database to make sure.
>>>>>>>
>>>>>>> Executed this command similar to yours...
>>>>>>>
>>>>>>> java -cp ~/.m2/repository/org/hps/hps-distribution/3.1-SNAPSHOT/hps-distribution-3.1-SNAPSHOT-bin.jar org.hps.conditions.cli.CommandLineTool -v -p ../hps-java-sandbox/conditions_dev.prop add -t ecal_gains -k ecal_gains -c 3 -r 2000 -e 9999 -u baltzell -m 'CosmicGains'
>>>>>>>
>>>>>>> You should see something like this in the log which indicates it succeeded...
>>>>>>>
>>>>>>> Thu Dec 11 12:05:01 PST 2014 :: DatabaseConditionsManager ::
>>>>>>> FINE :: INSERT INTO conditions ( run_start, run_end, table_name,
>>>>>>> name, collection_id, created_by, notes, created ) VALUES (
>>>>>>> '2000', '9999', 'ecal_gains', 'ecal_gains', '3', 'baltzell',
>>>>>>> 'CosmicGains', STR_TO_DATE( '2014-12-11 12:05:01', '%Y-%m-%d
>>>>>>> %H:%i:%S' ))
>>>>>>>
>>>>>>> You will want to 'svn up' and build trunk and then use hps-distribution from there.
>>>>>>>
>>>>>>> Or you can wait for this build to finish...
>>>>>>>
>>>>>>> http://srs.slac.stanford.edu/hudson/view/HPS/job/hps-modules/835
>>>>>>> /
>>>>>>>
>>>>>>> And then download the 3.1-SNAPSHOT bin jar from Nexus.
>>>>>>>
>>>>>>> -Jeremy
>>>>>>>
>>>>>>>> On Dec 11, 2014, at 11:15 AM, McCormick, Jeremy I. <[log in to unmask]> wrote:
>>>>>>>>
>>>>>>>> That shouldn't be a fatal error, as it is being trapped in the
>>>>>>>> manager. It just means SVT conditions aren't in the db yet...
>>>>>>>>
>>>>>>>>> On Dec 11, 2014, at 11:08 AM, Nathan Baltzell <[log in to unmask]> wrote:
>>>>>>>>>
>>>>>>>>> I just now used the latest jar from nexus, and now it complains about "svt_channels"
>>>>>>>>> when trying to "add" a table for "ecal_gains". This is using
>>>>>>>>> the same command as yesterday.
>>>>>>>>> -Nathan
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> On Dec 11, 2014, at 1:28 PM, "McCormick, Jeremy I." <[log in to unmask]> wrote:
>>>>>>>>>>
>>>>>>>>>> Hi, Nathan.
>>>>>>>>>>
>>>>>>>>>> I know we discussed before that the currently used calibrations (pedestal + noise) in the JLAB database are wrong for about half the crystals due to some kind of mix up with the channel ID convention that was used. I think we should fix this ASAP so that the calibrations are reasonable. The existing conditions collection should just be deleted, too, as it isn't usable.
>>>>>>>>>>
>>>>>>>>>> I have an LCSim Driver that generates a pedestal + noise
>>>>>>>>>> conditions set from data. It is relatively simple right now
>>>>>>>>>> and just uses the mean and sigma distribution of all ADC
>>>>>>>>>> values from a histogram. But it could be made more
>>>>>>>>>> sophisticated by, for instance, selecting only ADC values
>>>>>>>>>> from background "hits". Could we start working from this
>>>>>>>>>> Driver to generate these calibrations? If we need to improve
>>>>>>>>>> it then we should do it. It is already in SVN. (mentioned
>>>>>>>>>> in my talk today)
>>>>>>>>>>
>>>>>>>>>> Also, are the pedestals sufficiently stable that we could use one calibration for all the runs thus far? I have calibrated just a few runs with this Driver, and I don't have much idea if there is any pedestal drift (none that I have seen), or at least enough for us to want to store this information by individual run. I know you stated that there is no significant amount of pedestal drift. Has this been shown definitively in any analysis/plots e.g. for the cosmic runs?
>>>>>>>>>>
>>>>>>>>>> I currently have all data files for runs 2823, 2825 and 2826 copied to SLAC where I can do analysis on them. Do you want me to generate the pedestal calibrations for these runs and send them to you as text files so you can verify and then load yourself OR I just can directly load them into the JLAB database myself if you're too busy with ECAL operations. Probably if I did this I would just assign the collections to the individual run numbers and not a range.
>>>>>>>>>>
>>>>>>>>>> Anyways, let me know what you think is best...
>>>>>>>>>>
>>>>>>>>>> -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-SOFTWA
>>>>>>>> RE&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
>>>
>>
>
########################################################################
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
|
