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/
-------------------------------------------------------------------------------
Test set: org.apache.airavata.persistance.registry.jpa.GFacJobDataResourceTest
-------------------------------------------------------------------------------
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.897 sec <<<
FAILURE!
testSave(org.apache.airavata.persistance.registry.jpa.GFacJobDataResourceTest)
Time elapsed: 0.894 sec <<< ERROR!
<openjpa-2.2.0-r422266:1244990 fatal general error>
org.apache.openjpa.persistence.PersistenceException: 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
DELETE FROM GFac_Job_Data
WHERE local_Job_ID IN (SELECT DISTINCT t0.local_Job_ID FROM
GFac_Job_Data t0 WHERE (t0.local_Job_ID = ?))
[params=(String) testJobID]} [code=-1, state=23503]
FailedObject: DELETE FROM GFac_Job_Data WHERE local_Job_ID IN (SELECT DISTINCT
t0.local_Job_ID FROM GFac_Job_Data t0 WHERE (t0.local_Job_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.WorkflowDataResource.remove(WorkflowDataResource.java:153)
at
org.apache.airavata.persistance.registry.jpa.GFacJobDataResourceTest.testSave(GFacJobDataResourceTest.java:79)
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
'GFAC_JOB_DATA' caused a violation of foreign key constraint
'SQL130808233503570' for key (testJobID). The statement has been rolled back.
{prepstmnt 1766794158
DELETE FROM GFac_Job_Data
WHERE local_Job_ID IN (SELECT DISTINCT t0.local_Job_ID FROM
GFac_Job_Data t0 WHERE (t0.local_Job_ID = ?))
[params=(String) testJobID]} [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
'GFAC_JOB_DATA' caused a violation of foreign key constraint
'SQL130808233503570' for key (testJobID). 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.WorkflowDataResource.remove(WorkflowDataResource.java:153)
at
org.apache.airavata.persistance.registry.jpa.GFacJobDataResourceTest.testSave(GFacJobDataResourceTest.java:79)
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
'GFAC_JOB_DATA' caused a violation of foreign key constraint
'SQL130808233503570' for key (testJobID). 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
