OpenNMS

Occasional exception when adding a path outage

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.3.11
  • Fix Version/s: Backlog
  • Component/s: Service Polling/Outages
  • Security Level: Default (Default Security Scheme)
  • Labels:
    None
  • Environment:
    Operating System: All
    Platform: All
  • Bugzilla Id:
    2299

Description

Occasionally when adding a path outage the exception

SetCriticalPathServlet: Error writing to database.org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "pathoutage_nodeid"
at org.opennms.web.admin.nodeManagement.SetCriticalPathServlet.doPost(SetCriticalPathServlet.java:87)

occurs. The path outage _is_ correctly added despite this.

I have not seen this occur when changing the critical IP for a node, only when adding a new one, however I do have not changed a critical IP very often.

An unclean database could be the cause of this; the database has been upgraded from 1.3.2 to 1.3.7 to 1.3.10 to 1.3.11, and possibly one or two others before 1.3.7.

Issue Links

blocks

Bug - A problem which impairs or prevents the functions of the product. NMS-2497 Tracking Ticket for OpenNMS 1.5.92 (blocker for 1.6)

  • Blocker - Blocks development and/or testing work, production could not run.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

Hide
Permalink
Omni Flux added a comment -

This seems to be related to the critical IP address. If the exception occurs while adding a path outage, it appears to happen on any other path outages with the same critical IP address. If the exception does not occur while adding a path outage, I have not seen the exception occur while adding additional path outages with the same critical IP address.

Show
Omni Flux added a comment - This seems to be related to the critical IP address. If the exception occurs while adding a path outage, it appears to happen on any other path outages with the same critical IP address. If the exception does not occur while adding a path outage, I have not seen the exception occur while adding additional path outages with the same critical IP address.

People

  • Assignee:
    Matt Brozowski
    Reporter:
    Omni Flux
Vote (0)
Watch (0)

Dates

  • Created:
    Updated: