|
[root@ZABBIX jobarranger]# tail -500 jobarg_server.log
|
|
12075:20170501:124247.084 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124247.084 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124247.132 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124247.132 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124247.132 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124247.132 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124247.132 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000289 seconds while processing rules
|
|
12084:20170501:124247.132 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124247.132 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124247.132 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000270 seconds while processing rules
|
|
12084:20170501:124247.132 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124247.132 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124247.133 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000267 seconds while processing rules
|
|
12084:20170501:124247.133 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124247.446 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124247.446 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124247.446 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124247.525 [DEBUG] In message_purge()
|
|
12085:20170501:124247.525 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124247.525 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124247.525 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124247.525 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124247.525 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124247.525 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124247.526 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124247.526 [DEBUG] message send #1 (message purge) spent 0.001127 seconds while processing rules
|
|
12085:20170501:124247.526 [DEBUG] In message_send()
|
|
12085:20170501:124247.526 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124247 order by retry_date, message_date]
|
|
12085:20170501:124247.526 [DEBUG] message send #1 (message send) spent 0.000337 seconds while processing rules
|
|
12085:20170501:124247.526 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124247.801 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124247.801 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000368 sec.
|
|
12077:20170501:124247.801 [DEBUG] End of process_jajob()
|
|
12077:20170501:124247.801 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124247.954 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124247.954 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124247.955 [DEBUG] job loader #1 (immediate start) spent 0.000557 seconds while processing rules
|
|
12083:20170501:124247.955 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124247.968 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124247.968 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000276 sec.
|
|
12076:20170501:124247.968 [DEBUG] End of process_jarun()
|
|
12076:20170501:124247.968 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124248.085 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124248.085 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000288 sec.
|
|
12075:20170501:124248.085 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124248.085 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124248.085 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000199 sec.
|
|
12075:20170501:124248.085 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124248.085 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124248.133 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124248.133 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124248.133 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124248.133 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124248.133 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000266 seconds while processing rules
|
|
12084:20170501:124248.133 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124248.133 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124248.133 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000271 seconds while processing rules
|
|
12084:20170501:124248.133 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124248.134 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124248.134 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000281 seconds while processing rules
|
|
12084:20170501:124248.134 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124248.447 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124248.447 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124248.447 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124248.526 [DEBUG] In message_purge()
|
|
12085:20170501:124248.526 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124248.526 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124248.527 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124248.527 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124248.527 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124248.527 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124248.527 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124248.527 [DEBUG] message send #1 (message purge) spent 0.000936 seconds while processing rules
|
|
12085:20170501:124248.527 [DEBUG] In message_send()
|
|
12085:20170501:124248.527 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124248 order by retry_date, message_date]
|
|
12085:20170501:124248.528 [DEBUG] message send #1 (message send) spent 0.000284 seconds while processing rules
|
|
12085:20170501:124248.528 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124248.802 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124248.802 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000268 sec.
|
|
12077:20170501:124248.802 [DEBUG] End of process_jajob()
|
|
12077:20170501:124248.802 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124248.955 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124248.955 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124248.956 [DEBUG] job loader #1 (immediate start) spent 0.000576 seconds while processing rules
|
|
12083:20170501:124248.956 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124248.969 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124248.969 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000307 sec.
|
|
12076:20170501:124248.969 [DEBUG] End of process_jarun()
|
|
12076:20170501:124248.969 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124249.085 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124249.086 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000323 sec.
|
|
12075:20170501:124249.086 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124249.086 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124249.086 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000205 sec.
|
|
12075:20170501:124249.086 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124249.086 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124249.134 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124249.134 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124249.134 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124249.134 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124249.134 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000277 seconds while processing rules
|
|
12084:20170501:124249.134 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124249.134 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124249.135 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000293 seconds while processing rules
|
|
12084:20170501:124249.135 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124249.135 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124249.135 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000267 seconds while processing rules
|
|
12084:20170501:124249.135 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124249.447 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124249.447 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124249.447 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124249.528 [DEBUG] In message_purge()
|
|
12085:20170501:124249.528 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124249.528 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124249.528 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124249.528 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124249.528 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124249.529 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124249.529 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124249.529 [DEBUG] message send #1 (message purge) spent 0.001072 seconds while processing rules
|
|
12085:20170501:124249.529 [DEBUG] In message_send()
|
|
12085:20170501:124249.529 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124249 order by retry_date, message_date]
|
|
12085:20170501:124249.529 [DEBUG] message send #1 (message send) spent 0.000326 seconds while processing rules
|
|
12085:20170501:124249.529 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124249.802 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124249.802 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000289 sec.
|
|
12077:20170501:124249.802 [DEBUG] End of process_jajob()
|
|
12077:20170501:124249.802 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124249.956 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124249.956 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124249.956 [DEBUG] job loader #1 (immediate start) spent 0.000458 seconds while processing rules
|
|
12083:20170501:124249.956 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124249.969 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124249.969 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000255 sec.
|
|
12076:20170501:124249.969 [DEBUG] End of process_jarun()
|
|
12076:20170501:124249.969 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124250.086 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124250.087 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000329 sec.
|
|
12075:20170501:124250.087 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124250.087 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124250.087 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000265 sec.
|
|
12075:20170501:124250.087 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124250.087 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124250.135 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124250.135 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124250.135 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124250.135 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124250.136 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000389 seconds while processing rules
|
|
12084:20170501:124250.136 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124250.136 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124250.136 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000304 seconds while processing rules
|
|
12084:20170501:124250.136 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124250.136 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124250.136 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000346 seconds while processing rules
|
|
12084:20170501:124250.137 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124250.447 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124250.447 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124250.447 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124250.529 [DEBUG] In message_purge()
|
|
12085:20170501:124250.530 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124250.530 [DEBUG] message send #1 (message purge) spent 0.000957 seconds while processing rules
|
|
12085:20170501:124250.530 [DEBUG] In message_send()
|
|
12085:20170501:124250.530 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124250 order by retry_date, message_date]
|
|
12085:20170501:124250.531 [DEBUG] message send #1 (message send) spent 0.000317 seconds while processing rules
|
|
12085:20170501:124250.531 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124250.803 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124250.803 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000291 sec.
|
|
12077:20170501:124250.803 [DEBUG] End of process_jajob()
|
|
12077:20170501:124250.803 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124250.956 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124250.957 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124250.957 [DEBUG] job loader #1 (immediate start) spent 0.000366 seconds while processing rules
|
|
12083:20170501:124250.957 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124250.970 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124250.970 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000247 sec.
|
|
12076:20170501:124250.970 [DEBUG] End of process_jarun()
|
|
12076:20170501:124250.970 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124251.087 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124251.087 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000282 sec.
|
|
12075:20170501:124251.088 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124251.088 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124251.088 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000227 sec.
|
|
12075:20170501:124251.088 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124251.088 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124251.137 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124251.137 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124251.137 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124251.137 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124251.137 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000280 seconds while processing rules
|
|
12084:20170501:124251.137 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124251.137 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124251.137 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000258 seconds while processing rules
|
|
12084:20170501:124251.137 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124251.137 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124251.138 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000303 seconds while processing rules
|
|
12084:20170501:124251.138 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124251.447 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124251.448 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124251.448 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124251.531 [DEBUG] In message_purge()
|
|
12085:20170501:124251.531 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124251.531 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124251.531 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124251.532 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124251.532 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124251.532 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124251.532 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124251.532 [DEBUG] message send #1 (message purge) spent 0.001089 seconds while processing rules
|
|
12085:20170501:124251.532 [DEBUG] In message_send()
|
|
12085:20170501:124251.532 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124251 order by retry_date, message_date]
|
|
12085:20170501:124251.532 [DEBUG] message send #1 (message send) spent 0.000351 seconds while processing rules
|
|
12085:20170501:124251.532 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124251.803 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124251.803 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000291 sec.
|
|
12077:20170501:124251.803 [DEBUG] End of process_jajob()
|
|
12077:20170501:124251.803 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124251.957 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124251.957 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124251.957 [DEBUG] job loader #1 (immediate start) spent 0.000455 seconds while processing rules
|
|
12083:20170501:124251.958 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124251.970 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124251.970 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000259 sec.
|
|
12076:20170501:124251.970 [DEBUG] End of process_jarun()
|
|
12076:20170501:124251.970 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124252.088 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124252.088 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000290 sec.
|
|
12075:20170501:124252.088 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124252.088 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124252.089 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000271 sec.
|
|
12075:20170501:124252.089 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124252.089 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124252.138 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124252.138 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124252.138 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124252.138 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124252.138 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000343 seconds while processing rules
|
|
12084:20170501:124252.138 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124252.138 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124252.139 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000329 seconds while processing rules
|
|
12084:20170501:124252.139 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124252.139 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124252.139 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000353 seconds while processing rules
|
|
12084:20170501:124252.139 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124252.448 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124252.448 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124252.448 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124252.533 [DEBUG] In message_purge()
|
|
12085:20170501:124252.533 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124252.533 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124252.533 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124252.533 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124252.533 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124252.533 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124252.534 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124252.534 [DEBUG] message send #1 (message purge) spent 0.001105 seconds while processing rules
|
|
12085:20170501:124252.534 [DEBUG] In message_send()
|
|
12085:20170501:124252.534 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124252 order by retry_date, message_date]
|
|
12085:20170501:124252.534 [DEBUG] message send #1 (message send) spent 0.000355 seconds while processing rules
|
|
12085:20170501:124252.534 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124252.804 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124252.804 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000412 sec.
|
|
12077:20170501:124252.804 [DEBUG] End of process_jajob()
|
|
12077:20170501:124252.804 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124252.958 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124252.958 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124252.958 [DEBUG] job loader #1 (immediate start) spent 0.000371 seconds while processing rules
|
|
12083:20170501:124252.958 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124252.971 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124252.971 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000248 sec.
|
|
12076:20170501:124252.971 [DEBUG] End of process_jarun()
|
|
12076:20170501:124252.971 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124253.089 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124253.089 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000277 sec.
|
|
12075:20170501:124253.089 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124253.089 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124253.090 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000200 sec.
|
|
12075:20170501:124253.090 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124253.090 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124253.139 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124253.139 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124253.139 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124253.139 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124253.140 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000297 seconds while processing rules
|
|
12084:20170501:124253.140 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124253.140 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124253.140 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000269 seconds while processing rules
|
|
12084:20170501:124253.140 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124253.140 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124253.140 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000266 seconds while processing rules
|
|
12084:20170501:124253.140 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124253.448 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124253.448 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124253.448 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124253.534 [DEBUG] In message_purge()
|
|
12085:20170501:124253.534 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124253.534 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124253.535 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124253.535 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124253.535 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124253.535 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124253.536 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124253.536 [DEBUG] message send #1 (message purge) spent 0.001321 seconds while processing rules
|
|
12085:20170501:124253.536 [DEBUG] In message_send()
|
|
12085:20170501:124253.536 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124253 order by retry_date, message_date]
|
|
12085:20170501:124253.536 [DEBUG] message send #1 (message send) spent 0.000349 seconds while processing rules
|
|
12085:20170501:124253.536 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124253.804 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124253.805 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000445 sec.
|
|
12077:20170501:124253.805 [DEBUG] End of process_jajob()
|
|
12077:20170501:124253.805 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124253.958 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124253.958 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124253.959 [DEBUG] job loader #1 (immediate start) spent 0.000488 seconds while processing rules
|
|
12083:20170501:124253.959 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124253.971 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124253.971 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000261 sec.
|
|
12076:20170501:124253.971 [DEBUG] End of process_jarun()
|
|
12076:20170501:124253.971 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124254.090 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124254.090 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000287 sec.
|
|
12075:20170501:124254.090 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124254.090 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124254.090 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000205 sec.
|
|
12075:20170501:124254.090 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124254.090 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124254.141 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124254.141 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124254.141 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124254.141 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124254.141 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000276 seconds while processing rules
|
|
12084:20170501:124254.141 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124254.141 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124254.141 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000275 seconds while processing rules
|
|
12084:20170501:124254.141 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124254.141 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124254.142 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000299 seconds while processing rules
|
|
12084:20170501:124254.142 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124254.448 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124254.448 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124254.449 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124254.536 [DEBUG] In message_purge()
|
|
12085:20170501:124254.536 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124254.536 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124254.537 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124254.537 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124254.537 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124254.537 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124254.537 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124254.537 [DEBUG] message send #1 (message purge) spent 0.001122 seconds while processing rules
|
|
12085:20170501:124254.537 [DEBUG] In message_send()
|
|
12085:20170501:124254.537 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124254 order by retry_date, message_date]
|
|
12085:20170501:124254.538 [DEBUG] message send #1 (message send) spent 0.000365 seconds while processing rules
|
|
12085:20170501:124254.538 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124254.805 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124254.805 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000386 sec.
|
|
12077:20170501:124254.805 [DEBUG] End of process_jajob()
|
|
12077:20170501:124254.805 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124254.959 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124254.959 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124254.960 [DEBUG] job loader #1 (immediate start) spent 0.000517 seconds while processing rules
|
|
12083:20170501:124254.960 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124254.972 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124254.972 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000277 sec.
|
|
12076:20170501:124254.972 [DEBUG] End of process_jarun()
|
|
12076:20170501:124254.972 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124255.091 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124255.091 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000374 sec.
|
|
12075:20170501:124255.091 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124255.091 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124255.091 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000207 sec.
|
|
12075:20170501:124255.091 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124255.091 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124255.142 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124255.142 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124255.142 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124255.142 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124255.142 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000290 seconds while processing rules
|
|
12084:20170501:124255.142 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124255.142 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124255.142 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000277 seconds while processing rules
|
|
12084:20170501:124255.143 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124255.143 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124255.143 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000299 seconds while processing rules
|
|
12084:20170501:124255.143 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124255.449 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124255.449 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124255.449 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124255.538 [DEBUG] In message_purge()
|
|
12085:20170501:124255.538 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124255.538 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124255.538 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124255.539 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124255.539 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124255.539 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124255.539 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124255.539 [DEBUG] message send #1 (message purge) spent 0.001005 seconds while processing rules
|
|
12085:20170501:124255.539 [DEBUG] In message_send()
|
|
12085:20170501:124255.539 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124255 order by retry_date, message_date]
|
|
12085:20170501:124255.539 [DEBUG] message send #1 (message send) spent 0.000330 seconds while processing rules
|
|
12085:20170501:124255.539 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124255.806 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124255.806 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000370 sec.
|
|
12077:20170501:124255.806 [DEBUG] End of process_jajob()
|
|
12077:20170501:124255.806 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124255.960 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124255.960 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124255.960 [DEBUG] job loader #1 (immediate start) spent 0.000611 seconds while processing rules
|
|
12083:20170501:124255.960 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124255.972 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124255.972 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000281 sec.
|
|
12076:20170501:124255.973 [DEBUG] End of process_jarun()
|
|
12076:20170501:124255.973 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124256.091 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124256.092 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000473 sec.
|
|
12075:20170501:124256.092 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124256.092 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124256.092 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000214 sec.
|
|
12075:20170501:124256.092 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124256.092 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124256.143 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124256.143 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124256.143 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124256.143 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124256.143 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000341 seconds while processing rules
|
|
12084:20170501:124256.144 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124256.144 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124256.144 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000299 seconds while processing rules
|
|
12084:20170501:124256.144 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124256.144 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124256.144 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000290 seconds while processing rules
|
|
12084:20170501:124256.144 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124256.449 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124256.449 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124256.449 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124256.540 [DEBUG] In message_purge()
|
|
12085:20170501:124256.540 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124256.540 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124256.540 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124256.540 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124256.541 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124256.541 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124256.541 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124256.541 [DEBUG] message send #1 (message purge) spent 0.001346 seconds while processing rules
|
|
12085:20170501:124256.541 [DEBUG] In message_send()
|
|
12085:20170501:124256.541 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124256 order by retry_date, message_date]
|
|
12085:20170501:124256.541 [DEBUG] message send #1 (message send) spent 0.000442 seconds while processing rules
|
|
12085:20170501:124256.542 [DEBUG] sleeping for 1 seconds
|
|
12077:20170501:124256.806 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, job_type, method_flag, timeout_flag, start_time from ja_run_job_table where status = 2]
|
|
12077:20170501:124256.807 [DEBUG] In process_jajob() ja_run_job_table(status: RUN): 0.000413 sec.
|
|
12077:20170501:124256.807 [DEBUG] End of process_jajob()
|
|
12077:20170501:124256.807 [DEBUG] sleeping for 1 seconds
|
|
12083:20170501:124256.961 [DEBUG] In jobnet_load_immediate()
|
|
12083:20170501:124256.961 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, update_date, run_type, scheduled_time, public_flag, jobnet_id, user_name, jobnet_name, memo, execution_user_name, multiple_start_up, initial_scheduled_time from ja_run_jobnet_table where run_type <> 0 and main_flag = 0 and status = 0]
|
|
12083:20170501:124256.961 [DEBUG] job loader #1 (immediate start) spent 0.000516 seconds while processing rules
|
|
12083:20170501:124256.961 [DEBUG] sleeping for 1 seconds
|
|
12076:20170501:124256.973 [DEBUG] query [txnlev:0] [select inner_job_id, inner_jobnet_id, method_flag, job_type, test_flag from ja_run_job_table where status = 1 ]
|
|
12076:20170501:124256.973 [DEBUG] In process_jarun() ja_run_job_table(status = READY): 0.000280 sec.
|
|
12076:20170501:124256.973 [DEBUG] End of process_jarun()
|
|
12076:20170501:124256.973 [DEBUG] sleeping for 1 seconds
|
|
12075:20170501:124257.092 [DEBUG] query [txnlev:0] [select inner_jobnet_id, status, jobnet_abort_flag from ja_run_jobnet_summary_table where status in (1, 2)]
|
|
12075:20170501:124257.093 [DEBUG] In process_jajobnet_summary() ja_run_jobnet_summary_table(status): 0.000373 sec.
|
|
12075:20170501:124257.093 [DEBUG] End of process_jajobnet_summary()
|
|
12075:20170501:124257.093 [DEBUG] query [txnlev:0] [select inner_jobnet_id, inner_job_id, timeout_flag, status from ja_run_jobnet_table where status in (1, 2 ,4)]
|
|
12075:20170501:124257.093 [DEBUG] In process_jajobnet() ja_run_jobnet_table(status): 0.000210 sec.
|
|
12075:20170501:124257.093 [DEBUG] End of process_jajobnet()
|
|
12075:20170501:124257.093 [DEBUG] sleeping for 1 seconds
|
|
12084:20170501:124257.144 [DEBUG] In get_purge_date(60)
|
|
12084:20170501:124257.144 [DEBUG] In get_purge_date(43200)
|
|
12084:20170501:124257.144 [DEBUG] In jobnet_purge(201705011142)
|
|
12084:20170501:124257.144 [DEBUG] query [txnlev:0] [select inner_jobnet_id, jobnet_id, update_date, status from ja_run_jobnet_summary_table where end_time <= 20170501114259 and status in(3, 5)]
|
|
12084:20170501:124257.145 [DEBUG] jobnet boot #1 (jobnet purge) spent 0.000305 seconds while processing rules
|
|
12084:20170501:124257.145 [DEBUG] In joblog_purge(201704011242)
|
|
12084:20170501:124257.145 [DEBUG] query [txnlev:0] [select inner_jobnet_main_id from ja_run_log_table where log_date <= 20170401124259999 group by inner_jobnet_main_id]
|
|
12084:20170501:124257.145 [DEBUG] jobnet boot #1 (joblog purge) spent 0.000277 seconds while processing rules
|
|
12084:20170501:124257.145 [DEBUG] In jobnet_boot(201705011242)
|
|
12084:20170501:124257.145 [DEBUG] query [txnlev:0] [select inner_jobnet_id, run_type, scheduled_time, jobnet_id, update_date, multiple_start_up, load_status, start_pending_flag from ja_run_jobnet_summary_table where status = 0 and start_pending_flag != 1 and (scheduled_time <= 201705011242 or scheduled_time = 0) order by scheduled_time, inner_jobnet_id]
|
|
12084:20170501:124257.145 [DEBUG] jobnet boot #1 (jobnet start) spent 0.000283 seconds while processing rules
|
|
12084:20170501:124257.145 [DEBUG] sleeping for 1 seconds
|
|
12086:20170501:124257.449 [DEBUG] In ja_collect_selfmon_stats()
|
|
12086:20170501:124257.449 [DEBUG] End of ja_collect_selfmon_stats()
|
|
12086:20170501:124257.450 [DEBUG] sleeping for 1 seconds
|
|
12085:20170501:124257.542 [DEBUG] In message_purge()
|
|
12085:20170501:124257.542 [DEBUG] In get_purge_date(1440)
|
|
12085:20170501:124257.542 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124257.542 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 1 and send_date <= 20170430124259]
|
|
12085:20170501:124257.542 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124257.542 [DEBUG] query [txnlev:1] [begin;]
|
|
12085:20170501:124257.543 [DEBUG] query [txnlev:1] [delete from ja_send_message_table where send_status = 3 and send_error_date <= 20170430124259]
|
|
12085:20170501:124257.543 [DEBUG] query [txnlev:1] [commit;]
|
|
12085:20170501:124257.543 [DEBUG] message send #1 (message purge) spent 0.001085 seconds while processing rules
|
|
12085:20170501:124257.543 [DEBUG] In message_send()
|
|
12085:20170501:124257.543 [DEBUG] query [txnlev:0] [select send_no, message_date, send_status, retry_count, retry_date, message_type, user_name, host_name, jobnet_id, jobnet_name, job_id, job_id_full, job_name, log_message_id, log_message from ja_send_message_table where (send_status = 0 or send_status = 2) and retry_date <= 20170501124257 order by retry_date, message_date]
|
|
12085:20170501:124257.543 [DEBUG] message send #1 (message send) spent 0.000337 seconds while processing rules
|
|
12085:20170501:124257.543 [DEBUG] sleeping for 1 seconds
|
|
[root@ZABBIX jobarranger]#
|