Failed to send alarms to DOI via restmon along with exception : java.sql.BatchUpdateException: integrity constraint violation: unique constraint or index violation
Article ID: 380590
Updated On:
Products
Issue/Introduction
When sending some Grafana alerts via RESTMon received errors in the restmon logs and some of the alerts do not appear in OI .
The agent runs in GKE, restmon version 2.1.6,
Example error:
INFO SendToDOI:157 - Sent chunk, document 0 of 1 with category ALARMS to DOI, time taken 62, status HTTP/1.1 202 Accepted
INFO SendAlarmsToDOI:261 - Publishing to OI is successful and Storing the data into Database
DEBUG SendAlarmsToDOI:317 - Storing/inserting the 1 new alarms into DB for the profile-grafana~~grafana
DEBUG PublishedAlarmsDao:135 - Inserting new published alarm attributes content for <number>
ERROR DoiPublisher:120 - Exception: failed to send alarms to DOI.
java.sql.BatchUpdateException: integrity constraint violation: unique constraint or index violation; SYS_PK_<xxxx> table: PUBLISHED_ALARM_ATTRIBUTES
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at com.ca.ce.restmon.common.db.dao.PublishedAlarmsDao.insertPublishedAlarms(PublishedAlarmsDao.java:158)
at com.ca.ce.restmon.common.db.DbUtil.insertPublishedAlarmDetails(DbUtil.java:763)
at com.ca.ce.restmon.publish.doi.update.SendAlarmsToDOI.storeOIPublishedAlarms(SendAlarmsToDOI.java:323)
at com.ca.ce.restmon.publish.doi.update.SendAlarmsToDOI.sendAlarmsToDOI(SendAlarmsToDOI.java:262)
at com.ca.ce.restmon.publish.doi.update.SendAlarmsToDOI.sendAlarmsToDOI(SendAlarmsToDOI.java:193)
at com.ca.ce.restmon.publish.doi.DoiPublisher.publishAndForgetAlarmData(DoiPublisher.java:116)
at com.ca.ce.restmon.common.handlers.profile.ProfileHandler.checkPublishAlarms(ProfileHandler.java:832)
at com.ca.ce.restmon.common.handlers.profile.ProfileHandler.lambda$processAndPublishAlarmDataForLog$5(ProfileHandler.java:777)
at java.base/java.util.concurrent.CompletableFuture$UniAccept.tryFire(CompletableFuture.java:714)
at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1705)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Environment
Full Product versions (EM, Agent etc.): restmon version 2.1.6, to APM SAAS
Resolution
OI Development recommended upgrade to latest version RESTMon to 2.2.5
Feedback
