Environment
Novell ZENworks Configuration Management 11 Database
Novell ZENworks Configuration Management 11.1 Database
Novell ZENworks Configuration Management 11.2 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)
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