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/ >
