Intermediate object cache in ShiftLog

Updated on Fri, 2014-05-02 14:55. Originally created by lbhajdu on 2014-05-02 14:01.

Notes on intermediate object cache in ShiftLog

The current cache stores objects used for the page logLatest.jsp and the run tables. The logLatest.jsp is updated once every minute. The log right now shows 6 users. Where one loads the page and 5 hit the cache.

 
timeBufferMemStore size = 1
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:05:01 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:05:16 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:05:28 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:05:28 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:05:29 EDT 2014
timeBufferMemStore size = 1
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:06:02 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:06:16 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:06:28 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:06:30 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:06:34 EDT 2014
timeBufferMemStore size = 1
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:07:02 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:07:16 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:07:29 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:07:30 EDT 2014
timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:07:39 EDT 2014
timeBufferMemStore size = 1
timeBufferMemStore size = 1

Because the logLatest.jsp is a sliding window page, the number of Sql selects needed to load the page depends on what has been entered in the shiftlog for that time window.
The formula is:

nSQLSelects = ( 2 + ( nEntry * 2 ) ) + ( 1 + nRun)

Note: This is without buffering

An example of the page loading dumped out from the log is:

imeBufferMemStore size = 0
loading "dbObjects.properties"
Initialize database connection broker
Initializing database connection broker
Connection Borker is logging to : /home/lbhajdu/.netbeans/3.6/jakarta-tomcat-5.0.19_base/temp/mysql_connection_broker.lbhajdu.log
Initializing shiftlog object mappings
SQL -> SELECT * FROM Entry WHERE  type = 0 AND entryTime >= '2014-05-02 12:24:16' AND entryTime <= '2014-05-02 18:24:16' ORDER BY entryTime
Running ->com.mysql.jdbc.PreparedStatement@2f356f: SELECT * FROM Entry WHERE  type = 0 AND entryTime >= '2014-05-02 12:24:16' AND entryTime <= '2014-05-02 18:24:16' ORDER BY entryTime
SQL -> SELECT * FROM Entry WHERE  type = 1 AND eventTime >= '2014-05-02 08:24:16' AND eventTime <= '2014-05-02 14:24:16' ORDER BY eventTime
Running ->com.mysql.jdbc.PreparedStatement@1dfd868: SELECT * FROM Entry WHERE  type = 1 AND eventTime >= '2014-05-02 08:24:16' AND eventTime <= '2014-05-02 14:24:16' ORDER BY eventTime
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 18:07:08') AND (isNull(endTime) OR (endTime >= '2014-05-02 18:07:08'))
Running ->com.mysql.jdbc.PreparedStatement@1ae9aaa: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 18:07:08') AND (isNull(endTime) OR (endTime >= '2014-05-02 18:07:08'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7664
Running ->com.mysql.jdbc.PreparedStatement@1a7f9dc: SELECT * FROM Attachment WHERE  entryID = 7664
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:49:55') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:49:55'))
Running ->com.mysql.jdbc.PreparedStatement@104e28b: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:49:55') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:49:55'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7663
Running ->com.mysql.jdbc.PreparedStatement@1b54362: SELECT * FROM Attachment WHERE  entryID = 7663
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:42:57') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:42:57'))
Running ->com.mysql.jdbc.PreparedStatement@15b0e2c: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:42:57') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:42:57'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7662
Running ->com.mysql.jdbc.PreparedStatement@ff9053: SELECT * FROM Attachment WHERE  entryID = 7662
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:38:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:38:07'))
Running ->com.mysql.jdbc.PreparedStatement@5c7734: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:38:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:38:07'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7661
Running ->com.mysql.jdbc.PreparedStatement@5b675e: SELECT * FROM Attachment WHERE  entryID = 7661
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:52:33') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:52:33'))
Running ->com.mysql.jdbc.PreparedStatement@df83e5: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:52:33') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:52:33'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7660
Running ->com.mysql.jdbc.PreparedStatement@4c6320: SELECT * FROM Attachment WHERE  entryID = 7660
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:13:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:13:15'))
Running ->com.mysql.jdbc.PreparedStatement@1000bcf: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:13:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:13:15'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7659
Running ->com.mysql.jdbc.PreparedStatement@754fc: SELECT * FROM Attachment WHERE  entryID = 7659
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:11:04') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:11:04'))
Running ->com.mysql.jdbc.PreparedStatement@6458a6: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:11:04') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:11:04'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7658
Running ->com.mysql.jdbc.PreparedStatement@1f82ab4: SELECT * FROM Attachment WHERE  entryID = 7658
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:09:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:09:15'))
Running ->com.mysql.jdbc.PreparedStatement@1bb9696: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:09:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:09:15'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7657
Running ->com.mysql.jdbc.PreparedStatement@9b6220: SELECT * FROM Attachment WHERE  entryID = 7657
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:43:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:43:12'))
Running ->com.mysql.jdbc.PreparedStatement@3a6e5c: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:43:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:43:12'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7655
Running ->com.mysql.jdbc.PreparedStatement@238016: SELECT * FROM Attachment WHERE  entryID = 7655
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:22:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:22:35'))
Running ->com.mysql.jdbc.PreparedStatement@ae4646: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:22:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:22:35'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7654
Running ->com.mysql.jdbc.PreparedStatement@187b287: SELECT * FROM Attachment WHERE  entryID = 7654
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:18:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:18:35'))
Running ->com.mysql.jdbc.PreparedStatement@1d9e2c7: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:18:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:18:35'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7653
Running ->com.mysql.jdbc.PreparedStatement@1b7ae22: SELECT * FROM Attachment WHERE  entryID = 7653
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:07:42') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:07:42'))
Running ->com.mysql.jdbc.PreparedStatement@1ce1bea: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:07:42') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:07:42'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7652
Running ->com.mysql.jdbc.PreparedStatement@8acfc3: SELECT * FROM Attachment WHERE  entryID = 7652
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:05:30') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:05:30'))
Running ->com.mysql.jdbc.PreparedStatement@14e0e90: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:05:30') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:05:30'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7651
Running ->com.mysql.jdbc.PreparedStatement@62610b: SELECT * FROM Attachment WHERE  entryID = 7651
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:03:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:03:12'))
Running ->com.mysql.jdbc.PreparedStatement@17b40fe: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:03:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:03:12'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7650
Running ->com.mysql.jdbc.PreparedStatement@e7f6eb: SELECT * FROM Attachment WHERE  entryID = 7650
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:56:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:56:12'))
Running ->com.mysql.jdbc.PreparedStatement@1cc0a7f: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:56:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:56:12'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7649
Running ->com.mysql.jdbc.PreparedStatement@3b4b1e: SELECT * FROM Attachment WHERE  entryID = 7649
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:23:02') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:23:02'))
Running ->com.mysql.jdbc.PreparedStatement@c0a9f9: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:23:02') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:23:02'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7648
Running ->com.mysql.jdbc.PreparedStatement@d72200: SELECT * FROM Attachment WHERE  entryID = 7648
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:38:54') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:38:54'))
Running ->com.mysql.jdbc.PreparedStatement@1f9338f: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:38:54') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:38:54'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7647
Running ->com.mysql.jdbc.PreparedStatement@1a80aea: SELECT * FROM Attachment WHERE  entryID = 7647
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:32:28') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:32:28'))
Running ->com.mysql.jdbc.PreparedStatement@164b9b6: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:32:28') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:32:28'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7646
Running ->com.mysql.jdbc.PreparedStatement@1dc64a5: SELECT * FROM Attachment WHERE  entryID = 7646

This is 38 sql statments:

[caine2] ~/> cat beforeBuffer.txt | grep Running | wc -l
38

Note that there is not run table in this example else there would be a few more SELECT statmants.

After the buffer we see this in the log:

timeBufferMemStore size = 1
Using Buffered values for: logLatest.jsp Fri May 02 14:24:52 EDT 2014
SQL -> SELECT * FROM Attachment WHERE  entryID = 7664
Running ->com.mysql.jdbc.PreparedStatement@e93999: SELECT * FROM Attachment WHERE  entryID = 7664
SQL -> SELECT * FROM Attachment WHERE  entryID = 7663
Running ->com.mysql.jdbc.PreparedStatement@1c486f2: SELECT * FROM Attachment WHERE  entryID = 7663
SQL -> SELECT * FROM Attachment WHERE  entryID = 7662
Running ->com.mysql.jdbc.PreparedStatement@1779885: SELECT * FROM Attachment WHERE  entryID = 7662
SQL -> SELECT * FROM Attachment WHERE  entryID = 7661
Running ->com.mysql.jdbc.PreparedStatement@be76c7: SELECT * FROM Attachment WHERE  entryID = 7661
SQL -> SELECT * FROM Attachment WHERE  entryID = 7660
Running ->com.mysql.jdbc.PreparedStatement@682406: SELECT * FROM Attachment WHERE  entryID = 7660
SQL -> SELECT * FROM Attachment WHERE  entryID = 7659
Running ->com.mysql.jdbc.PreparedStatement@115126e: SELECT * FROM Attachment WHERE  entryID = 7659
SQL -> SELECT * FROM Attachment WHERE  entryID = 7658
Running ->com.mysql.jdbc.PreparedStatement@6d2380: SELECT * FROM Attachment WHERE  entryID = 7658
SQL -> SELECT * FROM Attachment WHERE  entryID = 7657
Running ->com.mysql.jdbc.PreparedStatement@24de7d: SELECT * FROM Attachment WHERE  entryID = 7657
SQL -> SELECT * FROM Attachment WHERE  entryID = 7655
Running ->com.mysql.jdbc.PreparedStatement@8b058b: SELECT * FROM Attachment WHERE  entryID = 7655
SQL -> SELECT * FROM Attachment WHERE  entryID = 7654
Running ->com.mysql.jdbc.PreparedStatement@1192059: SELECT * FROM Attachment WHERE  entryID = 7654
SQL -> SELECT * FROM Attachment WHERE  entryID = 7653
Running ->com.mysql.jdbc.PreparedStatement@9ac0f5: SELECT * FROM Attachment WHERE  entryID = 7653
SQL -> SELECT * FROM Attachment WHERE  entryID = 7652
Running ->com.mysql.jdbc.PreparedStatement@1f21c50: SELECT * FROM Attachment WHERE  entryID = 7652
SQL -> SELECT * FROM Attachment WHERE  entryID = 7651
Running ->com.mysql.jdbc.PreparedStatement@20f237: SELECT * FROM Attachment WHERE  entryID = 7651
SQL -> SELECT * FROM Attachment WHERE  entryID = 7650
Running ->com.mysql.jdbc.PreparedStatement@fe315d: SELECT * FROM Attachment WHERE  entryID = 7650
SQL -> SELECT * FROM Attachment WHERE  entryID = 7649
Running ->com.mysql.jdbc.PreparedStatement@5aebd9: SELECT * FROM Attachment WHERE  entryID = 7649
SQL -> SELECT * FROM Attachment WHERE  entryID = 7648
Running ->com.mysql.jdbc.PreparedStatement@132021a: SELECT * FROM Attachment WHERE  entryID = 7648
SQL -> SELECT * FROM Attachment WHERE  entryID = 7647
Running ->com.mysql.jdbc.PreparedStatement@2803d5: SELECT * FROM Attachment WHERE  entryID = 7647
SQL -> SELECT * FROM Attachment WHERE  entryID = 7646
Running ->com.mysql.jdbc.PreparedStatement@113981b: SELECT * FROM Attachment WHERE  entryID = 7646

[caine2] ~/> cat afterBuffer.txt | grep Running | wc -l
18

The Attachmant calls have not been isolated yet so there is a little bleed through even what the cache. But there is only one select per entry. This can be fixed to bring the selects with cache to zero.

The selects for a full day are:

SQL -> SELECT * FROM Entry WHERE  type = 0 AND entryTime >= '2014-05-02 04:00:00' AND entryTime <= '2014-05-03 03:59:59' ORDER BY entryTime
Running ->com.mysql.jdbc.PreparedStatement@1522de2: SELECT * FROM Entry WHERE  type = 0 AND entryTime >= '2014-05-02 04:00:00' AND entryTime <= '2014-05-03 03:59:59' ORDER BY entryTime
SQL -> SELECT * FROM Entry WHERE  type = 1 AND eventTime >= '2014-05-02 00:00:00' AND eventTime <= '2014-05-02 23:59:59' ORDER BY eventTime
Running ->com.mysql.jdbc.PreparedStatement@1e2afb2: SELECT * FROM Entry WHERE  type = 1 AND eventTime >= '2014-05-02 00:00:00' AND eventTime <= '2014-05-02 23:59:59' ORDER BY eventTime
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 04:09:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 04:09:15'))
Running ->com.mysql.jdbc.PreparedStatement@18105e8: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 04:09:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 04:09:15'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7624
Running ->com.mysql.jdbc.PreparedStatement@16d8196: SELECT * FROM Attachment WHERE  entryID = 7624
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 04:29:59') AND (isNull(endTime) OR (endTime >= '2014-05-02 04:29:59'))
Running ->com.mysql.jdbc.PreparedStatement@56b93a: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 04:29:59') AND (isNull(endTime) OR (endTime >= '2014-05-02 04:29:59'))
running :SELECT rd.`runNumber`, rs.`shiftLeaderStatus`, rs.`rtsStatus`, rd.`glbSetupName`, ds.`numberOfEvents` FROM `runDescriptor` rd, `runStatus` rs, `daqSummary` ds WHERE rd.`runNumber` = rs.`runNumber` AND ds.`runNumber` = rd.`runNumber` AND rd.`endRunTime` BETWEEN UNIX_TIMESTAMP(?) AND UNIX_TIMESTAMP(?);
Gettting run map
SQL -> SELECT * FROM RunChange WHERE `runNumber` IN (15121047, 15121048, 15121049, 15121050, 15121051, 15121052, 15121053, 15121054, 15121055, 15121056, 15121057, 15121058, 15121060, 15121061, 15121062, 15121063, 15121064, 15121065, 15121066, 15121067, 15121068, 15121069, 15121070, 15121071, 15121072, 15121075, 15121076)
Running ->com.mysql.jdbc.PreparedStatement@9300cc: SELECT * FROM RunChange WHERE `runNumber` IN (15121047, 15121048, 15121049, 15121050, 15121051, 15121052, 15121053, 15121054, 15121055, 15121056, 15121057, 15121058, 15121060, 15121061, 15121062, 15121063, 15121064, 15121065, 15121066, 15121067, 15121068, 15121069, 15121070, 15121071, 15121072, 15121075, 15121076)
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
Running ->com.mysql.jdbc.PreparedStatement@15c97e4: SELECT * FROM RunFlag 
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
SQL -> SELECT * FROM Attachment WHERE  entryID = 7625
Running ->com.mysql.jdbc.PreparedStatement@77eb97: SELECT * FROM Attachment WHERE  entryID = 7625
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 05:00:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 05:00:07'))
Running ->com.mysql.jdbc.PreparedStatement@10c3a08: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 05:00:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 05:00:07'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7626
Running ->com.mysql.jdbc.PreparedStatement@1b6235b: SELECT * FROM Attachment WHERE  entryID = 7626
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 05:39:41') AND (isNull(endTime) OR (endTime >= '2014-05-02 05:39:41'))
Running ->com.mysql.jdbc.PreparedStatement@cb42cf: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 05:39:41') AND (isNull(endTime) OR (endTime >= '2014-05-02 05:39:41'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7627
Running ->com.mysql.jdbc.PreparedStatement@8f2ca6: SELECT * FROM Attachment WHERE  entryID = 7627
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 05:43:53') AND (isNull(endTime) OR (endTime >= '2014-05-02 05:43:53'))
Running ->com.mysql.jdbc.PreparedStatement@1d840d9: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 05:43:53') AND (isNull(endTime) OR (endTime >= '2014-05-02 05:43:53'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7628
Running ->com.mysql.jdbc.PreparedStatement@898540: SELECT * FROM Attachment WHERE  entryID = 7628
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 06:11:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 06:11:07'))
Running ->com.mysql.jdbc.PreparedStatement@8b677f: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 06:11:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 06:11:07'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7629
Running ->com.mysql.jdbc.PreparedStatement@37d490: SELECT * FROM Attachment WHERE  entryID = 7629
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 06:46:28') AND (isNull(endTime) OR (endTime >= '2014-05-02 06:46:28'))
Running ->com.mysql.jdbc.PreparedStatement@1647278: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 06:46:28') AND (isNull(endTime) OR (endTime >= '2014-05-02 06:46:28'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7630
Running ->com.mysql.jdbc.PreparedStatement@1972e3a: SELECT * FROM Attachment WHERE  entryID = 7630
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 06:47:45') AND (isNull(endTime) OR (endTime >= '2014-05-02 06:47:45'))
Running ->com.mysql.jdbc.PreparedStatement@5bf624: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 06:47:45') AND (isNull(endTime) OR (endTime >= '2014-05-02 06:47:45'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7631
Running ->com.mysql.jdbc.PreparedStatement@17cd15d: SELECT * FROM Attachment WHERE  entryID = 7631
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 07:00:34') AND (isNull(endTime) OR (endTime >= '2014-05-02 07:00:34'))
Running ->com.mysql.jdbc.PreparedStatement@1955970: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 07:00:34') AND (isNull(endTime) OR (endTime >= '2014-05-02 07:00:34'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7632
Running ->com.mysql.jdbc.PreparedStatement@22ce00: SELECT * FROM Attachment WHERE  entryID = 7632
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 07:26:56') AND (isNull(endTime) OR (endTime >= '2014-05-02 07:26:56'))
Running ->com.mysql.jdbc.PreparedStatement@162522b: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 07:26:56') AND (isNull(endTime) OR (endTime >= '2014-05-02 07:26:56'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7633
Running ->com.mysql.jdbc.PreparedStatement@89dd: SELECT * FROM Attachment WHERE  entryID = 7633
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 07:39:10') AND (isNull(endTime) OR (endTime >= '2014-05-02 07:39:10'))
Running ->com.mysql.jdbc.PreparedStatement@15b1773: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 07:39:10') AND (isNull(endTime) OR (endTime >= '2014-05-02 07:39:10'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7634
Running ->com.mysql.jdbc.PreparedStatement@160bf50: SELECT * FROM Attachment WHERE  entryID = 7634
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:13:29') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:13:29'))
Running ->com.mysql.jdbc.PreparedStatement@b05236: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:13:29') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:13:29'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7635
Running ->com.mysql.jdbc.PreparedStatement@1e55794: SELECT * FROM Attachment WHERE  entryID = 7635
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:22:53') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:22:53'))
Running ->com.mysql.jdbc.PreparedStatement@1d8d237: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:22:53') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:22:53'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7636
Running ->com.mysql.jdbc.PreparedStatement@1d13272: SELECT * FROM Attachment WHERE  entryID = 7636
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:45:32') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:45:32'))
Running ->com.mysql.jdbc.PreparedStatement@146e381: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:45:32') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:45:32'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7637
Running ->com.mysql.jdbc.PreparedStatement@1024994: SELECT * FROM Attachment WHERE  entryID = 7637
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:50:38') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:50:38'))
Running ->com.mysql.jdbc.PreparedStatement@12cd19d: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 08:50:38') AND (isNull(endTime) OR (endTime >= '2014-05-02 08:50:38'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7638
Running ->com.mysql.jdbc.PreparedStatement@1759d12: SELECT * FROM Attachment WHERE  entryID = 7638
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 09:00:32') AND (isNull(endTime) OR (endTime >= '2014-05-02 09:00:32'))
Running ->com.mysql.jdbc.PreparedStatement@9b2a51: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 09:00:32') AND (isNull(endTime) OR (endTime >= '2014-05-02 09:00:32'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7639
Running ->com.mysql.jdbc.PreparedStatement@f7345b: SELECT * FROM Attachment WHERE  entryID = 7639
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 09:35:32') AND (isNull(endTime) OR (endTime >= '2014-05-02 09:35:32'))
Running ->com.mysql.jdbc.PreparedStatement@18e609b: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 09:35:32') AND (isNull(endTime) OR (endTime >= '2014-05-02 09:35:32'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7640
Running ->com.mysql.jdbc.PreparedStatement@687ea9: SELECT * FROM Attachment WHERE  entryID = 7640
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 09:55:38') AND (isNull(endTime) OR (endTime >= '2014-05-02 09:55:38'))
Running ->com.mysql.jdbc.PreparedStatement@538974: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 09:55:38') AND (isNull(endTime) OR (endTime >= '2014-05-02 09:55:38'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7641
Running ->com.mysql.jdbc.PreparedStatement@6545d2: SELECT * FROM Attachment WHERE  entryID = 7641
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 10:26:05') AND (isNull(endTime) OR (endTime >= '2014-05-02 10:26:05'))
Running ->com.mysql.jdbc.PreparedStatement@cade31: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 10:26:05') AND (isNull(endTime) OR (endTime >= '2014-05-02 10:26:05'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7642
Running ->com.mysql.jdbc.PreparedStatement@c1a0eb: SELECT * FROM Attachment WHERE  entryID = 7642
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 10:56:24') AND (isNull(endTime) OR (endTime >= '2014-05-02 10:56:24'))
Running ->com.mysql.jdbc.PreparedStatement@2bccb2: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 10:56:24') AND (isNull(endTime) OR (endTime >= '2014-05-02 10:56:24'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7643
Running ->com.mysql.jdbc.PreparedStatement@18bbf55: SELECT * FROM Attachment WHERE  entryID = 7643
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 11:29:59') AND (isNull(endTime) OR (endTime >= '2014-05-02 11:29:59'))
Running ->com.mysql.jdbc.PreparedStatement@1be8711: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 11:29:59') AND (isNull(endTime) OR (endTime >= '2014-05-02 11:29:59'))
running :SELECT rd.`runNumber`, rs.`shiftLeaderStatus`, rs.`rtsStatus`, rd.`glbSetupName`, ds.`numberOfEvents` FROM `runDescriptor` rd, `runStatus` rs, `daqSummary` ds WHERE rd.`runNumber` = rs.`runNumber` AND ds.`runNumber` = rd.`runNumber` AND rd.`endRunTime` BETWEEN UNIX_TIMESTAMP(?) AND UNIX_TIMESTAMP(?);
Gettting run map
SQL -> SELECT * FROM RunChange WHERE `runNumber` IN (15121077, 15121078, 15122001, 15122002, 15122003, 15122004, 15122005, 15122006, 15122007, 15122008, 15122009, 15122010, 15122011, 15122012, 15122013, 15122014)
Running ->com.mysql.jdbc.PreparedStatement@ed9f47: SELECT * FROM RunChange WHERE `runNumber` IN (15121077, 15121078, 15122001, 15122002, 15122003, 15122004, 15122005, 15122006, 15122007, 15122008, 15122009, 15122010, 15122011, 15122012, 15122013, 15122014)
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
SQL -> SELECT * FROM Attachment WHERE  entryID = 7644
Running ->com.mysql.jdbc.PreparedStatement@164cbde: SELECT * FROM Attachment WHERE  entryID = 7644
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:06:45') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:06:45'))
Running ->com.mysql.jdbc.PreparedStatement@848ecc: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:06:45') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:06:45'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7645
Running ->com.mysql.jdbc.PreparedStatement@bb2bc3: SELECT * FROM Attachment WHERE  entryID = 7645
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:32:28') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:32:28'))
Running ->com.mysql.jdbc.PreparedStatement@363068: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:32:28') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:32:28'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7646
Running ->com.mysql.jdbc.PreparedStatement@1a41cc7: SELECT * FROM Attachment WHERE  entryID = 7646
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:38:54') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:38:54'))
Running ->com.mysql.jdbc.PreparedStatement@15d601f: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 12:38:54') AND (isNull(endTime) OR (endTime >= '2014-05-02 12:38:54'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7647
Running ->com.mysql.jdbc.PreparedStatement@151b0a5: SELECT * FROM Attachment WHERE  entryID = 7647
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:23:02') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:23:02'))
Running ->com.mysql.jdbc.PreparedStatement@2431b9: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:23:02') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:23:02'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7648
Running ->com.mysql.jdbc.PreparedStatement@3ca754: SELECT * FROM Attachment WHERE  entryID = 7648
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:56:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:56:12'))
Running ->com.mysql.jdbc.PreparedStatement@dac21: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 13:56:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 13:56:12'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7649
Running ->com.mysql.jdbc.PreparedStatement@19fdbcb: SELECT * FROM Attachment WHERE  entryID = 7649
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:03:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:03:12'))
Running ->com.mysql.jdbc.PreparedStatement@16fdac: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:03:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:03:12'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7650
Running ->com.mysql.jdbc.PreparedStatement@1682a53: SELECT * FROM Attachment WHERE  entryID = 7650
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:05:30') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:05:30'))
Running ->com.mysql.jdbc.PreparedStatement@7a9224: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:05:30') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:05:30'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7651
Running ->com.mysql.jdbc.PreparedStatement@110b640: SELECT * FROM Attachment WHERE  entryID = 7651
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:07:42') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:07:42'))
Running ->com.mysql.jdbc.PreparedStatement@2d59a3: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:07:42') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:07:42'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7652
Running ->com.mysql.jdbc.PreparedStatement@158015a: SELECT * FROM Attachment WHERE  entryID = 7652
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:18:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:18:35'))
Running ->com.mysql.jdbc.PreparedStatement@c0c8b5: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:18:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:18:35'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7653
Running ->com.mysql.jdbc.PreparedStatement@b914b3: SELECT * FROM Attachment WHERE  entryID = 7653
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:22:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:22:35'))
Running ->com.mysql.jdbc.PreparedStatement@fdfc58: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:22:35') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:22:35'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7654
Running ->com.mysql.jdbc.PreparedStatement@c22a3b: SELECT * FROM Attachment WHERE  entryID = 7654
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:43:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:43:12'))
Running ->com.mysql.jdbc.PreparedStatement@1629e71: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 15:43:12') AND (isNull(endTime) OR (endTime >= '2014-05-02 15:43:12'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7655
Running ->com.mysql.jdbc.PreparedStatement@1904e0d: SELECT * FROM Attachment WHERE  entryID = 7655
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:09:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:09:15'))
Running ->com.mysql.jdbc.PreparedStatement@f449b8: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:09:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:09:15'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7657
Running ->com.mysql.jdbc.PreparedStatement@13fba1: SELECT * FROM Attachment WHERE  entryID = 7657
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:11:04') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:11:04'))
Running ->com.mysql.jdbc.PreparedStatement@1ed27e4: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:11:04') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:11:04'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7658
Running ->com.mysql.jdbc.PreparedStatement@d61aef: SELECT * FROM Attachment WHERE  entryID = 7658
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:13:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:13:15'))
Running ->com.mysql.jdbc.PreparedStatement@82674b: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:13:15') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:13:15'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7659
Running ->com.mysql.jdbc.PreparedStatement@14b84c7: SELECT * FROM Attachment WHERE  entryID = 7659
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:52:33') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:52:33'))
Running ->com.mysql.jdbc.PreparedStatement@fa5ff3: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 16:52:33') AND (isNull(endTime) OR (endTime >= '2014-05-02 16:52:33'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7660
Running ->com.mysql.jdbc.PreparedStatement@1b17d49: SELECT * FROM Attachment WHERE  entryID = 7660
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:38:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:38:07'))
Running ->com.mysql.jdbc.PreparedStatement@19855ed: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:38:07') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:38:07'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7661
Running ->com.mysql.jdbc.PreparedStatement@31688f: SELECT * FROM Attachment WHERE  entryID = 7661
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:42:57') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:42:57'))
Running ->com.mysql.jdbc.PreparedStatement@1c794cc: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:42:57') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:42:57'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7662
Running ->com.mysql.jdbc.PreparedStatement@1f9e31e: SELECT * FROM Attachment WHERE  entryID = 7662
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:49:55') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:49:55'))
Running ->com.mysql.jdbc.PreparedStatement@9fdee: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 17:49:55') AND (isNull(endTime) OR (endTime >= '2014-05-02 17:49:55'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7663
Running ->com.mysql.jdbc.PreparedStatement@bbfa5c: SELECT * FROM Attachment WHERE  entryID = 7663
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 18:07:08') AND (isNull(endTime) OR (endTime >= '2014-05-02 18:07:08'))
Running ->com.mysql.jdbc.PreparedStatement@131de9b: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 18:07:08') AND (isNull(endTime) OR (endTime >= '2014-05-02 18:07:08'))
 relativeURL = '/BGND_spikes_May_2_2014.png' AND entryID IS NOT NULL
SQL -> SELECT * FROM Attachment WHERE  relativeURL = '/BGND_spikes_May_2_2014.png' AND entryID IS NOT NULL
SQL -> SELECT * FROM Attachment WHERE  entryID = 7664
Running ->com.mysql.jdbc.PreparedStatement@10d95cd: SELECT * FROM Attachment WHERE  entryID = 7664
SQL -> SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 18:34:37') AND (isNull(endTime) OR (endTime >= '2014-05-02 18:34:37'))
Running ->com.mysql.jdbc.PreparedStatement@e5f46e: SELECT * FROM Tag WHERE  (startTime <= '2014-05-02 18:34:37') AND (isNull(endTime) OR (endTime >= '2014-05-02 18:34:37'))
SQL -> SELECT * FROM Attachment WHERE  entryID = 7665
Running ->com.mysql.jdbc.PreparedStatement@1128f5a: SELECT * FROM Attachment WHERE  entryID = 7665
Running ->com.mysql.jdbc.PreparedStatement@7ff5b6: SELECT * FROM Attachment WHERE  relativeURL = '/BGND_spikes_May_2_2014.png' AND entryID IS NOT NULL

[caine2] ~/> cat logForDay.txt | grep unning | wc -l
125

The below shows the shiftlog GUI with the run window open (1 refresh ever five min ):

running :SELECT rd.`runNumber`, rs.`shiftLeaderStatus`, rs.`rtsStatus`, rd.`glbSetupName`, ds.`numberOfEvents` FROM `runDescriptor` rd, `runStatus` rs, `daqSummary` ds WHERE rd.`runNumber` = rs.`runNumber` AND ds.`runNumber` = rd.`runNumber` AND rd.`endRunTime` BETWEEN UNIX_TIMESTAMP(?) AND UNIX_TIMESTAMP(?);
Gettting run map
SQL -> SELECT * FROM RunChange WHERE `runNumber` IN (15122016, 15122017, 15122018, 15122019, 15122020, 15122021, 15122023, 15122024, 15122025, 15122026, 15122027, 15122028, 15122030, 15122031, 15122032, 15122033, 15122034, 15122035, 15122036, 15122037, 15122039, 15122041, 15122042, 15122043)
Running ->com.mysql.jdbc.PreparedStatement@94b146: SELECT * FROM RunChange WHERE `runNumber` IN (15122016, 15122017, 15122018, 15122019, 15122020, 15122021, 15122023, 15122024, 15122025, 15122026, 15122027, 15122028, 15122030, 15122031, 15122032, 15122033, 15122034, 15122035, 15122036, 15122037, 15122039, 15122041, 15122042, 15122043)
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
running :SELECT `flagID` FROM `Run` WHERE `runNumber`=? LIMIT 1;
Running ->com.mysql.jdbc.PreparedStatement@917cb0: SELECT * FROM RunFlag

Groups:

STAR Protected

lbhajdu's blog
Login or register to post comments

The STAR experiment

lbhajdu's blog

STAR Protected

User login

Navigation

Group notifications

Intermediate object cache in ShiftLog