12:53 a.m.
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/563437#563437
--------------------------------------------------------------
Looking at how the jbpm_job table is utilized, yes, I think these
specific indexes can be removed. Just to clarify. From what I have seen in *our
use-case*, under normal circumstances the jbpm_job table has very few entries at any point
in time. Seems like entries are added and removed constantly. That being the case, I'm
not sure I can see a benefit of spending the extra time/resources maintaining indexes
which are never utilized.
I'm going to explore the possibility of removing the
job indexes. Can you please https://jira.jboss.org/browse/JBPM create a JIRA issue for
this?
By the way, this is as good a time to explain the use-case that is
failing for us. We have a workflow with three steps synchronous steps. The first step
takes a couple to a few hundred milliseconds to complete, the second step can take
anywhere from 5 to 30 seconds to complete and then the last step usually takes a half a
second. When I mentioned jobs earlier, I was referring to workflows contained the three
steps just mentioned.
If possible, could you attach your workflow and test harness
to the JIRA issue? Please remove any sensitive information you would not like to see
published.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/563437#563437]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
10:29 p.m.
Sash K [http://community.jboss.org/people/swishey] 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/567033#567033
--------------------------------------------------------------
Found a solution that works if you are using mssql 2005 and above. Can allow snapshot on
mssql to make it behave more like oracle. The following two statements should do the
trick:
* ALTER DATABASE YOUR_DB_NAME SET ALLOW_SNAPSHOT_ISOLATION ON;
* ALTER DATABASE YOUR_DB_NAME SET READ_COMMITTED_SNAPSHOT ON;
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/567033#567033]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
12:36 p.m.
Yuriy R [http://community.jboss.org/people/yrachek] 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/637686#637686
--------------------------------------------------------------
But can we set only JBPM isolation level to READ_COMMITTED_SNAPSHOT ?
Not whole DB but only JBPM.
Did you try this ?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/637686#637686]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4532
days inactive
4957
days old
2 comments
3 participants
participants (3)
-
Alejandro Guizar -
Sash K
-
Yuriy R