Notifications Fail with IPv6 Addresses

Description

Notifications fail with IPv6 Addresses due to a field size in the database:

nodeID integer,
interfaceID varchar(16),
serviceID integer,

2011-10-11 03:23:18,943 ERROR [Notifd:BroadcastEventProcessor] BroadcastEventProcessor: Failed to enter notification into database, exiting this notification
org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)
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:777)
at org.opennms.netmgt.notifd.BroadcastEventProcessor.scheduleNoticesForEvent(BroadcastEventProcessor.java:590)
at org.opennms.netmgt.notifd.BroadcastEventProcessor.onEvent(BroadcastEventProcessor.java:217)
at org.opennms.netmgt.eventd.EventIpcManagerDefaultImpl$ListenerThread.run(EventIpcManagerDefaultImpl.java:175)
at java.lang.Thread.run(Thread.java:662)

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:
Fixed

Details

Assignee

Reporter

Fix versions

Affects versions

Priority

PagerDuty

Created October 11, 2011 at 8:27 AM
Updated January 27, 2017 at 4:20 PM
Resolved October 11, 2011 at 1:45 PM

Flag notifications