'Re: [opennms-discuss] exceptions in output.log'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opennms-discuss
Subject:    Re: [opennms-discuss] exceptions in output.log
From:       Stephen Hillier <shillier () halogensoftware ! com>
Date:       2009-01-27 19:17:38
Message-ID: 891DC8A475C92943B8F5E6784A1D8E2107287F7B1C () CAOTWPMXHUB1 ! halogen ! local
[Download RAW message or body]

As per your post:

Exception in thread "Thread-18716" \
                org.springframework.dao.InvalidDataAccessResourceUsageException: \
                could not insert:
.
.
.
Caused by: org.postgresql.util.PSQLException: FEHLER: duplizierter Schl�ssel \
verletzt Unique-Constraint �node_foreign_unique_idx�

If you read the error log, you can see the problem is the foreign ID not being \
unique. Just my take on the errors itself. Is this an imported provisioning group?

Steve.

-----Original Message-----
From: PENZ Robert [mailto:ROBERT.PENZ@TIROL.GV.AT]
Sent: Tuesday, January 27, 2009 4:15 AM
To: General OpenNMS Discussion
Subject: [opennms-discuss] exceptions in output.log

Hi!


I have following entries in /var/log/opennms/daemon/output.log. I'm running \
opennms-1.6.2 on rhel5. Should I be concerned?


Exception in thread "Thread-18716" \
org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: \
[org.opennms.netmgt.model.OnmsNode]; nested exception is \
org.hibernate.exception.DataException: could not insert: \
[org.opennms.netmgt.model.OnmsNode] Caused by: org.hibernate.exception.DataException: \
                could not insert: [org.opennms.netmgt.model.OnmsNode]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
                
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
                
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
  at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
                
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
                
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
                
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
                
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:139)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager.persistToDatabase(ImportOperationsManager.java:277)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager.persistOperation(ImportOperationsManager.java:247)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager$2.run(ImportOperationsManager.java:236)
                
        at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: FEHLER: Wert zu lang f�r Typ \
                character varying(64)
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
                
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
                
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
                
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
                
        at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
                
        ... 19 more
Exception in thread "Thread-18717" \
org.springframework.dao.DataIntegrityViolationException: could not insert: \
[org.opennms.netmgt.model.OnmsNode]; nested exception is \
org.hibernate.exception.ConstraintViolationException: could not insert: \
[org.opennms.netmgt.model.OnmsNode] Caused by: \
org.hibernate.exception.ConstraintViolationException: could not insert: \
                [org.opennms.netmgt.model.OnmsNode]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
                
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
                
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
  at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
                
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
                
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
                
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
                
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:139)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager.persistToDatabase(ImportOperationsManager.java:277)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager.persistOperation(ImportOperationsManager.java:247)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager$2.run(ImportOperationsManager.java:236)
                
        at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: FEHLER: duplizierter Schl�ssel \
                verletzt Unique-Constraint �node_foreign_unique_idx�
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
                
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
                
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
                
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
                
        at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
                
        ... 19 more
Exception in thread "Thread-19544" \
org.springframework.dao.DataIntegrityViolationException: could not insert: \
[org.opennms.netmgt.model.OnmsNode]; nested exception is \
org.hibernate.exception.ConstraintViolationException: could not insert: \
[org.opennms.netmgt.model.OnmsNode] Caused by: \
org.hibernate.exception.ConstraintViolationException: could not insert: \
                [org.opennms.netmgt.model.OnmsNode]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
                
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
                
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
  at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
                
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
                
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
                
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
                
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:139)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager.persistToDatabase(ImportOperationsManager.java:277)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager.persistOperation(ImportOperationsManager.java:247)
                
        at org.opennms.netmgt.importer.operations.ImportOperationsManager$2.run(ImportOperationsManager.java:236)
                
        at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: FEHLER: duplizierter Schl�ssel \
                verletzt Unique-Constraint �node_foreign_unique_idx�
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
                
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
                
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
                
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
                
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
                
        at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
                
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
                
        ... 19 more



Mit freundlichen Grüßen
Robert Penz

----------------------------------------------------
Dipl. Inf. Robert Penz
DVT-Daten-Verarbeitung-Tirol GmbH
Adamgasse 22, 6020 Innsbruck
Tel: +43 512 508 3334 / Fax: +43 512 508 3355
eMail: robert.penz@tirol.gv.at

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic