Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-7585

Pollerd attempts to create duplicate outages

    XMLWordPrintable

    Details

      Description

      Pollerd threads can fail with the following exception, even with the fix for NMS-7519 applied:

      Exception in thread "Poller-Thread-347-of-500" Exception in thread "Poller-Thread-379-of-500" org.springframework.dao.DataIntegrityViolationException: could not insert: [org.opennms.netmgt.model.OnmsOutage]; SQL [insert into outages (ifLostService, ifRegainedService, ifserviceId, svcLostEventId, svcRegainedEventId, suppressTime, suppressedBy, outageId) values (?, ?, ?, ?, ?, ?, ?, ?)]; constraint [one_outstanding_outage_per_service_idx]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [org.opennms.netmgt.model.OnmsOutage]
      at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
      at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412)
      at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375)
      at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:738)
      at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.saveOrUpdate(AbstractDaoHibernate.java:410)
      at org.opennms.netmgt.poller.QueryManagerDaoImpl.openOutagePendingLostEventId(QueryManagerDaoImpl.java:116)
      at org.opennms.netmgt.poller.DefaultPollContext.openOutage(DefaultPollContext.java:303)
      at org.opennms.netmgt.poller.pollables.PollableService.createOutage(PollableService.java:272)

        Attachments

          Activity

            People

            • Assignee:
              j-white Jesse White
              Reporter:
              j-white Jesse White
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: