| 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 |
|
|
|
Parent Directory
| 
Revision Log