Derby
  1. Derby
  2. DERBY-4309

Intermittent errors in the Sun trunk nightlies upgrade tests especially on Vista

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.5.1.1, 10.5.2.0, 10.6.1.0
    • Fix Version/s: None
    • Component/s: Test
    • Environment:
      Sun JDK 1.6 under Windows XP and Vista
    • Urgency:
      Normal
    • Bug behavior facts:
      Regression, Regression Test Failure

      Description

      This is a follow up issue of what was being discussed here: http://www.nabble.com/Lots-of-errors-in-the-sun-trunk--nightlies-especially-on-vista-to24489773.html

      At this point, the errors seem to be intermittent and they seem to happen on both Vista and XP (as reported by Mamta), with special incidence on Vista.

      Kathey said she's seen them as far as April 6th which is after the 10.5 branched.

      Here is a list of failing tests when this occurs.
      *************************************************************
      1) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse55', see the next exception for details.
      2) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse56', see the next exception for details.
      3) testProcedureSignature(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1)java.sql.SQLException: PROCEDURE 'GC' already exists.
      4) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse55', see the next exception for details.
      5) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse56', see the next exception for details.
      6) testTableFunctionDeclaration(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)java.sql.SQLException: FUNCTION 'SVNLOGREADER' already exists.
      7) testSQLRoles(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)java.sql.SQLException: Role 'FOO' already exists.
      1) testRunTests(org.apache.derbyTesting.functionTests.tests.derbynet.RuntimeInfoTest)junit.framework.AssertionFailedError
      2) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<0> but was:<6>
      3) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]>
      4) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]>
      5) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected:<false> but was:<true>
      6) testTableFunctionDeclaration(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.AssertionFailedError: Expected error(s) ' 42X01' but no error was thrown.
      7) testErrorMessage(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.AssertionFailedError: expected error while creating unique constraint over nullable column
      8) testSQLRolesBasic(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]>
      9) testSYSCS_INPLACE_COMPRESS_TABLE(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_6)junit.framework.AssertionFailedError: Expected error(s) ' 42X05' but no error was thrown.
      10) testProcedureSignature(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1)junit.framework.AssertionFailedError: Expected error(s) ' XCL47' but no error was thrown.
      11) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[XCL47]> but was:<[42Z60]>
      12) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]>
      13) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade
      14) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade
      15) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error(s) ' 42Y03' but no error was thrown.
      16) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected:<false> but was:<true>
      17) testTableFunctionDeclaration(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<X[CL47]> but was:<X[0Y68]>
      18) testUniqueConstraint(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.AssertionFailedError: Expected error(s) ' 42Z20' but no error was thrown.
      19) testErrorMessage(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.ComparisonFailure: expected state 42831 expected:<42[831]> but was:<42[Z93]>
      20) testUpdateStatisticsProcdure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: Expected error(s) ' 42Y03' but no error was thrown.
      21) testDeterminismKeyword(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: expected compile error: XCL47
      22) testGenerationClauses(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: expected compile error: XCL47
      23) testSQLRolesBasic(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[XCL47]> but was:<[42Z60]>
      24) testSetXplainStyleProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_6)junit.framework.AssertionFailedError: Expected error(s) ' 42Y03' but no error was thrown.
      25) testSYSCS_INPLACE_COMPRESS_TABLE(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_6)junit.framework.AssertionFailedError: Expected error(s) ' 42X05' but no error was thrown.
      26) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<0> but was:<6>
      27) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]>
      28) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]>
      29) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected:<false> but was:<true>
      30) testTableFunctionDeclaration(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[42X01]> but was:<[X0Y68]>
      31) testUniqueConstraint(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)junit.framework.AssertionFailedError: Expected error(s) ' 23505' but no error was thrown.
      32) testUpdateStatisticsProcdure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: Expected error(s) ' 42Y03' but no error was thrown.
      33) testDeterminismKeyword(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: expected compile error: 42X01
      34) testGenerationClauses(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: expected compile error: 42X01
      35) testSQLRolesBasic(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]>
      36) testSQLRoles(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_5)junit.framework.AssertionFailedError: Expected error(s) ' 42X01' but no error was thrown.
      37) testSetXplainStyleProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_6)junit.framework.AssertionFailedError: Expected error(s) ' 42Y03' but no error was thrown.
      38) testSYSCS_INPLACE_COMPRESS_TABLE(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_6)junit.framework.AssertionFailedError: Expected error(s) ' 42X05' but no error was thrown.
      39) Upgrade Tests from 10.0.2.1junit.framework.AssertionFailedError: C:\cludev\jagtmp\autoderbyN_regression\suitesAll_7\log\system\singleUse\oneuse57\db.lck

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Tiago R. Espinha
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development