+--------------------------+ | Tables_in_PandaDB | +--------------------------+ | Atlas_SW_Releases | | Atlas_SW_Transformation | | Atlas_SW_Transformations | | Datasets | | PANDALOG | | ProductionPeriod | | cloudtasks | | filesTable4 | | jobsActive4 | | jobsActive5 | | jobsArchived4 | | jobsArchived5 | | jobsDefined4 | | jobsDefined5 | | jobsWaiting4 | | jobsWaiting5 | | logsTable4 | | metaTable | | siteQueues | | siteSpecifics | | subCounter | | t_data_format | | t_dataset_desc | | t_dataset_mc | | t_dataset_prim | | t_dataset_status | | t_production_step | | t_project | | t_sw_release | | t_sw_transformation | +--------------------------+ mysql> describe jobsActive4; +------------------------+--------------------------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------+--------------------------------------+------+-----+---------------------+-------+ | PandaID | int(11) unsigned | NO | PRI | 0 | | | jobDefinitionID | int(11) unsigned | NO | | 0 | | | schedulerID | varchar(128) | NO | | | | | pilotID | varchar(128) | NO | | | | | creationTime | datetime | NO | | 0000-00-00 00:00:00 | | | creationHost | varchar(128) | NO | | | | | modificationTime | datetime | NO | | 0000-00-00 00:00:00 | | | modificationHost | varchar(128) | NO | | | | | AtlasRelease | varchar(64) | NO | | | | | transformation | varchar(250) | NO | | | | | homepackage | varchar(64) | NO | | | | | prodSeriesLabel | enum('DC2','Rome','DC3','pandatest') | NO | | Rome | | | prodSourceLabel | varchar(20) | NO | | managed | | | prodUserID | varchar(250) | NO | | | | | assignedPriority | mediumint(5) | NO | | 0 | | | currentPriority | mediumint(5) | NO | MUL | 0 | | | attemptNr | tinyint(2) unsigned | NO | | 0 | | | maxAttempt | tinyint(2) unsigned | NO | | 0 | | | jobStatus | varchar(15) | NO | MUL | activated | | | jobName | varchar(128) | NO | | | | | maxCpuCount | mediumint(9) unsigned | NO | | 0 | | | maxCpuUnit | varchar(32) | NO | | | | | maxDiskCount | mediumint(9) unsigned | NO | | 0 | | | maxDiskUnit | char(2) | NO | | | | | ipConnectivity | char(3) | NO | | | | | minRamCount | mediumint(9) unsigned | NO | | 0 | | | minRamUnit | char(2) | NO | | | | | startTime | datetime | NO | | 0000-00-00 00:00:00 | | | endTime | datetime | NO | | 0000-00-00 00:00:00 | | | cpuConsumptionTime | mediumint(20) | NO | | 0 | | | cpuConsumptionUnit | varchar(128) | NO | | | | | commandToPilot | varchar(250) | NO | | | | | transExitCode | varchar(128) | NO | | | | | pilotErrorCode | mediumint(6) | NO | | 0 | | | pilotErrorDiag | varchar(250) | NO | | | | | exeErrorCode | mediumint(6) | NO | | 0 | | | exeErrorDiag | varchar(250) | NO | | | | | supErrorCode | mediumint(6) | NO | | 0 | | | supErrorDiag | varchar(250) | YES | | NULL | | | ddmErrorCode | mediumint(6) | NO | | 0 | | | ddmErrorDiag | varchar(250) | YES | | NULL | | | brokerageErrorCode | mediumint(6) | NO | | 0 | | | brokerageErrorDiag | varchar(250) | YES | | NULL | | | jobDispatcherErrorCode | mediumint(6) | NO | | 0 | | | jobDispatcherErrorDiag | varchar(250) | YES | | NULL | | | taskBufferErrorCode | mediumint(6) | NO | | 0 | | | taskBufferErrorDiag | varchar(250) | YES | | NULL | | | computingSite | varchar(128) | NO | | | | | computingElement | varchar(128) | NO | | | | | jobParameters | text | NO | | NULL | | | metadata | text | NO | | NULL | | | prodDBlock | varchar(250) | NO | | | | | dispatchDBlock | varchar(250) | NO | | | | | destinationDBlock | varchar(250) | NO | | | | | destinationSE | varchar(250) | NO | | | | | nEvents | mediumint(9) unsigned | NO | | 0 | | | grid | varchar(32) | NO | | | | | cloud | varchar(32) | NO | | | | | cpuConversion | decimal(9,4) | NO | | NULL | | | sourceSite | varchar(36) | NO | | | | | destinationSite | varchar(36) | NO | | | | | transferType | varchar(10) | NO | | | | | taskID | mediumint(9) | YES | | NULL | | | cmtConfig | varchar(250) | NO | | | | | stateChangeTime | datetime | NO | | 0000-00-00 00:00:00 | | | prodDBUpdateTime | datetime | NO | | 0000-00-00 00:00:00 | | | lockedby | varchar(128) | NO | | | | | relocationFlag | tinyint(1) unsigned | NO | | 0 | | | jobExecutionID | int(11) unsigned | NO | | 0 | | | VO | varchar(16) | NO | | | | | pilotTiming | varchar(100) | NO | | | | | workingGroup | varchar(20) | NO | | | | | processingType | varchar(64) | NO | | | | +------------------------+--------------------------------------+------+-----+---------------------+-------+ 73 rows in set (0.03 sec) mysql> describe jobsActive5; +--------------------+--------------------------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------------------------------+------+-----+---------------------+-------+ | PandaID | mediumint(9) unsigned | NO | PRI | 0 | | | jobDefinitionID | mediumint(9) unsigned | NO | | 0 | | | taskID | mediumint(9) unsigned | NO | | 0 | | | schedulerID | varchar(128) | NO | | | | | pilotID | varchar(128) | NO | | | | | pilotVersion | varchar(32) | NO | | | | | creationTime | datetime | NO | | 0000-00-00 00:00:00 | | | creationHost | varchar(128) | NO | | | | | modificationTime | datetime | NO | | 0000-00-00 00:00:00 | | | modificationHost | varchar(128) | NO | | | | | AtlasRelease | varchar(64) | NO | | | | | transformation | varchar(250) | NO | | | | | encrypt | varchar(250) | NO | | | | | homepackage | varchar(64) | NO | | | | | app | varchar(64) | NO | | | | | prodSeriesLabel | enum('DC2','Rome','DC3','pandatest') | NO | | Rome | | | prodSourceLabel | varchar(30) | NO | | managed | | | sourceGroup | varchar(32) | NO | | | | | VO | varchar(32) | NO | | | | | prodUserID | varchar(128) | NO | | | | | GridCert | varchar(128) | NO | | | | | assignedPriority | mediumint(5) | NO | | 0 | | | currentPriority | mediumint(5) | NO | MUL | 0 | | | attemptNr | tinyint(2) unsigned | NO | | 0 | | | maxAttempt | tinyint(2) unsigned | NO | | 0 | | | jobStatus | varchar(15) | NO | MUL | activated | | | jobName | varchar(128) | NO | | | | | maxCpuCount | mediumint(9) unsigned | NO | | 0 | | | maxCpuUnit | varchar(32) | NO | | | | | maxDiskCount | mediumint(9) unsigned | NO | | 0 | | | maxDiskUnit | char(2) | NO | | | | | ipConnectivity | char(3) | NO | | | | | minRamCount | mediumint(9) unsigned | NO | | 0 | | | minRamUnit | char(2) | NO | | | | | startTime | datetime | NO | | 0000-00-00 00:00:00 | | | endTime | datetime | NO | | 0000-00-00 00:00:00 | | | cpuConsumptionTime | mediumint(20) | NO | | 0 | | | cpuConsumptionUnit | varchar(128) | NO | | | | | commandToPilot | varchar(250) | NO | | | | | pilotErrorCode | mediumint(6) | NO | | 0 | | | pilotErrorDiag | varchar(128) | NO | | | | | exeErrorCode | mediumint(6) | NO | | 0 | | | exeErrorDiag | varchar(128) | NO | | | | | ddmErrorCode | mediumint(6) | NO | | 0 | | | ddmErrorDiag | varchar(128) | YES | | NULL | | | serverErrorCode | mediumint(6) unsigned | NO | | 0 | | | serverErrorDiag | varchar(128) | YES | | NULL | | | computingSite | varchar(128) | NO | | | | | computingElement | varchar(128) | NO | | | | | jobParameters | text | NO | | NULL | | | metadata | text | NO | | NULL | | | prodDBlock | varchar(250) | NO | | | | | dispatchDBlock | varchar(250) | NO | | | | | destinationDBlock | varchar(250) | NO | | | | | destinationSE | varchar(250) | NO | | | | +--------------------+--------------------------------------+------+-----+---------------------+-------+ 55 rows in set (0.04 sec) select * from t_pfn where pfname like "%calib0_mc12.007404.singlepart_singlepi5.digit.log.v12003103_tid003926._00576.job.log.tgz.1%" ; mysql> describe jobsArchived4; +------------------------+--------------------------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------+--------------------------------------+------+-----+---------------------+-------+ | PandaID | int(11) unsigned | NO | PRI | 0 | | | jobDefinitionID | int(11) unsigned | NO | | 0 | | | schedulerID | varchar(128) | NO | | | | | pilotID | varchar(128) | NO | | | | | creationTime | datetime | NO | | 0000-00-00 00:00:00 | | | creationHost | varchar(128) | NO | | | | | modificationTime | datetime | NO | MUL | 0000-00-00 00:00:00 | | | modificationHost | varchar(128) | NO | | | | | AtlasRelease | varchar(64) | NO | | | | | transformation | varchar(250) | NO | | | | | homepackage | varchar(64) | NO | | | | | prodSeriesLabel | enum('DC2','Rome','DC3','pandatest') | NO | | Rome | | | prodSourceLabel | varchar(20) | NO | | managed | | | prodUserID | varchar(250) | NO | | | | | assignedPriority | mediumint(5) | NO | | 0 | | | currentPriority | mediumint(5) | NO | | 0 | | | attemptNr | tinyint(2) unsigned | NO | | 0 | | | maxAttempt | tinyint(2) unsigned | NO | | 0 | | | jobStatus | varchar(15) | NO | MUL | activated | | | jobName | varchar(128) | NO | | | | | maxCpuCount | mediumint(9) unsigned | NO | | 0 | | | maxCpuUnit | varchar(32) | NO | | | | | maxDiskCount | mediumint(9) unsigned | NO | | 0 | | | maxDiskUnit | char(2) | NO | | | | | ipConnectivity | char(3) | NO | | | | | minRamCount | mediumint(9) unsigned | NO | | 0 | | | minRamUnit | char(2) | NO | | | | | startTime | datetime | NO | | 0000-00-00 00:00:00 | | | endTime | datetime | NO | | 0000-00-00 00:00:00 | | | cpuConsumptionTime | mediumint(20) | NO | | 0 | | | cpuConsumptionUnit | varchar(128) | NO | | | | | commandToPilot | varchar(250) | NO | | | | | transExitCode | varchar(128) | NO | | | | | pilotErrorCode | mediumint(6) | NO | | 0 | | | pilotErrorDiag | varchar(250) | NO | | | | | exeErrorCode | mediumint(6) | NO | | 0 | | | exeErrorDiag | varchar(250) | NO | | | | | supErrorCode | mediumint(6) | NO | | 0 | | | supErrorDiag | varchar(250) | YES | | NULL | | | ddmErrorCode | mediumint(6) | NO | | 0 | | | ddmErrorDiag | varchar(250) | YES | | NULL | | | brokerageErrorCode | mediumint(6) | NO | | 0 | | | brokerageErrorDiag | varchar(250) | YES | | NULL | | | jobDispatcherErrorCode | mediumint(6) | NO | | 0 | | | jobDispatcherErrorDiag | varchar(250) | YES | | NULL | | | taskBufferErrorCode | mediumint(6) | NO | | 0 | | | taskBufferErrorDiag | varchar(250) | YES | | NULL | | | computingSite | varchar(128) | NO | | | | | computingElement | varchar(128) | NO | | | | | jobParameters | text | NO | | NULL | | | metadata | text | NO | | NULL | | | prodDBlock | varchar(250) | NO | | | | | dispatchDBlock | varchar(250) | NO | | | | | destinationDBlock | varchar(250) | NO | | | | | destinationSE | varchar(250) | NO | | | | | nEvents | mediumint(9) unsigned | NO | | 0 | | | grid | varchar(32) | NO | | | | | cloud | varchar(32) | NO | | | | | cpuConversion | decimal(9,4) | NO | | NULL | | | sourceSite | varchar(36) | NO | | | | | destinationSite | varchar(36) | NO | | | | | transferType | varchar(10) | NO | | | | | taskID | mediumint(9) | YES | | NULL | | | cmtConfig | varchar(250) | NO | | | | | stateChangeTime | datetime | NO | | 0000-00-00 00:00:00 | | | prodDBUpdateTime | datetime | NO | | 0000-00-00 00:00:00 | | | lockedby | varchar(128) | NO | | | | | relocationFlag | tinyint(1) unsigned | NO | | 0 | | | jobExecutionID | int(11) unsigned | NO | | 0 | | | VO | varchar(16) | NO | | | | | pilotTiming | varchar(100) | NO | | | | | workingGroup | varchar(20) | NO | | | | | processingType | varchar(64) | NO | | | | +------------------------+--------------------------------------+------+-----+---------------------+-------+ 73 rows in set (0.03 sec)