Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 79014 invoked from network); 30 May 2008 19:07:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 May 2008 19:07:07 -0000 Received: (qmail 69239 invoked by uid 500); 30 May 2008 19:07:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 69202 invoked by uid 500); 30 May 2008 19:07:09 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 69143 invoked by uid 99); 30 May 2008 19:07:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2008 12:07:09 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2008 19:06:28 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 6F622234C138 for ; Fri, 30 May 2008 12:06:45 -0700 (PDT) Message-ID: <326980477.1212174405455.JavaMail.jira@brutus> Date: Fri, 30 May 2008 12:06:45 -0700 (PDT) From: "Kathey Marsden (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-3625) XSDA3 error in concateTests in lang.LangHarnessJavaTest In-Reply-To: <1430514740.1208300542803.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-3625: ---------------------------------- Attachment: wombat.zip derbylog.zip Thanks Mike for the useful information. I will work first on getting the log output. Attached is the derby.log and the database. I tried connecting to the database with ij and compressing the table and it compressed ok. This database is actually after that compress. Let me know if you need a db before the compress and I will try to get that. Kathey > XSDA3 error in concateTests in lang.LangHarnessJavaTest > -------------------------------------------------------- > > Key: DERBY-3625 > URL: https://issues.apache.org/jira/browse/DERBY-3625 > Project: Derby > Issue Type: Bug > Components: Regression Test Failure > Affects Versions: 10.4.1.3 > Environment: iseries, ibm1.5.: > java version "1.5.0" > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05) > Classic VM (build 1.5, build JDK-1.5, native threads, jitc_de) > Reporter: Myrna van Lunteren > Attachments: derbylog.zip, wombat.zip > > > I saw this test fail once with a similar error to DERBY-3180 and DERBY-3381. > Unfortunately, possibly because it's an old harness test, the db and derby.log were not saved in the 'fail' directory. > All I have is the stack trace from the output: > 1) concateTests(org.apache.derbyTesting.functionTests.tests.lang.LangHarnessJavaTest)java.sql.SQLException: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation. > at java.lang.Throwable.(Throwable.java:196) > at java.lang.Exception.(Exception.java:41) > at java.sql.SQLException.(SQLException.java:40) > at org.apache.derby.impl.jdbc.EmbedSQLException.(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(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.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) > at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.compressObjects(CleanDatabaseTestSetup.java:267) > at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.cleanDatabase(CleanDatabaseTestSetup.java:166) > at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.setUp(CleanDatabaseTestSetup.java:109) > 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) > Caused by: ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation. > at java.lang.Throwable.(Throwable.java:196) > at java.lang.Exception.(Exception.java:41) > at org.apache.derby.iapi.error.StandardException.(Unknown Source) > at org.apache.derby.iapi.error.StandardException.(Unknown Source) > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.store.raw.data.CopyRowsOperation.writeOptionalDataToBuffer(Unknown Source) > at org.apache.derby.impl.store.raw.data.CopyRowsOperation.(Unknown Source) > at org.apache.derby.impl.store.raw.data.LoggableActions.actionCopyRows(Unknown Source) > at org.apache.derby.impl.store.raw.data.BasePage.copyInto(Unknown Source) > at org.apache.derby.impl.store.raw.data.BasePage.copyAndPurge(Unknown Source) > at org.apache.derby.impl.store.raw.data.StoredPage.moveRecordForCompressAtSlot(Unknown Source) > at org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchRowsForCompress(Unknown Source) > at org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchNextGroup(Unknown Source) > at org.apache.derby.iapi.db.OnlineCompress.defragmentRows(Unknown Source) > at org.apache.derby.iapi.db.OnlineCompress.compressTable(Unknown Source) > at org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown Source) > at org.apache.derby.exe.ac4388a4aax0119x3203xfc8fx0000783ef2472.g0(Unknown Source) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown Source) > at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > ... 24 more -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.