Thanks Shameera for testing this. Regards, Chathuri
On Thu, Aug 8, 2013 at 3:47 PM, Shameera Rathnayaka <[email protected]>wrote: > Hi Chathuri, > > Issues have been solved, Build succeed with clean repo. > > Thanks, > Shameera. > > > On Fri, Aug 9, 2013 at 12:03 AM, Chathuri Wimalasena <[email protected] > > wrote: > >> Hi Shameera, >> >> Saminda also faced the same issue in his ubuntu desktop. Can you again >> take an update and check please. >> >> Regards, >> Chathuri >> >> >> On Thu, Aug 8, 2013 at 2:24 PM, Shameera Rathnayaka < >> [email protected]> wrote: >> >>> Hi Chathuri, >>> >>> Now i am getting following build failure with clean repo, I have >>> attached surefire test report with this. >>> >>> Tests in error: >>> >>> testSave(org.apache.airavata.persistance.registry.jpa.GFacJobDataResourceTest): >>> DELETE on table 'GFAC_JOB_DATA' caused a violation of foreign key >>> constraint 'SQL130808233503570' for key (testJobID). The statement has >>> been rolled back. {prepstmnt 1766794158 (..) >>> >>> Tests run: 45, Failures: 0, Errors: 1, Skipped: 0 >>> >>> >>> Thanks, >>> Shameera. >>> >>> >>> On Wed, Aug 7, 2013 at 8:55 PM, Chathuri Wimalasena < >>> [email protected]> wrote: >>> >>>> Hi Shameera, >>>> >>>> This should be fixed now. Can you take an update on trunk and let me >>>> know if you still getting the same error. >>>> >>>> Regards, >>>> Chathuri >>>> >>>> >>>> >>>> On Sat, Jul 13, 2013 at 2:59 PM, Shameera Rathnayaka < >>>> [email protected]> wrote: >>>> >>>>> >>>>> On Sun, Jul 14, 2013 at 12:02 AM, Amila Jayasekara < >>>>> [email protected]> wrote: >>>>> >>>>>> Guess we found the cause for the issue. Soon we will commit a fix. >>>>>> >>>>> >>>>> Great, Thanks Amila. >>>>> >>>>> Cheers, >>>>> Shameera. >>>>> >>>>> >>>>>> >>>>>> >>>>>> Thanks >>>>>> AJ >>>>>> >>>>>> >>>>>> On Sat, Jul 13, 2013 at 2:00 PM, Shameera Rathnayaka < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> Hi devs, >>>>>>> >>>>>>> This test failure is still there, any workaround for this? >>>>>>> >>>>>>> Thanks, >>>>>>> Shameera. >>>>>>> >>>>>>> >>>>>>> On Fri, Jul 12, 2013 at 8:13 PM, Amila Jayasekara (JIRA) < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> >>>>>>>> [ >>>>>>>> https://issues.apache.org/jira/browse/AIRAVATA-886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel] >>>>>>>> >>>>>>>> Amila Jayasekara updated AIRAVATA-886: >>>>>>>> -------------------------------------- >>>>>>>> >>>>>>>> Attachment: >>>>>>>> org.apache.airavata.persistance.registry.jpa.ExperimentResourceTest.txt >>>>>>>> >>>>>>>> > Exception in jpa-registry when building in ubuntu with java 64 bit >>>>>>>> > ------------------------------------------------------------------ >>>>>>>> > >>>>>>>> > Key: AIRAVATA-886 >>>>>>>> > URL: >>>>>>>> https://issues.apache.org/jira/browse/AIRAVATA-886 >>>>>>>> > Project: Airavata >>>>>>>> > Issue Type: Bug >>>>>>>> > Components: Registry API >>>>>>>> > Affects Versions: 0.8 >>>>>>>> > Environment: Linux sgg-build 3.5.0-36-generic #57-Ubuntu >>>>>>>> SMP Wed Jun 19 15:10:49 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux >>>>>>>> > java version "1.7.0_25" >>>>>>>> > Java(TM) SE Runtime Environment (build 1.7.0_25-b15) >>>>>>>> > Java HotSpot(TM) 64-Bit Server VM (build 23.25-b01, mixed mode) >>>>>>>> > Reporter: Amila Jayasekara >>>>>>>> > Fix For: 0.9 >>>>>>>> > >>>>>>>> > Attachments: >>>>>>>> org.apache.airavata.persistance.registry.jpa.ExperimentResourceTest.txt >>>>>>>> > >>>>>>>> > >>>>>>>> > I am getting following exception when build airavata-jpa-registry >>>>>>>> in above environment; >>>>>>>> > Surefire reports are also attached. >>>>>>>> > >>>>>>>> ------------------------------------------------------------------------------- >>>>>>>> > Test set: >>>>>>>> org.apache.airavata.persistance.registry.jpa.ExperimentResourceTest >>>>>>>> > >>>>>>>> ------------------------------------------------------------------------------- >>>>>>>> > Tests run: 4, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: >>>>>>>> 0.779 sec <<< FAILURE! >>>>>>>> > >>>>>>>> testRemove(org.apache.airavata.persistance.registry.jpa.ExperimentResourceTest) >>>>>>>> Time elapsed: 0.225 sec <<< ERROR! >>>>>>>> > <openjpa-2.2.0-r422266:1244990 fatal general error> >>>>>>>> org.apache.openjpa.persistence.PersistenceException: DELETE on table >>>>>>>> 'WORKFLOW_DATA' caused a violation of foreign key constraint >>>>>>>> 'SQL130711163228212' for key (testWFInstance). The statement has been >>>>>>>> rolled back. {prepstmnt 1269198549 >>>>>>>> > DELETE FROM Experiment_Data >>>>>>>> > WHERE experiment_ID IN (SELECT DISTINCT t0.experiment_ID FROM >>>>>>>> > Experiment_Data t0 WHERE (t0.experiment_ID = ?)) >>>>>>>> > [params=(String) testExpID]} [code=-1, state=23503] >>>>>>>> > FailedObject: DELETE FROM Experiment_Data WHERE experiment_ID IN >>>>>>>> (SELECT DISTINCT t0.experiment_ID FROM Experiment_Data t0 WHERE >>>>>>>> (t0.experiment_ID = ?)) [java.lang.String] >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4912) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:579) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:491) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:789) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1025) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:865) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:892) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:574) >>>>>>>> > at >>>>>>>> org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:374) >>>>>>>> > at >>>>>>>> org.apache.airavata.persistance.registry.jpa.resources.ExperimentResource.remove(ExperimentResource.java:115) >>>>>>>> > at >>>>>>>> org.apache.airavata.persistance.registry.jpa.ExperimentResourceTest.testRemove(ExperimentResourceTest.java:73) >>>>>>>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>>>>>>> Method) >>>>>>>> > at >>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>>>>> > at >>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>>>>> > at java.lang.reflect.Method.invoke(Method.java:597) >>>>>>>> > at junit.framework.TestCase.runTest(TestCase.java:168) >>>>>>>> > at junit.framework.TestCase.runBare(TestCase.java:134) >>>>>>>> > at junit.framework.TestResult$1.protect(TestResult.java:110) >>>>>>>> > at >>>>>>>> junit.framework.TestResult.runProtected(TestResult.java:128) >>>>>>>> > at junit.framework.TestResult.run(TestResult.java:113) >>>>>>>> > at junit.framework.TestCase.run(TestCase.java:124) >>>>>>>> > at junit.framework.TestSuite.runTest(TestSuite.java:232) >>>>>>>> > at junit.framework.TestSuite.run(TestSuite.java:227) >>>>>>>> > at >>>>>>>> org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:236) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:134) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:113) >>>>>>>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>>>>>>> Method) >>>>>>>> > at >>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>>>>> > at >>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>>>>> > at java.lang.reflect.Method.invoke(Method.java:597) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:103) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:74) >>>>>>>> > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: >>>>>>>> DELETE on table 'WORKFLOW_DATA' caused a violation of foreign key >>>>>>>> constraint 'SQL130711163228212' for key (testWFInstance). The >>>>>>>> statement >>>>>>>> has been rolled back. {prepstmnt 1269198549 >>>>>>>> > DELETE FROM Experiment_Data >>>>>>>> > WHERE experiment_ID IN (SELECT DISTINCT t0.experiment_ID FROM >>>>>>>> > Experiment_Data t0 WHERE (t0.experiment_ID = ?)) >>>>>>>> > [params=(String) testExpID]} [code=-1, state=23503] >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:746) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:577) >>>>>>>> > ... 34 more >>>>>>>> > NestedThrowables: >>>>>>>> > java.sql.SQLIntegrityConstraintViolationException: DELETE on >>>>>>>> table 'WORKFLOW_DATA' caused a violation of foreign key constraint >>>>>>>> 'SQL130711163228212' for key (testWFInstance). The statement has been >>>>>>>> rolled back. >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) >>>>>>>> > at >>>>>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1160) >>>>>>>> > at >>>>>>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:746) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:577) >>>>>>>> > at >>>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:491) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:789) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1025) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:865) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:892) >>>>>>>> > at >>>>>>>> org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:574) >>>>>>>> > at >>>>>>>> org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:374) >>>>>>>> > at >>>>>>>> org.apache.airavata.persistance.registry.jpa.resources.ExperimentResource.remove(ExperimentResource.java:115) >>>>>>>> > at >>>>>>>> org.apache.airavata.persistance.registry.jpa.ExperimentResourceTest.testRemove(ExperimentResourceTest.java:73) >>>>>>>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>>>>>>> Method) >>>>>>>> > at >>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>>>>> > at >>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>>>>> > at java.lang.reflect.Method.invoke(Method.java:597) >>>>>>>> > at junit.framework.TestCase.runTest(TestCase.java:168) >>>>>>>> > at junit.framework.TestCase.runBare(TestCase.java:134) >>>>>>>> > at junit.framework.TestResult$1.protect(TestResult.java:110) >>>>>>>> > at >>>>>>>> junit.framework.TestResult.runProtected(TestResult.java:128) >>>>>>>> > at junit.framework.TestResult.run(TestResult.java:113) >>>>>>>> > at junit.framework.TestCase.run(TestCase.java:124) >>>>>>>> > at junit.framework.TestSuite.runTest(TestSuite.java:232) >>>>>>>> > at junit.framework.TestSuite.run(TestSuite.java:227) >>>>>>>> > at >>>>>>>> org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:236) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:134) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:113) >>>>>>>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>>>>>>> Method) >>>>>>>> > at >>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>>>>> > at >>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>>>>> > at java.lang.reflect.Method.invoke(Method.java:597) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:103) >>>>>>>> > at >>>>>>>> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:74) >>>>>>>> > Caused by: org.apache.derby.client.am.SqlException: DELETE on >>>>>>>> table 'WORKFLOW_DATA' caused a violation of foreign key constraint >>>>>>>> 'SQL130711163228212' for key (testWFInstance). The statement has been >>>>>>>> rolled back. >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.Statement.completeExecute(Unknown Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.net.NetStatementReply.readExecute(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.net.StatementReply.readExecute(Unknown Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.PreparedStatement.readExecute(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown >>>>>>>> Source) >>>>>>>> > at >>>>>>>> org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown >>>>>>>> Source) >>>>>>>> > ... 43 more >>>>>>>> >>>>>>>> -- >>>>>>>> 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 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Best Regards, >>>>>>> Shameera Rathnayaka. >>>>>>> >>>>>>> email: shameera AT apache.org , shameerainfo AT gmail.com >>>>>>> Blog : http://shameerarathnayaka.blogspot.com/ >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Best Regards, >>>>> Shameera Rathnayaka. >>>>> >>>>> email: shameera AT apache.org , shameerainfo AT gmail.com >>>>> Blog : http://shameerarathnayaka.blogspot.com/ >>>>> >>>> >>>> >>> >>> >>> -- >>> Best Regards, >>> Shameera Rathnayaka. >>> >>> email: shameera AT apache.org , shameerainfo AT gmail.com >>> Blog : http://shameerarathnayaka.blogspot.com/ >>> >> >> > > > -- > Best Regards, > Shameera Rathnayaka. > > email: shameera AT apache.org , shameerainfo AT gmail.com > Blog : http://shameerarathnayaka.blogspot.com/ >
