[opennms-discuss] No notifications send, db issue

[Bart v. d. H. <ba...@zo...>]

Hello,

We have a OpenNMS setup that is not sending out notifications, in the log
there is a error mentioning a update error based on a foreign key
constraint. I don't know what insert query is done so it's a bit hard to
troubleshoot. There has not been any new record in the notification table
since 2011-07-11 (based on pagetime)

It seems that the notifier is trying to send out information on one or more
events that are not in the event table.

Any idea's?

2011-07-11 11:09:49,906 ERROR [Notifd:BroadcastEventProcessor]
BroadcastEventProcessor: Failed to enter notification into database, exiting
this notification
org.postgresql.util.PSQLException: ERROR: insert or update on table
"notifications" violates foreign key constraint "fk_eventid3"
  Detail: Key (eventid)=(0) is not present in table "events".
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at
org.opennms.netmgt.config.NotificationManager.insertNotice(NotificationManager.java:784)
        at
org.opennms.netmgt.notifd.BroadcastEventProcessor.scheduleNoticesForEvent(BroadcastEventProcessor.java:611)
        at
org.opennms.netmgt.notifd.BroadcastEventProcessor.onEvent(BroadcastEventProcessor.java:239)
        at
org.opennms.netmgt.eventd.EventIpcManagerDefaultImpl$ListenerThread.run(EventIpcManagerDefaultImpl.java:197)
        at java.lang.Thread.run(Thread.java:595)

This is the table discription:

                     Table "public.notifications"
     Column      |           Type           | Modifiers | Description
-----------------+--------------------------+-----------+-------------
 notifyid        | integer                  | not null  |
 textmsg         | text                     | not null  |
 subject         | character varying(256)   |           |
 numericmsg      | character varying(256)   |           |
 pagetime        | timestamp with time zone |           |
 respondtime     | timestamp with time zone |           |
 answeredby      | character varying(256)   |           |
 nodeid          | integer                  |           |
 interfaceid     | character varying(16)    |           |
 serviceid       | integer                  |           |
 queueid         | character varying(256)   |           |
 eventid         | integer                  |           |
 eventuei        | character varying(256)   | not null  |
 notifconfigname | text                     |           |
Indexes:
    "pk_notifyid" PRIMARY KEY, btree (notifyid)
    "notifications_answeredby_idx" btree (answeredby)
    "notifications_eventid_idx" btree (eventid)
    "notifications_eventuei_idx" btree (eventuei)
    "notifications_interfaceid_idx" btree (interfaceid)
    "notifications_nodeid_idx" btree (nodeid)
    "notifications_respondtime_idx" btree (respondtime)
    "notifications_serviceid_idx" btree (serviceid)
Foreign-key constraints:
    "fk_eventid3" FOREIGN KEY (eventid) REFERENCES events(eventid) ON DELETE
CASCADE
    "fk_nodeid7" FOREIGN KEY (nodeid) REFERENCES node(nodeid) ON DELETE
CASCADE
Has OIDs: no