[
https://issues.apache.org/jira/browse/DERBY-6628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041974#comment-14041974
]
Knut Anders Hatlen commented on DERBY-6628:
-------------------------------------------
I'm just speculating... The trigger might be recompiled because the preceding
inserts into the T1 and PARENT tables causes the stale plan checking to decide
that a recompilation is needed. Not sure why it would be intermittent in that
case. Some interaction with the index statistics daemon, perhaps? Also, both
the delete statement itself and the select statement against the diagnostic
table would have to be compiled after setAutoCommit(false) has been called, and
those compilations would probably need locks on the system tables. I don't see
why the locks shouldn't be released, though, as compilation happens in a nested
transaction that is committed separately.
> 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
> Assignee: Dag H. Wanvik
> Attachments: derby-6628.diff
>
>
> 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)
