[
https://issues.apache.org/jira/browse/DERBY-4309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13069402#comment-13069402
]
Knut Anders Hatlen commented on DERBY-4309:
-------------------------------------------
This happened again today.
http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/testlog/vista/1149242-derbyall_diff.txt
The first test that failed was:
1)
testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError:
Old minor (driver): expected:<0> but was:<9>
at
org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup.testOldVersion(BasicSetup.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
(In the original report, there was a failure in RuntimeInfoTest before the
failure in BasicSetup.testOldVersion(), but that was probably DERBY-4307.)
> Intermittent errors in the Sun trunk nightlies upgrade tests especially on
> Vista
> ---------------------------------------------------------------------------------
>
> Key: DERBY-4309
> URL: https://issues.apache.org/jira/browse/DERBY-4309
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.5.1.1, 10.5.2.0, 10.6.1.0
> Environment: Sun JDK 1.6 under Windows XP and Vista
> Reporter: Tiago R. Espinha
> Labels: derby_triage10_5_2
>
> 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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
