-
Notifications
You must be signed in to change notification settings - Fork 7
2016 UL Alignments
Recommendation: use 271036 as the start of the IOV (first run of 2018A [1])
[1] https://twiki.cern.ch/twiki/bin/viewauth/CMS/PdmV2016Analysis#DATA
/SingleMuon/Run2016B-MuAlCalIsolatedMu-07Aug17_ver2-v1/ALCARECO:[273150, 275376]
/SingleMuon/Run2016C-MuAlCalIsolatedMu-07Aug17-v1/ALCARECO: [275656, 276283]
/SingleMuon/Run2016D-MuAlCalIsolatedMu-07Aug17-v1/ALCARECO: [276315, 276811]
/SingleMuon/Run2016E-MuAlCalIsolatedMu-07Aug17-v1/ALCARECO: [276831, 277420]
/SingleMuon/Run2016F-MuAlCalIsolatedMu-07Aug17-v1/ALCARECO: [277932, 278808]
/SingleMuon/Run2016G-MuAlCalIsolatedMu-07Aug17-v1/ALCARECO: [278820, 280385]
/SingleMuon/Run2016H-MuAlCalIsolatedMu-07Aug17-v1/ALCARECO: [281613, 284044]
PhEDEx Request:
-
https://cmsweb.cern.ch/phedex/prod/Request::View?request=1894473
-
https://cmsweb.cern.ch/phedex/prod/Request::View?request=1939768
-
https://cmsweb.cern.ch/phedex/prod/Request::View?request=1973002
Tracker DB: https://indico.cern.ch/event/853645/#3-ul-2016-further-studies-trac
271036 - 276314
Align over: 273158 - 276283 (7.84 /fb)
{"273158": [[1, 1279]], "273302": [[1, 459]], "273402": [[100, 292]], "273403": [[1, 53]], "273404": [[1, 18]], "273405": [[2, 25]], "273406": [[1, 112]], "273408": [[1, 6]], "273409": [[1, 309]], "273410": [[1, 90]], "273411": [[1, 29]], "273425": [[62, 352], [354, 733]], "273446": [[1, 33]], "273447": [[1, 113], [115, 412]], "273448": [[1, 391]], "273449": [[1, 214]], "273450": [[1, 214], [219, 647]], "273492": [[71, 71], [73, 282], [284, 325], [327, 338]], "273493": [[1, 233]], "273494": [[1, 192]], "273502": [[73, 256], [258, 318], [320, 813], [815, 1064]], "273503": [[1, 598]], "273554": [[77, 437]], "273555": [[1, 173]], "273725": [[83, 252], [254, 2545]], "273728": [[1, 100]], "273730": [[1, 1814], [1820, 2126]], "274094": [[108, 332]], "274146": [[1, 67]], "274157": [[105, 534]], "274159": [[1, 43]], "274160": [[1, 207]], "274161": [[1, 516]], "274172": [[31, 95]], "274198": [[81, 191]], "274199": [[1, 623]], "274200": [[1, 678]], "274240": [[1, 40], [42, 82]], "274241": [[1, 1152], [1161, 1176]], "274244": [[1, 607]], "274250": [[1, 701]], "274251": [[1, 546]], "274283": [[2, 19]], "274284": [[1, 210]], "274286": [[1, 154]], "274314": [[97, 97], [99, 158]], "274315": [[1, 424]], "274316": [[1, 959]], "274317": [[1, 3]], "274319": [[1, 225]], "274335": [[60, 1003]], "274336": [[1, 14]], "274337": [[3, 17]], "274338": [[1, 698]], "274339": [[1, 29], [31, 31], [33, 33], [35, 93]], "274344": [[1, 632]], "274345": [[1, 170]], "274382": [[94, 144]], "274387": [[88, 439]], "274388": [[1, 1820]], "274420": [[94, 268]], "274421": [[1, 342]], "274422": [[1, 2207]], "274440": [[92, 493]], "274441": [[1, 431]], "274442": [[1, 752]], "274954": [[37, 37], [39, 57]], "274955": [[1, 91]], "274968": [[1, 1192]], "274969": [[1, 1003]], "274970": [[1, 47]], "274971": [[1, 905]], "274998": [[64, 782]], "274999": [[1, 1241]], "275000": [[1, 136]], "275001": [[1, 1781], [1786, 2061]], "275059": [[78, 81], [105, 137]], "275066": [[1, 96]], "275067": [[1, 392]], "275068": [[1, 915]], "275073": [[1, 517]], "275074": [[1, 442], [444, 647]], "275124": [[106, 106], [108, 431]], "275125": [[1, 989]], "275282": [[91, 180]], "275283": [[1, 132]], "275284": [[1, 74]], "275290": [[96, 143]], "275291": [[1, 347]], "275292": [[1, 121]], "275293": [[1, 142], [144, 201]], "275309": [[55, 617]], "275310": [[1, 1929]], "275311": [[1, 1253]], "275319": [[141, 282]], "275337": [[1, 427]], "275338": [[1, 520]], "275344": [[76, 356]], "275345": [[1, 353]], "275370": [[81, 365]], "275371": [[1, 22], [28, 569]], "275375": [[127, 1449]], "275376": [[1, 2667], [2669, 3096]], "275657": [[1, 105]], "275658": [[1, 337]], "275659": [[1, 17]], "275761": [[1, 9]], "275767": [[1, 4]], "275772": [[1, 56]], "275773": [[1, 7]], "275774": [[1, 311], [315, 315]], "275776": [[1, 140]], "275777": [[1, 300]], "275778": [[1, 305]], "275782": [[1, 131], [133, 762]], "275832": [[1, 367]], "275833": [[1, 53], [56, 115], [117, 251]], "275834": [[1, 297]], "275835": [[1, 13]], "275836": [[1, 429], [431, 1163], [1166, 1170], [1184, 1293]], "275837": [[1, 186], [198, 726]], "275847": [[1, 2263]], "275886": [[73, 109]], "275890": [[1, 1393]], "275911": [[62, 298], [300, 354], [356, 440]], "275912": [[1, 289]], "275913": [[1, 475]], "275918": [[1, 318], [348, 361]], "275920": [[5, 463]], "275921": [[1, 2], [4, 5], [17, 20]], "275923": [[3, 53], [63, 64], [66, 126]], "275931": [[1, 14], [19, 89]], "275963": [[82, 139], [141, 172]], "276092": [[74, 149]], "276097": [[1, 507]], "276242": [[1, 7], [18, 61], [72, 1664]], "276243": [[1, 15], [18, 480], [482, 611]], "276244": [[3, 1202]], "276282": [[75, 534], [537, 1142]], "276283": [[3, 1087]]}
276315 - 280927
Align over: 276315 - 277420 (8.31 /fb)
{"276315": [[40, 175], [178, 217]], "276317": [[3, 138]], "276318": [[3, 103], [106, 570]], "276355": [[1, 33]], "276361": [[1, 161], [169, 208], [210, 800], [802, 833]], "276363": [[1, 140], [142, 238], [242, 1482]], "276384": [[2, 1117]], "276437": [[63, 224], [227, 1074], [1076, 2190]], "276454": [[1, 527]], "276458": [[1, 341]], "276495": [[87, 268]], "276501": [[4, 221], [223, 2547]], "276502": [[2, 741]], "276525": [[88, 469], [471, 1606], [1626, 2893]], "276527": [[1, 214]], "276528": [[4, 394]], "276542": [[74, 857]], "276543": [[1, 638], [643, 952]], "276544": [[2, 161]], "276545": [[2, 110], [117, 213]], "276581": [[79, 444]], "276582": [[1, 871]], "276583": [[1, 52]], "276584": [[1, 2]], "276585": [[1, 238], [241, 242], [245, 246]], "276586": [[2, 658], [680, 773]], "276587": [[1, 1006]], "276653": [[72, 550]], "276655": [[1, 593], [595, 1106]], "276659": [[1, 127], [129, 252]], "276775": [[96, 1260]], "276776": [[1, 1823]], "276794": [[1, 885]], "276807": [[66, 220]], "276808": [[1, 875]], "276810": [[1, 287]], "276811": [[1, 1270], [1272, 2563]], "276831": [[64, 755], [761, 2702]], "276834": [[1, 720]], "276870": [[78, 1354], [1356, 3108], [3111, 3258], [3260, 3484]], "276935": [[79, 184], [186, 838], [842, 906]], "276940": [[70, 213]], "276946": [[1, 27]], "276947": [[1, 89], [91, 126], [135, 141]], "276948": [[1, 474]], "276950": [[1, 2353]], "277069": [[81, 265], [267, 390]], "277070": [[1, 309], [311, 1059]], "277071": [[1, 82], [90, 178]], "277072": [[1, 253], [256, 466]], "277073": [[1, 90]], "277076": [[1, 3], [5, 7], [9, 35], [38, 1037]], "277087": [[204, 1191]], "277094": [[1, 161], [164, 584]], "277096": [[1, 1309], [1311, 2086]], "277112": [[1, 155]], "277126": [[42, 59]], "277127": [[1, 438], [440, 902]], "277148": [[83, 190], [193, 700]], "277166": [[77, 186], [188, 431]], "277168": [[1, 1708], [1711, 1822], [1824, 2223]], "277180": [[88, 228]], "277194": [[113, 139], [144, 497], [500, 1115], [1117, 1312], [1320, 1749], [1754, 2067], [2070, 2070]], "277305": [[62, 744]], "277420": [[84, 84], [86, 291], [293, 346]]}
280928-284044
Align over: 281613 - 284044 (8.75 /fb)
{"281613": [[101, 128], [130, 130], [133, 133], [135, 139], [143, 256], [258, 903]], "281639": [[1, 132]], "281641": [[1, 319]], "281693": [[1, 2191]], "281707": [[99, 982], [1000, 1065]], "281726": [[1, 288]], "281727": [[1, 1605]], "281797": [[125, 2176]], "281975": [[1, 215]], "281976": [[1, 2166]], "282033": [[82, 117]], "282034": [[1, 33]], "282035": [[1, 40]], "282037": [[1, 457], [459, 1862]], "282092": [[92, 222], [624, 2276]], "282708": [[1, 8]], "282710": [[1, 2], [8, 8]], "282712": [[1, 1], [10, 68]], "282730": [[89, 164]], "282731": [[1, 172]], "282732": [[1, 69]], "282733": [[1, 177]], "282734": [[1, 327]], "282735": [[1, 642], [645, 1232], [1235, 1823]], "282800": [[1, 377]], "282807": [[1, 326]], "282814": [[1, 1843]], "282842": [[1, 80]], "282917": [[117, 157], [159, 191]], "282918": [[1, 51]], "282919": [[1, 243]], "282922": [[1, 131]], "282923": [[1, 17], [19, 30], [32, 36], [38, 39], [41, 86], [88, 224]], "283042": [[1, 6]], "283043": [[1, 105], [108, 519]], "283049": [[82, 93]], "283050": [[1, 212]], "283052": [[1, 111]], "283059": [[1, 125], [127, 451]], "283270": [[76, 573], [576, 1502], [1504, 1888], [1890, 1912]], "283283": [[4, 1668], [1670, 1748]], "283305": [[79, 85]], "283306": [[1, 289]], "283307": [[1, 153], [156, 456]], "283308": [[1, 547], [549, 571], [573, 895], [897, 948]], "283353": [[80, 822]], "283358": [[1, 243], [245, 981]], "283359": [[1, 428]], "283407": [[82, 114]], "283408": [[1, 27], [29, 2088], [2098, 2125], [2203, 2416], [2528, 2542]], "283416": [[49, 151], [154, 245]], "283453": [[83, 537]], "283469": [[74, 74]], "283478": [[76, 303], [324, 969]], "283548": [[145, 288]], "283680": [[1, 81]], "283681": [[1, 17]], "283682": [[1, 384]], "283685": [[1, 314]], "283820": [[67, 1548]], "283830": [[1, 722]], "283834": [[1, 67], [69, 82]], "283835": [[1, 14], [16, 112]], "283865": [[1, 1177]], "283876": [[65, 211], [215, 724]], "283877": [[1, 1496]], "283884": [[349, 504], [509, 756]], "283885": [[1, 1723]], "283933": [[88, 232]], "283934": [[1, 784], [793, 870], [875, 1245], [1267, 1291]], "283946": [[85, 1448], [1450, 1462]], "283964": [[1, 388]], "284006": [[73, 390]], "284014": [[1, 266]], "284025": [[110, 157]], "284029": [[1, 112]], "284035": [[1, 360]], "284036": [[1, 140], [143, 348]], "284037": [[1, 340]], "284038": [[1, 55]], "284039": [[1, 30]], "284040": [[1, 33]], "284041": [[1, 44]], "284042": [[1, 129]], "284043": [[1, 205], [210, 224]], "284044": [[1, 30]]}
CMSSW release: CMSSW_10_6_4
GT: 106X_dataRun2_UL2016TkAl_v24
Tracker Sign-off: https://indico.cern.ch/event/848325/#3-ul-2016-sign-off-tracker-ali
GPR Sign-off: https://indico.cern.ch/event/854617/#6-ul-2016-sign-off-gpr
Alignment: https://indico.cern.ch/event/854616/#8-ul-2016-status-report-muon-a
Physics validation: https://indico.cern.ch/event/854617/#5-ul-2016-muon-alignment-sign
Sign-off: https://indico.cern.ch/event/859480/#3-ul-2016-sign-off-muongpr
DTAlignment_2018_UL_v2
data_DT-1100-111111_2016UL_IOV1_CMSSW106_JSON-271036-276314_dataRun2_MuAl_v1_01.db: b35397b24393119b1d4225da1973adef3d69946c
data_DT-1100-111111_2016UL_IOV2_CMSSW106_JSON-276315-280927_dataRun2_MuAl_v1_01.db: 7c6b0af035705fadd7595f6894318cee7d98fcf8
data_DT-1100-111111_2016UL_IOV3_CMSSW106_JSON-280928-284044_dataRun2_MuAl_v1_01.db: a996ba8817087c1776243704193d82af8e4be917
conddb_import -c sqlite_file:data_DT_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i DTAlignment_2018_UL_v2 -t DTAlignmentRcd -b 0 -e 271035
conddb --db data_DT_short.db list DTAlignmentRcd
Since: Run Insertion Time Payload Object Type
----------- -------------------------- ---------------------------------------- -----------
1 2019-10-30 22:07:36.179679 c73311ece81a057ac0a2a1454386161493b22120 Alignments
126000 2019-10-30 22:07:36.187195 c73153c55efbd075487478adef4e4b7b0f9a46c8 Alignments
157866 2019-10-30 22:07:36.194722 66e71c4cf462348272da41cad7336a931731dc0e Alignments
185189 2019-10-30 22:07:36.200694 f5c7f7aa1a88dfc870038b0fe53987c98562fe33 Alignments
233238 2019-10-30 22:07:36.211516 00589442fc0fba38c9f147c42a36e53df27b8d59 Alignments
238341 2019-10-30 22:07:36.218340 9cbd0edce1a92f0b7d6fb19a26b659f1bfa80336 Alignments
250933 2019-10-30 22:07:36.225266 78ec2669108f782c813ff90d2bd6bfc76a6ace79 Alignments
conddb_import -c sqlite:data_DT_short.db -f sqlite:data_DT-1100-111111_2016UL_IOV1_CMSSW106_JSON-271036-276314_dataRun2_MuAl_v1_01.db -i DTAlignmentRcd -t DTAlignmentRcd -b 271036 -e 276314
conddb_import -c sqlite:data_DT_short.db -f sqlite:data_DT-1100-111111_2016UL_IOV2_CMSSW106_JSON-276315-280927_dataRun2_MuAl_v1_01.db -i DTAlignmentRcd -t DTAlignmentRcd -b 276315 -e 280927
conddb_import -c sqlite:data_DT_short.db -f sqlite:data_DT-1100-111111_2016UL_IOV3_CMSSW106_JSON-280928-284044_dataRun2_MuAl_v1_01.db -i DTAlignmentRcd -t DTAlignmentRcd -b 280928 -e 284044
conddb_import -c sqlite:data_DT_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i DTAlignment_2018_UL_v2 -t DTAlignmentRcd -b 284045
conddb --db data_DT_short.db list DTAlignmentRcd
Since: Run Insertion Time Payload Object Type
----------- -------------------------- ---------------------------------------- -----------
1 2019-10-30 22:07:36.179679 c73311ece81a057ac0a2a1454386161493b22120 Alignments
126000 2019-10-30 22:07:36.187195 c73153c55efbd075487478adef4e4b7b0f9a46c8 Alignments
157866 2019-10-30 22:07:36.194722 66e71c4cf462348272da41cad7336a931731dc0e Alignments
185189 2019-10-30 22:07:36.200694 f5c7f7aa1a88dfc870038b0fe53987c98562fe33 Alignments
233238 2019-10-30 22:07:36.211516 00589442fc0fba38c9f147c42a36e53df27b8d59 Alignments
238341 2019-10-30 22:07:36.218340 9cbd0edce1a92f0b7d6fb19a26b659f1bfa80336 Alignments
250933 2019-10-30 22:07:36.225266 78ec2669108f782c813ff90d2bd6bfc76a6ace79 Alignments
271036 2019-10-30 22:07:40.066763 b35397b24393119b1d4225da1973adef3d69946c Alignments
276315 2019-10-30 22:07:40.777857 7c6b0af035705fadd7595f6894318cee7d98fcf8 Alignments
280928 2019-10-30 22:07:41.564970 a996ba8817087c1776243704193d82af8e4be917 Alignments
284045 2019-10-30 22:07:46.489333 e6e7e3db0821d29cb9954034f243b06b90708c1a Alignments
293466 2019-10-30 22:07:46.495805 cbbf431b2ad8aab5d570070bd889d9c04fc21311 Alignments
297049 2019-10-30 22:07:46.504300 a96ff5d1c0695c474424099048dd30253be30877 Alignments
300817 2019-10-30 22:07:46.510525 113e8bcb0d359ba5714a961909c47c4564d3dd7d Alignments
304000 2019-10-30 22:07:46.517760 83998ac5dd182c22e7dde0bc33edbe1357258aeb Alignments
307082 2019-10-30 22:07:46.528715 2e8d0cea957f4855541d0209b69404ccf23509a8 Alignments
313041 2019-10-30 22:07:46.536711 85ca6e7bd4d895b40f146011df2c76ed35c8dccc Alignments
314472 2019-10-30 22:07:46.542536 97b210a7e66b734eb8a738bc7ecb3b3dfc680980 Alignments
320377 2019-10-30 22:07:46.561710 4ace088d2fcbeb8f0e648daa57d4dedb4f01c0c8 Alignments
322603 2019-10-30 22:07:46.567622 a47d040149aad5bf8ce1efcfbe1429b253bf64ee Alignments
{ "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": { "DTAlignment_2016_UL_v1": {} }, "inputTag": "DTAlignmentRcd", "since": null, "userText": "2016 UL ReReco DTAlignmentRcd" }
conddb diff DTAlignment_2016_UL_v1 DTAlignment_2018_UL_v2
Range pro::DTAlignment_2016_UL_v1 Payload pro::DTAlignment_2018_UL_v2 Payload
------------------ ---------------------------------------- ----------------------------------------
[1, 271036) = =
[271036, 271952) b35397b24393119b1d4225da1973adef3d69946c 78ec2669108f782c813ff90d2bd6bfc76a6ace79
[271952, 276315) b35397b24393119b1d4225da1973adef3d69946c e6e7e3db0821d29cb9954034f243b06b90708c1a
[276315, 280928) 7c6b0af035705fadd7595f6894318cee7d98fcf8 e6e7e3db0821d29cb9954034f243b06b90708c1a
[280928, 284045) a996ba8817087c1776243704193d82af8e4be917 e6e7e3db0821d29cb9954034f243b06b90708c1a
[284045, Infinity) = =
CSCAlignment_2018_UL_v3
data_CSC-1100-110001_2016UL_IOV1_CMSSW106_JSON-271036-276314_dataRun2_MuAl_v1_01.db: 33635204c7b5e8db12be492d9e1bd61673ac6732
data_CSC-1100-110001_2016UL_IOV2_CMSSW106_JSON-276315-280927_dataRun2_MuAl_v1_01.db: 85f7ac17e8d01dc340c2447f8759515d2f480184
data_CSC-1100-110001_2016UL_IOV3_CMSSW106_JSON-280928-284044_dataRun2_MuAl_v1_01.db: cd4a273738faf96f8e2b8a24d46d3e3b81fe6c95
conddb_import -c sqlite_file:data_CSC_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i CSCAlignment_2018_UL_v3 -t CSCAlignmentRcd -b 0 -e 271035
conddb --db data_CSC_short.db list CSCAlignmentRcd
Since: Run Insertion Time Payload Object Type
----------- -------------------------- ---------------------------------------- -----------
1 2019-10-30 22:07:37.672862 026fe1ec9ee55023890fda434bae581302838833 Alignments
126000 2019-10-30 22:07:37.678616 bbb4c95ed02de6c5531fbdd4a569ef4613f056bf Alignments
157866 2019-10-30 22:07:37.685544 e95d92cd4c845ea008b1be75faeae5018ad91ebc Alignments
185189 2019-10-30 22:07:37.691996 5c65c6dcfc597cc4a7af16c3db3efa958c0b3087 Alignments
250933 2019-10-30 22:07:37.699651 d41465cae4d75b4054822a21df6af8a330091a1a Alignments
conddb_import -c sqlite:data_CSC_short.db -f sqlite:data_CSC-1100-110001_2016UL_IOV1_CMSSW106_JSON-271036-276314_dataRun2_MuAl_v1_01.db -i CSCAlignmentRcd -t CSCAlignmentRcd -b 271036 -e 276314
conddb_import -c sqlite:data_CSC_short.db -f sqlite:data_CSC-1100-110001_2016UL_IOV2_CMSSW106_JSON-276315-280927_dataRun2_MuAl_v1_01.db -i CSCAlignmentRcd -t CSCAlignmentRcd -b 276315 -e 280927
conddb_import -c sqlite:data_CSC_short.db -f sqlite:data_CSC-1100-110001_2016UL_IOV3_CMSSW106_JSON-280928-284044_dataRun2_MuAl_v1_01.db -i CSCAlignmentRcd -t CSCAlignmentRcd -b 280928 -e 284044
conddb_import -c sqlite:data_CSC_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i CSCAlignment_2018_UL_v3 -t CSCAlignmentRcd -b 284045
conddb --db data_CSC_short.db list CSCAlignmentRcd
Since: Run Insertion Time Payload Object Type
----------- -------------------------- ---------------------------------------- -----------
1 2019-10-30 22:07:37.672862 026fe1ec9ee55023890fda434bae581302838833 Alignments
126000 2019-10-30 22:07:37.678616 bbb4c95ed02de6c5531fbdd4a569ef4613f056bf Alignments
157866 2019-10-30 22:07:37.685544 e95d92cd4c845ea008b1be75faeae5018ad91ebc Alignments
185189 2019-10-30 22:07:37.691996 5c65c6dcfc597cc4a7af16c3db3efa958c0b3087 Alignments
250933 2019-10-30 22:07:37.699651 d41465cae4d75b4054822a21df6af8a330091a1a Alignments
271036 2019-10-30 22:07:42.311685 33635204c7b5e8db12be492d9e1bd61673ac6732 Alignments
276315 2019-10-30 22:07:43.119709 85f7ac17e8d01dc340c2447f8759515d2f480184 Alignments
280928 2019-10-30 22:07:43.801130 cd4a273738faf96f8e2b8a24d46d3e3b81fe6c95 Alignments
284045 2019-10-30 22:07:47.333682 8c6841aaf4fb53cfcf3aec57aa630a19eccc6013 Alignments
293466 2019-10-30 22:07:47.341124 0ab8834ad8d67a4bf73311be521ccee6cb6b71d7 Alignments
297049 2019-10-30 22:07:47.348927 ca997811445961ddb4c964a02ca22ed4a44117ec Alignments
300817 2019-10-30 22:07:47.354930 a01c9d976ab4ca5e36f8757eea4412cfecc07390 Alignments
304000 2019-10-30 22:07:47.361806 c0aa126feff8ccd07491faa6b2ca03954b664a57 Alignments
307082 2019-10-30 22:07:47.368678 684e4a7182abeebfe6b9dddd5ce41ac54e2059f2 Alignments
313041 2019-10-30 22:07:47.400619 25c002b179e37876ee27f49e35b119ff92105bc6 Alignments
314472 2019-10-30 22:07:47.410840 be1743fc3978eb3ece71781130c6473b25a207e0 Alignments
320377 2019-10-30 22:07:47.420184 e099f2e961641b0feac6058995ac25991905ed44 Alignments
322603 2019-10-30 22:07:47.431189 682f670532ddead56a55e157ac57fa5177ae2e7e Alignments
{ "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": { "CSCAlignment_2016_UL_v1": {} }, "inputTag": "CSCAlignmentRcd", "since": null, "userText": "2016 UL ReReco CSCAlignmentRcd"
conddb diff CSCAlignment_2016_UL_v1 CSCAlignment_2018_UL_v3
Range pro::CSCAlignment_2016_UL_v1 Payload pro::CSCAlignment_2018_UL_v3 Payload
------------------ ---------------------------------------- ----------------------------------------
[1, 271036) = =
[271036, 271952) 33635204c7b5e8db12be492d9e1bd61673ac6732 d41465cae4d75b4054822a21df6af8a330091a1a
[271952, 276315) 33635204c7b5e8db12be492d9e1bd61673ac6732 8c6841aaf4fb53cfcf3aec57aa630a19eccc6013
[276315, 280928) 85f7ac17e8d01dc340c2447f8759515d2f480184 8c6841aaf4fb53cfcf3aec57aa630a19eccc6013
[280928, 284045) cd4a273738faf96f8e2b8a24d46d3e3b81fe6c95 8c6841aaf4fb53cfcf3aec57aa630a19eccc6013
[284045, Infinity) = =
GlobalAlignment_2018_UL_v2
GPR_Oct5_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV1_dL4_iter1.db: 684b673ebc4eb3c10eba3b508a7b793e7f3a8f93
GPR_Oct6_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV2_dL4_iter1.db: 43a1b9264ceec15beade51260fc4654a00653ef9
GPR_Oct7_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV3_dL4_iter1.db: 5ef6fa2013def65768857566e82dc5806953cbd5
conddb_import -c sqlite_file:data_GPR_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i GlobalAlignment_2018_UL_v2 -t GlobalPositionRcd -b 0 -e 271035
conddb --db data_GPR_short.db list GlobalPositionRcd
Since: Run Insertion Time Payload Object Type
----------- -------------------------- ---------------------------------------- -----------
1 2019-10-30 22:07:38.972129 bebab3b872ed1374f553b40874eabeed7083bc68 Alignments
111462 2019-10-30 22:07:38.973438 f11ab0bbcc7a5a62bd7cedd16abef7237296af5a Alignments
125597 2019-10-30 22:07:38.974670 715c012706896ec0f544aa98db2ac01298a998de Alignments
125913 2019-10-30 22:07:38.976111 ac4ea80e58fc9916c0ec040021710baec5b6dbee Alignments
126000 2019-10-30 22:07:38.977171 29ae6df8edf5529a71539f6fb9bde1737d5e15f0 Alignments
157866 2019-10-30 22:07:38.978257 1fed0c079b602f496c143f9053938ad34b94aee4 Alignments
185189 2019-10-30 22:07:38.979459 a4fa987fd3e5fce7709bd57bd25c01969de134f1 Alignments
233238 2019-10-30 22:07:38.980683 682477060c27c698b3e346e58d18c175afebe073 Alignments
250933 2019-10-30 22:07:38.981880 68163d6221b5ca1e76ab8aeb0f987c74ddb14373 Alignments
conddb_import -c sqlite:data_GPR_short.db -f sqlite:GPR_Oct5_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV1_dL4_iter1.db -i IdealGeometry -t GlobalPositionRcd -b 271036 -e 276314
conddb_import -c sqlite:data_GPR_short.db -f sqlite:GPR_Oct6_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV2_dL4_iter1.db -i IdealGeometry -t GlobalPositionRcd -b 276315 -e 280927
conddb_import -c sqlite:data_GPR_short.db -f sqlite:GPR_Oct7_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV3_dL4_iter1.db -i IdealGeometry -t GlobalPositionRcd -b 280928 -e 284044
conddb_import -c sqlite:data_GPR_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i GlobalAlignment_2018_UL_v2 -t GlobalPositionRcd -b 284045
conddb --db data_GPR_short.db list GlobalPositionRcd
Since: Run Insertion Time Payload Object Type
----------- -------------------------- ---------------------------------------- -----------
1 2019-10-30 22:07:38.972129 bebab3b872ed1374f553b40874eabeed7083bc68 Alignments
111462 2019-10-30 22:07:38.973438 f11ab0bbcc7a5a62bd7cedd16abef7237296af5a Alignments
125597 2019-10-30 22:07:38.974670 715c012706896ec0f544aa98db2ac01298a998de Alignments
125913 2019-10-30 22:07:38.976111 ac4ea80e58fc9916c0ec040021710baec5b6dbee Alignments
126000 2019-10-30 22:07:38.977171 29ae6df8edf5529a71539f6fb9bde1737d5e15f0 Alignments
157866 2019-10-30 22:07:38.978257 1fed0c079b602f496c143f9053938ad34b94aee4 Alignments
185189 2019-10-30 22:07:38.979459 a4fa987fd3e5fce7709bd57bd25c01969de134f1 Alignments
233238 2019-10-30 22:07:38.980683 682477060c27c698b3e346e58d18c175afebe073 Alignments
250933 2019-10-30 22:07:38.981880 68163d6221b5ca1e76ab8aeb0f987c74ddb14373 Alignments
271036 2019-10-30 22:07:44.458479 684b673ebc4eb3c10eba3b508a7b793e7f3a8f93 Alignments
276315 2019-10-30 22:07:45.083003 43a1b9264ceec15beade51260fc4654a00653ef9 Alignments
280928 2019-10-30 22:07:45.787849 5ef6fa2013def65768857566e82dc5806953cbd5 Alignments
284045 2019-10-30 22:07:48.225848 7f794ee33f398dc10431fbf459d328cf167c1c13 Alignments
293466 2019-10-30 22:07:48.227215 a38e5ed21b79a3b50efd7ff735cc054f070e4415 Alignments
297049 2019-10-30 22:07:48.228251 cf403b0b4391bdc6b4d949c5da740a4631a33cd9 Alignments
300817 2019-10-30 22:07:48.229475 9c82ef40a18decc7de1300c5340f43c3ec9d9547 Alignments
304000 2019-10-30 22:07:48.230926 cc19d5f61e7ee5ec19a6f8bc50a3e07abff9269f Alignments
307082 2019-10-30 22:07:48.232480 41669f34eb927bf1468e66abc56a850d581d573a Alignments
313041 2019-10-30 22:07:48.233544 fff98d5a97b8d878768307bd09cdcf240032db2e Alignments
314472 2019-10-30 22:07:48.234687 d912ca8411848520757b6864cf1e6542037cd58b Alignments
320377 2019-10-30 22:07:48.235735 59a3e7ce9caebcbd3cbfa7bccd639267df1a017e Alignments
322603 2019-10-30 22:07:48.236849 15c2fbdd7a3299b19f5eaaeedc80f89b85cad463 Alignments
{ "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": { "GlobalAlignment_2016_UL_v1": {} }, "inputTag": "GlobalPositionRcd", "since": null, "userText": "2016 UL ReReco GlobalPositionRcd" }
conddb diff GlobalAlignment_2016_UL_v1 GlobalAlignment_2018_UL_v2
Range pro::GlobalAlignment_2016_UL_v1 Payload pro::GlobalAlignment_2018_UL_v2 Payload
------------------ ---------------------------------------- ----------------------------------------
[1, 271036) = =
[271036, 271952) 684b673ebc4eb3c10eba3b508a7b793e7f3a8f93 68163d6221b5ca1e76ab8aeb0f987c74ddb14373
[271952, 276315) 684b673ebc4eb3c10eba3b508a7b793e7f3a8f93 7f794ee33f398dc10431fbf459d328cf167c1c13
[276315, 280928) 43a1b9264ceec15beade51260fc4654a00653ef9 7f794ee33f398dc10431fbf459d328cf167c1c13
[280928, 284045) 5ef6fa2013def65768857566e82dc5806953cbd5 7f794ee33f398dc10431fbf459d328cf167c1c13
[284045, Infinity) = =
import os
DT = ["data_DT-1100-111111_2016UL_IOV1_CMSSW106_JSON-271036-276314_dataRun2_MuAl_v1_01.db", "data_DT-1100-111111_2016UL_IOV2_CMSSW106_JSON-276315-280927_dataRun2_MuAl_v1_01.db", "data_DT-1100-111111_2016UL_IOV3_CMSSW106_JSON-280928-284044_dataRun2_MuAl_v1_01.db"]
CSC = ["data_CSC-1100-110001_2016UL_IOV1_CMSSW106_JSON-271036-276314_dataRun2_MuAl_v1_01.db", "data_CSC-1100-110001_2016UL_IOV2_CMSSW106_JSON-276315-280927_dataRun2_MuAl_v1_01.db", "data_CSC-1100-110001_2016UL_IOV3_CMSSW106_JSON-280928-284044_dataRun2_MuAl_v1_01.db"]
GPR = ["GPR_Oct5_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV1_dL4_iter1.db", "GPR_Oct6_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV2_dL4_iter1.db", "GPR_Oct7_2019_SW1064_GT106X_dataRun2_UL2016TkAl_v24_IOV3_dL4_iter1.db"]
IOVs = [[271036, 276314], [276315, 280927], [280928, 284044]]
start, end = 271036, 284044
lDT = "DTAlignment_2018_UL_v2"
lCSC = "CSCAlignment_2018_UL_v3"
lGPR = "GlobalAlignment_2018_UL_v2"
nDT = "DTAlignment_2016_UL_v1"
nCSC = "CSCAlignment_2016_UL_v1"
nGPR = "GlobalAlignment_2016_UL_v1"
#++++++++++++++++++++++++++++++++++++++++++++++++++++
tagNameDT = "DTAlignmentRcd"
tagNameCSC = "CSCAlignmentRcd"
tagNameGPR,tmpNameGPR = "GlobalPositionRcd", "IdealGeometry"
baseDT = "data_DT_short.db"
baseCSC = "data_CSC_short.db"
baseGPR = "data_GPR_short.db"
tagList = []
tagList.extend(DT)
tagList.extend(CSC)
tagList.extend(GPR)
baseList = [baseDT, baseCSC, baseGPR]
log = """{{ "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": {{ "{newTagName}": {{}} }}, "inputTag": "{tagNameT}", "since": null, "userText": "{userText}" }}"""
def getDet(x_):
i = -1
if x_ in DT: i = DT.index(x_)
if x_ in CSC: i = CSC.index(x_)
if x_ in GPR: i = GPR.index(x_)
if "DT" in x_: return {'arg':x_, 'base':baseDT, 'tagNameI':tagNameDT, 'tagNameT':tagNameDT, 'lDB':lDT, 'sRun':IOVs[i][0], 'eRun':IOVs[i][1], 'iStart':start-1, 'iEnd':end+1, 'newTagName':nDT, 'userText':"2016 UL ReReco DTAlignmentRcd"}
if "CSC" in x_: return {'arg':x_, 'base':baseCSC, 'tagNameI':tagNameCSC, 'tagNameT':tagNameCSC, 'lDB':lCSC, 'sRun':IOVs[i][0], 'eRun':IOVs[i][1], 'iStart':start-1, 'iEnd':end+1, 'newTagName':nCSC, 'userText':"2016 UL ReReco CSCAlignmentRcd"}
if "GPR" in x_: return {'arg':x_, 'base':baseGPR, 'tagNameI':tmpNameGPR, 'tagNameT':tagNameGPR, 'lDB':lGPR, 'sRun':IOVs[i][0], 'eRun':IOVs[i][1], 'iStart':start-1, 'iEnd':end+1, 'newTagName':nGPR, 'userText':"2016 UL ReReco GlobalPositionRcd"}
def runCMD(x_):
print x_
os.system(x_)
def getPayLoad():
print "check payload"
for x in tagList:
tmp = "conddb --db {arg} list {tagNameI}".format(**getDet(x))
runCMD(tmp)
def getBaseDB():
print "get base DB"
for x in baseList:
if x in os.listdir("."):
print x+" exist"
os.system("rm "+x)
tmp = "conddb_import -c sqlite_file:{base} -f frontier://FrontierProd/CMS_CONDITIONS -i {lDB} -t {tagNameT} -b 0 -e {iStart}".format(**getDet(x))
runCMD(tmp)
tmp2 = "conddb --db {arg} list {tagNameT}".format(**getDet(x))
runCMD(tmp2)
def importTags():
print "import tags"
for x in tagList:
tmp = "conddb_import -c sqlite:{base} -f sqlite:{arg} -i {tagNameI} -t {tagNameT} -b {sRun} -e {eRun}".format(**getDet(x))
runCMD(tmp)
def addNextTags():
print "add tags"
for x in baseList:
tmp = "conddb_import -c sqlite:{base} -f frontier://FrontierProd/CMS_CONDITIONS -i {lDB} -t {tagNameT} -b {iEnd}".format(**getDet(x))
runCMD(tmp)
def printFinalDB():
for x in baseList:
tmp = "conddb --db {arg} list {tagNameT}".format(**getDet(x))
runCMD(tmp)
def writeTXT():
for x in baseList:
of = open(x.replace(".db",".txt"),"w")
of.write(log.format(**getDet(x)))
getPayLoad()
getBaseDB()
importTags()
addNextTags()
printFinalDB()
writeTXT()