Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 12273 invoked from network); 3 Jun 2007 23:52:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Jun 2007 23:52:37 -0000 Received: (qmail 37730 invoked by uid 500); 3 Jun 2007 23:52:41 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 37682 invoked by uid 500); 3 Jun 2007 23:52:40 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 37667 invoked by uid 99); 3 Jun 2007 23:52:40 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jun 2007 16:52:40 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jun 2007 16:52:36 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id E844E714187 for ; Sun, 3 Jun 2007 16:52:15 -0700 (PDT) Message-ID: <17856442.1180914735948.JavaMail.jira@brutus> Date: Sun, 3 Jun 2007 16:52:15 -0700 (PDT) From: "Myrna van Lunteren (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-2645) upgrade test failures with weme 6.1. In-Reply-To: <14043393.1179169396204.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren closed DERBY-2645. ------------------------------------- Resolution: Fixed Fix Version/s: 10.3.0.0 I didn't fully debug this, but I theorize that what happens, is that the test framework attempts to create an EmbeddedSimpleDataSource, but instead of finding this with the 10.0 derby.jar, it finds the 10.3 version and uses that. Hence, the db is really created with 10.3 and the test fails. I did a manual simple test, and created a 10.0.2.1 database (with one very simple table) using jdk15, then used JSR169 to upgrade to 10.3 with soft upgrade, then went back at it with jdk15 and that was fine. Then I used the simple 10.0 database with very simple table and did a hard upgrade to 10.3 with JSR169 and that was fine too. I don't think we should automate that test, it was just to make sure upgrade from 10.0 works also for JSR169. Prevented test from running upgrade from 10.0 with JSR169 with revisions: http://svn.apache.org/viewvc?view=rev&revision=542984 http://svn.apache.org/viewvc?view=rev&revision=543809 > 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 > Assignee: Myrna van Lunteren > Fix For: 10.3.0.0 > > > 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 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 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: 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 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: but was: > 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 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: but was: > 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 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 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.