Changes between Version 36 and Version 37 of DatabaseBasedAnalysis/Tables
- Timestamp:
- 09/03/18 20:36:34 (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis/Tables
v36 v37 74 74 ||='''Status''' =||= '''fStartTime''' =||= '''fStopTime''' =||= '''fReturnCode''' =||= '''Comment''' =|| 75 75 ||=Waiting =|| NULL || NULL || [NULL] || Processing is supposed to be done (just not yet started or pre-conditions are still missing) || 76 ||=Running =|| NOT NULL || NULL || [NULL] || Processing is supposed to be done and running already (this includes ''Scheduled'') || 76 77 ||=Scheduled =|| -''marker''- || NULL || [NULL] || Pre-conditions fulfilled, scheduled for processing by job-manager (only callisto and star) || 77 ||=Running =|| NOT NULL || NULL || [NULL] || Processing is supposed to be done and running already ||78 78 ||=Success =|| > 2000 || > 2000 || NULL || Processing was successfully finished for this index || 79 79 ||=Failed =|| > 2000 || > 2000 || NOT NULL || Processing failed || … … 86 86 {{{#!sql 87 87 SELECT 88 COUNT(IF(ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)) AS 'WAITING', 89 COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND ISNULL(fStopTime), 1, NULL)) AS 'RUNNING', 88 COUNT(IF( ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)) AS 'WAITING', 89 COUNT(IF(NOT ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)) AS 'RUNNING', 90 COUNT(IF(fStartTime='1971-01-01 01:01:01' AND ISNULL(fStopTime), 1, NULL)) AS 'SCHEDULED', 90 91 COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND ISNULL(fReturnCode), 1, NULL)) AS 'SUCCESS', 91 92 COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND NOT ISNULL(fReturnCode), 1, NULL)) AS 'FAILED',
