発報されたアラート内容
--------------------------------------
検知日時:2024.02.05 07:40:21
ホスト名: KZ-USV24
ログレベル:Error
イベントログソース: RA_TRAP
イベントログID: 4096
レベル:Error
イベント内容:
2023-12-30 07:15:06,047 [QuartzSchedulerRA_2_Worker-1] ERROR jp.co.rkkcs.RA_jobcontroller.traplog - RAPPEB_IDODATA-0-0-0:トリガー実行処理実行中に例外が発生しました。org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQLで例外(SQL=[select T1_.GRP_ID as C1_, T1_.EXEC_ID as C2_, T1_.EXEC_EDA_NO as C3_, T1_.JOB_SEQ_NO as C4_, T1_.JOB_TYPE as C5_, T1_.JOB_DESCRIPTION as C6_, T1_.STORED_NAME as C7_, T1_.RENKEI_NO as C8_, T1_.RENKEI_SNO as C9_, T1_.WS_ID as C10_, T1_.PRECEDING_JOB_SEQ_NO as C11_, T1_.STATUS as C12_, T1_.SUB_STATUS as C13_, T1_.PLAN_START_DATE as C14_, T1_.PLAN_START_TIME as C15_, T1_.START_DATE as C16_, T1_.START_TIME as C17_, T1_.END_DATE as C18_, T1_.END_TIME as C19_, T1_.EXECUTION_TRIGGER_ID as C20_, T1_.REGIST_EXEC_ID as C21_, T1_.SYS_SAKUSEIBI as C22_, T1_.SYS_KOSHINBI as C23_, T1_.SYS_JIKAN as C24_, T1_.BAT_ID as C25_ from RAT_EXEC_RIREKI T1_ where T1_.GRP_ID = ? and T1_.EXEC_ID = ? and T1_.EXEC_EDA_NO = ? and T1_.JOB_SEQ_NO = ?], Message=[[ESSR0072]SQLで例外(SQL=[select T1_.GRP_ID as C1_, T1_.EXEC_ID as C2_, T1_.EXEC_EDA_NO as C3_, T1_.JOB_SEQ_NO as C4_, T1_.JOB_TYPE as C5_, T1_.JOB_DESCRIPTION as C6_, T1_.STORED_NAME as C7_, T1_.RENKEI_NO as C8_, T1_.RENKEI_SNO as C9_, T1_.WS_ID as C10_, T1_.PRECEDING_JOB_SEQ_NO as C11_, T1_.STATUS as C12_, T1_.SUB_STATUS as C13_, T1_.PLAN_START_DATE as C14_, T1_.PLAN_START_TIME as C15_, T1_.START_DATE as C16_, T1_.START_TIME as C17_, T1_.END_DATE as C18_, T1_.END_TIME as C19_, T1_.EXECUTION_TRIGGER_ID as C20_, T1_.REGIST_EXEC_ID as C21_, T1_.SYS_SAKUSEIBI as C22_, T1_.SYS_KOSHINBI as C23_, T1_.SYS_JIKAN as C24_, T1_.BAT_ID as C25_ from RAT_EXEC_RIREKI T1_ where T1_.GRP_ID = ? and T1_.EXEC_ID = ? and T1_.EXEC_EDA_NO = ? and T1_.JOB_SEQ_NO = ?], Message=[17008], ErrorCode=08003, SQLState={3})が発生しました : [SQLで例外(Message=[クローズされた接続です。], ErrorCode=17008, SQLState=08003)が発生しました。], [クローズされた接続です。], ErrorCode=17008, SQLState=08003)が発生しました at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:51) at org.seasar.extension.jdbc.query.AbstractSelect$6.handle(AbstractSelect.java:427) at org.seasar.extension.jdbc.query.AbstractSelect$6.handle(AbstractSelect.java:426) at org.seasar.extension.jdbc.query.AbstractSelect$1.handle(AbstractSelect.java:299) at org.seasar.extension.jdbc.query.AbstractSelect$1.handle(AbstractSelect.java:297) at org.seasar.extension.jdbc.manager.JdbcContextImpl.usingPreparedStatement(JdbcContextImpl.java:144) at org.seasar.extension.jdbc.query.AbstractSelect.processPreparedStatement(AbstractSelect.java:294) at org.seasar.extension.jdbc.query.AbstractSelect.processResultSet(AbstractSelect.java:423) at org.seasar.extension.jdbc.query.AbstractSelect.getSingleResultInternal(AbstractSelect.java:248) at org.seasar.extension.jdbc.query.AbstractSelect.getSingleResult(AbstractSelect.java:182) at jp.co.rkkcs.common.service.entity.AbstractService.findById(AbstractService.java:25) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.JobControllerAbstractService.findById(JobControllerAbstractService.java:213) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.$$findById$$invokeSuperMethod$$(RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.java) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c$$MethodInvocation$$findById$$18.proceed(MethodInvocationClassGenerator.java) at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58) at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65) at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c$$MethodInvocation$$findById$$18.proceed(MethodInvocationClassGenerator.java) at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c$$MethodInvocation$$findById$$18.proceed(MethodInvocationClassGenerator.java) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.findById(RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.java) at jp.co.rkkcs.cas.RA_jobcontroller.schedule.TriggerListenerImpl.triggerFired(TriggerListenerImpl.java:99) at org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1851) at org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:329) at org.quartz.core.JobRunShell.run(JobRunShell.java:190) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[select T1_.GRP_ID as C1_, T1_.EXEC_ID as C2_, T1_.EXEC_EDA_NO as C3_, T1_.JOB_SEQ_NO as C4_, T1_.JOB_TYPE as C5_, T1_.JOB_DESCRIPTION as C6_, T1_.STORED_NAME as C7_, T1_.RENKEI_NO as C8_, T1_.RENKEI_SNO as C9_, T1_.WS_ID as C10_, T1_.PRECEDING_JOB_SEQ_NO as C11_, T1_.STATUS as C12_, T1_.SUB_STATUS as C13_, T1_.PLAN_START_DATE as C14_, T1_.PLAN_START_TIME as C15_, T1_.START_DATE as C16_, T1_.START_TIME as C17_, T1_.END_DATE as C18_, T1_.END_TIME as C19_, T1_.EXECUTION_TRIGGER_ID as C20_, T1_.REGIST_EXEC_ID as C21_, T1_.SYS_SAKUSEIBI as C22_, T1_.SYS_KOSHINBI as C23_, T1_.SYS_JIKAN as C24_, T1_.BAT_ID as C25_ from RAT_EXEC_RIREKI T1_ where T1_.GRP_ID = ? and T1_.EXEC_ID = ? and T1_.EXEC_EDA_NO = ? and T1_.JOB_SEQ_NO = ?], Message=[17008], ErrorCode=08003, SQLState={3})が発生しました at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:72) at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:67) at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:83) at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:49) ... 25 moreCaused by: java.sql.SQLException: クローズされた接続です。 at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3980) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3428) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:81) ... 26 more
--------------------------------------
ama - 投稿数: 76
記載されたものでは情報が少なすぎるかと思います。
とりあえず下記情報くらいはいただけると、少しはアドバイスができるかもしれません。
わからないことの方が多いですが。。。
・Zabbixサーバ、監視対象の各OS・Zabbixのバージョン
・登録アイテム、トリガーの内容
・zabbix-server.log zabbix-agent.logの内容
MasahiroTakeuchi - 投稿数: 11
申し訳ございません。
下記回答となります。
OS(Zabbix):CentOS7
監視対象:Windows2016
バージョン:Zabbix4.2.6
アイテム:
・キー :eventlog[Application,,,"RA_TRAP"]
・データ型:ログ
トリガー:
・条件式:(KZ-USV24:eventlog[Application,,,"RA_TRAP"].logeventid(4096))=1
発報されたアラート内容
--------------------------------------
検知日時:2024.02.05 07:40:21
ホスト名: KZ-USV24
ログレベル:Error
イベントログソース: RA_TRAP
イベントログID: 4096
レベル:Error
イベント内容:
2023-12-30 07:15:06,047 [QuartzSchedulerRA_2_Worker-1] ERROR jp.co.rkkcs.RA_jobcontroller.traplog - RAPPEB_IDODATA-0-0-0:トリガー実行処理実行中に例外が発生しました。org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQLで例外(SQL=[select T1_.GRP_ID as C1_, T1_.EXEC_ID as C2_, T1_.EXEC_EDA_NO as C3_, T1_.JOB_SEQ_NO as C4_, T1_.JOB_TYPE as C5_, T1_.JOB_DESCRIPTION as C6_, T1_.STORED_NAME as C7_, T1_.RENKEI_NO as C8_, T1_.RENKEI_SNO as C9_, T1_.WS_ID as C10_, T1_.PRECEDING_JOB_SEQ_NO as C11_, T1_.STATUS as C12_, T1_.SUB_STATUS as C13_, T1_.PLAN_START_DATE as C14_, T1_.PLAN_START_TIME as C15_, T1_.START_DATE as C16_, T1_.START_TIME as C17_, T1_.END_DATE as C18_, T1_.END_TIME as C19_, T1_.EXECUTION_TRIGGER_ID as C20_, T1_.REGIST_EXEC_ID as C21_, T1_.SYS_SAKUSEIBI as C22_, T1_.SYS_KOSHINBI as C23_, T1_.SYS_JIKAN as C24_, T1_.BAT_ID as C25_ from RAT_EXEC_RIREKI T1_ where T1_.GRP_ID = ? and T1_.EXEC_ID = ? and T1_.EXEC_EDA_NO = ? and T1_.JOB_SEQ_NO = ?], Message=[[ESSR0072]SQLで例外(SQL=[select T1_.GRP_ID as C1_, T1_.EXEC_ID as C2_, T1_.EXEC_EDA_NO as C3_, T1_.JOB_SEQ_NO as C4_, T1_.JOB_TYPE as C5_, T1_.JOB_DESCRIPTION as C6_, T1_.STORED_NAME as C7_, T1_.RENKEI_NO as C8_, T1_.RENKEI_SNO as C9_, T1_.WS_ID as C10_, T1_.PRECEDING_JOB_SEQ_NO as C11_, T1_.STATUS as C12_, T1_.SUB_STATUS as C13_, T1_.PLAN_START_DATE as C14_, T1_.PLAN_START_TIME as C15_, T1_.START_DATE as C16_, T1_.START_TIME as C17_, T1_.END_DATE as C18_, T1_.END_TIME as C19_, T1_.EXECUTION_TRIGGER_ID as C20_, T1_.REGIST_EXEC_ID as C21_, T1_.SYS_SAKUSEIBI as C22_, T1_.SYS_KOSHINBI as C23_, T1_.SYS_JIKAN as C24_, T1_.BAT_ID as C25_ from RAT_EXEC_RIREKI T1_ where T1_.GRP_ID = ? and T1_.EXEC_ID = ? and T1_.EXEC_EDA_NO = ? and T1_.JOB_SEQ_NO = ?], Message=[17008], ErrorCode=08003, SQLState={3})が発生しました : [SQLで例外(Message=[クローズされた接続です。], ErrorCode=17008, SQLState=08003)が発生しました。], [クローズされた接続です。], ErrorCode=17008, SQLState=08003)が発生しました at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:51) at org.seasar.extension.jdbc.query.AbstractSelect$6.handle(AbstractSelect.java:427) at org.seasar.extension.jdbc.query.AbstractSelect$6.handle(AbstractSelect.java:426) at org.seasar.extension.jdbc.query.AbstractSelect$1.handle(AbstractSelect.java:299) at org.seasar.extension.jdbc.query.AbstractSelect$1.handle(AbstractSelect.java:297) at org.seasar.extension.jdbc.manager.JdbcContextImpl.usingPreparedStatement(JdbcContextImpl.java:144) at org.seasar.extension.jdbc.query.AbstractSelect.processPreparedStatement(AbstractSelect.java:294) at org.seasar.extension.jdbc.query.AbstractSelect.processResultSet(AbstractSelect.java:423) at org.seasar.extension.jdbc.query.AbstractSelect.getSingleResultInternal(AbstractSelect.java:248) at org.seasar.extension.jdbc.query.AbstractSelect.getSingleResult(AbstractSelect.java:182) at jp.co.rkkcs.common.service.entity.AbstractService.findById(AbstractService.java:25) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.JobControllerAbstractService.findById(JobControllerAbstractService.java:213) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.$$findById$$invokeSuperMethod$$(RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.java) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c$$MethodInvocation$$findById$$18.proceed(MethodInvocationClassGenerator.java) at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58) at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65) at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c$$MethodInvocation$$findById$$18.proceed(MethodInvocationClassGenerator.java) at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c$$MethodInvocation$$findById$$18.proceed(MethodInvocationClassGenerator.java) at jp.co.rkkcs.cas.RA_jobcontroller.service.entity.RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.findById(RatExecRirekiEntityService$$EnhancedByS2AOP$$1625b1c.java) at jp.co.rkkcs.cas.RA_jobcontroller.schedule.TriggerListenerImpl.triggerFired(TriggerListenerImpl.java:99) at org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1851) at org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:329) at org.quartz.core.JobRunShell.run(JobRunShell.java:190) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[select T1_.GRP_ID as C1_, T1_.EXEC_ID as C2_, T1_.EXEC_EDA_NO as C3_, T1_.JOB_SEQ_NO as C4_, T1_.JOB_TYPE as C5_, T1_.JOB_DESCRIPTION as C6_, T1_.STORED_NAME as C7_, T1_.RENKEI_NO as C8_, T1_.RENKEI_SNO as C9_, T1_.WS_ID as C10_, T1_.PRECEDING_JOB_SEQ_NO as C11_, T1_.STATUS as C12_, T1_.SUB_STATUS as C13_, T1_.PLAN_START_DATE as C14_, T1_.PLAN_START_TIME as C15_, T1_.START_DATE as C16_, T1_.START_TIME as C17_, T1_.END_DATE as C18_, T1_.END_TIME as C19_, T1_.EXECUTION_TRIGGER_ID as C20_, T1_.REGIST_EXEC_ID as C21_, T1_.SYS_SAKUSEIBI as C22_, T1_.SYS_KOSHINBI as C23_, T1_.SYS_JIKAN as C24_, T1_.BAT_ID as C25_ from RAT_EXEC_RIREKI T1_ where T1_.GRP_ID = ? and T1_.EXEC_ID = ? and T1_.EXEC_EDA_NO = ? and T1_.JOB_SEQ_NO = ?], Message=[17008], ErrorCode=08003, SQLState={3})が発生しました at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:72) at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:67) at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:83) at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:49) ... 25 moreCaused by: java.sql.SQLException: クローズされた接続です。 at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3980) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3428) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:81) ... 26 more
--------------------------------------
ama - 投稿数: 76
設定は問題ないように見えます。
> 2023/12/30と2024/2/5にアラートが発報されておりましたが
> 2024/2/5に発報されたアラートの内容は2023/12/30に発報されるべきアラートとなっておりました
⇒とありますので、上記12/30に2件アラートが出力される想定だったと推測します。
私の浅い知識で原因として考えられるのは、12/30の1件目アラート発報後に何らかの原因で、
監視対象のZabbixエージェントが2/5まで停止していたのでは?くらいしか想像できません。
あとは、該当日時のzabbix-server.log zabbix-agent.logの内容に何か出力されていないかを確認されてみてはいかがでしょうか?