Vocms201

Set to drain: 19th Jan 2015

Checking Jobs in Condor

cmst1@vocms201:/data/srv/wmagent/current $ condor_q


-- Submitter: vocms201.cern.ch : <128.142.172.200:4080?sock=3546381_aba3_38> : vocms201.cern.ch
 ID      OWNER            SUBMITTED     RUN_TIME ST PRI SIZE CMD               

0 jobs; 0 completed, 0 removed, 0 idle, 0 running, 0 held, 0 suspended

Checking queued jobs in database

SQL>  SELECT wmbs_job.id AS id, wmbs_job.name AS name,
wmbs_job.cache_dir AS cache_dir,
wmbs_sub_types.name AS type, wmbs_job.retry_count AS retry_count,
wmbs_subscription.workflow as workflow,
wmbs_subscription.last_update as timestamp,
wmbs_workflow.name as request_name,
wmbs_workflow.priority as task_priority,
wmbs_workflow.task as task_name
FROM wmbs_job
INNER JOIN wmbs_jobgroup ON
wmbs_job.jobgroup = wmbs_jobgroup.id
INNER JOIN wmbs_subscription ON
wmbs_jobgroup.subscription = wmbs_subscription.id
INNER JOIN wmbs_sub_types ON
wmbs_subscription.subtype = wmbs_sub_types.id
INNER JOIN wmbs_job_state ON
wmbs_job.state = wmbs_job_state.id
INNER JOIN wmbs_workflow ON
wmbs_subscription.workflow = wmbs_workflow.id
WHERE wmbs_job_state.name = 'created';  2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20  

no rows selected

Checking workflows in the system

SQL> SELECT DISTINCT name from wmbs_workflow;

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
jbadillo_TOP-Summer12WMLHE-00078_00026_v0__141103_120222_3352

Checking files and blocks in Phedex and DBS

SQL> SELECT * from dbsbuffer_file where in_phedex = 0 and block_id != NULL;

no rows selected

SQL> select * from dbsbuffer_block where status!='Closed';

no rows selected

SQL>  SELECT * from dbsbuffer_file where status = 'NOTUPLOADED';

no rows selected

SQL>  SELECT lfn FROM dbsbuffer_file WHERE in_phedex=0 AND block_id!=NULL AND (lfn NOT LIKE '%unmerged%' AND lfn NOT LIKE 'MCFakeFile%');

no rows selected

SQL> SELECT count(*) FROM dbsbuffer_file WHERE in_phedex=0 AND (lfn NOT LIKE '%unmerged%' AND lfn NOT LIKE 'MCFakeFile%');
  COUNT(*)
----------
      1296

Running Phedex - Fix (updating blocks in phedex)

cmst1@vocms201:/data/srv/wmagent/current $ curl https://raw.githubusercontent.com/amaltaro/ProductionTools/master/newFixPhEDEx.py> newFixPhEDEx.py
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  5791  100  5791    0     0  26239      0 --:--:-- --:--:-- --:--:-- 5655k
cmst1@vocms201:/data/srv/wmagent/current $ python newFixPhEDEx.py 
Shutting down PhEDExInjector...
Checking 78 dataset in both PhEDEx and DBS ...
error on /store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x
Found 1239 out of 1296 files that are already registered in PhEDEx            but buffer doesn't know
Fixing them now, it may take several minutes ...
Rows were successfully updated! Good job!
Starting PhEDExInjector now ...

started with pid 1515592
Done!

Check files after phedex fix

SQL>  SELECT lfn, se_name FROM dbsbuffer_file 
LEFT OUTER JOIN dbsbuffer_block on (dbsbuffer_block.id = dbsbuffer_file.block_id)
LEFT OUTER JOIN dbsbuffer_location on (dbsbuffer_location.id = dbsbuffer_block.location)
WHERE in_phedex=0 AND (lfn NOT LIKE '%unmerged%' AND lfn NOT LIKE 'MCFakeFile%')  2    3    4  
  5  ;

LFN										     SE_NAME
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_997_1_6X9.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_991_1_DyZ.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_984_1_zWZ.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_923_1_oTi.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_914_1_QtE.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_912_1_xaW.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_910_1_PN6.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_888_1_aJL.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_884_1_cBb.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_880_1_WZB.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_815_1_kT4.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_810_1_KQx.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_79_2_J6p.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_77_1_3Zy.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_741_1_z3r.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_736_1_5fS.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_704_1_qGO.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_690_1_uwJ.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_64_1_TUd.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_6_1_ljD.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_569_1_hts.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_568_1_SYe.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_521_1_Zxw.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_519_1_rmv.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_5_1_5cU.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_481_1_Sdk.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_479_1_2m2.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_465_1_Y7w.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_451_1_Tcz.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_335_1_2qn.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_324_1_V61.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_263_1_7HU.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_262_1_HDk.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_26_1_NFn.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_259_1_uhd.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_231_1_4GK.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_228_1_bZZ.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_227_1_WI9.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_222_1_P30.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_220_1_pp4.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_218_1_4No.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_214_1_IXt.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_20_1_v59.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_179_1_Tur.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1268_1_Kof.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1265_1_Cee.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1210_1_ZNb.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1197_1_A8u.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1195_1_C1Q.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1117_1_aBe.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1112_1_Ffs.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1084_1_Kyj.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1080_1_Bs7.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1077_1_UlU.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1007_1_x22.root
/store/user/dfehling/JetHT/Run2012C-22Jan2013-TLBSM_53x/0161496fccaa0bf55fbb525b618345b5/tlbsm_53x_v3_data_1001_1_Up4.root
/store/generator/Summer12WMLHE/TT_weights_CT10_8TeV-powheg/GEN/START53_V7C-v2/10000/3AF97403-3764-E411-AF49-AC853D9F52D8.root
Alll these files are input user files from StoreResults requests, so we can safely ignore them.

This agent is ready to be decomissioned JulianBadillo - 2015-01-28

Edit | Attach | Watch | Print version | History: r8 < r7 < r6 < r5 < r4 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r8 - 2015-01-28 - JulianBadillo
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    CMSPublic All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback