[JBoss JIRA] Created: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
5:55 a.m.
org.hibernate.NonUniqueResultException when task completion results in the assignment of a
subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:57 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Nils Preusker updated JBPM-2607:
--------------------------------
Attachment: MultipleTasksTest.java
Attaching a unit test to reproduce the exception
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Attachments: MultipleTasksTest.java
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:59 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Nils Preusker updated JBPM-2607:
--------------------------------
Attachment: process.jpdl.xml
Attaching the process definition to reproduce the exception
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:31 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Joram Barrez updated JBPM-2607:
-------------------------------
Fix Version/s: jBPM 4.x
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Fix For: jBPM 4.x
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:37 a.m.
New subject: [JBoss JIRA] Assigned: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Joram Barrez reassigned JBPM-2607:
----------------------------------
Assignee: Joram Barrez
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Joram Barrez
Fix For: jBPM 4.x
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:37 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Joram Barrez commented on JBPM-2607:
------------------------------------
Nils: first of all thanks for the great test case, this really helps us to find the
problem quicker.
I've ivestigated the cause and you are right. This is what happens:
taskService.completeTask(task2)
--> CompleteTaskCmd
--> task.complete
--> execution.signal
---> MailListener.notify
--> task.delete
So the problem is that the delete is happening after the execution has been signalled to
continue (and calling the MailListener as a consequence).
At that point the first task is not yet delete (happens after the complete).
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Fix For: jBPM 4.x
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:39 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Joram Barrez updated JBPM-2607:
-------------------------------
Fix Version/s: jBPM 4.3
(was: jBPM 4.x)
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Joram Barrez
Fix For: jBPM 4.3
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:10 a.m.
New subject: [JBoss JIRA] Assigned: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Tom Baeyens reassigned JBPM-2607:
---------------------------------
Assignee: Tom Baeyens (was: Joram Barrez)
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Tom Baeyens
Fix For: jBPM 4.3
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:22 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2607:
------------------------------
Fix Version/s: jBPM 4.4
(was: jBPM 4.3)
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Tom Baeyens
Fix For: jBPM 4.4
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:08 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2607:
------------------------------
Assignee: Koen Aers (was: Tom Baeyens)
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Koen Aers
Fix For: jBPM 4.4
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:04 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2607:
-----------------------------------
koen, if solving this requires more then the proposed change of a few lines, sync with me
about it. also make sure that you put the issue number correctly in all commit comments
for easy traceability. and sync with me after you've committed. i want to review the
fix for this issue.
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Koen Aers
Fix For: jBPM 4.4
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:24 p.m.
New subject: [JBoss JIRA] Resolved: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
[
https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plug...
]
Koen Aers resolved JBPM-2607.
-----------------------------
Resolution: Done
I added the testcase to the source tree but could not reproduce the error (anymore). I
verified the implementation of task.complete() and the sequence seems to be fixed by Tom
in the meantime (changeset 6101: http://fisheye.jboss.org/changelog/JbpmSvn?cs=6101).
org.hibernate.NonUniqueResultException when task completion results
in the assignment of a subsequent task to the same user
---------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2607
URL: https://jira.jboss.org/jira/browse/JBPM-2607
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.1
Environment: OS: Mac OS X 10.6
java version "1.6.0_15"
Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
DB: MySQL 5 and HSQL
Reporter: Nils Preusker
Assignee: Koen Aers
Fix For: jBPM 4.4
Attachments: MultipleTasksTest.java, process.jpdl.xml
The exception occurs when two subsequent tasks are both assigned to the same person and
the second task contains a notification node. When the first task is completed, the
MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn
queries the database for tasks by execution. I'm not sure if accidentally two
instances of the same task are inserted into the database or if the previous task is not
yet removed, but the query apparently returns two results, so the
"uniqueResult()" call throws a NonUniqueResultException.
(See attached process and unit test for details, this can also be found in the forum at
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5924
days inactive
6013
days old
11 comments
4 participants
participants (4)
-
Joram Barrez (JIRA) -
Koen Aers (JIRA)
-
Nils Preusker (JIRA)
-
Tom Baeyens (JIRA)