Dead locks while deploying project in BCC

Symptoms :

If there are dead lock issues in BCC while deploying large assets/feeds project either in Staging or Production agents . If it fails after multiple attempts with "java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource" errors in logs, we can try tweaking below configurations to make it successful. (Note: This might solve the issue for temporarily , but you need to look at the error log for exact issue)


Solution:

1. Increase the INITRANS  for the affected table (will get the table names from the bcc/pub application logs)  

Use this SQL to check current INITRANS value of the table : 

select ini_trans,max_trans from dba_tables where table_name='table_Name';

Increase the value of INITRANS to good number, this can be determined based on the site.  

Also request DBA team to examine the AWR report to detected the high ITL waits on a number of tables.

2. Tweak the default values of the DeploymentManager component for the properties maxThreads, threadBatchSize and transactionBatchSize. 

Option 1:
maxThreads=5 threadBatchSize=5000, transactionBatchSize=5000 

Option 2: (If option 1 did not work then set the max threads to 2, this will take longer time to deploy project, but resolves the deadlock issue)


maxThreads=2 threadBatchSize=5000, transactionBatchSize=5000