Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 35387 invoked from network); 11 Mar 2006 00:46:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 11 Mar 2006 00:46:19 -0000 Received: (qmail 77867 invoked by uid 500); 11 Mar 2006 00:46:19 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 77831 invoked by uid 500); 11 Mar 2006 00:46:18 -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 77822 invoked by uid 99); 11 Mar 2006 00:46:18 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Mar 2006 16:46:18 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Mar 2006 16:46:18 -0800 Received: from ajax (localhost.localdomain [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id BED52D49FA for ; Sat, 11 Mar 2006 00:45:56 +0000 (GMT) Message-ID: <787340071.1142037956779.JavaMail.jira@ajax> Date: Sat, 11 Mar 2006 00:45:56 +0000 (GMT) From: "Deepa Remesh (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-1076) Resolve the ouput differences in upgrade test In-Reply-To: <1372423573.1141428699729.JavaMail.jira@ajax.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-1076?page=all ] Deepa Remesh updated DERBY-1076: -------------------------------- Attachment: phaseTester.diff phaseTester.out When I run the upgrade test on my machine, I get a huge diff. I am attaching the diff and out file. There are few diffs caused by difference in version (10.1.2.2 vs 10.1.2.3) and machine-specific locations. Other than that, the main diffs are caused by the following exceptions in the output: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- getColumnPrivileges(): FAIL -- unexpected exception SQLSTATE(42X05):ERROR 42X05: Table 'SYS.SYSCOLPERMS' does not exist. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311) at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2382) at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2120) at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:303) at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:471) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:220) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:158) at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java:252) at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:344) at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:721) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPreparedStatement.java:118) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(EmbedPreparedStatement20.java:82) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(EmbedPreparedStatement30.java:62) at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92) at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:1614) at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3172) at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumnPrivileges(EmbedDatabaseMetaData.java:1798) at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getMetaDataRS(metadata.java:113) at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:729) at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177) Test metadata finished ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Test metadata starting FAIL -- unexpected exception SQLSTATE(X0Y32):ERROR X0Y32: Table/View 'T' already exists in Schema 'APP'. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:344) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(DataDictionaryImpl.java:1505) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptorNow(DataDictionaryImpl.java:1496) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:1478) at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(CreateTableConstantAction.java:223) at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:56) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:379) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1108) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:517) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:475) at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:190) at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FAIL -- unexpected exception SQLSTATE(X0Y32):ERROR X0Y32: Table/View 'T' already exists in Schema 'APP'. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:392) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(DataDictionaryImpl.java:1606) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptorNow(DataDictionaryImpl.java:1597) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:1579) at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(CreateTableConstantAction.java:223) at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:56) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:361) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1142) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480) at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:190) at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177) Test metadata finished ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- I would appreciate if someone else can also take a look and help me figure out the cause for these differences. Note: For details of running the upgrade test, please see Mamta's comment at http://issues.apache.org/jira/browse/DERBY-573#action_12359550 > Resolve the ouput differences in upgrade test > --------------------------------------------- > > Key: DERBY-1076 > URL: http://issues.apache.org/jira/browse/DERBY-1076 > Project: Derby > Type: Sub-task > Components: Test > Reporter: Deepa Remesh > Priority: Minor > Fix For: 10.2.0.0 > Attachments: phaseTester.diff, phaseTester.out > > The output of running the upgrade test script (runphases.ksh) differs from what is checked into the master file (java\testing\org\apache\derbyTesting\functionTests\master\phaseTester.out). These differences need to be checked to see there are no real issues in the upgrade itself. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira