db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6297) Intermittent failures in XplainStatisticsTest.testSimpleXplainOnly
Date Tue, 27 Aug 2013 14:27:52 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-6297:
--------------------------------------

    Attachment: d6297-1a.diff

Attaching d6297-1a.diff which makes AccessDatabase.schemaExists() close the ResultSet before
returning.

The patch also adds an assert to testXplainOnlyExecutePrepared(). The reason for this, was
that I found during debugging that the getSchemas query was recorded in the xplain tables
much more frequently in this test case than in testSimpleXplainOnly(). But it didn't fail
because it didn't check the xplain tables. With the extra assert, I could reproduce the intermittent
failure much easier in my environment.

All the regression tests passed with the patch.

I also ran XplainStatisticsTest in a loop. It used to fail in approximately one out of five
runs without the fix. With the fix, it ran 96 times in a row without failing. The 97th time,
it failed with the same symptoms as reported in DERBY-6306, which I believe is a different
bug.
                
> Intermittent failures in XplainStatisticsTest.testSimpleXplainOnly
> ------------------------------------------------------------------
>
>                 Key: DERBY-6297
>                 URL: https://issues.apache.org/jira/browse/DERBY-6297
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.11.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>         Attachments: d6297-1a.diff
>
>
> 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)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message