[
https://issues.apache.org/jira/browse/DERBY-6529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13947150#comment-13947150
]
Mike Matrigali commented on DERBY-6529:
---------------------------------------
Here is the first time it happened:
http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm16/1580120-suites.All_diff.txt
http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm17/1580120-suites.All_diff.txt
There were 3 failures:
1)
testTriggersInGeneral(org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest)junit.framework.ComparisonFailure:
expected:<...,(3,3,'3'),(4,4,'4')[
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <5th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
]
> but was:<...,(3,3,'3'),(4,4,'4')[
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <5th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
]
>
at
org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest.assertTriggerOutput(TriggerGeneralTest.java:2362)
at
org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest.testTriggersInGeneral(TriggerGeneralTest.java:444)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
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)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
2)
testTriggersInGeneral(org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest)junit.framework.ComparisonFailure:
expected:<...,(3,3,'3'),(4,4,'4')[
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <5th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
]
> but was:<...,(3,3,'3'),(4,4,'4')[
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <2nd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <3rd> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{3,3,3}
TRIGGER: <4th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{4,4,4}
TRIGGER: <5th> on statement insert into t values (2,2,'2'),(3,3,'3'),(4,4,'4')
BEFORE RESULT SET
<NULL>
AFTER RESULT SET
X,Y,C
- - -
{2,2,2}
{3,3,3}
{4,4,4}
]
>
at
org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest.assertTriggerOutput(TriggerGeneralTest.java:2362)
at
org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest.testTriggersInGeneral(TriggerGeneralTest.java:444)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
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)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
3)
testDerby5866TriggerExecutionOrder(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_11)junit.framework.AssertionFailedError:
Column value mismatch @ column 'Y', row 1:
Expected: >CREATE<
Found: >POST SOFT UPGRADE<
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1291)
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1203)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1090)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1013)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:970)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:928)
at
org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_11.testDerby5866TriggerExecutionOrder(Changes10_11.java:266)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
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)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
FAILURES!!!
Tests run: 18443, Failures: 3, Errors: 0
> nightly regression test failure in newly added junit test TriggerGeneralTest
> ----------------------------------------------------------------------------
>
> Key: DERBY-6529
> URL: https://issues.apache.org/jira/browse/DERBY-6529
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.11.0.0
> Environment: is failing on windows ibm16 and ibm17, is not failing on
> linux ibm16 and ibm17
> Reporter: Mike Matrigali
>
> consistent nightly regression test failure in testTriggersInGeneral newly
> added junit test. The error happens consistently in windows ibm16 and
> ibm17 but not in linux ibm16 and ibm17.
> summary of failures:
> 1)
> testTriggersInGeneral(org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest)junit.framework.ComparisonFailure:
> expected:<...,(3,3,'3'),(4,4,'4')[
> 2)
> testTriggersInGeneral(org.apache.derbyTesting.functionTests.tests.lang.TriggerGeneralTest)junit.framework.ComparisonFailure:
> expected:<...,(3,3,'3'),(4,4,'4')[
> 3)
> testDerby5866TriggerExecutionOrder(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_11)junit.framework.AssertionFailedError:
> Column value mismatch @ column 'Y', row 1:
--
This message was sent by Atlassian JIRA
(v6.2#6252)
