db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6529) nightly regression test failure in newly added junit test TriggerGeneralTest
Date Tue, 25 Mar 2014 21:05:14 GMT

    [ 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)

Mime
View raw message