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 "Kathey Marsden (JIRA)" <ji...@apache.org> on 2011/01/06 00:22:46 UTC
[jira] Commented: (DERBY-4157) Create a test to verify that virgin
metadata is identical to hard-upgraded metadata
[ https://issues.apache.org/jira/browse/DERBY-4157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12978032#action_12978032 ]
Kathey Marsden commented on DERBY-4157:
---------------------------------------
I merged the refactoring change, revision 764912 to 10.5, ran upgrade tests and checked into 10.5 with revision 105585. Later I ran the full suite with the DERBY-4913 patch and saw these failures in the collation tests, perhaps from an insufficiently removed single use database from the upgrade tests. I will investigate and file an issue if it shows up in the nightly runs.
1) CollationTest:territory=nojava.sql.SQLException: Failed to create database 'singleUse/oneusea', see the next exception for details.
at java.lang.Throwable.<init>(Throwable.java:80)
at java.sql.SQLException.<init>(SQLException.java:153)
at java.sql.SQLException.<init>(SQLException.java:176)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:64)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142)
at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:278)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2452)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:396)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:238)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java:479)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java:423)
at org.apache.derbyTesting.junit.Decorator$2.setUp(Decorator.java:189)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
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 org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
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)
Caused by: java.sql.SQLException: Failed to create database 'singleUse/oneusea', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:73)
... 33 more
Caused by: java.sql.SQLException: Directory C:\cygwin\test3\system\C:\cygwin\test3\system\singleUse\oneusea already exists.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:73)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2204)
... 31 more
Caused by: ERROR XBM0J: Directory C:\cygwin\test3\system\C:\cygwin\test3\system\singleUse\oneusea already exists.
at java.lang.Throwable.<init>(Throwable.java:67)
at org.apache.derby.iapi.error.StandardException.<init>(StandardException.java:80)
at org.apache.derby.iapi.error.StandardException.<init>(StandardException.java:75)
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:285)
at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(StorageFactoryService.java:670)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(StorageFactoryService.java:650)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1782)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java:1044)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java:596)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2446)
... 30 more
2) CollationTest:territory=nojava.sql.SQLException: Failed to create database 'singleUse/oneusea', see the next exception for details.
at java.lang.Throwable.<init>(Throwable.java:80)
at java.sql.SQLException.<init>(SQLException.java:153)
at java.sql.SQLException.<init>(SQLException.java:176)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:64)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142)
at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:278)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2452)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:396)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:238)
at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
at java.sql.DriverManager.getConnection(DriverManager.java:322)
at java.sql.DriverManager.getConnection(DriverManager.java:297)
at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:95)
at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:47)
at org.apache.derbyTesting.junit.TestConfiguration.openConnection(TestConfiguration.java:1363)
at org.apache.derbyTesting.junit.DropDatabaseSetup.tearDown(DropDatabaseSetup.java:54)
at junit.extensions.TestSetup$1.protect(TestSetup.java:20)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
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)
Caused by: java.sql.SQLException: Failed to create database 'singleUse/oneusea', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:73)
... 32 more
Caused by: java.sql.SQLException: Directory C:\cygwin\test3\system\C:\cygwin\test3\system\singleUse\oneusea already exists.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:73)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2204)
... 30 more
Caused by: ERROR XBM0J: Directory C:\cygwin\test3\system\C:\cygwin\test3\system\singleUse\oneusea already exists.
at java.lang.Throwable.<init>(Throwable.java:67)
at org.apache.derby.iapi.error.StandardException.<init>(StandardException.java:80)
at org.apache.derby.iapi.error.StandardException.<init>(StandardException.java:75)
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:285)
at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(StorageFactoryService.java:670)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(StorageFactoryService.java:650)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1782)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java:1044)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java:596)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2446)
... 29 more
FAILURES!!!
Tests run: 11303, Failures: 0, Errors: 2
> Create a test to verify that virgin metadata is identical to hard-upgraded metadata
> -----------------------------------------------------------------------------------
>
> Key: DERBY-4157
> URL: https://issues.apache.org/jira/browse/DERBY-4157
> Project: Derby
> Issue Type: Improvement
> Components: Test
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-4157-01-aa-refactor.diff, derby-4157-02-aa-newtest.diff, derby-4157-02-ab-newtest.diff
>
>
> We should write a test to verify that the metadata is correct for each release for all hard-upgrade trajectories which terminate in that release. The test should examine all system tables. Note that if there are N releases, then there will (2<sup>N</sup> - N) - 1 trajectories to examine.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.