[jboss-user] [jBPM] - Re: JBPM 3.2.5, MSSQL 2005 - blocking in JBPM_JOB table
Alejandro Guizar [http://community.jboss.org/people/alex.guizar%40jboss.com] created the
discussion
"Re: JBPM 3.2.5,MSSQL 2005 - blocking in JBPM_JOB table"
To view the discussion, visit: http://community.jboss.org/message/563018#563018
--------------------------------------------------------------
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 ?
You mentioned earlier that removing all the indexes in the jbpm_job table greatly
reduces blocking issues. Are these numbers produced without indexes? Do you believe the
engine would be better off without them? What about Oracle, does it perform better or
worse without indexes in the job table? At some point we
https://jira.jboss.org/browse/JBPM-2094 added indexes to other tables because Oracle
deadlocked without them.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/563018#563018]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
Attachments:
- attachment.html (text/html — 3.9 KB)