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 "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2006/03/11 01:45:56 UTC
[jira] Updated: (DERBY-1076) Resolve the ouput differences in
upgrade test
[ 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.
--
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
Re: [jira] Updated: (DERBY-1076) Resolve the ouput differences in upgrade test
Posted by Deepa Remesh <dr...@gmail.com>.
On 3/10/06, Satheesh Bandaram <sa...@sourcery.org> wrote:
> 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.
The first failure is in soft upgrade mode. Thanks Satheesh for looking
into this.
Deepa