[jira] [Commented] (DERBY-6628) Intermittent error in TriggerGeneralTest

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-6628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037853#comment-14037853 ] 

Dag H. Wanvik commented on DERBY-6628:
--------------------------------------

The assertion that fails has just done a query to check the lock in the lock table:
{code}
select type, mode, tablename from syscs_diag.lock_table order by tablename, type
{code}
and the assert finds an unexpected lock on SYSCHECKS. This table is accessed for CHECK constraints and for some reason is still lingering.

> Intermittent error in TriggerGeneralTest
> ----------------------------------------
>
>                 Key: DERBY-6628
>                 URL: https://issues.apache.org/jira/browse/DERBY-6628
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>            Reporter: Dag H. Wanvik
>
> See in nightly regression test:
> http://download.java.net/javadesktop/derby/request_5592869/javadb-task-3886181.html
> where the relevant part of stacktrace is as follows:
> {code}
> junit.framework.AssertionFailedError: Column value mismatch @ column 'TABLENAME', row 3:
>     Expected: >T1<
>     Found:    >SYSCHECKS<
> 	at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1303)
> 	at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1215)
> 	at org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1102)
> 	at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1025)
> 	at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:982)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest.testTriggersInGeneral(TriggerGeneralTest.java:874)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:118)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:440)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:457)
> {code }



--
This message was sent by Atlassian JIRA
(v6.2#6252)