Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

query did not return a unique result: 12 Exception in EnhancedLink bridge discovery

Description

Exception in thread "Scheduler-Thread-6-of-5" org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 12; nested exception is org.hibernate.NonUniqueResultException: query did not return a unique result: 12
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:659)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:198)
at org.opennms.netmgt.dao.hibernate.BridgeElementDaoHibernate.getByNodeIdVlan(BridgeElementDaoHibernate.java:65)
at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$5.query(EnhancedLinkdServiceImpl.java:473)
at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$5.query(EnhancedLinkdServiceImpl.java:469)
at org.opennms.netmgt.dao.support.UpsertTemplate.doUpsert(UpsertTemplate.java:157)
at org.opennms.netmgt.dao.support.UpsertTemplate.access$000(UpsertTemplate.java:123)
at org.opennms.netmgt.dao.support.UpsertTemplate$1.doInTransaction(UpsertTemplate.java:147)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
at org.opennms.netmgt.dao.support.UpsertTemplate.execute(UpsertTemplate.java:143)
at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl.saveBridgeElement(EnhancedLinkdServiceImpl.java:469)
at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl.store(EnhancedLinkdServiceImpl.java:464)
at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$$FastClassByCGLIB$$fe4d2451.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:627)
at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$$EnhancerByCGLIB$$96ccf8d6.store(<generated>)
at org.opennms.netmgt.enlinkd.NodeDiscoveryBridge.walkDot1d(NodeDiscoveryBridge.java:225)
at org.opennms.netmgt.enlinkd.NodeDiscoveryBridge.runCollection(NodeDiscoveryBridge.java:95)
at org.opennms.netmgt.enlinkd.NodeDiscovery.run(NodeDiscovery.java:121)
at org.opennms.netmgt.linkd.scheduler.Scheduler$1.run(Scheduler.java:209)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.opennms.core.concurrent.LogPreservingThreadFactory$3.run(LogPreservingThreadFactory.java:124)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 12
at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:193)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Antonio Russo September 27, 2014 at 8:20 AM

Resolved in junos/14.1

MacBook-Pro-di-Antonio-Russo:opennms antonio$ git push
Counting objects: 205, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (24/24), done.
Writing objects: 100% (31/31), 5.08 KiB | 0 bytes/s, done.
Total 31 (delta 12), reused 0 (delta 0)
To git@github.com:OpenNMS/opennms.git
a05f07b..8c4b61f space/14.1 -> space/14.1

commit 8c4b61f36c680cc370571c1765827a62097d759d
Author: Antonio <rssntn67@yahoo.it>
Date: Sat Sep 27 14:17:37 2014 +0200

Fix for https://opennms.atlassian.net/browse/NMS-6909#icft=NMS-6909: NonUniqueResultException BridgeDiscovery

Matt Brozowski September 26, 2014 at 2:06 PM
Edited

I got exactly the same exception running on my own machine in the office:

Exception in thread "Scheduler-Thread-3-of-5" org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 12; nested exception is org.hibernate.NonUniqueResultException: query did not return a unique result: 12 at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:659) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:198) at org.opennms.netmgt.dao.hibernate.BridgeElementDaoHibernate.getByNodeIdVlan(BridgeElementDaoHibernate.java:65) at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$5.query(EnhancedLinkdServiceImpl.java:473) at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$5.query(EnhancedLinkdServiceImpl.java:469) at org.opennms.netmgt.dao.support.UpsertTemplate.doUpsert(UpsertTemplate.java:157) at org.opennms.netmgt.dao.support.UpsertTemplate.access$000(UpsertTemplate.java:123) at org.opennms.netmgt.dao.support.UpsertTemplate$1.doInTransaction(UpsertTemplate.java:147) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131) at org.opennms.netmgt.dao.support.UpsertTemplate.execute(UpsertTemplate.java:143) at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl.saveBridgeElement(EnhancedLinkdServiceImpl.java:469) at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl.store(EnhancedLinkdServiceImpl.java:464) at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$$FastClassByCGLIB$$fe4d2451.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:627) at org.opennms.netmgt.enlinkd.EnhancedLinkdServiceImpl$$EnhancerByCGLIB$$9f163303.store(<generated>) at org.opennms.netmgt.enlinkd.NodeDiscoveryBridge.walkDot1d(NodeDiscoveryBridge.java:225) at org.opennms.netmgt.enlinkd.NodeDiscoveryBridge.runCollection(NodeDiscoveryBridge.java:95) at org.opennms.netmgt.enlinkd.NodeDiscovery.run(NodeDiscovery.java:121) at org.opennms.netmgt.linkd.scheduler.Scheduler$1.run(Scheduler.java:209) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.opennms.core.concurrent.LogPreservingThreadFactory$3.run(LogPreservingThreadFactory.java:124) at java.lang.Thread.run(Thread.java:744) Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 12 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:193) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 24 more
Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

PagerDuty

Created September 25, 2014 at 11:31 AM
Updated September 27, 2014 at 12:17 PM
Resolved September 27, 2014 at 8:20 AM

Flag notifications