Problems adding nodes during discovery

Description

2011-02-03 16:27:26,666 WARN [scanExecutor-4] JDBCExceptionReporter: SQL Error: 0, SQLState: P0001
2011-02-03 16:27:26,667 ERROR [scanExecutor-4] JDBCExceptionReporter: ERROR: IfServices Trigger Exception, Condition 5: IpInterface found for ipInterfaceId: 185 has 0.0.0.0 ipAdd
r
2011-02-03 16:27:26,667 ERROR [scanExecutor-4] AbstractFlushingEventListener: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [org.opennms.netmgt.model.OnmsMonitoredService]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:375)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy66.addMonitoredService(Unknown Source)
at org.opennms.netmgt.provision.service.IpInterfaceScan$1$2.run(IpInterfaceScan.java:149)
at org.opennms.core.tasks.TaskBuilder$1.run(TaskBuilder.java:150)
at org.opennms.core.tasks.SyncTask.run(SyncTask.java:92)
at org.opennms.core.tasks.SyncTask$1.run(SyncTask.java:103)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)

Environment

Clean install of current 1.8.git, added 4 ranges of IPs for discovery

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Matt Brozowski July 6, 2011 at 5:16 PM

Ok.. This should now be fixed in revision 2c1e6d13438952862e927e1407b003f683eb158e

Seth Leger June 28, 2011 at 11:16 AM

This could be a possible "upsert" issue (where the system needs to safely decide between inserting a new row or updating an existing row). Matt has been working on this for inclusion in 1.10.

Benjamin Reed February 3, 2011 at 2:06 PM

Sorry about that, had 2 bugs open, moved the wrong one. winking face

Fixed

Details

Assignee

Reporter

Fix versions

Affects versions

Priority

PagerDuty

Created February 3, 2011 at 10:32 AM
Updated January 27, 2017 at 4:21 PM
Resolved July 6, 2011 at 5:16 PM

Flag notifications