Test job submission start: 2008-11-24 21:09:13 end: 2008-11-24 19:24:44 Test completion: 2008-11-24 19:55:10 2008-11-25 23:25:56 homepackage AnalysisTransforms-AtlasProduction_14.2.22 mysql> select distinct transformation from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2'; +---------------------------------------------------------------------+ | transformation | +---------------------------------------------------------------------+ | http://www.usatlas.bnl.gov/svn/panda/pathena/trf/buildJob-00-00-03 | 250 247 3 | http://www.usatlas.bnl.gov/svn/panda/pathena/trf/runAthena-00-00-11 | 5250 5138 112 (63ab) +---------------------------------------------------------------------+ mysql> select distinct cpuConsumptionUnit from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/buildJob-00-00-03';+--------------------------------------------------------------+ | cpuConsumptionUnit | +--------------------------------------------------------------+ | kSI2kseconds+Quad-Core AMD Opteron(tm) Processor 2350 512 KB | | kSI2kseconds+Dual Core AMD Opteron(tm) Processor 285 1024 KB | | ? | +--------------------------------------------------------------+ 3 rows in set (0.42 sec) Build s Build f Run s Run f 453.3360 271.0000 1299.3562 322.1518 avg CPU (units?) 4045.7206477733 4289.3333333333 3908365265.9990267754 11474928138573.0449218750avg(endTime-startTime) mysql> select count(*), avg(endTime-startTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/runAthena-00-00-11' and endTime!=0 and startTime!=0 group by jobStatus; +----------+------------------------+ | count(*) | avg(endTime-startTime) | +----------+------------------------+ | 48 | 16042.6250000000 | | 5137 | 10818.8199338135 | +----------+------------------------+ 2 rows in set (0.84 sec) mysql> select jobStatus, count(*), avg(endTime-startTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/buildJob-00-00-03' and endTime!=0 and startTime!=0 group by jobStatus; +-----------+----------+------------------------+ | jobStatus | count(*) | avg(endTime-startTime) | +-----------+----------+------------------------+ | failed | 3 | 4289.3333333333 | | finished | 247 | 4045.7206477733 | +-----------+----------+------------------------+ 2 rows in set (0.84 sec) mysql> select jobStatus, count(*), avg(endTime-startTime), min(endTime-startTime), max(endTime-startTime), sum(endTime-startTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/buildJob-00-00-03' and endTime!=0 and startTime!=0 group by jobStatus; +-----------+----------+------------------------+------------------------+------------------------+------------------------+ | jobStatus | count(*) | avg(endTime-startTime) | min(endTime-startTime) | max(endTime-startTime) | sum(endTime-startTime) | +-----------+----------+------------------------+------------------------+------------------------+------------------------+ | failed | 3 | 4289.3333333333 | 1.000000 | 6533.000000 | 12868.000000 | | finished | 247 | 4045.7206477733 | 2226.000000 | 6673.000000 | 999293.000000 | +-----------+----------+------------------------+------------------------+------------------------+------------------------+ 2 rows in set (0.98 sec) mysql> select jobStatus, count(*), avg(endTime-startTime), min(endTime-startTime), max(endTime-startTime), sum(endTime-startTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/runAthena-00-00-11' and endTime!=0 and startTime!=0 group by jobStatus; +-----------+----------+------------------------+------------------------+------------------------+------------------------+ | jobStatus | count(*) | avg(endTime-startTime) | min(endTime-startTime) | max(endTime-startTime) | sum(endTime-startTime) | +-----------+----------+------------------------+------------------------+------------------------+------------------------+ | failed | 48 | 16042.6250000000 | 1.000000 | 50218.000000 | 770046.000000 | | finished | 5137 | 10818.8199338135 | 873.000000 | 767584.000000 | 55576278.000000 | +-----------+----------+------------------------+------------------------+------------------------+------------------------+ 2 rows in set (0.92 sec) mysql> select jobStatus, count(*), avg(cpuConsumptionTime), min(cpuConsumptionTime), max(cpuConsumptionTime), sum(cpuConsumptionTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/runAthena-00-00-11' and endTime!=0 and startTime!=0 group by jobStatus; +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ | jobStatus | count(*) | avg(cpuConsumptionTime) | min(cpuConsumptionTime) | max(cpuConsumptionTime) | sum(cpuConsumptionTime) | +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ | failed | 48 | 726.8958 | 0 | 1989 | 34891 | | finished | 5137 | 1299.2813 | 481 | 3803 | 6674408 | +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ 2 rows in set (0.96 sec) mysql> select jobStatus, count(*), avg(cpuConsumptionTime), min(cpuConsumptionTime), max(cpuConsumptionTime), sum(cpuConsumptionTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/runAthena-00-00-11' group by jobStatus; +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ | jobStatus | count(*) | avg(cpuConsumptionTime) | min(cpuConsumptionTime) | max(cpuConsumptionTime) | sum(cpuConsumptionTime) | +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ | failed | 112 | 322.1518 | 0 | 1989 | 36081 | | finished | 5138 | 1299.3562 | 481 | 3803 | 6676092 | +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ 2 rows in set (0.97 sec) mysql> select jobStatus, count(*), avg(cpuConsumptionTime), min(cpuConsumptionTime), max(cpuConsumptionTime), sum(cpuConsumptionTime) from jobsArchived4 where prodUserID='/DC=org/DC=doegrids/OU=People/CN=Marco Mambelli 325802/CN=proxy' and computingSite='ANALY_MWT2' and transformation='http://www.usatlas.bnl.gov/svn/panda/pathena/trf/buildJob-00-00-03' group by jobStatus; +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ | jobStatus | count(*) | avg(cpuConsumptionTime) | min(cpuConsumptionTime) | max(cpuConsumptionTime) | sum(cpuConsumptionTime) | +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ | failed | 3 | 271.0000 | 0 | 416 | 813 | | finished | 247 | 453.3360 | 388 | 933 | 111974 | +-----------+----------+-------------------------+-------------------------+-------------------------+-------------------------+ 2 rows in set (0.96 sec)