airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shameera Rathnayaka <shameerai...@gmail.com>
Subject Re: [jira] [Updated] (AIRAVATA-886) Exception in jpa-registry when building in ubuntu with java 64 bit
Date Thu, 08 Aug 2013 19:47:45 GMT
Hi Chathuri,

Issues have been solved, Build succeed with clean repo.

Thanks,
Shameera.


On Fri, Aug 9, 2013 at 12:03 AM, Chathuri Wimalasena
<kamalasini@gmail.com>wrote:

> Hi Shameera,
>
> Saminda also faced the same issue in his ubuntu desktop. Can you again
> take an update and check please.
>
> Regards,
> Chathuri
>
>
> On Thu, Aug 8, 2013 at 2:24 PM, Shameera Rathnayaka <
> shameerainfo@gmail.com> wrote:
>
>> 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 <kamalasini@gmail.com
>> > 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 <
>>> shameerainfo@gmail.com> wrote:
>>>
>>>>
>>>> On Sun, Jul 14, 2013 at 12:02 AM, Amila Jayasekara <
>>>> thejaka.amila@gmail.com> 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) <
>>>>>> jira@apache.org> 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/
>>
>
>


-- 
Best Regards,
Shameera Rathnayaka.

email: shameera AT apache.org , shameerainfo AT gmail.com
Blog : http://shameerarathnayaka.blogspot.com/

Mime
View raw message