Guest User

Untitled

a guest
Jul 15th, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 54.43 KB | None | 0 0
  1. hlcblxnedsst:/usr/local/trisano-postgres-data/pg_log # tail -n 500 startup.log
  2. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1318-1] LOG: duration: 0.035 ms
  3. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1319-1] LOG: execute S_1: BEGIN
  4. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1320-1] LOG: duration: 0.015 ms
  5. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1321-1] LOG: duration: 0.079 ms
  6. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1322-1] LOG: duration: 0.122 ms
  7. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1323-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  8. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1324-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985384514'
  9. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1325-1] LOG: duration: 0.072 ms
  10. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1326-1] LOG: duration: 0.070 ms
  11. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1327-1] LOG: duration: 0.087 ms
  12. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1328-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  13. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1329-1] DETAIL: parameters: $1 = 'WAITING'
  14. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1330-1] LOG: duration: 0.037 ms
  15. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1331-1] LOG: duration: 0.014 ms
  16. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1332-1] LOG: execute S_2: COMMIT
  17. 2009-10-19 14:50:44 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1333-1] LOG: duration: 0.021 ms
  18. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1334-1] LOG: duration: 0.083 ms
  19. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1335-1] LOG: duration: 0.016 ms
  20. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1336-1] LOG: execute <unnamed>: select 1
  21. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1337-1] LOG: duration: 0.018 ms
  22. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1338-1] LOG: duration: 0.013 ms
  23. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1339-1] LOG: execute S_1: BEGIN
  24. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1340-1] LOG: duration: 0.015 ms
  25. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1341-1] LOG: duration: 0.064 ms
  26. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1342-1] LOG: duration: 0.095 ms
  27. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1343-1] LOG: execute <unnamed>: SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1
  28. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1344-1] DETAIL: parameters: $1 = 'MISFIRED'
  29. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1345-1] LOG: duration: 0.075 ms
  30. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1346-1] LOG: duration: 0.014 ms
  31. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1347-1] LOG: execute S_2: COMMIT
  32. 2009-10-19 14:51:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1348-1] LOG: duration: 0.021 ms
  33. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1349-1] LOG: duration: 0.059 ms
  34. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1350-1] LOG: duration: 0.015 ms
  35. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1351-1] LOG: execute <unnamed>: select 1
  36. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1352-1] LOG: duration: 0.019 ms
  37. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1353-1] LOG: duration: 0.011 ms
  38. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1354-1] LOG: execute S_1: BEGIN
  39. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1355-1] LOG: duration: 0.014 ms
  40. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1356-1] LOG: duration: 0.079 ms
  41. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1357-1] LOG: duration: 0.107 ms
  42. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1358-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  43. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1359-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985412593'
  44. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1360-1] LOG: duration: 0.074 ms
  45. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1361-1] LOG: duration: 0.070 ms
  46. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1362-1] LOG: duration: 0.087 ms
  47. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1363-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  48. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1364-1] DETAIL: parameters: $1 = 'WAITING'
  49. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1365-1] LOG: duration: 0.037 ms
  50. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1366-1] LOG: duration: 0.014 ms
  51. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1367-1] LOG: execute S_2: COMMIT
  52. 2009-10-19 14:51:12 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1368-1] LOG: duration: 0.021 ms
  53. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1369-1] LOG: duration: 0.060 ms
  54. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1370-1] LOG: duration: 0.016 ms
  55. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1371-1] LOG: execute <unnamed>: select 1
  56. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1372-1] LOG: duration: 0.019 ms
  57. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1373-1] LOG: duration: 0.011 ms
  58. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1374-1] LOG: execute S_1: BEGIN
  59. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1375-1] LOG: duration: 0.015 ms
  60. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1376-1] LOG: duration: 0.079 ms
  61. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1377-1] LOG: duration: 0.106 ms
  62. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1378-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  63. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1379-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985441123'
  64. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1380-1] LOG: duration: 0.070 ms
  65. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1381-1] LOG: duration: 0.072 ms
  66. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1382-1] LOG: duration: 0.091 ms
  67. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1383-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  68. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1384-1] DETAIL: parameters: $1 = 'WAITING'
  69. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1385-1] LOG: duration: 0.038 ms
  70. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1386-1] LOG: duration: 0.014 ms
  71. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1387-1] LOG: execute S_2: COMMIT
  72. 2009-10-19 14:51:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1388-1] LOG: duration: 0.022 ms
  73. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1389-1] LOG: duration: 0.060 ms
  74. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1390-1] LOG: duration: 0.012 ms
  75. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1391-1] LOG: execute <unnamed>: select 1
  76. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1392-1] LOG: duration: 0.018 ms
  77. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1393-1] LOG: duration: 0.012 ms
  78. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1394-1] LOG: execute S_1: BEGIN
  79. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1395-1] LOG: duration: 0.014 ms
  80. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1396-1] LOG: duration: 0.064 ms
  81. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1397-1] LOG: duration: 0.084 ms
  82. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1398-1] LOG: execute <unnamed>: SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1
  83. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1399-1] DETAIL: parameters: $1 = 'MISFIRED'
  84. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1400-1] LOG: duration: 0.050 ms
  85. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1401-1] LOG: duration: 0.013 ms
  86. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1402-1] LOG: execute S_2: COMMIT
  87. 2009-10-19 14:52:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1403-1] LOG: duration: 0.021 ms
  88. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1404-1] LOG: duration: 0.064 ms
  89. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1405-1] LOG: duration: 0.015 ms
  90. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1406-1] LOG: execute <unnamed>: select 1
  91. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1407-1] LOG: duration: 0.019 ms
  92. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1408-1] LOG: duration: 0.012 ms
  93. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1409-1] LOG: execute S_1: BEGIN
  94. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1410-1] LOG: duration: 0.014 ms
  95. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1411-1] LOG: duration: 0.081 ms
  96. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1412-1] LOG: duration: 0.108 ms
  97. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1413-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  98. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1414-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985469132'
  99. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1415-1] LOG: duration: 0.074 ms
  100. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1416-1] LOG: duration: 0.070 ms
  101. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1417-1] LOG: duration: 0.086 ms
  102. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1418-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  103. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1419-1] DETAIL: parameters: $1 = 'WAITING'
  104. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1420-1] LOG: duration: 0.057 ms
  105. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1421-1] LOG: duration: 0.015 ms
  106. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1422-1] LOG: execute S_2: COMMIT
  107. 2009-10-19 14:52:09 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1423-1] LOG: duration: 0.021 ms
  108. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1424-1] LOG: duration: 0.074 ms
  109. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1425-1] LOG: duration: 0.014 ms
  110. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1426-1] LOG: execute <unnamed>: select 1
  111. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1427-1] LOG: duration: 0.018 ms
  112. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1428-1] LOG: duration: 0.012 ms
  113. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1429-1] LOG: execute S_1: BEGIN
  114. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1430-1] LOG: duration: 0.014 ms
  115. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1431-1] LOG: duration: 0.081 ms
  116. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1432-1] LOG: duration: 0.109 ms
  117. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1433-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  118. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1434-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985498091'
  119. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1435-1] LOG: duration: 0.072 ms
  120. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1436-1] LOG: duration: 0.070 ms
  121. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1437-1] LOG: duration: 0.087 ms
  122. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1438-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  123. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1439-1] DETAIL: parameters: $1 = 'WAITING'
  124. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1440-1] LOG: duration: 0.037 ms
  125. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1441-1] LOG: duration: 0.015 ms
  126. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1442-1] LOG: execute S_2: COMMIT
  127. 2009-10-19 14:52:38 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1443-1] LOG: duration: 0.021 ms
  128. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1444-1] LOG: duration: 0.060 ms
  129. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1445-1] LOG: duration: 0.014 ms
  130. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1446-1] LOG: execute <unnamed>: select 1
  131. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1447-1] LOG: duration: 0.020 ms
  132. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1448-1] LOG: duration: 0.012 ms
  133. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1449-1] LOG: execute S_1: BEGIN
  134. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1450-1] LOG: duration: 0.014 ms
  135. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1451-1] LOG: duration: 0.059 ms
  136. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1452-1] LOG: duration: 0.093 ms
  137. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1453-1] LOG: execute <unnamed>: SELECT JOB_NAME FROM QRTZ_JOB_DETAILS WHERE JOB_GROUP = $1
  138. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1454-1] DETAIL: parameters: $1 = '000120314'
  139. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1455-1] LOG: duration: 0.029 ms
  140. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1456-1] LOG: duration: 0.014 ms
  141. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1457-1] LOG: execute S_2: COMMIT
  142. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1458-1] LOG: duration: 0.051 ms
  143. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1459-1] LOG: duration: 0.043 ms
  144. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1460-1] LOG: duration: 0.012 ms
  145. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1461-1] LOG: execute <unnamed>: select 1
  146. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1462-1] LOG: duration: 0.017 ms
  147. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1463-1] LOG: duration: 0.019 ms
  148. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1464-1] LOG: execute S_1: BEGIN
  149. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1465-1] LOG: duration: 0.012 ms
  150. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1466-1] LOG: duration: 0.102 ms
  151. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1467-1] LOG: duration: 0.020 ms
  152. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1468-1] LOG: execute <unnamed>: SELECT DISTINCT(TRIGGER_GROUP) FROM QRTZ_TRIGGERS
  153. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1469-1] LOG: duration: 0.032 ms
  154. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1470-1] LOG: duration: 0.012 ms
  155. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1471-1] LOG: execute S_2: COMMIT
  156. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1472-1] LOG: duration: 0.020 ms
  157. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1473-1] LOG: duration: 0.029 ms
  158. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1474-1] LOG: duration: 0.009 ms
  159. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1475-1] LOG: execute <unnamed>: select 1
  160. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1476-1] LOG: duration: 0.015 ms
  161. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1477-1] LOG: duration: 0.011 ms
  162. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1478-1] LOG: execute S_1: BEGIN
  163. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1479-1] LOG: duration: 0.012 ms
  164. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1480-1] LOG: duration: 0.045 ms
  165. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1481-1] LOG: duration: 0.075 ms
  166. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1482-1] LOG: execute <unnamed>: SELECT TRIGGER_NAME FROM QRTZ_TRIGGERS WHERE TRIGGER_GROUP = $1
  167. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1483-1] DETAIL: parameters: $1 = 'DEFAULT'
  168. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1484-1] LOG: duration: 0.032 ms
  169. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1485-1] LOG: duration: 0.012 ms
  170. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1486-1] LOG: execute S_2: COMMIT
  171. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1487-1] LOG: duration: 0.020 ms
  172. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1488-1] LOG: duration: 0.028 ms
  173. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1489-1] LOG: duration: 0.010 ms
  174. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1490-1] LOG: execute <unnamed>: select 1
  175. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1491-1] LOG: duration: 0.015 ms
  176. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1492-1] LOG: duration: 0.011 ms
  177. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1493-1] LOG: execute S_1: BEGIN
  178. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1494-1] LOG: duration: 0.011 ms
  179. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1495-1] LOG: duration: 0.063 ms
  180. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1496-1] LOG: duration: 0.097 ms
  181. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1497-1] LOG: execute <unnamed>: SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = $1 AND TRIGGER_GROUP = $2
  182. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1498-1] DETAIL: parameters: $1 = 'DailyTrigger', $2 = 'DEFAULT'
  183. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1499-1] LOG: duration: 0.073 ms
  184. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1500-1] LOG: duration: 0.057 ms
  185. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1501-1] LOG: duration: 0.084 ms
  186. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1502-1] LOG: execute <unnamed>: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE TRIGGER_NAME = $1 AND TRIGGER_GROUP = $2
  187. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1503-1] DETAIL: parameters: $1 = 'DailyTrigger', $2 = 'DEFAULT'
  188. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1504-1] LOG: duration: 0.050 ms
  189. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1505-1] LOG: duration: 0.054 ms
  190. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1506-1] LOG: duration: 0.081 ms
  191. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1507-1] LOG: execute <unnamed>: SELECT TRIGGER_LISTENER FROM QRTZ_TRIGGER_LISTENERS WHERE TRIGGER_NAME = $1 AND TRIGGER_GROUP = $2
  192. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1508-1] DETAIL: parameters: $1 = 'DailyTrigger', $2 = 'DEFAULT'
  193. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1509-1] LOG: duration: 0.027 ms
  194. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1510-1] LOG: duration: 0.014 ms
  195. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1511-1] LOG: execute S_2: COMMIT
  196. 2009-10-19 14:52:41 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1512-1] LOG: duration: 0.023 ms
  197. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [109-1] LOG: duration: 0.099 ms
  198. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [110-1] LOG: duration: 0.010 ms
  199. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [111-1] LOG: execute <unnamed>: select 1
  200. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [112-1] LOG: duration: 0.012 ms
  201. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [113-1] LOG: duration: 0.090 ms
  202. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [114-1] LOG: duration: 0.032 ms
  203. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [115-1] LOG: execute <unnamed>:
  204. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  205.  
  206. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [116-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '1CE1C016357922168169EC56787E0AAD', $3 = 'preview.xaction', $4 = 'com.pentaho.core.solution.EnhancedAuditingSolutionEngine', $5 = '000120314', $6 = 'instance_start', $7 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $8 = '', $9 = NULL, $10 = '0', $11 = '2009-10-19 14:52:46.898'
  207. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [117-1] LOG: duration: 0.181 ms
  208. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [118-1] LOG: duration: 0.024 ms
  209. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [119-1] LOG: duration: 0.005 ms
  210. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [120-1] LOG: execute <unnamed>: select 1
  211. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [121-1] LOG: duration: 0.007 ms
  212. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [122-1] LOG: duration: 0.061 ms
  213. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [123-1] LOG: duration: 0.023 ms
  214. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [124-1] LOG: execute <unnamed>:
  215. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  216.  
  217. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [125-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'org.pentaho.platform.engine.services.runtime.RuntimeContext', $5 = '000120314', $6 = 'action_sequence_start', $7 = 'start', $8 = '', $9 = NULL, $10 = '0', $11 = '2009-10-19 14:52:46.927'
  218. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [126-1] LOG: duration: 0.079 ms
  219. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [127-1] LOG: duration: 0.030 ms
  220. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [128-1] LOG: duration: 0.005 ms
  221. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [129-1] LOG: execute <unnamed>: select 1
  222. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [130-1] LOG: duration: 0.010 ms
  223. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [131-1] LOG: duration: 0.056 ms
  224. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [132-1] LOG: duration: 0.024 ms
  225. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [133-1] LOG: execute <unnamed>:
  226. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  227.  
  228. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [134-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'MQLRelationalDataComponent', $5 = '000120314', $6 = 'component_execution_started', $7 = 'start', $8 = '', $9 = NULL, $10 = '0', $11 = '2009-10-19 14:52:46.936'
  229. 2009-10-19 14:52:46 MDT (hibernate:hibuser@127.0.0.1) [7614]: [135-1] LOG: duration: 0.079 ms
  230. 2009-10-19 14:52:51 MDT (trisano_warehouse:trisano_ro@127.0.0.1) [7778]: [1-1] LOG: duration: 5.786 ms
  231. 2009-10-19 14:52:51 MDT (trisano_warehouse:trisano_ro@127.0.0.1) [7778]: [2-1] LOG: duration: 0.307 ms
  232. 2009-10-19 14:52:51 MDT (trisano_warehouse:trisano_ro@127.0.0.1) [7778]: [3-1] LOG: execute <unnamed>: SELECT DISTINCT
  233. MorbidityEvents.county AS COL0
  234. ,MorbidityPatients.last_name AS COL1
  235. FROM
  236. trisano.dw_morbidity_events_view MorbidityEvents
  237. ,trisano.dw_morbidity_patients_view MorbidityPatients
  238. WHERE
  239. ( MorbidityEvents.dw_patients_id = MorbidityPatients.id )
  240. AND
  241. (
  242. FALSE
  243. )
  244.  
  245. 2009-10-19 14:52:51 MDT (trisano_warehouse:trisano_ro@127.0.0.1) [7778]: [4-1] LOG: duration: 0.069 ms
  246. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [136-1] LOG: duration: 0.032 ms
  247. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [137-1] LOG: duration: 0.006 ms
  248. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [138-1] LOG: execute <unnamed>: select 1
  249. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [139-1] LOG: duration: 0.009 ms
  250. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [140-1] LOG: duration: 0.068 ms
  251. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [141-1] LOG: duration: 0.033 ms
  252. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [142-1] LOG: execute <unnamed>:
  253. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  254.  
  255. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [143-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'MQLRelationalDataComponent', $5 = '000120314', $6 = 'instance_attribute', $7 = 'metadata query action sequence', $8 = 'InMemorySolution', $9 = NULL, $10 = '4.54199981689453125', $11 = '2009-10-19 14:52:51.482'
  256. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [144-1] LOG: duration: 0.078 ms
  257. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [145-1] LOG: duration: 0.021 ms
  258. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [146-1] LOG: duration: 0.006 ms
  259. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [147-1] LOG: execute <unnamed>: select 1
  260. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [148-1] LOG: duration: 0.010 ms
  261. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [149-1] LOG: duration: 0.055 ms
  262. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [150-1] LOG: duration: 0.025 ms
  263. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [151-1] LOG: execute <unnamed>:
  264. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  265.  
  266. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [152-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'MQLRelationalDataComponent', $5 = '000120314', $6 = 'component_execution_ended', $7 = 'end', $8 = '', $9 = NULL, $10 = '4.631000041961669921875', $11 = '2009-10-19 14:52:51.567'
  267. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [153-1] LOG: duration: 0.063 ms
  268. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [154-1] LOG: duration: 0.046 ms
  269. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [155-1] LOG: duration: 0.005 ms
  270. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [156-1] LOG: execute <unnamed>: select 1
  271. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [157-1] LOG: duration: 0.009 ms
  272. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [158-1] LOG: duration: 0.048 ms
  273. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [159-1] LOG: duration: 0.023 ms
  274. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [160-1] LOG: execute <unnamed>:
  275. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  276.  
  277. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [161-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'JFreeReportComponent', $5 = '000120314', $6 = 'component_execution_started', $7 = 'start', $8 = '', $9 = NULL, $10 = '0', $11 = '2009-10-19 14:52:51.572'
  278. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [162-1] LOG: duration: 0.057 ms
  279. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [163-1] LOG: duration: 0.075 ms
  280. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [164-1] LOG: duration: 0.014 ms
  281. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [165-1] LOG: execute <unnamed>: select 1
  282. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [166-1] LOG: duration: 0.019 ms
  283. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [167-1] LOG: duration: 0.117 ms
  284. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [168-1] LOG: duration: 0.051 ms
  285. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [169-1] LOG: execute <unnamed>:
  286. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  287.  
  288. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [170-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'JFreeReportComponent', $5 = '000120314', $6 = 'component_execution_ended', $7 = 'end', $8 = '', $9 = NULL, $10 = '0.0489999987185001373291015625', $11 = '2009-10-19 14:52:51.621'
  289. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [171-1] LOG: duration: 0.379 ms
  290. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [172-1] LOG: duration: 0.041 ms
  291. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [173-1] LOG: duration: 0.012 ms
  292. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [174-1] LOG: execute <unnamed>: select 1
  293. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [175-1] LOG: duration: 0.015 ms
  294. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [176-1] LOG: duration: 0.089 ms
  295. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [177-1] LOG: duration: 0.042 ms
  296. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [178-1] LOG: execute <unnamed>:
  297. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  298.  
  299. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [179-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $3 = 'InMemorySolution', $4 = 'org.pentaho.platform.engine.services.runtime.RuntimeContext', $5 = '000120314', $6 = 'action_sequence_end', $7 = 'end', $8 = '', $9 = NULL, $10 = '4.691999912261962890625', $11 = '2009-10-19 14:52:51.628'
  300. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [180-1] LOG: duration: 0.149 ms
  301. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [181-1] LOG: duration: 0.030 ms
  302. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [182-1] LOG: duration: 0.009 ms
  303. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [183-1] LOG: execute <unnamed>: select 1
  304. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [184-1] LOG: duration: 0.014 ms
  305. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [185-1] LOG: duration: 0.105 ms
  306. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [186-1] LOG: duration: 0.042 ms
  307. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [187-1] LOG: execute <unnamed>:
  308. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  309.  
  310. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [188-1] DETAIL: parameters: $1 = 'Adhoc Reporting', $2 = '1CE1C016357922168169EC56787E0AAD', $3 = 'preview.xaction', $4 = 'com.pentaho.core.solution.EnhancedAuditingSolutionEngine', $5 = '000120314', $6 = 'instance_end', $7 = '5b15a9be-bcf1-11de-89b2-ab9a25caf716', $8 = '', $9 = NULL, $10 = '4.709000110626220703125', $11 = '2009-10-19 14:52:51.632'
  311. 2009-10-19 14:52:51 MDT (hibernate:hibuser@127.0.0.1) [7614]: [189-1] LOG: duration: 0.095 ms
  312. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1513-1] LOG: duration: 0.059 ms
  313. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1514-1] LOG: duration: 0.015 ms
  314. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1515-1] LOG: execute <unnamed>: select 1
  315. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1516-1] LOG: duration: 0.019 ms
  316. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1517-1] LOG: duration: 0.012 ms
  317. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1518-1] LOG: execute S_1: BEGIN
  318. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1519-1] LOG: duration: 0.014 ms
  319. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1520-1] LOG: duration: 0.073 ms
  320. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1521-1] LOG: duration: 0.102 ms
  321. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1522-1] LOG: execute <unnamed>: SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1
  322. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1523-1] DETAIL: parameters: $1 = 'MISFIRED'
  323. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1524-1] LOG: duration: 0.032 ms
  324. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1525-1] LOG: duration: 0.014 ms
  325. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1526-1] LOG: execute S_2: COMMIT
  326. 2009-10-19 14:53:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1527-1] LOG: duration: 0.024 ms
  327. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1528-1] LOG: duration: 0.064 ms
  328. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1529-1] LOG: duration: 0.012 ms
  329. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1530-1] LOG: execute <unnamed>: select 1
  330. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1531-1] LOG: duration: 0.018 ms
  331. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1532-1] LOG: duration: 0.011 ms
  332. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1533-1] LOG: execute S_1: BEGIN
  333. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1534-1] LOG: duration: 0.014 ms
  334. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1535-1] LOG: duration: 0.077 ms
  335. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1536-1] LOG: duration: 0.101 ms
  336. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1537-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  337. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1538-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985524373'
  338. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1539-1] LOG: duration: 0.070 ms
  339. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1540-1] LOG: duration: 0.070 ms
  340. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1541-1] LOG: duration: 0.087 ms
  341. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1542-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  342. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1543-1] DETAIL: parameters: $1 = 'WAITING'
  343. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1544-1] LOG: duration: 0.037 ms
  344. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1545-1] LOG: duration: 0.015 ms
  345. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1546-1] LOG: execute S_2: COMMIT
  346. 2009-10-19 14:53:04 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1547-1] LOG: duration: 0.021 ms
  347. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1548-1] LOG: duration: 0.070 ms
  348. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1549-1] LOG: duration: 0.014 ms
  349. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1550-1] LOG: execute <unnamed>: select 1
  350. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1551-1] LOG: duration: 0.020 ms
  351. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1552-1] LOG: duration: 0.012 ms
  352. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1553-1] LOG: execute S_1: BEGIN
  353. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1554-1] LOG: duration: 0.014 ms
  354. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1555-1] LOG: duration: 0.079 ms
  355. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1556-1] LOG: duration: 0.109 ms
  356. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1557-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  357. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1558-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985551575'
  358. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1559-1] LOG: duration: 0.072 ms
  359. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1560-1] LOG: duration: 0.070 ms
  360. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1561-1] LOG: duration: 0.088 ms
  361. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1562-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  362. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1563-1] DETAIL: parameters: $1 = 'WAITING'
  363. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1564-1] LOG: duration: 0.056 ms
  364. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1565-1] LOG: duration: 0.015 ms
  365. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1566-1] LOG: execute S_2: COMMIT
  366. 2009-10-19 14:53:31 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1567-1] LOG: duration: 0.021 ms
  367. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1568-1] LOG: duration: 0.071 ms
  368. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1569-1] LOG: duration: 0.013 ms
  369. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1570-1] LOG: execute <unnamed>: select 1
  370. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1571-1] LOG: duration: 0.019 ms
  371. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1572-1] LOG: duration: 0.012 ms
  372. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1573-1] LOG: execute S_1: BEGIN
  373. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1574-1] LOG: duration: 0.014 ms
  374. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1575-1] LOG: duration: 0.081 ms
  375. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1576-1] LOG: duration: 0.105 ms
  376. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1577-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  377. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1578-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985577342'
  378. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1579-1] LOG: duration: 0.072 ms
  379. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1580-1] LOG: duration: 0.071 ms
  380. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1581-1] LOG: duration: 0.087 ms
  381. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1582-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  382. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1583-1] DETAIL: parameters: $1 = 'WAITING'
  383. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1584-1] LOG: duration: 0.036 ms
  384. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1585-1] LOG: duration: 0.015 ms
  385. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1586-1] LOG: execute S_2: COMMIT
  386. 2009-10-19 14:53:57 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1587-1] LOG: duration: 0.021 ms
  387. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1588-1] LOG: duration: 0.058 ms
  388. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1589-1] LOG: duration: 0.014 ms
  389. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1590-1] LOG: execute <unnamed>: select 1
  390. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1591-1] LOG: duration: 0.019 ms
  391. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1592-1] LOG: duration: 0.012 ms
  392. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1593-1] LOG: execute S_1: BEGIN
  393. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1594-1] LOG: duration: 0.014 ms
  394. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1595-1] LOG: duration: 0.063 ms
  395. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1596-1] LOG: duration: 0.083 ms
  396. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1597-1] LOG: execute <unnamed>: SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1
  397. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1598-1] DETAIL: parameters: $1 = 'MISFIRED'
  398. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1599-1] LOG: duration: 0.033 ms
  399. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1600-1] LOG: duration: 0.014 ms
  400. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1601-1] LOG: execute S_2: COMMIT
  401. 2009-10-19 14:54:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1602-1] LOG: duration: 0.021 ms
  402. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1603-1] LOG: duration: 0.266 ms
  403. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1604-1] LOG: duration: 0.037 ms
  404. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1605-1] LOG: execute <unnamed>: select 1
  405. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1606-1] LOG: duration: 0.046 ms
  406. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1607-1] LOG: duration: 0.019 ms
  407. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1608-1] LOG: execute S_1: BEGIN
  408. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1609-1] LOG: duration: 0.012 ms
  409. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1610-1] LOG: duration: 0.174 ms
  410. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1611-1] LOG: duration: 0.202 ms
  411. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1612-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  412. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1613-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985601715'
  413. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1614-1] LOG: duration: 0.097 ms
  414. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1615-1] LOG: duration: 0.109 ms
  415. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1616-1] LOG: duration: 0.127 ms
  416. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1617-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  417. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1618-1] DETAIL: parameters: $1 = 'WAITING'
  418. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1619-1] LOG: duration: 0.045 ms
  419. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1620-1] LOG: duration: 0.014 ms
  420. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1621-1] LOG: execute S_2: COMMIT
  421. 2009-10-19 14:54:21 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1622-1] LOG: duration: 0.020 ms
  422. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1623-1] LOG: duration: 0.056 ms
  423. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1624-1] LOG: duration: 0.014 ms
  424. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1625-1] LOG: execute <unnamed>: select 1
  425. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1626-1] LOG: duration: 0.019 ms
  426. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1627-1] LOG: duration: 0.012 ms
  427. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1628-1] LOG: execute S_1: BEGIN
  428. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1629-1] LOG: duration: 0.014 ms
  429. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1630-1] LOG: duration: 0.076 ms
  430. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1631-1] LOG: duration: 0.105 ms
  431. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1632-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  432. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1633-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985629889'
  433. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1634-1] LOG: duration: 0.069 ms
  434. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1635-1] LOG: duration: 0.072 ms
  435. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1636-1] LOG: duration: 0.086 ms
  436. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1637-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  437. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1638-1] DETAIL: parameters: $1 = 'WAITING'
  438. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1639-1] LOG: duration: 0.059 ms
  439. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1640-1] LOG: duration: 0.015 ms
  440. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1641-1] LOG: execute S_2: COMMIT
  441. 2009-10-19 14:54:49 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1642-1] LOG: duration: 0.021 ms
  442. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1643-1] LOG: duration: 0.058 ms
  443. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1644-1] LOG: duration: 0.014 ms
  444. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1645-1] LOG: execute <unnamed>: select 1
  445. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1646-1] LOG: duration: 0.018 ms
  446. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1647-1] LOG: duration: 0.012 ms
  447. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1648-1] LOG: execute S_1: BEGIN
  448. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1649-1] LOG: duration: 0.015 ms
  449. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1650-1] LOG: duration: 0.064 ms
  450. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1651-1] LOG: duration: 0.083 ms
  451. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1652-1] LOG: execute <unnamed>: SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1
  452. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1653-1] DETAIL: parameters: $1 = 'MISFIRED'
  453. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1654-1] LOG: duration: 0.032 ms
  454. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1655-1] LOG: duration: 0.014 ms
  455. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1656-1] LOG: execute S_2: COMMIT
  456. 2009-10-19 14:55:02 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1657-1] LOG: duration: 0.021 ms
  457. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1658-1] LOG: duration: 0.062 ms
  458. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1659-1] LOG: duration: 0.014 ms
  459. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1660-1] LOG: execute <unnamed>: select 1
  460. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1661-1] LOG: duration: 0.019 ms
  461. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1662-1] LOG: duration: 0.011 ms
  462. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1663-1] LOG: execute S_1: BEGIN
  463. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1664-1] LOG: duration: 0.014 ms
  464. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1665-1] LOG: duration: 0.081 ms
  465. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1666-1] LOG: duration: 0.106 ms
  466. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1667-1] LOG: execute <unnamed>: UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) AND NEXT_FIRE_TIME < $4
  467. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1668-1] DETAIL: parameters: $1 = 'MISFIRED', $2 = 'WAITING', $3 = 'WAITING', $4 = '1255985654024'
  468. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1669-1] LOG: duration: 0.072 ms
  469. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1670-1] LOG: duration: 0.070 ms
  470. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1671-1] LOG: duration: 0.087 ms
  471. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1672-1] LOG: execute <unnamed>: SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME >= 0
  472. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1673-1] DETAIL: parameters: $1 = 'WAITING'
  473. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1674-1] LOG: duration: 0.037 ms
  474. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1675-1] LOG: duration: 0.015 ms
  475. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1676-1] LOG: execute S_2: COMMIT
  476. 2009-10-19 14:55:14 MDT (quartz:quartzuser@127.0.0.1) [7503]: [1677-1] LOG: duration: 0.021 ms
  477. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7810]: [1-1] LOG: duration: 3.499 ms
  478. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7810]: [2-1] LOG: duration: 1.333 ms
  479. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7810]: [3-1] LOG: execute <unnamed>:
  480. SELECT username, password, enabled FROM USERS WHERE username = $1 ORDER BY username
  481.  
  482. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7810]: [4-1] DETAIL: parameters: $1 = '100012241'
  483. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7810]: [5-1] LOG: duration: 0.241 ms
  484. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7811]: [1-1] LOG: duration: 2.910 ms
  485. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7811]: [2-1] LOG: duration: 1.290 ms
  486. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7811]: [3-1] LOG: execute <unnamed>:
  487. SELECT username, authority FROM GRANTED_AUTHORITIES WHERE username = $1 ORDER BY authority
  488.  
  489. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7811]: [4-1] DETAIL: parameters: $1 = '100012241'
  490. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7811]: [5-1] LOG: duration: 0.316 ms
  491. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [190-1] LOG: duration: 0.067 ms
  492. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [191-1] LOG: duration: 0.010 ms
  493. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [192-1] LOG: execute <unnamed>: select 1
  494. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [193-1] LOG: duration: 0.015 ms
  495. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [194-1] LOG: duration: 0.104 ms
  496. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [195-1] LOG: duration: 0.048 ms
  497. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [196-1] LOG: execute <unnamed>:
  498. INSERT INTO PRO_AUDIT (AUDIT_ID, JOB_ID, INST_ID, OBJ_ID, OBJ_TYPE, ACTOR, MESSAGE_TYPE, MESSAGE_NAME, MESSAGE_TEXT_VALUE, MESSAGE_NUM_VALUE, DURATION, AUDIT_TIME) values (NEXTVAL('hibernate_sequence'),$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
  499.  
  500. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [197-1] DETAIL: parameters: $1 = '', $2 = '47FF02079457EC84D7D4A6DA03A49AC5', $3 = '', $4 = 'org.pentaho.platform.web.http.session.PentahoHttpSession', $5 = '100012241', $6 = 'session_start', $7 = '', $8 = '', $9 = NULL, $10 = '0', $11 = '2009-10-19 14:55:14.741'
  501. 2009-10-19 14:55:14 MDT (hibernate:hibuser@127.0.0.1) [7614]: [198-1] LOG: duration: 0.174 ms
Add Comment
Please, Sign In to add comment