You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2012/10/28 09:21:12 UTC

[jira] [Closed] (CAY-1750) Occasional Invalid DB state during ValueForNullTest

     [ https://issues.apache.org/jira/browse/CAY-1750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-1750.
--------------------------------

    Resolution: Fixed
    
> Occasional Invalid DB state during ValueForNullTest
> ---------------------------------------------------
>
>                 Key: CAY-1750
>                 URL: https://issues.apache.org/jira/browse/CAY-1750
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 3.2M1
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>
> Rather often getting the following exceptions on Jenkins. E.g. in this build:
> https://builds.apache.org/job/Cayenne-trunk/782/cayenneTestConnection=derby,jdk=JDK%201.7%20%28latest%29,label=Ubuntu/
> -------------------------------------------------------------------------------
> Test set: org.apache.cayenne.merge.ValueForNullTest
> -------------------------------------------------------------------------------
> Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.022 sec <<< FAILURE!
> test(org.apache.cayenne.merge.ValueForNullTest)  Time elapsed: 0.02 sec  <<< ERROR!
> java.sql.SQLIntegrityConstraintViolationException: DELETE on table 'ARTGROUP' caused a violation of foreign key constraint 'SQL121021093552010' for key (2).  The statement has been rolled back.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at org.apache.cayenne.test.jdbc.UpdateTemplate.execute(UpdateTemplate.java:78)
> 	at org.apache.cayenne.test.jdbc.SQLBuilder.execute(SQLBuilder.java:51)
> 	at org.apache.cayenne.test.jdbc.DBHelper.deleteAll(DBHelper.java:163)
> 	at org.apache.cayenne.merge.MergeCase.setUpAfterInjection(MergeCase.java:73)
> 	at org.apache.cayenne.unit.di.DICase.setUp(DICase.java:38)
> 	at junit.framework.TestCase.runBare(TestCase.java:125)
> 	at junit.framework.TestResult$1.protect(TestResult.java:106)
> 	at junit.framework.TestResult.runProtected(TestResult.java:124)
> 	at junit.framework.TestResult.run(TestResult.java:109)
> 	at junit.framework.TestCase.run(TestCase.java:118)
> 	at junit.framework.TestSuite.runTest(TestSuite.java:208)
> 	at junit.framework.TestSuite.run(TestSuite.java:203)
> 	at sun.reflect.GeneratedMethodAccessor197.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:601)
> 	at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:213)
> 	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
> 	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
> 	at org.apache.maven.surefire.Surefire.run(Surefire.java:180)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:601)
> 	at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
> 	at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)
> Caused by: java.sql.SQLException: DELETE on table 'ARTGROUP' caused a violation of foreign key constraint 'SQL121021093552010' for key (2).  The statement has been rolled back.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 34 more
> Caused by: ERROR 23503: DELETE on table 'ARTGROUP' caused a violation of foreign key constraint 'SQL121021093552010' for key (2).  The statement has been rolled back.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DeleteResultSet.runFkChecker(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 28 more
> Caused by: java.sql.SQLException: DELETE on table 'ARTGROUP' caused a violation of foreign key constraint 'SQL121021093552010' for key (2).  The statement has been rolled back.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 34 more
> Caused by: ERROR 23503: DELETE on table 'ARTGROUP' caused a violation of foreign key constraint 'SQL121021093552010' for key (2).  The statement has been rolled back.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DeleteResultSet.runFkChecker(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 28 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