Re: [jira] Updated: (DERBY-1076) Resolve the ouput differences in upgrade test

[Satheesh Bandaram]

The first failure seems to mean either SYS.SYSCOLPERMS is not getting created as part of hard upgrade or more likely, 10.2 metadata query is referencing SYS.SYSCOLPERMS which is not be present in soft upgrade mode. If you can confirm which one of these is the problem, I can look into this. Satheesh Deepa Remesh (JIRA) wrote: [ 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.<init>(EmbedPreparedStatement.java:118) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(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.