Skip to content

Uploading conditions for 2018 UL ReReco

hyunyong edited this page Aug 21, 2019 · 24 revisions

Related talks

Tracker 2018 UL sign-off

https://indico.cern.ch/event/837619/#10-ul-2018-tracker-alignment-s

GPR 2018 UL sign-off

https://indico.cern.ch/event/839963/#33-global-position-record-for

Muon 2018 UL status

https://indico.cern.ch/event/839963/#34-2018-muon-alignment-report

Muon 2018 UL sign-off

https://indico.cern.ch/event/840920/#34-ul-2018-sign-off-for-muon-a

2018 UL IOVs: Recommendation: use 314472 as the start of the IOV (first collision run of 2018 [1])

IOV1: 314472 - 320376

IOV2: 320377 - 322602

IOV3: 322603 +

[1] https://twiki.cern.ch/twiki/bin/viewauth/CMS/PdmV2018Analysis#DATA

Uploading conditions

DT

Latest tag

DTAlignment_2017_UL_v2

New tags

data_DT-1100-111111_2018UL_IOV1_CMSSW106_JSON-313041-320377_dataRun2_MuAl_v1_01.db: 97b210a7e66b734eb8a738bc7ecb3b3dfc680980

data_DT-1100-111111_2018UL_IOV2_CMSSW106_JSON-320377-322603_dataRun2_MuAl_v1_01.db: 4ace088d2fcbeb8f0e648daa57d4dedb4f01c0c8

data_DT-1100-111111_2018UL_IOV3_CMSSW106_JSON-322603-325172_dataRun2_MuAl_v1_01.db: a47d040149aad5bf8ce1efcfbe1429b253bf64ee

Copy DB

conddb_import -c sqlite_file:data_DT_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i DTAlignment_2017_UL_v2 -t DTAlignmentRcd -b 0 -e 314471

Print list

conddb --db data_DT_short.db list DTAlignmentRcd

[2019-08-19 20:44:04,977] INFO: Connecting to data_DT_short.db [sqlite:///data_DT_short.db]
[2019-08-19 20:44:05,018] INFO: Listing with a limit of 500 IOVs, starting from the highest since. If you need to see more, please increase the limit of returned results.
Since: Run   Insertion Time              Payload                                   Object Type
-----------  --------------------------  ----------------------------------------  -----------
1            2019-08-19 18:44:04.272058  c73311ece81a057ac0a2a1454386161493b22120  Alignments
126000       2019-08-19 18:44:04.277914  c73153c55efbd075487478adef4e4b7b0f9a46c8  Alignments
157866       2019-08-19 18:44:04.285215  66e71c4cf462348272da41cad7336a931731dc0e  Alignments
185189       2019-08-19 18:44:04.292960  f5c7f7aa1a88dfc870038b0fe53987c98562fe33  Alignments
233238       2019-08-19 18:44:04.300227  00589442fc0fba38c9f147c42a36e53df27b8d59  Alignments
238341       2019-08-19 18:44:04.306342  9cbd0edce1a92f0b7d6fb19a26b659f1bfa80336  Alignments
250933       2019-08-19 18:44:04.313743  78ec2669108f782c813ff90d2bd6bfc76a6ace79  Alignments
271952       2019-08-19 18:44:04.320631  e6e7e3db0821d29cb9954034f243b06b90708c1a  Alignments
293466       2019-08-19 18:44:04.328057  cbbf431b2ad8aab5d570070bd889d9c04fc21311  Alignments
297049       2019-08-19 18:44:04.334137  a96ff5d1c0695c474424099048dd30253be30877  Alignments
300817       2019-08-19 18:44:04.341197  113e8bcb0d359ba5714a961909c47c4564d3dd7d  Alignments
304000       2019-08-19 18:44:04.347346  83998ac5dd182c22e7dde0bc33edbe1357258aeb  Alignments
307082       2019-08-19 18:44:04.353776  2e8d0cea957f4855541d0209b69404ccf23509a8  Alignments
313041       2019-08-19 18:44:04.360119  85ca6e7bd4d895b40f146011df2c76ed35c8dccc  Alignments

Import tags

conddb_import -c sqlite:data_DT_short.db -f sqlite:data_DT-1100-111111_2018UL_IOV1_CMSSW106_JSON-313041-320377_dataRun2_MuAl_v1_01.db -i DTAlignmentRcd -t DTAlignmentRcd -b 314472 -e 320376

conddb_import -c sqlite:data_DT_short.db -f sqlite:data_DT-1100-111111_2018UL_IOV2_CMSSW106_JSON-320377-322603_dataRun2_MuAl_v1_01.db -i DTAlignmentRcd -t DTAlignmentRcd -b 320377 -e 322602

conddb_import -c sqlite:data_DT_short.db -f sqlite:data_DT-1100-111111_2018UL_IOV3_CMSSW106_JSON-322603-325172_dataRun2_MuAl_v1_01.db -i DTAlignmentRcd -t DTAlignmentRcd -b 322603

data_DT_short.txt

{"destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": { "DTAlignment_2018_UL_v2": {} }, "inputTag": "DTAlignmentRcd", "since": null, "userText": "2018 UL ReReco DTAlignmentRcd" }

Check uploading

conddb diff DTAlignment_2017_UL_v2 DTAlignment_2018_UL_v2

[2019-08-21 22:50:32,603] INFO: Connecting to pro [frontier://PromptProd/CMS_CONDITIONS]
Range               pro::DTAlignment_2017_UL_v2 Payload       pro::DTAlignment_2018_UL_v2 Payload
------------------  ----------------------------------------  ----------------------------------------
[1, 314472)         =                                         =
[314472, 316505)    85ca6e7bd4d895b40f146011df2c76ed35c8dccc  97b210a7e66b734eb8a738bc7ecb3b3dfc680980
[316505, 318228)    38df9780d166b249758d51e8c71054f4625a69ef  97b210a7e66b734eb8a738bc7ecb3b3dfc680980
[318228, 320377)    da1099a877102e51631bc00f7ea17ecb4d57efcc  97b210a7e66b734eb8a738bc7ecb3b3dfc680980
[320377, 322603)    da1099a877102e51631bc00f7ea17ecb4d57efcc  4ace088d2fcbeb8f0e648daa57d4dedb4f01c0c8
[322603, Infinity)  da1099a877102e51631bc00f7ea17ecb4d57efcc  a47d040149aad5bf8ce1efcfbe1429b253bf64ee

CondDB url

https://cms-conddb.cern.ch/cmsDbBrowser/list/Prod/tags/DTAlignment_2018_UL_v2

CSC

Latest tag

CSCAlignment_2017_UL_v1

New tags

data_CSC-1100-110001_2018UL_IOV1_CMSSW106_JSON-313041-320377_dataRun2_MuAl_v1_01.db: be1743fc3978eb3ece71781130c6473b25a207e0

data_CSC-1100-110001_2018UL_IOV2_CMSSW106_JSON-320377-322603_dataRun2_MuAl_v1_01.db: e099f2e961641b0feac6058995ac25991905ed44

data_CSC-1100-110001_2018UL_IOV3_CMSSW106_JSON-322603-325172_dataRun2_MuAl_v1_01.db: 682f670532ddead56a55e157ac57fa5177ae2e7e

Copy DB

conddb_import -c sqlite_file:data_CSC_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i CSCAlignment_2017_UL_v1 -t CSCAlignmentRcd -b 0 -e 314471

Print list

conddb --db data_CSC_short.db list CSCAlignmentRcd

[2019-08-19 20:44:10,961] INFO: Connecting to data_CSC_short.db [sqlite:///data_CSC_short.db]
[2019-08-19 20:44:10,998] INFO: Listing with a limit of 500 IOVs, starting from the highest since. If you need to see more, please increase the limit of returned results.
Since: Run   Insertion Time              Payload                                   Object Type
-----------  --------------------------  ----------------------------------------  -----------
1            2019-08-19 18:44:10.372582  026fe1ec9ee55023890fda434bae581302838833  Alignments
126000       2019-08-19 18:44:10.377998  bbb4c95ed02de6c5531fbdd4a569ef4613f056bf  Alignments
157866       2019-08-19 18:44:10.384863  e95d92cd4c845ea008b1be75faeae5018ad91ebc  Alignments
185189       2019-08-19 18:44:10.391506  5c65c6dcfc597cc4a7af16c3db3efa958c0b3087  Alignments
250933       2019-08-19 18:44:10.397946  d41465cae4d75b4054822a21df6af8a330091a1a  Alignments
271952       2019-08-19 18:44:10.404398  8c6841aaf4fb53cfcf3aec57aa630a19eccc6013  Alignments
293466       2019-08-19 18:44:10.411548  0ab8834ad8d67a4bf73311be521ccee6cb6b71d7  Alignments
297049       2019-08-19 18:44:10.418781  ca997811445961ddb4c964a02ca22ed4a44117ec  Alignments
300817       2019-08-19 18:44:10.426098  a01c9d976ab4ca5e36f8757eea4412cfecc07390  Alignments
304000       2019-08-19 18:44:10.433844  c0aa126feff8ccd07491faa6b2ca03954b664a57  Alignments
307082       2019-08-19 18:44:10.441756  684e4a7182abeebfe6b9dddd5ce41ac54e2059f2  Alignments
313041       2019-08-19 18:44:10.449111  25c002b179e37876ee27f49e35b119ff92105bc6  Alignments

Import tags

conddb_import -c sqlite:data_CSC_short.db -f sqlite:data_CSC-1100-110001_2018UL_IOV1_CMSSW106_JSON-313041-320377_dataRun2_MuAl_v1_01.db -i CSCAlignmentRcd -t CSCAlignmentRcd -b 314472 -e 320376

conddb_import -c sqlite:data_CSC_short.db -f sqlite:data_CSC-1100-110001_2018UL_IOV2_CMSSW106_JSON-320377-322603_dataRun2_MuAl_v1_01.db -i CSCAlignmentRcd -t CSCAlignmentRcd -b 320377 -e 322602

conddb_import -c sqlite:data_CSC_short.db -f sqlite:data_CSC-1100-110001_2018UL_IOV3_CMSSW106_JSON-322603-325172_dataRun2_MuAl_v1_01.db -i CSCAlignmentRcd -t CSCAlignmentRcd -b 322603

data_CSC_short.txt

{ "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": { "CSCAlignment_2018_UL_v3": {} }, "inputTag": "CSCAlignmentRcd", "since": null, "userText": "2018 UL ReReco CSCAlignmentRcd" }

Check uploading

conddb diff CSCAlignment_2017_UL_v1 CSCAlignment_2018_UL_v3

[2019-08-21 22:49:56,301] INFO: Connecting to pro [frontier://PromptProd/CMS_CONDITIONS]
Range               pro::CSCAlignment_2017_UL_v1 Payload      pro::CSCAlignment_2018_UL_v3 Payload
------------------  ----------------------------------------  ----------------------------------------
[1, 314472)         =                                         =
[314472, 316505)    25c002b179e37876ee27f49e35b119ff92105bc6  be1743fc3978eb3ece71781130c6473b25a207e0
[316505, 318228)    1a0fa56feced18db97bce14970fd5c959a19f350  be1743fc3978eb3ece71781130c6473b25a207e0
[318228, 320377)    8c94a8981f499e0e56cd2ece50fdfb1da7527bd3  be1743fc3978eb3ece71781130c6473b25a207e0
[320377, 322603)    8c94a8981f499e0e56cd2ece50fdfb1da7527bd3  e099f2e961641b0feac6058995ac25991905ed44
[322603, Infinity)  8c94a8981f499e0e56cd2ece50fdfb1da7527bd3  682f670532ddead56a55e157ac57fa5177ae2e7e

CondDB url

https://cms-conddb.cern.ch/cmsDbBrowser/list/Prod/tags/CSCAlignment_2018_UL_v3

GPR

Latest tag

GlobalAlignment_2017_UL_v1

New tags

GPR_Aug03_2019_SW1060_GT106X_dataRun2_newTkAl_v18_IOV1_dL_iter2.db: d912ca8411848520757b6864cf1e6542037cd58b

GPR_Aug03_2019_SW1060_GT106X_dataRun2_newTkAl_v18_IOV2_dL_iter1.db: 59a3e7ce9caebcbd3cbfa7bccd639267df1a017e

GPR_Aug03_2019_SW1060_GT106X_dataRun2_newTkAl_v18_IOV3_dL_iter1.db: 15c2fbdd7a3299b19f5eaaeedc80f89b85cad463

Copy DB

conddb_import -c sqlite_file:data_GPR_short.db -f frontier://FrontierProd/CMS_CONDITIONS -i GlobalAlignment_2017_UL_v1 -t IdealGeometry -b 0 -e 314471

Print DB

conddb --db data_GPR_short.db list GlobalPositionRcd

[2019-08-19 20:44:17,340] INFO: Connecting to data_GPR_short.db [sqlite:///data_GPR_short.db]
[2019-08-19 20:44:17,380] INFO: Listing with a limit of 500 IOVs, starting from the highest since. If you need to see more, please increase the limit of returned results.
Since: Run   Insertion Time              Payload                                   Object Type
-----------  --------------------------  ----------------------------------------  -----------
1            2019-08-19 18:44:16.806706  bebab3b872ed1374f553b40874eabeed7083bc68  Alignments
111462       2019-08-19 18:44:16.808116  f11ab0bbcc7a5a62bd7cedd16abef7237296af5a  Alignments
125597       2019-08-19 18:44:16.809300  715c012706896ec0f544aa98db2ac01298a998de  Alignments
125913       2019-08-19 18:44:16.810484  ac4ea80e58fc9916c0ec040021710baec5b6dbee  Alignments
126000       2019-08-19 18:44:16.811617  29ae6df8edf5529a71539f6fb9bde1737d5e15f0  Alignments
157866       2019-08-19 18:44:16.812780  1fed0c079b602f496c143f9053938ad34b94aee4  Alignments
185189       2019-08-19 18:44:16.814047  a4fa987fd3e5fce7709bd57bd25c01969de134f1  Alignments
233238       2019-08-19 18:44:16.815234  682477060c27c698b3e346e58d18c175afebe073  Alignments
250933       2019-08-19 18:44:16.816178  68163d6221b5ca1e76ab8aeb0f987c74ddb14373  Alignments
271952       2019-08-19 18:44:16.817081  7f794ee33f398dc10431fbf459d328cf167c1c13  Alignments
293466       2019-08-19 18:44:16.818168  a38e5ed21b79a3b50efd7ff735cc054f070e4415  Alignments
297049       2019-08-19 18:44:16.819219  cf403b0b4391bdc6b4d949c5da740a4631a33cd9  Alignments
300817       2019-08-19 18:44:16.820320  9c82ef40a18decc7de1300c5340f43c3ec9d9547  Alignments
304000       2019-08-19 18:44:16.821307  cc19d5f61e7ee5ec19a6f8bc50a3e07abff9269f  Alignments
307082       2019-08-19 18:44:16.822355  41669f34eb927bf1468e66abc56a850d581d573a  Alignments
313041       2019-08-19 18:44:16.823291  fff98d5a97b8d878768307bd09cdcf240032db2e  Alignments

Import tags

conddb_import -c sqlite:data_GPR_short.db -f sqlite:GPR_Aug03_2019_SW1060_GT106X_dataRun2_newTkAl_v18_IOV1_dL_iter2.db -i IdealGeometry -t GlobalPositionRcd -b 314472 -e 320376

conddb_import -c sqlite:data_GPR_short.db -f sqlite:GPR_Aug03_2019_SW1060_GT106X_dataRun2_newTkAl_v18_IOV2_dL_iter1.db -i IdealGeometry -t GlobalPositionRcd -b 320377 -e 322602

conddb_import -c sqlite:data_GPR_short.db -f sqlite:GPR_Aug03_2019_SW1060_GT106X_dataRun2_newTkAl_v18_IOV3_dL_iter1.db -i IdealGeometry -t GlobalPositionRcd -b 322603

data_GPR_short.txt

{ "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", "destinationTags": { "GlobalAlignment_2018_UL_v2": {} }, "inputTag": "GlobalPositionRcd", "since": null, "userText": "2018 UL ReReco GlobalPositionRcd" }

Check uploading

conddb diff GlobalAlignment_2017_UL_v1 GlobalAlignment_2018_UL_v2

[2019-08-21 22:49:14,435] INFO: Connecting to pro [frontier://PromptProd/CMS_CONDITIONS]
Range               pro::GlobalAlignment_2017_UL_v1 Payload   pro::GlobalAlignment_2018_UL_v2 Payload
------------------  ----------------------------------------  ----------------------------------------
[1, 314472)         =                                         =
[314472, 316505)    fff98d5a97b8d878768307bd09cdcf240032db2e  d912ca8411848520757b6864cf1e6542037cd58b
[316505, 318228)    bef45457fb880d74615ec85c01329311638923ae  d912ca8411848520757b6864cf1e6542037cd58b
[318228, 320377)    838199b3db3098213f4648a9a59144af8db631eb  d912ca8411848520757b6864cf1e6542037cd58b
[320377, 322603)    838199b3db3098213f4648a9a59144af8db631eb  59a3e7ce9caebcbd3cbfa7bccd639267df1a017e
[322603, Infinity)  838199b3db3098213f4648a9a59144af8db631eb  15c2fbdd7a3299b19f5eaaeedc80f89b85cad463

CondDB url

https://cms-conddb.cern.ch/cmsDbBrowser/list/Prod/tags/GlobalAlignment_2018_UL_v2