Derby
  1. Derby
  2. DERBY-4540

'AssertionFailedError' in 'store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1729)' on SUSE Linux / IBM JIT - r9

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 10.6.1.0, 10.8.3.0
    • Fix Version/s: None
    • Component/s: Test
    • Environment:
    • Urgency:
      Normal
    • Bug behavior facts:
      Regression Test Failure

      Description

      See

      http://dbtg.foundry.sun.com/derby/test/trunk16/jvmAll/testing/testlog/JDK16_IBM60Linux-2.6.16.60-0.21-bigsmp_i686-i686/907276-org.apache.derbyTesting.functionTests.suites.All_diff.txt :

      There was 1 failure:
      1) testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError
      at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:363)
      at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1669)
      at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1729)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
      at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
      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

          Activity

          Hide
          Myrna van Lunteren added a comment -

          This test was recently converted to junit...The original had some instability in it, which was weeded out over time...Perhaps that's all this is also.

          Show
          Myrna van Lunteren added a comment - This test was recently converted to junit...The original had some instability in it, which was weeded out over time...Perhaps that's all this is also.
          Hide
          Dag H. Wanvik added a comment -
          Show
          Dag H. Wanvik added a comment - Just saw this on Vista/Sun JRE 1.6 as well ( http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/testing/Limited/testSummary-942136.html )
          Hide
          Myrna van Lunteren added a comment -

          I ran tests with10.8.0.0 alpha (1057502) with IBM 1.6 SR9 on windows XP and saw this same error. So, still there...

          Show
          Myrna van Lunteren added a comment - I ran tests with10.8.0.0 alpha (1057502) with IBM 1.6 SR9 on windows XP and saw this same error. So, still there...
          Hide
          Kathey Marsden added a comment -

          I saw this on IBM 1.6 on 2011-03-08
          There was 1 failure:
          1) testCaseCS4595B_NonUniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:363)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1669)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCaseCS4595B_NonUniqueIndex(AccessTest.java:1791)
          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:112)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:16)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:16)

          There was a prior failure in the same test. I am not sure if that is related but well could be.

          1) testQualifiers(org.apache.derbyTesting.functionTests.tests.store.AccessTest)java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'.
          at java.lang.Throwable.<init>(Throwable.java:80)
          at java.sql.SQLException.<init>(SQLException.java:153)
          at java.sql.SQLException.<init>(SQLException.java:176)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testQualifiers(AccessTest.java:1807)
          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:112)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:16)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:16)
          Caused by: java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          ... 47 more
          Caused by: ERROR X0Y32: Table/View 'FOO' already exists in Schema 'APP'.
          at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
          at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown Source)
          at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown Source)
          at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown Source)
          at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
          at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
          ... 41 more
          There was 1 failure:

          Show
          Kathey Marsden added a comment - I saw this on IBM 1.6 on 2011-03-08 There was 1 failure: 1) testCaseCS4595B_NonUniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:363) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1669) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCaseCS4595B_NonUniqueIndex(AccessTest.java:1791) 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:112) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:16) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:16) There was a prior failure in the same test. I am not sure if that is related but well could be. 1) testQualifiers(org.apache.derbyTesting.functionTests.tests.store.AccessTest)java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'. at java.lang.Throwable.<init>(Throwable.java:80) at java.sql.SQLException.<init>(SQLException.java:153) at java.sql.SQLException.<init>(SQLException.java:176) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testQualifiers(AccessTest.java:1807) 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:112) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:16) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:16) Caused by: java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 47 more Caused by: ERROR X0Y32: Table/View 'FOO' already exists in Schema 'APP'. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown Source) at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown Source) at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 41 more There was 1 failure:
          Hide
          Kathey Marsden added a comment -

          So the assertion that fails is:
          assertTrue(rtsp.findString("Number of pages visited="+expPages, 1));

          One nice improvement to the test would be for the expected and actual value to print.
          Tracing back I think here we are expecting to visit just one page, so presumably it is something more than that when we fail.

          In DERBY-5113 Knut mentioned that there might be scenarios where derby.storage.pageSize is not reset properly between fixtures. I wonder if that is what happens with this failure as a wrong pageSize could certainly cause this problem. I think there is a pretty good chance this won't happen again now that the property reset code has been added to tearDown in the test. I think we should wait a month and see if it happens again and if not resolve this issue.

          Show
          Kathey Marsden added a comment - So the assertion that fails is: assertTrue(rtsp.findString("Number of pages visited="+expPages, 1)); One nice improvement to the test would be for the expected and actual value to print. Tracing back I think here we are expecting to visit just one page, so presumably it is something more than that when we fail. In DERBY-5113 Knut mentioned that there might be scenarios where derby.storage.pageSize is not reset properly between fixtures. I wonder if that is what happens with this failure as a wrong pageSize could certainly cause this problem. I think there is a pretty good chance this won't happen again now that the property reset code has been added to tearDown in the test. I think we should wait a month and see if it happens again and if not resolve this issue.
          Hide
          Kathey Marsden added a comment -

          On second thought I think I will go ahead and resolve this issue and assume the property reset of DERBY-5113 fixed the issue. We can reopen the issue if that was not it.

          Show
          Kathey Marsden added a comment - On second thought I think I will go ahead and resolve this issue and assume the property reset of DERBY-5113 fixed the issue. We can reopen the issue if that was not it.
          Hide
          Mamta A. Satoor added a comment -

          I am trying to backport DERBY-5044 to 10.8 in my client. When I ran the junite suite with the backport on 10.8.1.6 with IBM 1.6 SR6 on my windows XP laptop, the following error showed up
          testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:402)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1708)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1768)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
          at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:16)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:16)

          Show
          Mamta A. Satoor added a comment - I am trying to backport DERBY-5044 to 10.8 in my client. When I ran the junite suite with the backport on 10.8.1.6 with IBM 1.6 SR6 on my windows XP laptop, the following error showed up testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:402) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1708) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1768) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:16) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:16)
          Hide
          Knut Anders Hatlen added a comment -

          Seen again on trunk: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/testlog/vista/1211980-suitesAll_diff.txt

          Reopening since it looks like DERBY-5113 did not fix this issue.

          Show
          Knut Anders Hatlen added a comment - Seen again on trunk: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/testlog/vista/1211980-suitesAll_diff.txt Reopening since it looks like DERBY-5113 did not fix this issue.
          Hide
          Mike Matrigali added a comment -

          saw it in nightly's, windows, ibm16 jvm, head of 10.8 branch

          http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm16/1232727-suites.All_diff.txt
          There was 1 failure:
          1) testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:402)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1708)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1768)
          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:113)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:18)
          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:51)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:18)

          Show
          Mike Matrigali added a comment - saw it in nightly's, windows, ibm16 jvm, head of 10.8 branch http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm16/1232727-suites.All_diff.txt There was 1 failure: 1) testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:402) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1708) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1768) 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:113) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:18) 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:51) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:18)
          Hide
          Mike Matrigali added a comment -

          it looks like this has never been fixed, so removing fixed version and adding last version where it was seen.

          Show
          Mike Matrigali added a comment - it looks like this has never been fixed, so removing fixed version and adding last version where it was seen.
          Hide
          Mike Matrigali added a comment -

          In the latest example of the problem the following line at AccessTest.java:402 is the problem:
          assertTrue(rtsp.findString("Number of pages visited="+expPages, 1));

          Show
          Mike Matrigali added a comment - In the latest example of the problem the following line at AccessTest.java:402 is the problem: assertTrue(rtsp.findString("Number of pages visited="+expPages, 1));
          Hide
          Mike Matrigali added a comment -

          failed in nightly's, 10.8 branch, windows, ibm142

          From new diagnostics, the test is expecting 1 page visited but query visited 2 pages. Maybe this is some kind of background task
          cleanup issue where there are still some deleted rows in the btree. query plan looks like it is using index correctly.

          http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1233151-suites.All_diff.txt

          There was 1 failure:
          1) testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError: RuntimeStatisticsParser.findstring(Number of pages visited= 1) returned falsefull runtime statistics = Statement Name:
          null
          Statement Text:
          select * from foo where a = 2
          Parse Time: 0
          Bind Time: 0
          Optimize Time: 0
          Generate Time: 0
          Compile Time: 0
          Execute Time: 0
          Begin Compilation Timestamp : null
          End Compilation Timestamp : null
          Begin Execution Timestamp : null
          End Execution Timestamp : null
          Statement Execution Plan Text:
          Index Row to Base Row ResultSet for FOO:
          Number of opens = 1
          Rows seen = 0
          Columns accessed from heap =

          {1}

          constructor time (milliseconds) = 0
          open time (milliseconds) = 0
          next time (milliseconds) = 0
          close time (milliseconds) = 0
          optimizer estimated row count: 1.00
          optimizer estimated cost: 20.96
          Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer
          Number of opens = 1
          Rows seen = 0
          Rows filtered = 0
          Fetch Size = 1
          constructor time (milliseconds) = 0
          open time (milliseconds) = 0
          next time (milliseconds) = 0
          close time (milliseconds) = 0

          scan information:
          Bit set of columns fetched=All
          Number of columns fetched=2
          Number of deleted rows visited=0
          Number of pages visited=2
          Number of rows qualified=0
          Number of rows visited=0
          Scan type=btree
          Tree height=-1
          start position:
          >= on first 1 column(s).
          Ordered null semantics on the following columns:
          stop position:
          > on first 1 column(s).
          Ordered null semantics on the following columns:
          qualifiers:
          None
          optimizer estimated row count: 1.00
          optimizer estimated cost: 20.96

          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:404)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1715)
          at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1775)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
          at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java(Compiled Code))
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined Compiled Code))
          at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled Code))
          at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code))
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined Compiled Code))
          at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled Code))
          at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code))
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined Compiled Code))
          at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled Code))
          at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code))

          FAILURES!!!
          Tests run: 11966, Failures: 1, Errors: 0

          Show
          Mike Matrigali added a comment - failed in nightly's, 10.8 branch, windows, ibm142 From new diagnostics, the test is expecting 1 page visited but query visited 2 pages. Maybe this is some kind of background task cleanup issue where there are still some deleted rows in the btree. query plan looks like it is using index correctly. http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1233151-suites.All_diff.txt There was 1 failure: 1) testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError: RuntimeStatisticsParser.findstring(Number of pages visited= 1) returned falsefull runtime statistics = Statement Name: null Statement Text: select * from foo where a = 2 Parse Time: 0 Bind Time: 0 Optimize Time: 0 Generate Time: 0 Compile Time: 0 Execute Time: 0 Begin Compilation Timestamp : null End Compilation Timestamp : null Begin Execution Timestamp : null End Execution Timestamp : null Statement Execution Plan Text: Index Row to Base Row ResultSet for FOO: Number of opens = 1 Rows seen = 0 Columns accessed from heap = {1} constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 optimizer estimated row count: 1.00 optimizer estimated cost: 20.96 Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer Number of opens = 1 Rows seen = 0 Rows filtered = 0 Fetch Size = 1 constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 scan information: Bit set of columns fetched=All Number of columns fetched=2 Number of deleted rows visited=0 Number of pages visited=2 Number of rows qualified=0 Number of rows visited=0 Scan type=btree Tree height=-1 start position: >= on first 1 column(s). Ordered null semantics on the following columns: stop position: > on first 1 column(s). Ordered null semantics on the following columns: qualifiers: None optimizer estimated row count: 1.00 optimizer estimated cost: 20.96 at org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:404) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1715) at org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1775) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code)) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code)) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java(Compiled Code)) at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined Compiled Code)) at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled Code)) at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code)) at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined Compiled Code)) at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled Code)) at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code)) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined Compiled Code)) at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled Code)) at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code)) FAILURES!!! Tests run: 11966, Failures: 1, Errors: 0
          Hide
          Myrna van Lunteren added a comment -

          Marking this as a duplicate of DERBY-5377.

          Show
          Myrna van Lunteren added a comment - Marking this as a duplicate of DERBY-5377 .
          Hide
          Knut Anders Hatlen added a comment -

          [bulk update: close all resolved issues that haven't had any activity the last year]

          Show
          Knut Anders Hatlen added a comment - [bulk update: close all resolved issues that haven't had any activity the last year]

            People

            • Assignee:
              Unassigned
              Reporter:
              Ole Solberg
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development