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 "Mike Matrigali (JIRA)" <ji...@apache.org> on 2007/05/05 03:03:16 UTC
[jira] Resolved: (DERBY-2611) upgrade test incorrectly tries to
test in place compress in 10.0 release.
[ https://issues.apache.org/jira/browse/DERBY-2611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali resolved DERBY-2611.
-----------------------------------
Resolution: Fixed
Fix Version/s: 10.3.0.0
checkin 535429 fixes the two errors from testNegValueSupportedLogRecord.
The other two errors do not look like they are related so I will report
those under a separate item.
The fix was just to insure that the test did not try to test in place compress
log record in 10.0, as it was added in 10.1.
> upgrade test incorrectly tries to test in place compress in 10.0 release.
> -------------------------------------------------------------------------
>
> Key: DERBY-2611
> URL: https://issues.apache.org/jira/browse/DERBY-2611
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure
> Affects Versions: 10.3.0.0
> Environment: windows XP, single processor laptop, ibm15 JVM
> m1_ibm15:30>sysinfo
> ------------------ Java Information ------------------
> Java Version: 1.5.0
> Java Vendor: IBM Corporation
> Java home: c:\p4\m1\ibm15\jre
> Java classpath: c:/p4/m1/classes;c:/p4/m1/tools/java/jdbctests.zip;c:/p4/m1/too
> ls/java/jakarta-oro-2.0.8.jar;c:/p4/m1/tools/java/jgl3.1.0.jar;c:/p4/m1/tools/ja
> va/jndi/providerutil.jar;c:/p4/m1/tools/java/jndi/ldap.jar;c:/p4/m1/tools/java/j
> ndi/jndi.jar;c:/p4/m1/tools/java/jnl1.0F.zip;c:/p4/m1/tools/java/junit.jar;c:/p4
> /m1/tools/java/servlet-2_2b.jar;c:/p4/m1/tools/java/xslt4j-2_5_0/xercesImpl.jar;
> c:/p4/m1/tools/java/xslt4j-2_5_0/xml-apis.jar;c:/p4/m1/tools/java/xslt4j-2_5_0/x
> alan.jar
> OS name: Windows XP
> OS architecture: x86
> OS version: 5.1 build 2600 Service Pack 2
> Java user name: mikem
> Java user home: C:\Documents and Settings\Administrator
> Java user dir: C:\p4\m1\systest\newout\upgrade
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.5
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\p4\m1\classes] 10.3.0.0 alpha - (1)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> Current Locale : [English/United States [en_US]]
> Found support for locale: [cs]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [de_DE]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [es]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [fr]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [hu]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [it]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [ja_JP]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [ko_KR]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [pl]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [pt_BR]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [ru]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [zh_CN]
> version: 10.3.0.0 alpha - (1)
> Found support for locale: [zh_TW]
> version: 10.3.0.0 alpha - (1)
> ------------------------------------------------------
> Reporter: Mike Matrigali
> Assigned To: Mike Matrigali
> Fix For: 10.3.0.0
>
>
> When trying to run upgrade test in trunk with all releases available for upgrade to test found at:
> https://svn.apache.org/repos/asf/db/derby/jars/10.2.2.0/
> I got 4 errors (not including those that are part of DERBY-2598).:
> 1) testNegValueSupportedLogRecord(org.apache.derbyTesting.functionTests.tests.up
> gradeTests.Changes10_3)java.sql.SQLException: 'SYSCS_UTIL.SYSCS_INPLACE_COMPRESS
> _TABLE' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(StandardExcept
> ion.java:305)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Sta
> ticMethodCallNode.java:224)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaT
> oSQLValueNode.java:243)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(CallSta
> tementNode.java:145)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.ja
> va:314)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:
> 88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareIn
> ternalStatement(GenericLanguageConnectionContext.java:742)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:567
> )
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:516
> )
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.chec
> kDataToCase606(Changes10_3.java:177)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.test
> NegValueSupportedLogRecord(Changes10_3.java:118)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
> :64)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
> mpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> 2) testGetTablesModify(org.apache.derbyTesting.functionTests.tests.jdbcapi.Data
> aseMetaDataTest)java.sql.SQLException: Use of 'XML' requires database to be upg
> aded from version 10.0 to version 10.1 or later.
> at org.apache.derby.iapi.error.StandardException.newException(StandardExcep
> ion.java:356)
> at org.apache.derby.impl.sql.catalog.DD_Version.checkVersion(DD_Version.jav
> :788)
> at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.checkVersion(DataDi
> tionaryImpl.java:8487)
> at org.apache.derby.impl.sql.compile.SQLParser.checkVersion(SQLParser.java:
> 00)
> at org.apache.derby.impl.sql.compile.SQLParser.XMLType(SQLParser.java:4181)
> at org.apache.derby.impl.sql.compile.SQLParser.dataTypeCommon(SQLParser.jav
> :3607)
> at org.apache.derby.impl.sql.compile.SQLParser.dataTypeDDL(SQLParser.java:3
> 37)
> at org.apache.derby.impl.sql.compile.SQLParser.columnDefinition(SQLParser.j
> va:3400)
> at org.apache.derby.impl.sql.compile.SQLParser.tableElement(SQLParser.java:
> 368)
> at org.apache.derby.impl.sql.compile.SQLParser.tableElementList(SQLParser.j
> va:3209)
> at org.apache.derby.impl.sql.compile.SQLParser.tableDefinition(SQLParser.ja
> a:10992)
> at org.apache.derby.impl.sql.compile.SQLParser.createStatements(SQLParser.j
> va:1811)
> at org.apache.derby.impl.sql.compile.SQLParser.StatementPart(SQLParser.java
> 1718)
> at org.apache.derby.impl.sql.compile.SQLParser.Statement(SQLParser.java:163
> )
> at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.j
> va:151)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.j
> va:280)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java
> 88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareI
> ternalStatement(GenericLanguageConnectionContext.java:742)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:56
> )
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:51
> )
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.DatabaseMetaDataTest
> createTablesForTest(DatabaseMetaDataTest.java:1123)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.DatabaseMetaDataTest
> testGetTablesModify(DatabaseMetaDataTest.java:912)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
> :64)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
> mpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> 3) testNegValueSupportedLogRecord(org.apache.derbyTesting.functionTests.tests.up
> gradeTests.Changes10_3)ERROR 42Y03: 'SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE' is
> not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(StandardExcept
> ion.java)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Sta
> ticMethodCallNode.java)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaT
> oSQLValueNode.java)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bind(CallStatementNod
> e.java)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.ja
> va)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareIn
> ternalStatement(GenericLanguageConnectionContext.java)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.chec
> kDataToCase606(Changes10_3.java:177)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.test
> NegValueSupportedLogRecord(Changes10_3.java:122)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
> :64)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
> mpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> 4) Upgrade Phase: UPGRADEjava.sql.SQLException: Failed to start database 'single
> Use/oneuse0', see the next exception for details.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExcepti
> onFactory.java:45)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:94)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:173)
> at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnectio
> n.java:2119)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.j
> ava:1783)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:24
> 9)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:74)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:209)
> at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource
> .java:479)
> at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource
> .java:423)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.PhaseChanger.set
> Up(PhaseChanger.java:94)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> FAILURES!!!
> Tests run: 505, Failures: 0, Errors: 4
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.