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

Exception in LatencyStoringServiceMonitorAdaptor: IncorrectResultSizeDataAccessException

    Details

      Description

      Threshold exception after
      Upgrading from older version 1.8 I got a lot of the following exception

      2016-09-23 15:39:03,942 ERROR [Poller-Thread-33-of-50] o.o.n.p.p.LatencyStoringServiceMonitorAdaptor: Failed to threshold on PollableService [PollableInterface [PollableNode [3942]:172.19.40.222]:ICMP] for icmp because of an exception
      org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2; nested exception is org.hibernate.NonUniqueResultException: query did not return a unique result: 2
      at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:674) ~[org.apache.servicemix.bundles.spring-orm-4.0.5.RELEASE_1.jar:?]
      at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:414) ~[org.apache.servicemix.bundles.spring-orm-4.0.5.RELEASE_1.jar:?]
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:416) ~[org.apache.servicemix.bundles.spring-orm-4.0.5.RELEASE_1.jar:?]
      at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:341) ~[org.apache.servicemix.bundles.spring-orm-4.0.5.RELEASE_1.jar:?]
      at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:203) ~[opennms-dao-17.1.1.jar:?]
      at org.opennms.netmgt.dao.hibernate.SnmpInterfaceDaoHibernate.findByNodeIdAndDescription(SnmpInterfaceDaoHibernate.java:70) ~[opennms-dao-17.1.1.jar:?]
      at org.opennms.netmgt.dao.hibernate.IfLabelDaoImpl.getInterfaceInfoFromIfLabel(IfLabelDaoImpl.java:112) ~[opennms-dao-17.1.1.jar:?]
      at org.opennms.netmgt.threshd.CollectionResourceWrapper.<init>(CollectionResourceWrapper.java:175) ~[opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.threshd.LatencyThresholdingSet.applyThresholds(LatencyThresholdingSet.java:105) ~[opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.LatencyStoringServiceMonitorAdaptor.applyThresholds(LatencyStoringServiceMonitorAdaptor.java:176) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.LatencyStoringServiceMonitorAdaptor.storeResponseTime(LatencyStoringServiceMonitorAdaptor.java:143) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.LatencyStoringServiceMonitorAdaptor.poll(LatencyStoringServiceMonitorAdaptor.java:118) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableServiceConfig.poll(PollableServiceConfig.java:119) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableService.poll(PollableService.java:191) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.poll(PollableElement.java:293) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableContainer$5.run(PollableContainer.java:319) [opennms-services-17.1.1.jar:?]
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_91]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:264) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:250) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:228) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableContainer.poll(PollableContainer.java:326) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableInterface.poll(PollableInterface.java:224) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableContainer$5.run(PollableContainer.java:319) [opennms-services-17.1.1.jar:?]
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_91]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:264) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:250) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:228) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableContainer.poll(PollableContainer.java:326) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableNode$3.run(PollableNode.java:331) [opennms-services-17.1.1.jar:?]
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_91]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:264) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:250) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:228) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableNode.doPoll(PollableNode.java:334) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.doPoll(PollableElement.java:184) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableService.doPoll(PollableService.java:226) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableService$PollRunner.run(PollableService.java:63) [opennms-services-17.1.1.jar:?]
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_91]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:264) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableElement.withTreeLock(PollableElement.java:250) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableService.doRun(PollableService.java:413) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.poller.pollables.PollableService.run(PollableService.java:388) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.scheduler.Schedule.run(Schedule.java:142) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.scheduler.Schedule$ScheduleEntry.run(Schedule.java:86) [opennms-services-17.1.1.jar:?]
      at org.opennms.netmgt.scheduler.LegacyScheduler$1.run(LegacyScheduler.java:209) [opennms-services-17.1.1.jar:?]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_91]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_91]
      at org.opennms.core.concurrent.LogPreservingThreadFactory$3.run(LogPreservingThreadFactory.java:124) [opennms-util-17.1.1.jar:?]
      at java.lang.Thread.run(Thread.java:745) [?:1.8.0_91]
      Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
      at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899) ~[hibernate-core-3.6.10.Final.jar:3.6.10.Final]
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) ~[hibernate-core-3.6.10.Final.jar:3.6.10.Final]
      at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:198) ~[opennms-dao-17.1.1.jar:?]
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) ~[org.apache.servicemix.bundles.spring-orm-4.0.5.RELEASE_1.jar:?]
      ... 46 more

        Attachments

          Activity

            People

            • Assignee:
              rssntn67 Antonio Russo
              Reporter:
              rssntn67 Antonio Russo
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: