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 E9BA410799 for ; Sat, 13 Jul 2013 18:59:50 +0000 (UTC) Received: (qmail 17792 invoked by uid 500); 13 Jul 2013 18:59:50 -0000 Delivered-To: apmail-airavata-dev-archive@airavata.apache.org Received: (qmail 17763 invoked by uid 500); 13 Jul 2013 18:59:48 -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 17756 invoked by uid 99); 13 Jul 2013 18:59:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Jul 2013 18:59:46 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of shameerainfo@gmail.com designates 209.85.212.47 as permitted sender) Received: from [209.85.212.47] (HELO mail-vb0-f47.google.com) (209.85.212.47) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Jul 2013 18:59:42 +0000 Received: by mail-vb0-f47.google.com with SMTP id x14so2341940vbb.34 for ; Sat, 13 Jul 2013 11:59:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=ketuccyVh7VvOPnwmhQq+lpk22DLcVQfrV3EuT27D9Y=; b=fCuLgzWLNO1CDhyouEflER8hCRNdM3Kfu10SxclofklOksOWzTorn6KfPhc1IXpD5C w6TMOBK/xUjqifUHZYt9RxkIMrbcUThU7y6AD+fIUqZ7Cn+mR70ACLc3gDgzEXkpn8Gd THxcXxYAcGDMxrqg2dYueM64xSX2InhCoHzF4o/Jk4S9LXn/yExPUvm2hbniA6TZWeiM QsvDm6l0ItLVzSHkn+KI/US1xSBSi8Wub+TDFcMfvAnAbH1nzEJ4NgbTiphR/FNFuqqg ZHwPp/JXs2sfRPPBAEqaI84HQRBZ766FMqdEbfKxIFO7cuFFLlzje+6G6mLZUWf3Bg1m iSEA== X-Received: by 10.220.181.69 with SMTP id bx5mr9325709vcb.71.1373741961513; Sat, 13 Jul 2013 11:59:21 -0700 (PDT) MIME-Version: 1.0 Received: by 10.58.228.41 with HTTP; Sat, 13 Jul 2013 11:59:01 -0700 (PDT) In-Reply-To: References: From: Shameera Rathnayaka Date: Sun, 14 Jul 2013 00:29:01 +0530 Message-ID: Subject: Re: [jira] [Updated] (AIRAVATA-886) Exception in jpa-registry when building in ubuntu with java 64 bit To: dev Content-Type: multipart/alternative; boundary=001a1132f30ca10ff304e1693994 X-Virus-Checked: Checked by ClamAV on apache.org --001a1132f30ca10ff304e1693994 Content-Type: text/plain; charset=ISO-8859-1 On Sun, Jul 14, 2013 at 12:02 AM, Amila Jayasekara 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 < > shameerainfo@gmail.com> 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) > > 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! >>> > >>> 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/ --001a1132f30ca10ff304e1693994 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Sun, Jul 14= , 2013 at 12:02 AM, Amila Jayasekara <thejaka.amila@gmail.com>= ; wrote:
Guess we found the cause fo= r the issue. Soon we will commit a fix.

Great, Thanks Amila.

Cheers,
Shameera.
=A0


Thanks
AJ


On Sat, Jul 13, 2013 at 2:00 PM, Shameera Rathnayaka <= shameerainfo@gm= ail.com> wrote:
Hi devs,

This test failure is still there, any workaround for this?

Thanks,
Shameera.


On Fr= i, Jul 12, 2013 at 8:13 PM, Amila Jayasekara (JIRA) <<= a href=3D"mailto:jira@apache.org" target=3D"_blank">jira@apache.org>= wrote:

=A0 =A0 =A0[ https://issues.apache.org/jira/browse/AIRAVATA-886?page=3Dcom.a= tlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amila Jayasekara updated AIRAVATA-886:
--------------------------------------

=A0 =A0 Attachment: org.apache.airavata.persistance.registry.jpa.Expe= rimentResourceTest.txt

> Exception in jpa-registry when building in ubuntu with java 64 bit
> ------------------------------------------------------------------
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Key: AIRAVATA-886
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 URL: https://issues.apache.org/j= ira/browse/AIRAVATA-886
> =A0 =A0 =A0 =A0 =A0 =A0 Project: Airavata
> =A0 =A0 =A0 =A0 =A0Issue Type: Bug
> =A0 =A0 =A0 =A0 =A0Components: Registry API
> =A0 =A0Affects Versions: 0.8
> =A0 =A0 =A0 =A0 Environment: Linux sgg-build 3.5.0-36-generic #57-Ubun= tu 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)
> =A0 =A0 =A0 =A0 =A0 =A0Reporter: Amila Jayasekara
> =A0 =A0 =A0 =A0 =A0 =A0 Fix For: 0.9
>
> =A0 =A0 =A0 =A0 Attachments: org.apache.airavata.persistance.registry.= jpa.ExperimentResourceTest.txt
>
>
> I am getting following exception when build airavata-j= pa-registry in above environment;
> Surefire reports are also attached.
> ----------------------------------------------------------------------= ---------
> Test set: org.apache.airavata.persistance.registry.jpa.ExperimentResou= rceTest
> ----------------------------------------------------------------------= ---------
> Tests run: 4, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.779 = sec <<< FAILURE!
> testRemove(org.apache.airavata.persistance.registry.jpa.ExperimentReso= urceTest) =A0Time elapsed: 0.225 sec =A0<<< ERROR!
> <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.o= penjpa.persistence.PersistenceException: DELETE on table 'WORKFLOW_DATA= ' caused a violation of foreign key constraint 'SQL130711163228212&= #39; for key (testWFInstance). =A0The statement has been rolled back. {prep= stmnt 1269198549
> DELETE FROM Experiment_Data
> =A0 =A0 WHERE experiment_ID IN (SELECT DISTINCT t0.experiment_ID FROM<= br> > =A0 =A0 =A0 =A0 Experiment_Data t0 WHERE (t0.experiment_ID =3D ?))
> [params=3D(String) testExpID]} [code=3D-1, state=3D23503]
> FailedObject: DELETE FROM Experiment_Data WHERE experiment_ID IN (SELE= CT DISTINCT t0.experiment_ID FROM Experiment_Data t0 WHERE (t0.experiment_I= D =3D ?)) [java.lang.String]
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDicti= onary.java:4912)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreExcept= ion(DBDictionary.java:4878)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLE= xceptions.java:136)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLE= xceptions.java:78)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBu= lkOperation(JDBCStoreQuery.java:579)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDe= lete(JDBCStoreQuery.java:491)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStor= eExecutor.executeDelete(ExpressionStoreQuery.java:789)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.ja= va:1025)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.j= ava:865)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl= .java:892)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.DelegatingQuery.deleteAll(Del= egatingQuery.java:574)
> =A0 =A0 =A0 at org.apache.openjpa.persistence.QueryImpl.executeUpdate(= QueryImpl.java:374)
> =A0 =A0 =A0 at org.apache.airavata.persistance.registry.jpa.resources.= ExperimentResource.remove(ExperimentResource.java:115)
> =A0 =A0 =A0 at org.apache.airavata.persistance.registry.jpa.Experiment= ResourceTest.testRemove(ExperimentResourceTest.java:73)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho= dAccessorImpl.java:39)
> =A0 =A0 =A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25)
> =A0 =A0 =A0 at java.lang.reflect.Method.invoke(Method.java:597)
> =A0 =A0 =A0 at junit.framework.TestCase.runTest(TestCase.java:168)
> =A0 =A0 =A0 at junit.framework.TestCase.runBare(TestCase.java:134)
> =A0 =A0 =A0 at junit.framework.TestResult$1.protect(TestResult.java:11= 0)
> =A0 =A0 =A0 at junit.framework.TestResult.runProtected(TestResult.java= :128)
> =A0 =A0 =A0 at junit.framework.TestResult.run(TestResult.java:113)
> =A0 =A0 =A0 at junit.framework.TestCase.run(TestCase.java:124)
> =A0 =A0 =A0 at junit.framework.TestSuite.runTest(TestSuite.java:232) > =A0 =A0 =A0 at junit.framework.TestSuite.run(TestSuite.java:227)
> =A0 =A0 =A0 at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit= 38ClassRunner.java:83)
> =A0 =A0 =A0 at org.apache.maven.surefire.junit4.JUnit4Provider.execute= (JUnit4Provider.java:236)
> =A0 =A0 =A0 at org.apache.maven.surefire.junit4.JUnit4Provider.execute= TestSet(JUnit4Provider.java:134)
> =A0 =A0 =A0 at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(= JUnit4Provider.java:113)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho= dAccessorImpl.java:39)
> =A0 =A0 =A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25)
> =A0 =A0 =A0 at java.lang.reflect.Method.invoke(Method.java:597)
> =A0 =A0 =A0 at org.apache.maven.surefire.util.ReflectionUtils.invokeMe= thodWithArray(ReflectionUtils.java:189)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ProviderFactory$Provid= erProxy.invoke(ProviderFactory.java:165)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ProviderFactory.invoke= Provider(ProviderFactory.java:85)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ForkedBooter.runSuites= InProcess(ForkedBooter.java:103)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ForkedBooter.main(Fork= edBooter.java:74)
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: DELETE o= n table 'WORKFLOW_DATA' caused a violation of foreign key constrain= t 'SQL130711163228212' for key (testWFInstance). =A0The statement h= as been rolled back. {prepstmnt 1269198549
> DELETE FROM Experiment_Data
> =A0 =A0 WHERE experiment_ID IN (SELECT DISTINCT t0.experiment_ID FROM<= br> > =A0 =A0 =A0 =A0 Experiment_Data t0 WHERE (t0.experiment_ID =3D ?))
> [params=3D(String) testExpID]} [code=3D-1, state=3D23503]
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.= wrap(LoggingConnectionDecorator.java:247)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.= wrap(LoggingConnectionDecorator.java:223)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.= access$1000(LoggingConnectionDecorator.java:72)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$= LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionD= ecorator.java:1162)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement= .executeUpdate(DelegatingPreparedStatement.java:272)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelP= reparedStatement.executeUpdate(JDBCStoreManager.java:1741)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUp= date(JDBCStoreQuery.java:746)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBu= lkOperation(JDBCStoreQuery.java:577)
> =A0 =A0 =A0 ... 34 more
> NestedThrowables:
> java.sql.SQLIntegrityConstraintViolationException: DELETE on table = 9;WORKFLOW_DATA' caused a violation of foreign key constraint 'SQL1= 30711163228212' for key (testWFInstance). =A0The statement has been rol= led back.
> =A0 =A0 =A0 at org.apache.derby.client.am.SQLExceptionFactory40.getSQL= Exception(Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.am.SqlException.getSQLException= (Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.am.PreparedStatement.executeUpd= ate(Unknown Source)
> =A0 =A0 =A0 at org.apache.commons.dbcp.DelegatingPreparedStatement.exe= cuteUpdate(DelegatingPreparedStatement.java:105)
> =A0 =A0 =A0 at org.apache.commons.dbcp.DelegatingPreparedStatement.exe= cuteUpdate(DelegatingPreparedStatement.java:105)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement= .executeUpdate(DelegatingPreparedStatement.java:272)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$= LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionD= ecorator.java:1160)
> =A0 =A0 =A0 at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement= .executeUpdate(DelegatingPreparedStatement.java:272)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelP= reparedStatement.executeUpdate(JDBCStoreManager.java:1741)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUp= date(JDBCStoreQuery.java:746)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBu= lkOperation(JDBCStoreQuery.java:577)
> =A0 =A0 =A0 at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDe= lete(JDBCStoreQuery.java:491)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStor= eExecutor.executeDelete(ExpressionStoreQuery.java:789)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.ja= va:1025)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.j= ava:865)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl= .java:892)
> =A0 =A0 =A0 at org.apache.openjpa.kernel.DelegatingQuery.deleteAll(Del= egatingQuery.java:574)
> =A0 =A0 =A0 at org.apache.openjpa.persistence.QueryImpl.executeUpdate(= QueryImpl.java:374)
> =A0 =A0 =A0 at org.apache.airavata.persistance.registry.jpa.resources.= ExperimentResource.remove(ExperimentResource.java:115)
> =A0 =A0 =A0 at org.apache.airavata.persistance.registry.jpa.Experiment= ResourceTest.testRemove(ExperimentResourceTest.java:73)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho= dAccessorImpl.java:39)
> =A0 =A0 =A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25)
> =A0 =A0 =A0 at java.lang.reflect.Method.invoke(Method.java:597)
> =A0 =A0 =A0 at junit.framework.TestCase.runTest(TestCase.java:168)
> =A0 =A0 =A0 at junit.framework.TestCase.runBare(TestCase.java:134)
> =A0 =A0 =A0 at junit.framework.TestResult$1.protect(TestResult.java:11= 0)
> =A0 =A0 =A0 at junit.framework.TestResult.runProtected(TestResult.java= :128)
> =A0 =A0 =A0 at junit.framework.TestResult.run(TestResult.java:113)
> =A0 =A0 =A0 at junit.framework.TestCase.run(TestCase.java:124)
> =A0 =A0 =A0 at junit.framework.TestSuite.runTest(TestSuite.java:232) > =A0 =A0 =A0 at junit.framework.TestSuite.run(TestSuite.java:227)
> =A0 =A0 =A0 at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit= 38ClassRunner.java:83)
> =A0 =A0 =A0 at org.apache.maven.surefire.junit4.JUnit4Provider.execute= (JUnit4Provider.java:236)
> =A0 =A0 =A0 at org.apache.maven.surefire.junit4.JUnit4Provider.execute= TestSet(JUnit4Provider.java:134)
> =A0 =A0 =A0 at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(= JUnit4Provider.java:113)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod)
> =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho= dAccessorImpl.java:39)
> =A0 =A0 =A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25)
> =A0 =A0 =A0 at java.lang.reflect.Method.invoke(Method.java:597)
> =A0 =A0 =A0 at org.apache.maven.surefire.util.ReflectionUtils.invokeMe= thodWithArray(ReflectionUtils.java:189)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ProviderFactory$Provid= erProxy.invoke(ProviderFactory.java:165)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ProviderFactory.invoke= Provider(ProviderFactory.java:85)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ForkedBooter.runSuites= InProcess(ForkedBooter.java:103)
> =A0 =A0 =A0 at org.apache.maven.surefire.booter.ForkedBooter.main(Fork= edBooter.java:74)
> Caused by: org.apache.derby.client.am.SqlException: DELETE on table &#= 39;WORKFLOW_DATA' caused a violation of foreign key constraint 'SQL= 130711163228212' for key (testWFInstance). =A0The statement has been ro= lled back.
> =A0 =A0 =A0 at org.apache.derby.client.am.Statement.completeExecute(Un= known Source)
> =A0 =A0 =A0 at org.apache.derby.client.net.NetStatementReply.parseEXCS= QLSTTreply(Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.net.NetStatementReply.readExecu= te(Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.net.StatementReply.readExecute(= Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.net.NetPreparedStatement.readEx= ecute_(Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.am.PreparedStatement.readExecut= e(Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.am.PreparedStatement.flowExecut= e(Unknown Source)
> =A0 =A0 =A0 at org.apache.derby.client.am.PreparedStatement.executeUpd= ateX(Unknown Source)
> =A0 =A0 =A0 ... 43 more

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



= --
Best Regards,
Shameera Rathnayaka.

email: shameer= a AT apache.org , shame= erainfo AT gmail.com
Blog : http://shameerarathna= yaka.blogspot.com/




--
Best Regard= s,
Shameer= a Rathnayaka.

email: shameer= a AT apache.org , shame= erainfo AT gmail.com
Blog : http://shameerarathna= yaka.blogspot.com/
--001a1132f30ca10ff304e1693994--