You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Alex Boisvert (JIRA)" <ji...@apache.org> on 2008/12/11 20:10:44 UTC
[jira] Created: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Improve InstanceManagement.listInstancesSummary() to include failure information
--------------------------------------------------------------------------------
Key: ODE-460
URL: https://issues.apache.org/jira/browse/ODE-460
Project: ODE
Issue Type: Improvement
Components: Management API
Reporter: Alex Boisvert
Fix For: 1.3
Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: ode-460.1x.patch
Patch file attached.
1. For hibernate DAO, the basic form of query is:
select count(*), last_failed_date from instance where failed_count > 0
2. For OpenJPA DAO, the basic form of query is:
select count(*), last_failed_date from instance where exists(select * from activity_recovery where instance.id = activity_recovery.instance_id)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Alex Boisvert (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex Boisvert updated ODE-460:
------------------------------
Fix Version/s: (was: 1.3.3)
1.3.4
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3.4
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Alex Boisvert (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12656769#action_12656769 ]
Alex Boisvert commented on ODE-460:
-----------------------------------
Patch applied to 1.x branch. Thanks!
boisvert@boog:~/svn/ode/1.1$ svn commit -m "ODE-460: Improve InstanceManagement.listInstancesSummary() to include failure information"
Sending bpel-dao/src/main/java/org/apache/ode/bpel/dao/BpelDAOConnection.java
Sending bpel-runtime/src/main/java/org/apache/ode/bpel/engine/ProcessAndInstanceManagementImpl.java
Sending bpel-runtime/src/main/java/org/apache/ode/bpel/memdao/BpelDAOConnectionImpl.java
Sending dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java
Sending dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HProcessInstance.java
Sending dao-jpa/src/main/java/org/apache/ode/dao/jpa/ActivityRecoveryDAOImpl.java
Sending dao-jpa/src/main/java/org/apache/ode/dao/jpa/BPELDAOConnectionImpl.java
Sending dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java
Transmitting file data ........
Committed revision 726820.
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: (was: ode-460.1x.patch)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: ode-460.1x.patch
Attached third retry:
The counts of activity recoveries are pre-fetched on the activity recovery member variable on the process instances.
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: ode-460.1x.patch
New patch attached with performance improvement on fault select in the ProcessAndInstanceManagementImp.listInstancesSummary(); the faults are eager loaded when selecting the instances. There is only one fault at most per process, so joining them together is not bad.
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (ODE-460) [1.x] Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Tammo van Lessen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tammo van Lessen resolved ODE-460.
----------------------------------
Resolution: Fixed
> [1.x] Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3.4
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: (was: ode-460.1x.patch)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: ode-460.1x.patch
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: (was: ode-460.1x.patch)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: (was: ode-460.1x.patch)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: ode-460.1x.patch
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: ode-460.1x.patch
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655893#action_12655893 ]
seanahn edited comment on ODE-460 at 12/12/08 5:20 PM:
--------------------------------------------------------
Patch file attached.
1. For hibernate DAO, the basic form of query is:
select count(*), max(last_failed_date) from instance where failed_count > 0
2. For OpenJPA DAO, the basic form of query is:
select count(*), max(last_failed_date) from instance where exists(select * from activity_recovery where instance.id = activity_recovery.instance_id)
was (Author: seanahn):
Patch file attached.
1. For hibernate DAO, the basic form of query is:
select count(*), last_failed_date from instance where failed_count > 0
2. For OpenJPA DAO, the basic form of query is:
select count(*), last_failed_date from instance where exists(select * from activity_recovery where instance.id = activity_recovery.instance_id)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Sean Ahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Ahn updated ODE-460:
-------------------------
Attachment: (was: ode-460.1x.patch)
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) [1.x] Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Tammo van Lessen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tammo van Lessen updated ODE-460:
---------------------------------
Summary: [1.x] Improve InstanceManagement.listInstancesSummary() to include failure information (was: Improve InstanceManagement.listInstancesSummary() to include failure information)
> [1.x] Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3.4
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Alex Boisvert (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655747#action_12655747 ]
Alex Boisvert commented on ODE-460:
-----------------------------------
Also, as part of this improvement, improve ProcessAndInstanceManagementImpl.getInstanceSummaryActivityFailure() which is hugely inefficient... it loads all active instances in memory....
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-460) Improve
InstanceManagement.listInstancesSummary() to include failure information
Posted by "Alexis Midon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexis Midon updated ODE-460:
-----------------------------
Fix Version/s: (was: 1.3.1)
1.3.2
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
> Key: ODE-460
> URL: https://issues.apache.org/jira/browse/ODE-460
> Project: ODE
> Issue Type: Improvement
> Components: Management API
> Reporter: Alex Boisvert
> Fix For: 1.3.2
>
> Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.