[DERBY-6297] Intermittent failures in XplainStatisticsTest.testSimpleXplainOnly

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Tools
• Urgency: Normal
• Bug behavior facts: Regression Test Failure
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 18/Jul/13 10:25
• Updated: 21/Jan/15 00:23
• Resolved: 28/Aug/13 10:44

Description

XplainStatisticsTest.testSimpleXplainOnly fails intermittently.

Examples:

http://download.java.net/javadesktop/derby/javadb-5579342-report/javadb-task-3689858.html

junit.framework.AssertionFailedError: Column value mismatch @ column '1', row 1:
Expected: >1<
Found: >2<
at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1278)
at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1190)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1077)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1000)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:957)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:915)
at org.apache.derbyTesting.junit.JDBC.assertSingleValueResultSet(JDBC.java:900)
at org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest.testSimpleXplainOnly(XplainStatisticsTest.java:1148)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
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)

http://download.java.net/javadesktop/derby/javadb-5579365-report/javadb-task-3690182.html

junit.framework.AssertionFailedError: Column value mismatch @ column '1', row 1:
Expected: >4<
Found: >7<
at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1278)
at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1190)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1077)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1000)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:957)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:915)
at org.apache.derbyTesting.junit.JDBC.assertSingleValueResultSet(JDBC.java:900)
at org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest.testSimpleXplainOnly(XplainStatisticsTest.java:1183)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
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)

Issue Links

• relates to: DERBY-6216 XPLAIN feature does not work and gives ERROR XCL16: ResultSet not open