You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "fabio martelli (JIRA)" <ji...@apache.org> on 2012/09/05 12:10:07 UTC

[jira] [Created] (SYNCOPE-202) MySQL and Oracle integration test hangs

fabio martelli created SYNCOPE-202:
--------------------------------------

             Summary: MySQL and Oracle integration test hangs
                 Key: SYNCOPE-202
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
             Project: Syncope
          Issue Type: Bug
          Components: core
    Affects Versions: 1.1.0-incubating, 1.0.2-incubating
         Environment: executing integration tests via
mvn -Poracle-it
mvn -Pmysql-it
            Reporter: fabio martelli
            Assignee: fabio martelli
             Fix For: 1.1.0-incubating, 1.0.2-incubating


IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (SYNCOPE-202) MySQL and Oracle integration test hangs

Posted by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/SYNCOPE-202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13464814#comment-13464814 ] 

Francesco Chicchiriccò commented on SYNCOPE-202:
------------------------------------------------

Messages at [1] suggest to add 

 org.quartz.jobStore.txIsolationLevelReadCommitted = true

to Quartz configuration in order to avoid deadlocks in Quartz 1.8.x, especially with MySQL.

[1] https://forums.terracotta.org/forums/posts/list/4051.page
                
> MySQL and Oracle integration test hangs
> ---------------------------------------
>
>                 Key: SYNCOPE-202
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0.2-incubating, 1.1.0-incubating
>         Environment: executing integration tests via
> mvn -Poracle-it
> mvn -Pmysql-it
>            Reporter: fabio martelli
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.0.2-incubating, 1.1.0-incubating
>
>
> IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
> The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (SYNCOPE-202) MySQL and Oracle integration test hangs

Posted by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/SYNCOPE-202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13461684#comment-13461684 ] 

Francesco Chicchiriccò commented on SYNCOPE-202:
------------------------------------------------

We need a consistent method for managing concurrent executions of Report and Task instances, currently triggered via Quartz.

The current method, implemented in ReportController.execute() (i.e. check if there is any ReportExec STARTED or RUNNING) seems to be not safe.
                
> MySQL and Oracle integration test hangs
> ---------------------------------------
>
>                 Key: SYNCOPE-202
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0.2-incubating, 1.1.0-incubating
>         Environment: executing integration tests via
> mvn -Poracle-it
> mvn -Pmysql-it
>            Reporter: fabio martelli
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.0.2-incubating, 1.1.0-incubating
>
>
> IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
> The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (SYNCOPE-202) MySQL and Oracle integration test hangs

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/SYNCOPE-202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13466882#comment-13466882 ] 

Hudson commented on SYNCOPE-202:
--------------------------------

Integrated in Syncope-linux-branches #28 (See [https://builds.apache.org/job/Syncope-linux-branches/28/])
    [SYNCOPE-124][SYNCOPE-202] Fixed concurrency issues with Quartz at JobInstanceLoader level + set transaction isolation level to READ-COMMITTED at Spring DataSource level + re-verified integration tests with all supported DBMS (Revision 1392392)

     Result = SUCCESS
ilgrosso : 
Files : 
* /incubator/syncope/branches/1_0_X/core/pom.xml
* /incubator/syncope/branches/1_0_X/core/src/main/java/org/apache/syncope/core/init/JobInstanceLoader.java
* /incubator/syncope/branches/1_0_X/core/src/main/java/org/apache/syncope/core/rest/controller/ReportController.java
* /incubator/syncope/branches/1_0_X/core/src/main/java/org/apache/syncope/core/rest/controller/UserController.java
* /incubator/syncope/branches/1_0_X/core/src/main/java/org/apache/syncope/core/scheduling/NotificationJob.java
* /incubator/syncope/branches/1_0_X/core/src/main/resources/persistenceContext.xml
* /incubator/syncope/branches/1_0_X/core/src/main/resources/persistenceContextEMFactory.xml
* /incubator/syncope/branches/1_0_X/core/src/main/resources/schedulingContext.xml
* /incubator/syncope/branches/1_0_X/core/src/main/resources/workflowContext.xml
* /incubator/syncope/branches/1_0_X/core/src/test/java/org/apache/syncope/core/rest/AbstractTest.java
* /incubator/syncope/branches/1_0_X/core/src/test/java/org/apache/syncope/core/rest/ReportTestITCase.java
* /incubator/syncope/branches/1_0_X/core/src/test/java/org/apache/syncope/core/rest/TaskTestITCase.java
* /incubator/syncope/branches/1_0_X/core/src/test/resources/content.xml
* /incubator/syncope/branches/1_0_X/core/src/test/resources/sqlserver/persistence.properties

                
> MySQL and Oracle integration test hangs
> ---------------------------------------
>
>                 Key: SYNCOPE-202
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0.2-incubating, 1.1.0-incubating
>         Environment: executing integration tests via
> mvn -Poracle-it
> mvn -Pmysql-it
>            Reporter: fabio martelli
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.0.2-incubating, 1.1.0-incubating
>
>
> IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
> The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Closed] (SYNCOPE-202) MySQL and Oracle integration test hangs

Posted by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/SYNCOPE-202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francesco Chicchiriccò closed SYNCOPE-202.
------------------------------------------


Bulk closing for 1.0.2-incubating
                
> MySQL and Oracle integration test hangs
> ---------------------------------------
>
>                 Key: SYNCOPE-202
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0.2-incubating, 1.1.0-incubating
>         Environment: executing integration tests via
> mvn -Poracle-it
> mvn -Pmysql-it
>            Reporter: fabio martelli
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.0.2-incubating, 1.1.0-incubating
>
>
> IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
> The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Resolved] (SYNCOPE-202) MySQL and Oracle integration test hangs

Posted by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/SYNCOPE-202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francesco Chicchiriccò resolved SYNCOPE-202.
--------------------------------------------

    Resolution: Fixed

http://svn.apache.org/viewvc?rev=1392392&view=rev
                
> MySQL and Oracle integration test hangs
> ---------------------------------------
>
>                 Key: SYNCOPE-202
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0.2-incubating, 1.1.0-incubating
>         Environment: executing integration tests via
> mvn -Poracle-it
> mvn -Pmysql-it
>            Reporter: fabio martelli
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.0.2-incubating, 1.1.0-incubating
>
>
> IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
> The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Assigned] (SYNCOPE-202) MySQL and Oracle integration test hangs

Posted by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/SYNCOPE-202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francesco Chicchiriccò reassigned SYNCOPE-202:
----------------------------------------------

    Assignee: Francesco Chicchiriccò  (was: fabio martelli)
    
> MySQL and Oracle integration test hangs
> ---------------------------------------
>
>                 Key: SYNCOPE-202
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-202
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0.2-incubating, 1.1.0-incubating
>         Environment: executing integration tests via
> mvn -Poracle-it
> mvn -Pmysql-it
>            Reporter: fabio martelli
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.0.2-incubating, 1.1.0-incubating
>
>
> IT tests execution (performed by "mvn -Poracle-it" or "mvn -Pmysql-it") hang.
> The bug should be on org.apache.syncope.core.rest.ReportTestITCase and org.apache.syncope.core.rest.TaskTestITCase.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira