db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Updated: (DERBY-1076) Resolve the ouput differences in upgrade test
Date Sat, 11 Mar 2006 01:09:37 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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.<br>
<br>
Satheesh<br>
<br>
Deepa Remesh (JIRA) wrote:<br>
<blockquote cite="mid787340071.1142037956779.JavaMail.jira@ajax"
 type="cite">
  <pre wrap="">     [ <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-1076?page=all">http://issues.apache.org/jira/browse/DERBY-1076?page=all</a>
]

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.&lt;init&gt;(EmbedPreparedStatement.java:118)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.&lt;init&gt;(EmbedPreparedStatement20.java:82)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.&lt;init&gt;(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 <a class="moz-txt-link-freetext"
href="http://issues.apache.org/jira/browse/DERBY-573#action_12359550">http://issues.apache.org/jira/browse/DERBY-573#action_12359550</a>

  </pre>
  <blockquote type="cite">
    <pre wrap="">Resolve the ouput differences in upgrade test
---------------------------------------------

         Key: DERBY-1076
         URL: <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-1076">http://issues.apache.org/jira/browse/DERBY-1076</a>
     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.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
</body>
</html>


Mime
View raw message