Return-Path: X-Original-To: apmail-airavata-dev-archive@www.apache.org Delivered-To: apmail-airavata-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DF743101E4 for ; Fri, 12 Jul 2013 14:41:54 +0000 (UTC) Received: (qmail 13617 invoked by uid 500); 12 Jul 2013 14:41:54 -0000 Delivered-To: apmail-airavata-dev-archive@airavata.apache.org Received: (qmail 13516 invoked by uid 500); 12 Jul 2013 14:41:50 -0000 Mailing-List: contact dev-help@airavata.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airavata.apache.org Delivered-To: mailing list dev@airavata.apache.org Received: (qmail 13506 invoked by uid 99); 12 Jul 2013 14:41:48 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Jul 2013 14:41:48 +0000 Date: Fri, 12 Jul 2013 14:41:48 +0000 (UTC) From: "Amila Jayasekara (JIRA)" To: dev@airavata.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (AIRAVATA-886) Exception in jpa-registry when building in ubuntu with java 64 bit MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Amila Jayasekara created AIRAVATA-886: ----------------------------------------- Summary: 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 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! 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