Alarm Journal Errors

Ignition
1

Getting this error on my gate logs.

Logger Time Message
DatabaseJournal 10Aug2020 22:27:29 Error logging alarm event to the database.
java.lang.Exception: Unable to add data to memory buffer, buffer full.

at com.inductiveautomation.ignition.gateway.history.stores.MemoryStore.insertInBuffer(MemoryStore.java:177)

at com.inductiveautomation.ignition.gateway.history.stores.MemoryStore.syncdStoreData(MemoryStore.java:80)

at com.inductiveautomation.ignition.gateway.history.stores.AbstractStore.storeData(AbstractStore.java:233)

at com.inductiveautomation.ignition.gateway.history.stores.MultiStageStore.syncdStoreData(MultiStageStore.java:144)

at com.inductiveautomation.ignition.gateway.history.stores.AbstractStore.storeData(AbstractStore.java:233)

at com.inductiveautomation.ignition.gateway.history.DefaultStoreAndForwardEngine.storeData(DefaultStoreAndForwardEngine.java:146)

at com.inductiveautomation.ignition.gateway.history.HistoryManagerImpl.storeHistory(HistoryManagerImpl.java:199)

at com.inductiveautomation.ignition.gateway.alarming.journal.DatabaseAlarmJournal.storeRawEvent(DatabaseAlarmJournal.java:200)

at com.inductiveautomation.ignition.gateway.alarming.journal.AbstractAlarmJournal.storeEvent(AbstractAlarmJournal.java:105)

at com.inductiveautomation.ignition.gateway.alarming.journal.AlarmJournalManagerImpl.storeEvent(AlarmJournalManagerImpl.java:281)

at com.inductiveautomation.ignition.gateway.alarming.AlarmManagerImpl.transitionAlarm(AlarmManagerImpl.java:496)

at com.inductiveautomation.ignition.gateway.alarming.evaluation.Alarm.processTransition(Alarm.java:894)

at com.inductiveautomation.ignition.gateway.alarming.evaluation.Alarm.acknowledge(Alarm.java:683)

at com.inductiveautomation.ignition.gateway.alarming.status.AlarmStateModel.acknowledge(AlarmStateModel.java:451)

at com.inductiveautomation.ignition.gateway.alarming.AlarmManagerImpl.acknowledge(AlarmManagerImpl.java:410)

at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.Alarming.acknowledge(Alarming.java:105)

at jdk.internal.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.base/java.lang.reflect.Method.invoke(Unknown Source)

at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:225)

at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:414)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:86)

at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1391)

Any ideas how to rectify this?

Thanks

Frank

2

It means either your DB isn’t keeping up with your store and forward load, or you have generated enough quarantine items to leave no room for bursts. Look in your logs for DB errors.

3

I have checked the quarantine status on the gateway, there are no quarantined items.

4

And no other DB errors?

5
DatabaseJournal 10Aug2020 22:18:13 Error logging alarm event to the database.
RealtimeState 10Aug2020 22:18:13 Task queue has exceeded its allowed length. No further tasks will be stored until a full state restore is performed.
DatasourceAuditProfile 10Aug2020 22:16:38 Error auditing [DefaultAuditRecord[action=“tag write”, actionTarget="[BatchTags]Batch/AlarmAckBit", actionValue=“1”, actor=“acsiuser”, actorHost=“USCHI1AS2021”, context=“4”, system=“sys:Ignition-GerresheimerCH:/project:GerresheimerCH”, status=“AuditStatus[0x00000000, Severity=Good, Subcode=NotSpecified]”, timestamp=“Mon Aug 10 22:16:38 CDT 2020”]], due to underlying exception.

These were the only other items i could find.

6

Has your DB logged errors of its own?

7

SQLLog.txt (63.7 KB)

Nothing in my SQL log looks suspicious.

Thanks,

Frank