その他問い合わせ #3631
完了Job Arranger Managerにてジョブの実行が進まなくなる
説明
以下の環境にてJob Arranger Managerにテスト用のジョブを登録し、即時実行させてみましたが、実行対象ジョブが黄色表示のままで止まってしまいます。
Zabbix バージョン：5.0.21-1
Job Arranger バージョン：5.1.0
DB：PostgreSQL バージョン 12.10-1
Job Arragener serverのログは以下の通りです。
1808:20220314:155355.851 [ERROR] [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "ja_run_jobnet_summary_pk"
DETAIL: Key (inner_jobnet_id)=(1500000000000000013) already exists.
[insert into ja_run_jobnet_summary_table ( inner_jobnet_id, update_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, execution_user_name, virtual_time, virtual_start_time, virtual_end_time, start_pending_flag, initial_scheduled_time,jobnet_timeout, timeout_run_type) values (1500000000000000013, 20220314155340, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2, 'JOBNET_4', 'Admin', 'JOB-4', 'テストジョブ', 'Admin', 0, 0, 0, 0, 0, 0, 0)]
1808:20220314:155355.852 [ERROR] [JALOADER200002] failed to insert the ja_run_jobnet_summary_table: key[1500000000000000013 JOBNET_4]
Response from "127.0.0.1:10051": "processed: 0; failed: 1; total: 1; seconds spent: 0.000068"
sent: 1; skipped: 0; total: 1
1791:20220314:155357.473 [ERROR] [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: deadlock detected
DETAIL: Process 12213 waits for ShareLock on transaction 64991; blocked by process 12214.
Process 12214 waits for ShareLock on transaction 64990; blocked by process 12213.
HINT: See server log for query details.
CONTEXT: while locking tuple (0,63) in relation "ja_run_jobnet_table"
[select status from ja_run_jobnet_table where inner_jobnet_id = 1500000000000000013 for update]
1791:20220314:155357.473 [ERROR] In process_jajobnet() rollback
PostgreSQLのログを確認すると、以下の通りデッドロックが発生して処理が停止してしまっているようです。
2022-03-14 15:53:57.472 JST [12213] ERROR: deadlock detected
2022-03-14 15:53:57.472 JST [12213] DETAIL: Process 12213 waits for ShareLock on transaction 64991; blocked by process 12214.
Process 12214 waits for ShareLock on transaction 64990; blocked by process 12213.
Process 12213: select status from ja_run_jobnet_table where inner_jobnet_id = 1500000000000000013 for update
Process 12214: select status from ja_run_jobnet_table where inner_jobnet_id = 1500000000000000013 for update
原因と対処方法があればご教授願いたく、ご確認よろしくお願いします。