JBoss Community

Re: JBPM 3.2.5,MSSQL 2005 - blocking in JBPM_JOB table

created by Sash K in jBPM - View the full discussion

Upgraded to jbpm 3.2.9.  The situation improved somewhat, but still having serious blocking issues.   Before the upgrade over 200 jobs would create blocking issues in mssql server, after upgrade can safely do 500 jobs.  Going to 1000 jobs creates blocking issues, freezing processing for many hours.   On oracle there are no blocking issues, but that was to be expected since oracle does not block.   Upgraded to mssql 2008 as well, but also as expected, did not solve the issue.   Is there some specific information I can provide that would help in troubleshooting ?  

 

Thank you.

Reply to this message by going to Community

Start a new discussion in jBPM at Community