[
https://issues.apache.org/jira/browse/DERBY-6627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037801#comment-14037801
]
Myrna van Lunteren edited comment on DERBY-6627 at 6/19/14 8:15 PM:
--------------------------------------------------------------------
Attaching the derby.log and the jar-ed up database from the failed test' 'fail'
directory.
I wanted to run the consistency checker on the database, but it uses some
territory so I have to check on that and adjust the select from the
page:http://wiki.apache.org/db-derby/DatabaseConsistencyCheck
the error is:
ij> SELECT schemaname || '.' || tablename as TableName,
SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename) AS OK
> > FROM sys.sysschemas s, sys.systables t
> WHERE s.schemaid = t.schemaid
and t.tablety> pe = 'T';
ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR
(TERRITORY_BASED)' are not supported. Types must be comparable. String types
must also have matching collation. If collation does not match, a possible
solution is to cast operands to force them to the default collation (e.g.
SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) =
'T1')
I think this means that SYSCS_CHECK_TABLE doesn't work on collated databases?
was (Author: myrna):
Attaching the derby.log and the jar-ed up database from the failed test' 'fail'
directory.
I wanted to run the consistency checker on the database, but it uses some
territory so I have to check on that and adjust the select from the
page:http://wiki.apache.org/db-derby/DatabaseConsistencyCheck
> failure in lang.MergeStatementTest test_052_multiClob; ERROR XSDG1 and ERROR
> 40XD2:
> -----------------------------------------------------------------------------------
>
> Key: DERBY-6627
> URL: https://issues.apache.org/jira/browse/DERBY-6627
> Project: Derby
> Issue Type: Bug
> Environment: windows 2008,
> java version "1.8.0"
> Java(TM) SE Runtime Environment (build 1.8.0-b132)
> Java HotSpot(TM) Client VM (build 25.0-b70, mixed mode)
> Reporter: Myrna van Lunteren
> Attachments: derby.log_testfail, singleUsedb.jar
>
>
> I saw this during a nightly test run against trunk (at 10.11.0.0 alpha -
> (1603695)), with the GA version of Oracle's Java 8 (this run's details is not
> copied to my public_html area):
> 1)
> test_052_multiClob(org.apache.derbyTesting.functionTests.tests.lang.MergeStatementTest$Collated)java.sql.SQLException:
> The store has been marked for shutdown by an earlier exception.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.commitIfAutoCommit(Unknown Source)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.commitIfAutoCommit(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.resultSetClosing(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertResults(BaseJDBCTestCase.java:1757)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertResults(BaseJDBCTestCase.java:1717)
> at
> org.apache.derbyTesting.functionTests.tests.lang.MergeStatementTest.test_052_multiClob(MergeStatementTest.java:8269)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:118)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:440)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:457)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: ERROR XSLAA: The store has been marked for shutdown by an earlier
> exception.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 84 more
> Caused by: ERROR XSDG1: Page Page(1,Container(-1, 1403145110371)) could not
> be written to disk, please check if the disk is full, or if a file system
> limit, such as a quota or a maximum file size, has been reached.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.clean(Unknown Source)
> at
> org.apache.derby.impl.services.cache.ConcurrentCache.cleanAndUnkeepEntry(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.ConcurrentCache.cleanCache(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.ConcurrentCache.cleanAll(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.checkpoint(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.log.LogToFile.checkpointWithTran(Unknown
> Source)
> at org.apache.derby.impl.store.raw.log.LogToFile.checkpoint(Unknown
> Source)
> at org.apache.derby.impl.store.raw.RawStore.checkpoint(Unknown Source)
> at org.apache.derby.impl.store.raw.log.LogToFile.performWork(Unknown
> Source)
> at
> org.apache.derby.impl.services.daemon.BasicDaemon.serviceClient(Unknown
> Source)
> at org.apache.derby.impl.services.daemon.BasicDaemon.work(Unknown
> Source)
> at org.apache.derby.impl.services.daemon.BasicDaemon.run(Unknown Source)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: ERROR 40XD2: Container Container(-1, 1403145110371) cannot be
> opened; it either has been dropped or does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> ... 15 more
--
This message was sent by Atlassian JIRA
(v6.2#6252)
