Bug 777552 (SOA-55)

Summary: jBPM - Possible problem in concurrent signalling from multiple threads
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Len DiMaggio <ldimaggi>
Component: JBPM - within SOAAssignee: Jiri Pechanec <jpechane>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 4.2 IR2   
Target Milestone: ---   
Target Release: 4.2 CR3   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-55
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Linux 2.6.21-1.3228.fc7 #1 SMP Tue Jun 12 14:56:37 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux MySQL 5.0.22
Last Closed: 2007-12-05 03:11:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
expl.tar.gz none

Description Len DiMaggio 2007-10-17 14:48:15 UTC
Date of First Response: 2007-11-20 09:22:43
project_key: SOA

Project issue logged in JBPM-1071

Attached is a simple test case that
1) Deploys process definition with two nodes
2) Starts the process instance that will go to the wait state on first node
3) Starts 20 threads that tries concurrently signal the same process instance
4) The second node writes a record to the database

The test case needs to be executed multiple times to see the incorrect behaviour.
This is an example of run output
Isol 8
Action 1
Action 2
Action 2
Action 2
Action 2
Action 2 1
Action 2 1
Action 2 1
Action 2 1
Signalist 5
Signalist 6
Signalist 8
Signalist 12
Signalist 7
Signalist 13
Signalist 14
Signalist 15
Signalist 9
Signalist 16
Signalist 17
Signalist 18
Signalist 4
Success 7
Failure 13

Explanation of the outcome
4 threads successfully executed the node action including database operation. All database opeartion were comitted (4 new records were created)
3 threads successfully executed the signal operation but no real action was performed
13 threads attempted to execute the signal operation but ended with an exception

Comment 1 Len DiMaggio 2007-10-17 14:48:40 UTC
Link: Added: This issue depends JBPM-1071


Comment 2 Len DiMaggio 2007-10-17 15:57:00 UTC
Attachment: Added: expl.tar.gz


Comment 3 Len DiMaggio 2007-11-01 16:39:00 UTC
Link: Added: This issue related SOA-84


Comment 4 Mark Little 2007-11-06 14:27:13 UTC
Link: Added: This issue is a dependency of JBESB-1301


Comment 5 Mark Little 2007-11-20 14:22:43 UTC
Tom to follow up with Jiri.

Comment 6 Tom Baeyens 2007-11-20 14:50:42 UTC
See JBPM-1071

Comment 7 Len DiMaggio 2007-11-28 17:44:56 UTC
Jirka - can you confirm that this problem is/is not reproducible on Windows? The QE lab has Windows systems we can use. Thanks.

Comment 8 Jiri Pechanec 2007-11-29 08:13:24 UTC
I have tried the following configs 
jBPM-win MySQL-win OK 
jBPM-linux MySQL-win OK 
jBPM-win MySQL-linux FAIL 

So the problem is probably related to MySQL on linux

Comment 9 Len DiMaggio 2007-11-30 14:08:03 UTC
Just talking to Jirka - apparently the this problem is MySQL version specific. He's seeing it pass on Linux with 5.0.27 and fail with 5.0.45



Comment 10 Jiri Pechanec 2007-12-03 14:09:54 UTC
Link: Added: This issue related SOA-195


Comment 11 Jiri Pechanec 2007-12-03 14:19:49 UTC
Link: Added: This issue is a dependency of SOA-196


Comment 12 Jiri Pechanec 2007-12-03 14:20:19 UTC
Link: Added: This issue related SOA-196


Comment 13 Jiri Pechanec 2007-12-03 14:21:23 UTC
Temporary solution SOA-195 
Final solution SOA-196

Comment 14 Jiri Pechanec 2007-12-03 14:22:55 UTC
Link: Removed: This issue is a dependency of SOA-196 


Comment 15 Len DiMaggio 2007-12-03 16:35:56 UTC
Current disposition for this JIRA:

* SOA-54 and SOA-55 - Mark these as 'resolved', reopen if made necessary - unlikely - by jBPM rework
 * JBPM-1072, JBPM-1072 - leave these open as they are jBPM issues
* SOA-195 - New JIRA to require SOA-P to document in Release Notes that when jBPM is used then it is not safe to use MySQL on Linux
* SOA-196 - The jBPM does not work with MySQL/Linux combo - mark as fix in 4.3
* JBPM-1095- Project bug for SOA-196


Comment 17 Len DiMaggio 2008-01-08 02:20:38 UTC
Link: Removed: This issue related SOA-84