Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6772

intermittent test failure in LangScripts schemas

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.12.1.1
    • Fix Version/s: 10.12.1.1
    • Component/s: Test
    • Labels:
      None
    • Environment:
      windows 2008, ibm 1.7
    • Bug behavior facts:
      Regression Test Failure

      Description

      I saw a failure in LangScripts schemas.sql on a trunk test run on windows 2008 with ibm 1.7:

      1) schemas(org.apache.derbyTesting.functionTests.tests.lang.LangScripts)junit.framework.ComparisonFailure: Output at line 477 expected:<...                   |[BTREE (1)]      > but was:<...                   |[NULL     ]      >
      	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:110)
      	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:201)
      	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:120)
      	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:443)
      	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:460)
      	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:58)
      

      See: http://people.apache.org/~myrnavl/derby_test_results/main/windows/testSummary-1639825.html

      Without code changes this same test passed fine with other jvms.
      The diff is resulting from this query:

      select schemaname, tablename, descriptor as descr
      from sys.sysschemas s, sys.sysconglomerates c , sys.systables t
      where CAST(t.tablename AS VARCHAR(128)) = 'SAMPLETAB'
              and s.schemaid = c.schemaid
              and c.tableid = t.tableid
      order by schemaname, tablename;
      

      This gives three rows: In the master file (removed some spaces for display):

      SCHEMANAME  |TABLENAME        |DESCR
      -------------------------------------------------------------------------
      APP                     |SAMPLETAB        |NULL
      TEST                   |SAMPLETAB        |BTREE (1)
      TEST                   |SAMPLETAB        |NULL
      

      In the failed situation, the 'TEST' rows are ordered differently.

        Attachments

          Activity

            People

            • Assignee:
              myrna Myrna van Lunteren
              Reporter:
              myrna Myrna van Lunteren

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment