Trying to use a previously finished transaction. Invalid transaction found

[adelatorre]

Help!

Our Plastic Server was frozen earlier today, so we restarted the service (windows), but now no one can commit any changes.

The UI gives the error The operation can't be commited, and it was cancelled.

Looking at the loader.log.txt I see the following error over and over again:

2011-11-10 13:03:49,111 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 INFO UpdatePerf - Checkout initial security check [0] ms

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 INFO UpdatePerf - Checkout operation [1141] ms

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 INFO UpdatePerf - Checkout final security check [0] ms

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 INFO Operations - Commit repository transaction 7a8cd1bd-d6f0-4ee3-9aab-f12333345358

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 INFO Transaction - ORPHAN TRANSACTION FOUND!!!!!! ID = 7a8cd1bd-d6f0-4ee3-9aab-f12333345358

2011-11-10 13:03:50,252 5148 ERROR Operations - OnError catching exception A previous operation was not properly finished. Please, try again.

at aal.a(Guid A_0, Boolean A_1)

at aal.d(Guid A_0)

at Codice.CM.Data.SQLTransactionManager.CommitTransaction(Guid TransactionId)

at Codice.CM.Server.TransactionManager.e(Guid A_0)

at Codice.CM.Server.TransactionManager.CommitExplicitTransaction(Guid trId)

at Codice.CM.Server.RepositoryHandler.RepCommitTransaction(Guid trId)

at Codice.CM.Server.SecuredRepositoryHandler.RepCommitTransaction(Guid trId)

at Codice.CM.Server.TransactionInterceptor.RepCommitTransaction(Guid trId)

2011-11-10 13:03:50,252 5148 ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:A previous operation was not properly finished. Please, try again.

at aal.a(Guid A_0, Boolean A_1)

at aal.d(Guid A_0)

at Codice.CM.Data.SQLTransactionManager.CommitTransaction(Guid TransactionId)

at Codice.CM.Server.TransactionManager.e(Guid A_0)

at Codice.CM.Server.TransactionManager.CommitExplicitTransaction(Guid trId)

at Codice.CM.Server.RepositoryHandler.RepCommitTransaction(Guid trId)

at Codice.CM.Server.SecuredRepositoryHandler.RepCommitTransaction(Guid trId)

at Codice.CM.Server.TransactionInterceptor.RepCommitTransaction(Guid trId)

at Codice.CM.Server.TriggerInterceptor.RepCommitTransaction(Guid trId)

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 INFO Operations - Rollback repository transaction 7a8cd1bd-d6f0-4ee3-9aab-f12333345358

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 ERROR Transaction - Trying to use a previously finished transaction 7a8cd1bd-d6f0-4ee3-9aab-f12333345358

2011-11-10 13:03:50,252 5148 gus 7a8cd1bd-d6f0-4ee3-9aab-f12333345358 SFOW325410 ERROR Operations - OnError catching exception Trying to use a previously finished transaction. Invalid transaction found 7a8cd1bd-d6f0-4ee3-9aab-f12333345358. Aborting operation

at Codice.CM.Server.TransactionManager.CheckValidTransaction(Guid TransactionId)

at Codice.CM.Server.TransactionManager.RollbackExplicitTransaction(Guid trId)

at Codice.CM.Server.RepositoryHandler.RepRollbackTransaction(Guid trId)

at Codice.CM.Server.SecuredRepositoryHandler.RepRollbackTransaction(Guid trId)

at Codice.CM.Server.TransactionInterceptor.RepRollbackTransaction(Guid trId)

2011-11-10 13:03:50,252 5148 ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:Trying to use a previously finished transaction. Invalid transaction found 7a8cd1bd-d6f0-4ee3-9aab-f12333345358. Aborting operation

at Codice.CM.Server.TransactionManager.CheckValidTransaction(Guid TransactionId)

at Codice.CM.Server.TransactionManager.RollbackExplicitTransaction(Guid trId)

at Codice.CM.Server.RepositoryHandler.RepRollbackTransaction(Guid trId)

at Codice.CM.Server.SecuredRepositoryHandler.RepRollbackTransaction(Guid trId)

at Codice.CM.Server.TransactionInterceptor.RepRollbackTransaction(Guid trId)

at Codice.CM.Server.TriggerInterceptor.RepRollbackTransaction(Guid trId)

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

[adelatorre]

Apparently the DB just needed some time to unwind the transaction or something. I restarted the service a few hours later and now everything is working again.