Hi,
I have an error with Alarm Journal. When I configure the journal, it creates the tables for the first time and is working fine, but once I add an index to the alarm_events table, the next message is shown in the log.
E [a.J.DatabaseJournal ] [12:56:25.723]: Alarm journal initialization failed. Will try again in 60 seconds. journal=alrj_xxxxxx
INFO | jvm 1 | 2025/06/28 12:56:25 | java.lang.Exception: Error running query: CREATE TABLE alarm_events ("id" SERIAL NOT NULL,"eventid" varchar(255),"source" varchar(255),"displaypath" varchar(255),"priority" int,"eventtype" int,"eventflags" int,"eventtime" timestamp,PRIMARY KEY ("id","eventtime"))
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.executeCommandSet(DBTableSchema.java:140)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.createTable(DBTableSchema.java:109)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.verifyAndUpdate(DBTableSchema.java:91)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.alarming.journal.JournalTables$EventTable.verifyTable(JournalTables.java:59)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.alarming.journal.DatabaseAlarmJournal.verifyTables(DatabaseAlarmJournal.java:175)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.alarming.journal.DatabaseAlarmJournal.tryInit(DatabaseAlarmJournal.java:155)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:550)
INFO | jvm 1 | 2025/06/28 12:56:25 | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
INFO | jvm 1 | 2025/06/28 12:56:25 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
INFO | jvm 1 | 2025/06/28 12:56:25 | at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
INFO | jvm 1 | 2025/06/28 12:56:25 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
INFO | jvm 1 | 2025/06/28 12:56:25 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO | jvm 1 | 2025/06/28 12:56:25 | at java.base/java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2025/06/28 12:56:25 | Caused by: org.postgresql.util.PSQLException: ERROR: la relación «alarm_events» ya existe
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2736)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2423)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:374)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:518)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:435)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:357)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:342)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:318)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:291)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
INFO | jvm 1 | 2025/06/28 12:56:25 | at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeUpdate(DelegatingStatement.java:80)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRStatement.executeUpdate(SRConnectionWrapper.java:867)
INFO | jvm 1 | 2025/06/28 12:56:25 | at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.executeCommandSet(DBTableSchema.java:138)
INFO | jvm 1 | 2025/06/28 12:56:25 | ... 12 common frames omitted
The alarms are inserted inside the table but, every 60 seconds I get a error message inside the log.
Can I disable the table check or the message ?
I'm using Ignition 8.1.48
Thanks