ZCM database transactions not completing

  • 7003035
  • 05-Apr-2012
  • 03-Jul-2012

Environment

Novell ZENworks Configuration Management 11 Database
Novell ZENworks Configuration Management 11.1 Database
Novell ZENworks Configuration Management 11.2 Database

Situation

Database transactions can be left open and uncommitted.  This will increase the transaction log size as they are tracked until committed.


Example error from loader-messages.log:

[DEBUG] [16/02/12 23:10:49] [] [Loader.PatchSubscriptionService] []
[org.hibernate.AssertionFailure: possible nonthreadsafe access to session
 at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:83)
 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:144)
 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.lumension.PatchManager.saveOrUpdate(PatchManager.java:746)
 at com.novell.zenworks.lumension.PatchSubscriptionService.processAction(PatchSubscriptionService.java:928)
 at com.novell.zenworks.loader.modules.queue.runner.QueueThreadWorker.processAction(QueueThreadWorker.java:212)
 at com.novell.zenworks.loader.modules.queue.runner.QueueThreadWorker.run(QueueThreadWorker.java:143)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
 at java.lang.Thread.run(Thread.java:595)

Resolution

This is fixed in version 11.2.1 - see KB 7010042 "ZENworks Configuration Management 11.21 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7010042