You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2007/05/30 05:58:15 UTC
[jira] Commented: (DERBY-2645) upgrade test failures with weme 6.1.
[ https://issues.apache.org/jira/browse/DERBY-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12500017 ]
Myrna van Lunteren commented on DERBY-2645:
-------------------------------------------
The problem only happens when upgrading from 10.0.2.1
> upgrade test failures with weme 6.1.
> ------------------------------------
>
> Key: DERBY-2645
> URL: https://issues.apache.org/jira/browse/DERBY-2645
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure
> Affects Versions: 10.3.0.0
> Environment: windows 2000, weme6.1 (j2ME/CDCFoundation/JSR169)
> Reporter: Myrna van Lunteren
>
> Since activating the upgrade tests for weme6.1 (and resolving some of the failures) I can now see 1 new error and 13 new failures. Some of these may warrant their own bug; some are probably caused by the initial problem.
> (In the section below, I'm skipping the junit.extensions.* part of the stack.)
> error:
> 2)
> testProcedureSignature(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1)java.sql.SQLException: PROCEDURE 'GC' already exists.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.execute.CreateAliasConstantAction.executeConstantAction(Unknown Source)
> at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(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.execute(Unknown Source)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1.testProcedureSignature(Changes10_1.java:87)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ....
> ------------------
> failures:
> 6) testProcedureSignature(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1)junit.framework.AssertionFailedError: Expected error 'XCL47' but no error was thrown.
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:703)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1.testProcedureSignature(Changes10_1.java:82)
> at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> at <unknown class>.<unknown method>(Unknown Source)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ...
> 2) and, 11)
> testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<0> but was:<3>
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup.testOldVersion(BasicSetup.java:61)
> at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> at <unknown class>.<unknown method>(Unknown Source)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ...
> --------------------
> 3), 7) and 12), with a variation in originating line number in Changes10_2:(marked (#) in the stack below).
> and expected error number
> testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)
> (3, 12) junit.framework.ComparisonFailure: Unexpected SQL state. expected:<...X01> but was:<...Z60>
> (7)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<XCL47> but was:<42Z60>
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:523)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:585)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:706)
> (3, 12) at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2.testGrantRevokeStatements(Changes10_2.java:241)
> (7) at
> org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2.testGrantRevokeStatements(Changes10_2.java:250)
> at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> at <unknown class>.<unknown method>(Unknown Source)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ...
> Caused by: java.sql.SQLException: GRANT not allowed unless database property derby.database.sqlAuthorization has value 'TRUE'.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.SQLParser.checkSqlStandardAccess(Unknown Source)
> at org.apache.derby.impl.sql.compile.SQLParser.grantStatement(Unknown Source)
> at org.apache.derby.impl.sql.compile.SQLParser.StatementPart(Unknown Source)
> at org.apache.derby.impl.sql.compile.SQLParser.Statement(Unknown Source)
> at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:701)
> (3, 12) at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2.testGrantRevokeStatements(Changes10_2.java:241)
> (7) at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2.testGrantRevokeStatements(Changes10_2.java:250)
> at at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> ... 64 more
> ------------------
> 4), 8) and 13)
> testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<DBA> but was:<APP>
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2.checkSystemSchemasOwner(Changes10_2.java:300)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2.testDatabaseOwnerChange(Changes10_2.java:282)
> at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> at <unknown class>.<unknown method>(Unknown Source)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ...
> ------------------
> 5) , 10) and 14)
> testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected:<false> but was:<true>
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.tryReloading(Changes10_3.java:362)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.assertPolicyReloaderDoesNotExist(Changes10_3.java:340)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.testPolicyReloadingProcedure(Changes10_3.java:311)
> at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> at <unknown class>.<unknown method>(Unknown Source)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ...
> ------------------
> 9) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown.
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:703)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.testImportExportLobsProcedures(Changes10_3.java:252)
> at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> at <unknown class>.<unknown method>(Unknown Source)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> ...
> ------------------
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.