/[PAMELA software]/chewbacca/YodaProfiler/docs/baco
ViewVC logotype

Annotation of /chewbacca/YodaProfiler/docs/baco

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.1 - (hide annotations) (download)
Tue Sep 23 07:20:32 2008 UTC (16 years, 2 months ago) by mocchiut
Branch: MAIN
Branch point for: v0r00 
Initial revision
1 mocchiut 1.1
2    
3     WOW! using the new software features
4    
5    
6     Welcome to the PAMELA YodaProfiler, version v6r00
7    
8     1 => Initialize and open SQL connection
9     => using database to process the file
10    
11     DB INFORMATIONS:
12     SQL: MySQL Version: MySQL 4.1.20 Host srv-g2-01.ts.infn.it Port 3306
13    
14     chewbacca: query is SELECT ROOT_ID_N,PKT_NUMBER_INIT,PKT_NUMBER_FINAL,PKT_OBT_INIT,PKT_OBT_FINAL from ROOT_TABLE_MERGING where ID_N=4;
15     chewbacca: query is SELECT FOLDER_NAME,FILE_NAME,OBT_TIME_SYNC,LAST_TIME_SYNC_INFO,TIME_OFFSET,BOOT_NUMBER from ROOT_TABLE where ID_N=4;
16     chewbacca: filename is /gpfs/wizard/flight/src/nergal//yoda_07909_005_002_3.root
17     look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
18     - look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
19     - up , tjump was 50000 it was 0
20     look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
21     - look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
22     - up , tjump was 5000 it was 0
23     look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
24     - look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
25     - up , tjump was 1000 it was 0
26     look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
27     - look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
28     - up , tjump was 100 it was 0
29     look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
30     - look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
31     - up , tjump was 10 it was 0
32     look for up 0 13956844 13956849 nevent 256283 (nevent-1-it) 256282
33     - look for up 1 13956844 13956849 nevent 256283 (nevent-1-it) 256281
34     - up , tjump was 1 it was 1
35     look for down 0 13700268 13700263
36     down , tjump was 50000 it was 0
37     look for down 0 13700268 13700263
38     down , tjump was 5000 it was 0
39     look for down 0 13700268 13700263
40     down , tjump was 1000 it was 0
41     look for down 0 13700268 13700263
42     down , tjump was 100 it was 0
43     look for down 0 13700268 13700263
44     down , tjump was 10 it was 0
45     look for down 0 13700268 13700263
46     down , tjump was 1 it was 1
47     Chewbacca: chminentry 0 chmaxentry 256282 nevent 256283
48     RRRRRRR 13700266 13700263 13956849 2922220129 2922220356 2933443235
49     ++++ RH 1
50     RRRRRRR 13700983 13700263 13956849 2922220129 2922240637 2933443235
51     ++++ RH 2
52     RRRRRRR 13724628 13700263 13956849 2922220129 2923141402 2933443235
53     ++++ RH 3
54     RRRRRRR 13731149 13700263 13956849 2922220129 2923423620 2933443235
55     ++++ RH 4
56     RRRRRRR 13749250 13700263 13956849 2922220129 2924324373 2933443235
57     ++++ RH 5
58     RRRRRRR 13766070 13700263 13956849 2922220129 2924988669 2933443235
59     ++++ RH 6
60     RRRRRRR 13790228 13700263 13956849 2922220129 2925889009 2933443235
61     ++++ RH 7
62     RRRRRRR 13802199 13700263 13956849 2922220129 2926371782 2933443235
63     ++++ RH 8
64     RRRRRRR 13815531 13700263 13956849 2922220129 2927179746 2933443235
65     ++++ RH 9
66     RRRRRRR 13816428 13700263 13956849 2922220129 2927279989 2933443235
67     ++++ RH 10
68     RRRRRRR 13830939 13700263 13956849 2922220129 2927904692 2933443235
69     ++++ RH 11
70     RRRRRRR 13854644 13700263 13956849 2922220129 2928805010 2933443235
71     ++++ RH 12
72     RRRRRRR 13860665 13700263 13956849 2922220129 2929066951 2933443235
73     ++++ RH 13
74     RRRRRRR 13878954 13700263 13956849 2922220129 2929967271 2933443235
75     ++++ RH 14
76     RRRRRRR 13898698 13700263 13956849 2922220129 2930712047 2933443235
77     ++++ RH 15
78     RRRRRRR 13922913 13700263 13956849 2922220129 2931612386 2933443235
79     ++++ RH 16
80     RRRRRRR 13934823 13700263 13956849 2922220129 2932095463 2933443235
81     ++++ RH 17
82     RRRRRRR 13946131 13700263 13956849 2922220129 2932816220 2933443235
83     ++++ RH 18
84     RRRRRRR 13946999 13700263 13956849 2922220129 2932916649 2933443235
85     ++++ RH 19
86     TTTTTTT 13700979 13700263 13956849 2922220129 2922240413 2933443235
87     ++++ RT 1
88     TTTTTTT 13724622 13700263 13956849 2922220129 2923140673 2933443235
89     ++++ RT 2
90     TTTTTTT 13731145 13700263 13956849 2922220129 2923423132 2933443235
91     ++++ RT 3
92     TTTTTTT 13749245 13700263 13956849 2922220129 2924323645 2933443235
93     ++++ RT 4
94     TTTTTTT 13766066 13700263 13956849 2922220129 2924988286 2933443235
95     ++++ RT 5
96     TTTTTTT 13790224 13700263 13956849 2922220129 2925888706 2933443235
97     ++++ RT 6
98     TTTTTTT 13802195 13700263 13956849 2922220129 2926371520 2933443235
99     ++++ RT 7
100     TTTTTTT 13815445 13700263 13956849 2922220129 2927084812 2933443235
101     ++++ RT 8
102     TTTTTTT 13816425 13700263 13956849 2922220129 2927279771 2933443235
103     ++++ RT 9
104     TTTTTTT 13830935 13700263 13956849 2922220129 2927904416 2933443235
105     ++++ RT 10
106     TTTTTTT 13854640 13700263 13956849 2922220129 2928804707 2933443235
107     ++++ RT 11
108     TTTTTTT 13860661 13700263 13956849 2922220129 2929066713 2933443235
109     ++++ RT 12
110     TTTTTTT 13878950 13700263 13956849 2922220129 2929966968 2933443235
111     ++++ RT 13
112     TTTTTTT 13898693 13700263 13956849 2922220129 2930711759 2933443235
113     ++++ RT 14
114     TTTTTTT 13922909 13700263 13956849 2922220129 2931612080 2933443235
115     ++++ RT 15
116     TTTTTTT 13934819 13700263 13956849 2922220129 2932095203 2933443235
117     ++++ RT 16
118     TTTTTTT 13946045 13700263 13956849 2922220129 2932720848 2933443235
119     ++++ RT 17
120     TTTTTTT 13946995 13700263 13956849 2922220129 2932916342 2933443235
121     ++++ RT 18
122     TTTTTTT 13956846 13700263 13956849 2922220129 2933443235 2933443235
123     ++++ RT 19
124     NUMBER OF RH 19 RT 19 IN THE INTERVAL, NUMBER OF TOTAL RH 19 RT 19
125     First entries are: OBT 2922220129 pkt_num 13700263
126     Last entries are: OBT 2933443235 pkt_num 13956849 entry 256282
127     Upper limits are: OBT 2933443235 pkt_num 13956849 upper entry 256282
128     3 => Insert an entry in GL_TIMESYNC
129     select * from GL_RESURS_OFFSET where OFFSET_DATE=FROM_UNIXTIME(1191877200) limit 1;
130     Query the GL_TIMESYNC table to fill it:
131     INSERT INTO GL_TIMESYNC (ID_RAW,TYPE,OBT0,TIMESYNC,ID_RESURS_OFFSET) VALUES ('0','777','2910943000','2986177','12');
132     found a timesync t0 is 1191877200
133     4 => Update a single GL_RAW record with its BOOT_NUMBER
134     5 => Insert unpacked ROOT file in GL_ROOT
135     query is SELECT ID FROM GL_TIMESYNC where TIMESYNC=2986177 AND OBT0=2910943000 limit 1;
136     query is INSERT INTO GL_ROOT (ID_RAW, ID_TIMESYNC,PATH, NAME) VALUES ('0', '1', '$PAM_L0', 'yoda_07909_005_002_3.root')
137     query is SELECT ID FROM GL_ROOT WHERE PATH='$PAM_L0' and NAME='yoda_07909_005_002_3.root';
138     The ID of the ROOT file is 1
139     6 => Scan physics and store runs in the GL_RUN table
140     Loop in runtrailers, evbeft is 10630 upperentry 256282 cod->getetc 10631
141     Could be a good run, we have a runheader followed by a runtrailer 2 4294967295 0
142     ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 13724628 2923141402 2922240413
143     oh no! the distance between runheader and runtrailer seems wrong: check 13725340 pktt 13700979
144     try to recover run(s) without runheader and runtrailer between runheader and runtrailer
145     Check first is 40
146     Check last is 24
147     There are no-physics packets inside the run, try to separate runs
148     Standard case, evbefh is 34265 chminentry 0 cod->getetc 34266
149     Piece of run at the beginning of the file WITH NO RUNTRAILER evbefh = 34265
150     Check first is 17 firstev is 0
151     Check last is 40 lastev is 34265
152     There are no-phyics packets inside the run!
153     Never seen this case, try to handle it anyway, it was throw -95
154     Run between 0 and 709 entries
155     check if run has been inserted: query is
156     SELECT ID,NEVENTS,TRK_CALIB_USED,PKT_COUNTER FROM GL_RUN WHERE BOOT_NUMBER=0 AND ( (RUNHEADER_TIME>=1194874644 AND RUNTRAILER_TIME<=1194874684 AND ( RUNHEADER_OBT>=2922220371 OR RUNHEADER_PKT>=13700268) AND ( RUNTRAILER_OBT<=2922240363 OR RUNTRAILER_PKT<=13700977) ) OR (RUNHEADER_TIME<=1194874654 AND RUNTRAILER_TIME>=1194874674 AND ( RUNHEADER_OBT<=2922220371 OR RUNHEADER_PKT<=13700268) AND ( RUNTRAILER_OBT>=2922240363 OR RUNTRAILER_PKT>=13700977) OR (RUNHEADER_TIME=1194874654 AND RUNTRAILER_TIME=1194874674 AND NEVENTS>100) OR (RUNHEADER_TIME=1194874654 AND RUNTRAILER_TIME>1194874674 AND NEVENTS>100) OR (RUNHEADER_TIME<1194874654 AND RUNTRAILER_TIME=1194874674 AND NEVENTS>100) ));
157     The run is new
158     -> fill the DB
159     Run between 710 and 24344 entries
160     check if run has been inserted: query is
161     SELECT ID,NEVENTS,TRK_CALIB_USED,PKT_COUNTER FROM GL_RUN WHERE BOOT_NUMBER=0 AND ( (RUNHEADER_TIME>=1194874664 AND RUNTRAILER_TIME<=1194875584 AND ( RUNHEADER_OBT>=2922240667 OR RUNHEADER_PKT>=13700985) AND ( RUNTRAILER_OBT<=2923140668 OR RUNTRAILER_PKT<=13724620) ) OR (RUNHEADER_TIME<=1194874674 AND RUNTRAILER_TIME>=1194875574 AND ( RUNHEADER_OBT<=2922240667 OR RUNHEADER_PKT<=13700985) AND ( RUNTRAILER_OBT>=2923140668 OR RUNTRAILER_PKT>=13724620) OR (RUNHEADER_TIME=1194874674 AND RUNTRAILER_TIME=1194875574 AND NEVENTS>100) OR (RUNHEADER_TIME=1194874674 AND RUNTRAILER_TIME>1194875574 AND NEVENTS>100) OR (RUNHEADER_TIME<1194874674 AND RUNTRAILER_TIME=1194875574 AND NEVENTS>100) ));
162     The run is new
163     -> fill the DB
164     Run between 24345 and 30858 entries
165     check if run has been inserted: query is
166     SELECT ID,NEVENTS,TRK_CALIB_USED,PKT_COUNTER FROM GL_RUN WHERE BOOT_NUMBER=0 AND ( (RUNHEADER_TIME>=1194875565 AND RUNTRAILER_TIME<=1194875867 AND ( RUNHEADER_OBT>=2923141470 OR RUNHEADER_PKT>=13724630) AND ( RUNTRAILER_OBT<=2923423086 OR RUNTRAILER_PKT<=13731143) ) OR (RUNHEADER_TIME<=1194875575 AND RUNTRAILER_TIME>=1194875857 AND ( RUNHEADER_OBT<=2923141470 OR RUNHEADER_PKT<=13724630) AND ( RUNTRAILER_OBT>=2923423086 OR RUNTRAILER_PKT>=13731143) OR (RUNHEADER_TIME=1194875575 AND RUNTRAILER_TIME=1194875857 AND NEVENTS>100) OR (RUNHEADER_TIME=1194875575 AND RUNTRAILER_TIME>1194875857 AND NEVENTS>100) OR (RUNHEADER_TIME<1194875575 AND RUNTRAILER_TIME=1194875857 AND NEVENTS>100) ));
167     The run is new
168     -> fill the DB
169     Run between 30859 and 34265 entries
170     check if run has been inserted: query is
171     SELECT ID,NEVENTS,TRK_CALIB_USED,PKT_COUNTER FROM GL_RUN WHERE BOOT_NUMBER=0 AND ( (RUNHEADER_TIME>=1194875847 AND RUNTRAILER_TIME<=1194875987 AND ( RUNHEADER_OBT>=2923423645 OR RUNHEADER_PKT>=13731151) AND ( RUNTRAILER_OBT<=2923543541 OR RUNTRAILER_PKT<=13734557) ) OR (RUNHEADER_TIME<=1194875857 AND RUNTRAILER_TIME>=1194875977 AND ( RUNHEADER_OBT<=2923423645 OR RUNHEADER_PKT<=13731151) AND ( RUNTRAILER_OBT>=2923543541 OR RUNTRAILER_PKT>=13734557) OR (RUNHEADER_TIME=1194875857 AND RUNTRAILER_TIME=1194875977 AND NEVENTS>100) OR (RUNHEADER_TIME=1194875857 AND RUNTRAILER_TIME>1194875977 AND NEVENTS>100) OR (RUNHEADER_TIME<1194875857 AND RUNTRAILER_TIME=1194875977 AND NEVENTS>100) ));
172     The run is new
173     -> fill the DB
174     The run is not consistent, it contains non-physics packets! The run has been handled
175     The run is good, is it the other piece in the GL_RUN_FRAGMENTS table?
176     check if run has been inserted: query is
177     SELECT ID FROM GL_RUN_FRAGMENTS WHERE BOOT_NUMBER=0 AND ( (RUNHEADER_TIME>=1194874644 AND RUNTRAILER_TIME<=1194875867 AND ( RUNHEADER_OBT>=2922220371 OR RUNHEADER_PKT>=13700268) AND ( RUNTRAILER_OBT<=2923423086 OR RUNTRAILER_PKT<=13731143) ) OR (RUNHEADER_TIME<=1194874654 AND RUNTRAILER_TIME>=1194875857 AND ( RUNHEADER_OBT<=2922220371 OR RUNHEADER_PKT<=13700268) AND ( RUNTRAILER_OBT>=2923423086 OR RUNTRAILER_PKT>=13731143) ));
178     The run is new
179     -> fill the GL_RUNFRAGMENTS table
180     not found, check if we have already processed the file
181     check if run has been inserted: query is
182     SELECT ID FROM GL_RUN WHERE BOOT_NUMBER=0 AND ( (RUNHEADER_TIME>=1194874644 AND RUNTRAILER_TIME<=1194875867 AND ( RUNHEADER_OBT>=2922220371 OR RUNHEADER_PKT>=13700268) AND ( RUNTRAILER_OBT<=2923423086 OR RUNTRAILER_PKT<=13731143) ) OR (RUNHEADER_TIME<=1194874654 AND RUNTRAILER_TIME>=1194875857 AND ( RUNHEADER_OBT<=2922220371 OR RUNHEADER_PKT<=13700268) AND ( RUNTRAILER_OBT>=2923423086 OR RUNTRAILER_PKT>=13731143) ));
183     The run is already present in the GL_RUN table
184    
185     ERROR (-70) PEDANTIC: RUN ALREADY INSERTED
186    
187     13 => Free objects and close SQL connection
188     Total number of queries through GLTABLES: 10
189    
190     Finished, exiting...
191    
  ViewVC Help
Powered by ViewVC 1.1.23