Guess we found the cause for the issue. Soon we will commit a fix.
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/ >
