==> alarm.log <== 13 CLEARED MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 08:46:27 2017 1496731587 um1 ProcessMonitor DMLProc ==> crit.log <== Jun 6 08:46:26 s4-maraidbcs-um-01 ProcessMonitor[10737]: 26.074920 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 15546 ==> debug.log <== Jun 6 08:58:16 s4-maraidbcs-um-01 ExeMgr[15466]: 16.061474 |2147485900|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='schema_1' and tablename='test_data_fct' --tableRID/; || Jun 6 08:58:16 s4-maraidbcs-um-01 ExeMgr[15466]: 16.072459 |2147485900|0|0| D 16 CAL0042: End SQL statement Jun 6 08:58:16 s4-maraidbcs-um-01 ExeMgr[15466]: 16.073213 |2147485900|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_fct' --columnRIDs/FE; || Jun 6 08:58:16 s4-maraidbcs-um-01 ExeMgr[15466]: 16.084132 |2147485900|0|0| D 16 CAL0042: End SQL statement Jun 6 08:58:16 s4-maraidbcs-um-01 ExeMgr[15466]: 16.084672 |2147485900|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_dim_user_prf' --columnRIDs/FE; || Jun 6 08:58:16 s4-maraidbcs-um-01 ExeMgr[15466]: 16.094544 |2147485900|0|0| D 16 CAL0042: End SQL statement Jun 6 08:59:38 s4-maraidbcs-um-01 ExeMgr[15466]: 38.194235 |2242|0|0| D 16 CAL0041: Start SQL statement: select count(1) from schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-22','%Y%m%d')); |mysql| Jun 6 08:59:41 s4-maraidbcs-um-01 ExeMgr[15466]: 41.365292 |2242|0|0| D 16 CAL0042: End SQL statement Jun 6 09:02:07 s4-maraidbcs-um-01 ExeMgr[15466]: 07.048869 |2242|0|0| D 16 CAL0041: Start SQL statement: select count(1) from schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-22','%Y%m%d')); |mysql| Jun 6 09:02:09 s4-maraidbcs-um-01 ExeMgr[15466]: 09.920437 |2242|0|0| D 16 CAL0042: End SQL statement ==> err.log <== Jun 6 08:40:44 s4-maraidbcs-um-01 dmlpackageproc[15546]: 44.227326 |0|0|0| E 21 Query execution was interrupted Jun 6 08:46:26 s4-maraidbcs-um-01 ProcessMonitor[10737]: 26.074920 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 15546 Jun 6 08:54:22 s4-maraidbcs-um-01 dmlpackageproc[16775]: 22.410524 |0|0|0| E 21 Query execution was interrupted ==> info.log <== Jun 6 08:32:16 s4-maraidbcs-um-01 writeenginesplit[11960]: 16.188687 |0|0|0| I 33 CAL0000: Released Table Lock Jun 6 08:40:44 s4-maraidbcs-um-01 dmlpackageproc[15546]: 44.227326 |0|0|0| E 21 Query execution was interrupted Jun 6 08:46:24 s4-maraidbcs-um-01 messagequeue[11169]: 24.611585 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed Jun 6 08:46:26 s4-maraidbcs-um-01 ProcessMonitor[10737]: 26.074920 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 15546 Jun 6 08:46:27 s4-maraidbcs-um-01 ProcessMonitor[10737]: 27.114340 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! Jun 6 08:46:28 s4-maraidbcs-um-01 DMLProc[16775]: 28.159339 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. Jun 6 08:46:28 s4-maraidbcs-um-01 DMLProc[16775]: 28.174062 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. Jun 6 08:46:28 s4-maraidbcs-um-01 DMLProc[16775]: 28.175946 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 15 Jun 6 08:46:29 s4-maraidbcs-um-01 DMLProc[16775]: 29.279291 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. Jun 6 08:54:22 s4-maraidbcs-um-01 dmlpackageproc[16775]: 22.410524 |0|0|0| E 21 Query execution was interrupted ==> uiCommands.log <== Mon Jun 5 14:47:24 2017: Start of a command session!!! Mon Jun 5 14:47:25 2017: quit Mon Jun 5 14:47:25 2017: End of a command session!!! ==> warning.log <== Jun 6 08:40:44 s4-maraidbcs-um-01 dmlpackageproc[15546]: 44.227326 |0|0|0| E 21 Query execution was interrupted Jun 6 08:46:24 s4-maraidbcs-um-01 messagequeue[11169]: 24.611585 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed Jun 6 08:46:26 s4-maraidbcs-um-01 ProcessMonitor[10737]: 26.074920 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 15546 Jun 6 08:54:22 s4-maraidbcs-um-01 dmlpackageproc[16775]: 22.410524 |0|0|0| E 21 Query execution was interrupted Jun 6 09:05:43 s4-maraidbcs-um-01 messagequeue[11169]: 43.547138 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> info.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 messagequeue[11169]: 43.547138 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> debug.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 messagequeue[11169]: 43.547138 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> crit.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547174 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 16775 ==> err.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547174 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 16775 ==> warning.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547174 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 16775 ==> info.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547174 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 16775 ==> debug.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547174 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 16775 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547273 |0|0|0| D 18 CAL0000: STOPPING Process: DMLProc Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.547374 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 1 PID = 0 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.548152 |0|0|0| D 18 CAL0000: Send SET Alarm ID 13 on device DMLProc ==> alarm.log <== 13 MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 09:05:43 2017 1496732743 um1 ProcessMonitor DMLProc ==> debug.log <== Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.549775 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 25 on device DMLProc Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.550893 |0|0|0| D 18 CAL0000: Send SET Alarm ID 13 on device DMLProc Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.558664 |0|0|0| D 18 CAL0000: Pkill Process just to make sure: DMLProc\* Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.558710 |0|0|0| D 18 CAL0000: STARTING Process: DMLProc Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.558746 |0|0|0| D 18 CAL0000: Process location: /usr/local/mariadb/columnstore/bin/DMLProc Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.559352 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm1 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.560192 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm2 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.561110 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm3 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.562048 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm4 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.563345 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/um1 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.564091 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/um2 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.564769 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm1 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.565459 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm2 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.566167 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm3 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.566779 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm4 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.567775 |0|0|0| D 18 CAL0000: Dependent process of DDLProc/um1 is 4 Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.567870 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 27 on device DBRM Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.576232 |0|0|0| D 18 CAL0000: Pkill Process just to make sure: DMLProc\* Jun 6 09:05:43 s4-maraidbcs-um-01 ProcessMonitor[10737]: 43.576285 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 3 PID = 0 Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.583205 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 21 PID = 22977 Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.583737 |0|0|0| D 18 CAL0000: DMLProc PID is 22977 Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.583922 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 21 on device DMLProc Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.583954 |0|0|0| D 18 CAL0000: Inform Process Mgr that process was restarted: DMLProc ==> info.log <== Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.584223 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! ==> debug.log <== Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.584223 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.584963 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 13 on device DMLProc ==> alarm.log <== 13 CLEARED MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 09:05:44 2017 1496732744 um1 ProcessMonitor DMLProc ==> debug.log <== Jun 6 09:05:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.586381 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 25 on device DMLProc ==> info.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.629565 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. ==> debug.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.629565 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. ==> info.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.646807 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. ==> debug.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.646807 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. ==> info.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.649270 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 17 ==> debug.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.649270 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 17 ==> info.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.674452 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. ==> debug.log <== Jun 6 09:05:45 s4-maraidbcs-um-01 DMLProc[22977]: 45.674452 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. ^[[A^[[D^[[BJun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.038211 |2147485902|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='schema_1' and tablename='test_data_fct' --tableRID/; || Jun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.056756 |2147485902|0|0| D 16 CAL0042: End SQL statement Jun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.057679 |2147485902|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_fct' --columnRIDs/FE; || Jun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.073323 |2147485902|0|0| D 16 CAL0042: End SQL statement Jun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.073888 |2147485902|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_dim_user_prf' --columnRIDs/FE; || Jun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.081905 |2147485902|0|0| D 16 CAL0042: End SQL statement Jun 6 09:07:56 s4-maraidbcs-um-01 dmlpackageproc[22977]: 56.104612 |2254|18|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= 20170522;|schema_1| Jun 6 09:07:56 s4-maraidbcs-um-01 ExeMgr[15466]: 56.135409 |2254|0|0| D 16 CAL0041: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= 20170522; || Jun 6 09:08:22 s4-maraidbcs-um-01 dmlpackageproc[22977]: 22.418685 |2254|18|0| D 21 CAL0001: End SQL statement Jun 6 09:08:22 s4-maraidbcs-um-01 ExeMgr[15466]: 22.475404 |2254|0|0| D 16 CAL0042: End SQL statement Jun 6 09:08:22 s4-maraidbcs-um-01 dmlpackageproc[22977]: 22.482523 |2254|18|0| D 21 CAL0001: Start SQL statement: COMMIT Jun 6 09:08:22 s4-maraidbcs-um-01 dmlpackageproc[22977]: 22.506014 |2254|18|0| D 21 CAL0001: End SQL statement Jun 6 09:09:59 s4-maraidbcs-um-01 ExeMgr[15466]: 59.806103 |2242|0|0| D 16 CAL0041: Start SQL statement: select count(1) from schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-21','%Y%m%d')); |mysql| Jun 6 09:10:02 s4-maraidbcs-um-01 ExeMgr[15466]: 02.769409 |2242|0|0| D 16 CAL0042: End SQL statement Jun 6 09:10:12 s4-maraidbcs-um-01 ExeMgr[15466]: 12.913815 |2242|0|0| D 16 CAL0041: Start SQL statement: select count(1) from schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-19','%Y%m%d')); |mysql| Jun 6 09:10:15 s4-maraidbcs-um-01 ExeMgr[15466]: 15.993319 |2242|0|0| D 16 CAL0042: End SQL statement Jun 6 09:11:15 s4-maraidbcs-um-01 dmlpackageproc[22977]: 15.188183 |2254|19|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-19','%Y%m%d'));|schema_1| Jun 6 09:11:15 s4-maraidbcs-um-01 ExeMgr[15466]: 15.219420 |2254|0|0| D 16 CAL0041: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-19','%Y%m%d')); || Jun 6 09:11:44 s4-maraidbcs-um-01 dmlpackageproc[22977]: 44.427735 |2254|19|0| D 21 CAL0001: End SQL statement Jun 6 09:11:44 s4-maraidbcs-um-01 ExeMgr[15466]: 44.454946 |2254|0|0| D 16 CAL0042: End SQL statement Jun 6 09:11:44 s4-maraidbcs-um-01 dmlpackageproc[22977]: 44.461722 |2254|19|0| D 21 CAL0001: Start SQL statement: COMMIT Jun 6 09:11:44 s4-maraidbcs-um-01 dmlpackageproc[22977]: 44.478224 |2254|19|0| D 21 CAL0001: End SQL statement Jun 6 09:12:13 s4-maraidbcs-um-01 ExeMgr[15466]: 13.004490 |2242|0|0| D 16 CAL0041: Start SQL statement: select count(1) from schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-01','%Y%m%d')); |mysql| Jun 6 09:12:17 s4-maraidbcs-um-01 ExeMgr[15466]: 17.379375 |2242|0|0| D 16 CAL0042: End SQL statement Jun 6 09:12:24 s4-maraidbcs-um-01 dmlpackageproc[22977]: 24.262357 |2254|20|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-01','%Y%m%d'));|schema_1| Jun 6 09:12:24 s4-maraidbcs-um-01 ExeMgr[15466]: 24.287127 |2254|0|0| D 16 CAL0041: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-05-01','%Y%m%d')); || Jun 6 09:13:27 s4-maraidbcs-um-01 dmlpackageproc[22977]: 27.502403 |2254|20|0| D 21 CAL0001: End SQL statement Jun 6 09:13:27 s4-maraidbcs-um-01 ExeMgr[15466]: 27.578563 |2254|0|0| D 16 CAL0042: End SQL statement Jun 6 09:13:27 s4-maraidbcs-um-01 dmlpackageproc[22977]: 27.585107 |2254|20|0| D 21 CAL0001: Start SQL statement: COMMIT Jun 6 09:13:27 s4-maraidbcs-um-01 dmlpackageproc[22977]: 27.601220 |2254|20|0| D 21 CAL0001: End SQL statement Jun 6 09:15:12 s4-maraidbcs-um-01 ExeMgr[15466]: 12.540069 |2242|0|0| D 16 CAL0041: Start SQL statement: select count(1) from schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-04-22','%Y%m%d')); |mysql| Jun 6 09:15:17 s4-maraidbcs-um-01 ExeMgr[15466]: 17.736988 |2242|0|0| D 16 CAL0042: End SQL statement Jun 6 09:15:28 s4-maraidbcs-um-01 dmlpackageproc[22977]: 28.344469 |2254|21|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct set co_cde = '15';|schema_1| Jun 6 09:15:28 s4-maraidbcs-um-01 ExeMgr[15466]: 28.360263 |2254|0|0| D 16 CAL0041: Start SQL statement: update schema_1.test_data_fct set co_cde = '15'; || Jun 6 09:17:01 s4-maraidbcs-um-01 DMLProc[22977]: 01.429406 |0|0|0| D 20 CAL0002: PackageHandler::rollbackPending: Processing DMLPackage. Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.432423 |2254|21|0| D 21 CAL0001: SQL statement canceled by user Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.436314 |2254|21|0| D 21 CAL0001: End SQL statement with error ==> err.log <== Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.445390 |0|0|0| E 21 Query execution was interrupted ==> warning.log <== Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.445390 |0|0|0| E 21 Query execution was interrupted ==> info.log <== Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.445390 |0|0|0| E 21 Query execution was interrupted ==> debug.log <== Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.445390 |0|0|0| E 21 Query execution was interrupted Jun 6 09:17:01 s4-maraidbcs-um-01 dmlpackageproc[22977]: 01.462535 |2254|21|0| D 21 CAL0001: Start SQL statement: ROLLBACK Jun 6 09:17:01 s4-maraidbcs-um-01 ExeMgr[15466]: 01.467229 |2254|0|0| D 16 CAL0042: End SQL statement Jun 6 09:17:16 s4-maraidbcs-um-01 dmlpackageproc[22977]: 16.037940 |2254|21|0| D 21 CAL0001: End SQL statement ==> warning.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 messagequeue[11169]: 44.364367 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> info.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 messagequeue[11169]: 44.364367 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> debug.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 messagequeue[11169]: 44.364367 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> crit.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364400 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 22977 ==> err.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364400 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 22977 ==> warning.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364400 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 22977 ==> info.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364400 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 22977 ==> debug.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364400 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 22977 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364498 |0|0|0| D 18 CAL0000: STOPPING Process: DMLProc Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364558 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 1 PID = 0 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.364719 |0|0|0| D 18 CAL0000: Send SET Alarm ID 13 on device DMLProc ==> alarm.log <== 13 MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 09:17:44 2017 1496733464 um1 ProcessMonitor DMLProc ==> debug.log <== Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.367700 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 25 on device DMLProc Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.368916 |0|0|0| D 18 CAL0000: Send SET Alarm ID 13 on device DMLProc Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.376593 |0|0|0| D 18 CAL0000: Pkill Process just to make sure: DMLProc\* Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.376647 |0|0|0| D 18 CAL0000: STARTING Process: DMLProc Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.376682 |0|0|0| D 18 CAL0000: Process location: /usr/local/mariadb/columnstore/bin/DMLProc Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.377275 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm1 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.378404 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm2 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.379545 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm3 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.380450 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm4 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.381755 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/um1 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.382722 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/um2 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.383853 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm1 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.384626 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm2 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.385241 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm3 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.386045 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm4 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.387118 |0|0|0| D 18 CAL0000: Dependent process of DDLProc/um1 is 4 Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.387757 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 27 on device DBRM Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.396126 |0|0|0| D 18 CAL0000: Pkill Process just to make sure: DMLProc\* Jun 6 09:17:44 s4-maraidbcs-um-01 ProcessMonitor[10737]: 44.396188 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 3 PID = 0 Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.404054 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 21 PID = 27435 Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.404625 |0|0|0| D 18 CAL0000: DMLProc PID is 27435 Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.404829 |0|0|0| D 18 CAL0000: Inform Process Mgr that process was restarted: DMLProc Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.404900 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 13 on device DMLProc ==> info.log <== Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.405090 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! ==> debug.log <== Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.405090 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! ==> alarm.log <== 13 CLEARED MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 09:17:45 2017 1496733465 um1 ProcessMonitor DMLProc ==> debug.log <== Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.406007 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 21 on device DMLProc Jun 6 09:17:45 s4-maraidbcs-um-01 ProcessMonitor[10737]: 45.407483 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 25 on device DMLProc ==> info.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.450374 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. ==> debug.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.450374 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. ==> info.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.469073 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. ==> debug.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.469073 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. ==> info.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.471309 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 22 ==> debug.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.471309 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 22 ==> info.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.503528 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. ==> debug.log <== Jun 6 09:17:46 s4-maraidbcs-um-01 DMLProc[27435]: 46.503528 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.479421 |2147485904|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='schema_1' and tablename='test_data_fct' --tableRID/; || Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.504483 |2147485904|0|0| D 16 CAL0042: End SQL statement Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.505102 |2147485904|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_fct' --columnRIDs/FE; || Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.517829 |2147485904|0|0| D 16 CAL0042: End SQL statement Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.518378 |2147485904|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_dim_user_prf' --columnRIDs/FE; || Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.527913 |2147485904|0|0| D 16 CAL0042: End SQL statement Jun 6 09:18:10 s4-maraidbcs-um-01 dmlpackageproc[27435]: 10.547692 |2256|23|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-04-22','%Y%m%d'));|schema_1| Jun 6 09:18:10 s4-maraidbcs-um-01 ExeMgr[15466]: 10.581495 |2256|0|0| D 16 CAL0041: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-04-22','%Y%m%d')); || Jun 6 09:19:29 s4-maraidbcs-um-01 dmlpackageproc[27435]: 29.788324 |2256|23|0| D 21 CAL0001: End SQL statement Jun 6 09:19:29 s4-maraidbcs-um-01 ExeMgr[15466]: 29.855076 |2256|0|0| D 16 CAL0042: End SQL statement Jun 6 09:19:29 s4-maraidbcs-um-01 dmlpackageproc[27435]: 29.861917 |2256|23|0| D 21 CAL0001: Start SQL statement: COMMIT Jun 6 09:19:29 s4-maraidbcs-um-01 dmlpackageproc[27435]: 29.886218 |2256|23|0| D 21 CAL0001: End SQL statement ^[[AJun 6 09:42:18 s4-maraidbcs-um-01 dmlpackageproc[27435]: 18.692784 |2257|24|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-04-01','%Y%m%d'));|schema_1| Jun 6 09:42:54 s4-maraidbcs-um-01 DMLProc[27435]: 54.719289 |0|0|0| D 20 CAL0002: PackageHandler::rollbackPending: Processing DMLPackage. Jun 6 09:43:08 s4-maraidbcs-um-01 ExeMgr[15466]: 08.645014 |2147485908|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='schema_1' and tablename='test_data_fct' --tableRID/; || Jun 6 09:43:08 s4-maraidbcs-um-01 ExeMgr[15466]: 08.652330 |2147485908|0|0| D 16 CAL0042: End SQL statement Jun 6 09:43:08 s4-maraidbcs-um-01 ExeMgr[15466]: 08.652965 |2147485908|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_fct' --columnRIDs/FE; || Jun 6 09:43:08 s4-maraidbcs-um-01 ExeMgr[15466]: 08.661408 |2147485908|0|0| D 16 CAL0042: End SQL statement Jun 6 09:43:08 s4-maraidbcs-um-01 ExeMgr[15466]: 08.661942 |2147485908|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_dim_user_prf' --columnRIDs/FE; || Jun 6 09:43:08 s4-maraidbcs-um-01 ExeMgr[15466]: 08.669744 |2147485908|0|0| D 16 CAL0042: End SQL statement Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.155065 |2257|24|0| D 21 CAL0001: SQL statement canceled by user Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.187901 |2257|24|0| D 21 CAL0001: End SQL statement with error ==> err.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199936 |2257|24|0| E 21 CAL0001: ReleaseTableAccess: Txn being released is not the current txn in the tablOidQueue for tableid 3546 ==> warning.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199936 |2257|24|0| E 21 CAL0001: ReleaseTableAccess: Txn being released is not the current txn in the tablOidQueue for tableid 3546 ==> info.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199936 |2257|24|0| E 21 CAL0001: ReleaseTableAccess: Txn being released is not the current txn in the tablOidQueue for tableid 3546 Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199988 |0|0|0| E 21 Query execution was interrupted ==> debug.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199936 |2257|24|0| E 21 CAL0001: ReleaseTableAccess: Txn being released is not the current txn in the tablOidQueue for tableid 3546 Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199988 |0|0|0| E 21 Query execution was interrupted ==> err.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199988 |0|0|0| E 21 Query execution was interrupted ==> warning.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.199988 |0|0|0| E 21 Query execution was interrupted ==> info.log <== ==> debug.log <== Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.208574 |2260|25|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-04-01','%Y%m%d'));|schema_1| Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.210099 |2257|24|0| D 21 CAL0001: Start SQL statement: ROLLBACK Jun 6 09:44:12 s4-maraidbcs-um-01 dmlpackageproc[27435]: 12.246887 |2257|24|0| D 21 CAL0001: End SQL statement Jun 6 09:44:12 s4-maraidbcs-um-01 ExeMgr[15466]: 12.363921 |2260|0|0| D 16 CAL0041: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= (date_format('2017-04-01','%Y%m%d')); || Jun 6 09:44:32 s4-maraidbcs-um-01 DMLProc[27435]: 32.755353 |0|0|0| D 20 CAL0002: PackageHandler::rollbackPending: Processing DMLPackage. Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.002505 |2260|25|0| D 21 CAL0001: SQL statement canceled by user Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.039464 |2260|25|0| D 21 CAL0001: End SQL statement with error ==> err.log <== Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.049736 |0|0|0| E 21 Query execution was interrupted ==> warning.log <== Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.049736 |0|0|0| E 21 Query execution was interrupted ==> info.log <== Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.049736 |0|0|0| E 21 Query execution was interrupted ==> debug.log <== Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.049736 |0|0|0| E 21 Query execution was interrupted Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.058652 |2260|25|0| D 21 CAL0001: Start SQL statement: ROLLBACK Jun 6 09:46:05 s4-maraidbcs-um-01 dmlpackageproc[27435]: 05.089118 |2260|25|0| D 21 CAL0001: End SQL statement Jun 6 09:46:05 s4-maraidbcs-um-01 ExeMgr[15466]: 05.231126 |2260|0|0| D 16 CAL0042: End SQL statement Jun 6 09:46:43 s4-maraidbcs-um-01 ExeMgr[15466]: 43.751831 |2147485912|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='schema_1' and tablename='test_data_fct' --tableRID/; || Jun 6 09:46:43 s4-maraidbcs-um-01 ExeMgr[15466]: 43.775907 |2147485912|0|0| D 16 CAL0042: End SQL statement Jun 6 09:46:43 s4-maraidbcs-um-01 ExeMgr[15466]: 43.777091 |2147485912|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_fct' --columnRIDs/FE; || Jun 6 09:46:43 s4-maraidbcs-um-01 ExeMgr[15466]: 43.785044 |2147485912|0|0| D 16 CAL0042: End SQL statement Jun 6 09:46:43 s4-maraidbcs-um-01 ExeMgr[15466]: 43.785624 |2147485912|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='schema_1' and tablename='test_data_dim_user_prf' --columnRIDs/FE; || Jun 6 09:46:43 s4-maraidbcs-um-01 ExeMgr[15466]: 43.796032 |2147485912|0|0| D 16 CAL0042: End SQL statement ==> warning.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 messagequeue[11169]: 20.079035 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> info.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 messagequeue[11169]: 20.079035 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> debug.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 messagequeue[11169]: 20.079035 |0|0|0| W 31 CAL0000: Client read close socket for InetStreamSocket::readToMagic: Remote is closed ==> crit.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079124 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 27435 ==> err.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079124 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 27435 ==> warning.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079124 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 27435 ==> info.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079124 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 27435 ==> debug.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079124 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: DMLProc, old PID = 27435 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079228 |0|0|0| D 18 CAL0000: STOPPING Process: DMLProc Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.079289 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 1 PID = 0 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.080174 |0|0|0| D 18 CAL0000: Send SET Alarm ID 13 on device DMLProc ==> alarm.log <== 13 MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 09:51:20 2017 1496735480 um1 ProcessMonitor DMLProc ==> debug.log <== Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.081835 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 25 on device DMLProc Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.082964 |0|0|0| D 18 CAL0000: Send SET Alarm ID 13 on device DMLProc Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.090814 |0|0|0| D 18 CAL0000: Pkill Process just to make sure: DMLProc\* Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.090868 |0|0|0| D 18 CAL0000: STARTING Process: DMLProc Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.090891 |0|0|0| D 18 CAL0000: Process location: /usr/local/mariadb/columnstore/bin/DMLProc Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.091401 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm1 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.092529 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm2 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.093677 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm3 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.094504 |0|0|0| D 18 CAL0000: Dependent process of WriteEngineServer/pm4 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.095770 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/um1 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.096693 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/um2 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.098524 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm1 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.099405 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm2 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.100218 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm3 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.100979 |0|0|0| D 18 CAL0000: Dependent process of DBRMWorkerNode/pm4 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.102294 |0|0|0| D 18 CAL0000: Dependent process of DDLProc/um1 is 4 Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.102928 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 27 on device DBRM Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.111046 |0|0|0| D 18 CAL0000: Pkill Process just to make sure: DMLProc\* Jun 6 09:51:20 s4-maraidbcs-um-01 ProcessMonitor[10737]: 20.111124 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 3 PID = 0 Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.119044 |0|0|0| D 18 CAL0000: StatusUpdate of Process DMLProc State = 21 PID = 5530 Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.119685 |0|0|0| D 18 CAL0000: DMLProc PID is 5530 Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.119897 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 21 on device DMLProc Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.119906 |0|0|0| D 18 CAL0000: Inform Process Mgr that process was restarted: DMLProc ==> info.log <== Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.120156 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! ==> debug.log <== Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.120156 |0|0|0| I 18 CAL0000: Calpont Process DMLProc restarted successfully!! Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.121583 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 13 on device DMLProc ==> alarm.log <== 13 CLEARED MAJOR ALARM PROCESS_DOWN_AUTO Tue Jun 6 09:51:21 2017 1496735481 um1 ProcessMonitor DMLProc ==> debug.log <== Jun 6 09:51:21 s4-maraidbcs-um-01 ProcessMonitor[10737]: 21.122576 |0|0|0| D 18 CAL0000: Send CLEAR Alarm ID 25 on device DMLProc ==> info.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.163661 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. ==> debug.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.163661 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll. ==> info.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.179634 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. ==> debug.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.179634 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. ==> info.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.182124 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 26 ==> debug.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.182124 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables. DMLProc released transaction 26 ==> info.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.216490 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. ==> debug.log <== Jun 6 09:51:22 s4-maraidbcs-um-01 DMLProc[5530]: 22.216490 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll. Jun 6 09:52:55 s4-maraidbcs-um-01 dmlpackageproc[5530]: 55.722484 |2265|27|0| D 21 CAL0001: Start SQL statement: update schema_1.test_data_fct a, schema_1.test_data_dim_user_prf b set a.co_cde = b.co_cde where a.user_ref = b.user_ref and a.bhdb = b.bhdb and a.co_cde <> b.co_cde and b.co_cde > 0 and a.event_date >= 20170401;|schema_1| Jun 6 09:54:49 s4-maraidbcs-um-01 dmlpackageproc[5530]: 49.541056 |2265|27|0| D 21 CAL0001: End SQL statement Jun 6 09:54:49 s4-maraidbcs-um-01 dmlpackageproc[5530]: 49.599503 |2265|27|0| D 21 CAL0001: Start SQL statement: COMMIT Jun 6 09:54:49 s4-maraidbcs-um-01 dmlpackageproc[5530]: 49.629750 |2265|27|0| D 21 CAL0001: End SQL statement