Hello Friends,
I am facing Deadlock issue with DataDeploy when runnint concurrent deployments jobs. I did concurrency management setup in odbase.xml but that did solve the issue.
<initiatorProperties completedQueueCapacity="75" serializeDeploymentSetUp="yes" pendSessions="yes">
<serializeDeploymentByTime maxNumberOfDeploymentQueues="200" maxDeploymentQueueLength="200"/>
</initiatorProperties>
Is anyone faced this kind of issue earlier?
Below is the exception log:
DBD: SQLException occured in TDbSchemaGroupInfoNode
DBD: Exception Message: ORA-00060: deadlock detected while waiting for resource
DBD: Vendor Error Code: 60
DBD: SQL state: 61000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.DoDelete(TDbSchemaGroupInfoNode.java:762)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.DeleteUsingGroupTree(TDbSchemaGroupInfo.java:469)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.DoDelete(TDbSchemaGroupInfo.java:216)
at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingRootPrimaryKeys(TDbSchemaCfg.java:795)
at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingDelTracker(TDbSchemaCfg.java:818)
at com.interwoven.dd100.dd.TDbSchemaCfg.Delete(TDbSchemaCfg.java:576)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:450)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1083)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:637)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:594)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:539)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:632)
at java.lang.Thread.run(Thread.java:662)
Thanks
