その他問い合わせ #3606
完了jobnetが終了しない
説明
お世話になっております。
9/10 05:30稼働のジョブネットがタイムアウトしてから終了せずに残り続けております。
Managerから終了処理を実行いたしましたが、状態変わらない模様です。
Serverログを確認すると下記が断続的に出力されており、ジョブを停止しているように見受けられます。復旧にあたってどういった対応をすればよろしいかご教示いただけますでしょうか。
48503:20210911:084740.825 [INFO] [JAJOBNET000001] In jajobnet_kill() jobnet was forced to stop. inner_jobnet_id: 1080698, jobnet_id: p_sf_nim008_jn001, user_name: P_SF_NIM008
48503:20210911:084740.826 [INFO] [JAJOBNET000002] In jajobnet_kill() inner_jobnet_id: 1080698, ready_cnt: 0, run_cnt: 1
■jobarg_get結果
- jobarg_get -z *** -U Admin -P zabbix -r 1080698 -e
export JA_JOBNETID="p_sf_nim008_jn001"
export JA_JOBNETNAME="s_sf_nim008_CUBIC連携ファイル取込バッチ"
export JA_SCHEDULEDTIME="202109100530"
export JA_STARTTIME="20210910053001"
export JA_ENDTIME="0"
export JA_JOBNETRUNTYPE="NORMAL"
export JA_JOBNETSTATUS="RUN"
export JA_JOBSTATUS="TIMEOUT"
export JA_LASTEXITCD=""
export JA_LASTSTDOUT=""
export JA_LASTSTDERR=""
・ ja_run_jobnet_table-------------------------------------+--------------+----------------+---------------------+----------+-----------+--------------+--------+----------------+----------------+----------+-------------+-------------------+-------------------+-------------+----------------------------------------------------+------+------------------+----------------------+-----------+---------------------+---------------------------+------------------+--------------+--------------------+------------------+------------------------+
| inner_jobnet_id | inner_jobnet_main_id | inner_job_id | update_date | created_date | run_type | main_flag | timeout_flag | status | scheduled_time | start_time | end_time | public_flag | multiple_start_up | jobnet_id | user_name | jobnet_name | memo | schedule_id | calendar_id | boot_time | execution_user_name | running_job_id | running_job_name | virtual_time | virtual_start_time | virtual_end_time | initial_scheduled_time |-------------------------------------+--------------+----------------+---------------------+----------+-----------+--------------+--------+----------------+----------------+----------+-------------+-------------------+-------------------+-------------+----------------------------------------------------+------+------------------+----------------------+-----------+---------------------+---------------------------+------------------+--------------+--------------------+------------------+------------------------+
| 1080698 | 1080698 | 0 | 20200124142121 | 2021-09-10 07:50:14 | 0 | 0 | 0 | 5 | 202109100530 | 20210910053001 | 0 | 0 | 0 | p_sf_nim008_jn001 | P_SF_NIM008 | s_sf_nim008_CUBIC連携ファイル取込バッチ | | p_sf_nim008_s001 | pub_s_sf_nim000_c001 | 0530 | P_SF_NIM008 | p_sf_nim008_jn001/FCOPY-1 | | 0 | 0 | 0 | 202109100530 |-------------------------------------+--------------+----------------+---------------------+----------+-----------+--------------+--------+----------------+----------------+----------+-------------+-------------------+-------------------+-------------+----------------------------------------------------+------+------------------+----------------------+-----------+---------------------+---------------------------+------------------+--------------+--------------------+------------------+------------------------+
・ja_run_jobnet_summary_table-------------------------------+---------------------+-----------+----------+--------+------------+-------------------+-------------+----------------+----------------+----------+-------------+-------------------+-------------------+-------------+----------------------------------------------------+------+------------------+----------------------+-----------+---------------------+---------------------------+------------------+--------------+--------------------+------------------+--------------------+------------------------+----------------+------------------+---------------------+
| inner_jobnet_id | update_date | created_date | invo_flag | run_type | status | job_status | jobnet_abort_flag | load_status | scheduled_time | start_time | end_time | public_flag | multiple_start_up | jobnet_id | user_name | jobnet_name | memo | schedule_id | calendar_id | boot_time | execution_user_name | running_job_id | running_job_name | virtual_time | virtual_start_time | virtual_end_time | start_pending_flag | initial_scheduled_time | jobnet_timeout | timeout_run_type | jobnet_timeout_flag |-------------------------------+---------------------+-----------+----------+--------+------------+-------------------+-------------+----------------+----------------+----------+-------------+-------------------+-------------------+-------------+----------------------------------------------------+------+------------------+----------------------+-----------+---------------------+---------------------------+------------------+--------------+--------------------+------------------+--------------------+------------------------+----------------+------------------+---------------------+
| 1080698 | 20200124142121 | 2021-09-10 07:50:13 | 1 | 0 | 2 | 1 | 1 | 0 | 202109100530 | 20210910053001 | 0 | 0 | 0 | p_sf_nim008_jn001 | P_SF_NIM008 | s_sf_nim008_CUBIC連携ファイル取込バッチ | | p_sf_nim008_s001 | pub_s_sf_nim000_c001 | 0530 | P_SF_NIM008 | p_sf_nim008_jn001/FCOPY-1 | | 0 | 0 | 0 | 0 | 202109100530 | 140 | 1 | 1 |-------------------------------+---------------------+-----------+----------+--------+------------+-------------------+-------------+----------------+----------------+----------+-------------+-------------------+-------------------+-------------+----------------------------------------------------+------+------------------+----------------------+-----------+---------------------+---------------------------+------------------+--------------+--------------------+------------------+--------------------+------------------------+----------------+------------------+---------------------+
・ja_run_job_table-----------------------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+------------------------+-----------------------------------+---------------+----------+-------------------+
| inner_job_id | inner_jobnet_id | inner_jobnet_main_id | inner_job_id_fs_link | created_date | invo_flag | job_type | test_flag | method_flag | force_flag | timeout_flag | status | boot_count | end_count | start_time | end_time | point_x | point_y | job_id | job_name | continue_flag | run_user | run_user_password |-----------------------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+------------------------+-----------------------------------+---------------+----------+-------------------+
| 9031418 | 1080698 | 1080698 | 0 | 2021-09-10 05:30:19 | 0 | 14 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 20210910053019 | 0 | 170 | 273 | FCOPY-1 | | 0 | | |
| 9031421 | 1080698 | 1080698 | 0 | 2021-09-10 05:30:18 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20210910053018 | 20210910053018 | 171 | 218 | IF-1 | | 0 | | |
| 9031419 | 1080698 | 1080698 | 0 | 2021-09-10 05:30:18 | 0 | 15 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20210910053016 | 20210910053018 | 170 | 165 | FWAIT-1 | ファイル存在チェック | 0 | | |
| 9031424 | 1080698 | 1080698 | 0 | 2021-09-10 05:30:15 | 0 | 8 | 0 | 0 | 0 | 0 | 3 | 2 | 1 | 20210910053015 | 20210910053015 | 196 | 77 | LOOP-1 | | 0 | | |
| 9031413 | 1080698 | 1080698 | 0 | 2021-09-10 05:30:16 | 0 | 10 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20210910053015 | 20210910053016 | 168 | 119 | COUNT | | 0 | | |
| 9031425 | 1080698 | 1080698 | 0 | 2021-09-10 05:30:07 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 20210910053006 | 20210910053007 | 171 | 35 | START | | 0 | | |
| 9031426 | 1080698 | 1080698 | 9031427 | 2021-09-10 04:30:32 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 170 | 332 | p_sf_nim008_jn001_j001 | | 0 | | |
| 9031428 | 1080698 | 1080698 | 9031429 | 2021-09-10 04:30:32 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 169 | 384 | p_sf_nim008_jn001_j002 | | 0 | | |
| 9031414 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 172 | 537 | END-1 | | 0 | | |
| 9031415 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 424 | 276 | END-2 | | 0 | | |
| 9031416 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 287 | 487 | END-3 | | 0 | | |
| 9031417 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 300 | 218 | EXTJOB-1 | | 0 | | |
| 9031420 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 171 | 436 | FWAIT-2 | コピー後元ファイル削除 | 0 | | |
| 9031422 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 424 | 217 | IF-2 | | 0 | | |
| 9031423 | 1080698 | 1080698 | 0 | 2021-09-10 04:30:32 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 171 | 486 | IF-3 | | 0 | | |-----------------------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+------------------------+-----------------------------------+---------------+----------+-------------------+
----------------------------------+----------------------+--------------+----------------+-------------+---------------+------------+----------+-------------+-------------------+----------------------------------------------------+---------+--------------------------------+-------------+-------------+---------+---------+------------+
| log_date | inner_jobnet_id | inner_jobnet_main_id | inner_job_id | update_date | method_flag | jobnet_status | job_status | run_type | public_flag | jobnet_id | jobnet_name | job_id | job_name | user_name | return_code | std_out | std_err | message_id |----------------------------------+----------------------+--------------+----------------+-------------+---------------+------------+----------+-------------+-------------------+----------------------------------------------------+---------+--------------------------------+-------------+-------------+---------+---------+------------+
| 20210910053001175 | 1080698 | 1080698 | NULL | 20200124142121 | 0 | 1 | NULL | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | NULL | NULL | P_SF_NIM008 | NULL | NULL | NULL | JC00000001 |
| 20210910053006671 | 1080698 | 1080698 | 9031425 | 20200124142121 | 0 | 2 | 1 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | START | | P_SF_NIM008 | NULL | NULL | NULL | JC00000003 |
| 20210910053015451 | 1080698 | 1080698 | 9031424 | 20200124142121 | 0 | 2 | 1 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | LOOP-1 | | P_SF_NIM008 | NULL | NULL | NULL | JC00000003 |
| 20210910053015789 | 1080698 | 1080698 | 9031413 | 20200124142121 | 0 | 2 | 1 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | COUNT | | P_SF_NIM008 | NULL | NULL | NULL | JC00000003 |
| 20210910053016049 | 1080698 | 1080698 | 9031419 | 20200124142121 | 0 | 2 | 1 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | FWAIT-1 | ファイル存在チェック | P_SF_NIM008 | NULL | NULL | NULL | JC00000003 |
| 20210910053018623 | 1080698 | 1080698 | 9031421 | 20200124142121 | 0 | 2 | 1 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | IF-1 | | P_SF_NIM008 | NULL | NULL | NULL | JC00000003 |
| 20210910053019163 | 1080698 | 1080698 | 9031418 | 20200124142121 | 0 | 2 | 1 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | FCOPY-1 | | P_SF_NIM008 | NULL | NULL | NULL | JC00000003 |
| 20210910053007178 | 1080698 | 1080698 | 9031425 | 20200124142121 | 0 | 2 | 2 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | START | | P_SF_NIM008 | NULL | NULL | NULL | JC00000004 |
| 20210910053015707 | 1080698 | 1080698 | 9031424 | 20200124142121 | 0 | 2 | 2 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | LOOP-1 | | P_SF_NIM008 | NULL | NULL | NULL | JC00000004 |
| 20210910053016047 | 1080698 | 1080698 | 9031413 | 20200124142121 | 0 | 2 | 2 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | COUNT | | P_SF_NIM008 | NULL | NULL | NULL | JC00000004 |
| 20210910053018072 | 1080698 | 1080698 | 9031419 | 20200124142121 | 0 | 2 | 2 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | FWAIT-1 | ファイル存在チェック | P_SF_NIM008 | NULL | NULL | NULL | JC00000004 |
| 20210910053018888 | 1080698 | 1080698 | 9031421 | 20200124142121 | 0 | 2 | 2 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | IF-1 | | P_SF_NIM008 | NULL | NULL | NULL | JC00000004 |
| 20210910075013711 | 1080698 | 1080698 | NULL | 20200124142121 | 0 | 2 | 0 | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | | | P_SF_NIM008 | NULL | NULL | NULL | JC00000008 |
| 20210914174003823 | 1080698 | 1080698 | NULL | 20200124142121 | 0 | 5 | NULL | 0 | 0 | p_sf_nim008_jn001 | s_sf_nim008_CUBIC連携ファイル取込バッチ | NULL | NULL | P_SF_NIM008 | NULL | NULL | NULL | JC90000003 |----------------------------------+----------------------+--------------+----------------+-------------+---------------+------------+----------+-------------+-------------------+----------------------------------------------------+---------+--------------------------------+-------------+-------------+---------+---------+------------+
14 rows in set (0.00 sec)
ファイル
