High Utilization in ZCM Primary server, logs shows loop in Loader.Status Storer Module

  • 3725413
  • 30-Mar-2008
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management

Situation

Within the loader.messages.log we can see there seems to be a loop within Loader.Status Storer Module - About to save StatusData, the same objectUID, targetDeviceUID and targetUserUID are shown followed by a Java exception.
ERROR: "[DEBUG] [01/11/07 17:16:00] [] [Loader.Status Storer Module] [Failed to save status data because of Exception: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]] [Failed to save status data because of Exception: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]] [] []"

Resolution

This is fixed in version 10.0.2 - see KB 3486285 "Updates to ZENworks 10 Configuration Management" which can be found athttps://www.novell.com/support

Additional Information

For other possible causes of high utilization, see TID 3389520"High utilization on ZCM server"

Extract from loader-messages.log with logging set to debug level (SeeTID 3418069"Enable debug logging for ZENworks 10 Configuration Management" athttp://novell.com/support)
[DEBUG] [01/11/07 17:16:00] [] [Loader.Status Storer Module] [Failed to save status data because of Exception: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]] [Failed to save status data because of Exception: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]] [] []
[DEBUG] [01/11/07 17:16:00] [] [Loader.Status Storer Module] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleSave(HibernateBasicSession.java:895)
at com.novell.zenworks.datamodel.services.status.StatusImpl.saveStatusEvent(StatusImpl.java:310)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.processStatus(StatusStorerModule.java:211)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
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:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zObjectInfo_objectUID". The conflict occurred in database "zenworks_ZONE", table"dbo.zZENObject", column 'UID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
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:2120)
... 18 more
] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleSave(HibernateBasicSession.java:895)
at com.novell.zenworks.datamodel.services.status.StatusImpl.saveStatusEvent(StatusImpl.java:310)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.processStatus(StatusStorerModule.java:211)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
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:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zObjectInfo_objectUID". The conflict occurred in database "zenworks_ZONE", table"dbo.zZENObject", column 'UID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
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:2120)
... 18 more
] [] []