Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E6B764019 for ; Wed, 22 Jun 2011 00:07:13 +0000 (UTC) Received: (qmail 21228 invoked by uid 500); 22 Jun 2011 00:07:13 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 21197 invoked by uid 500); 22 Jun 2011 00:07:13 -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 21190 invoked by uid 99); 22 Jun 2011 00:07:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2011 00:07:13 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2011 00:07:10 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id A2B9E427490 for ; Wed, 22 Jun 2011 00:06:47 +0000 (UTC) Date: Wed, 22 Jun 2011 00:06:47 +0000 (UTC) From: "Mike Matrigali (JIRA)" To: derby-dev@db.apache.org Message-ID: <1774815046.26818.1308701207663.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <325197893.22950.1308615767428.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (DERBY-5289) Unable to boot 10.5.1.1 database MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-5289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052957#comment-13052957 ] Mike Matrigali commented on DERBY-5289: --------------------------------------- I still think there may be an architectural problem. I believe we are counting on upgrade getting rid of invalid SPS's during the code that is executing on the stack of this issue. But it seems that in order to do it, it is reading all the SPS's from disk and possibly using bad read/write code to do so. At least that is what it looks like for the stacks shown, have not debugged this. > Unable to boot 10.5.1.1 database > -------------------------------- > > Key: DERBY-5289 > URL: https://issues.apache.org/jira/browse/DERBY-5289 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.7.1.1, 10.8.1.2 > Environment: >sysinfo > ------------------ Java Information ------------------ > Java Version: 1.6.0_26 > Java Vendor: Sun Microsystems Inc. > Java home: C:\Program Files (x86)\Java\jre6 > Java classpath: .;C:\Program Files (x86)\Java\jre6\lib\ext\QTJava.zip;C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\bin\../lib/derby.jar;C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\bin\../lib/derbynet.jar;C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\bin\../lib/derbyclient.jar;C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\bin\../lib/derbytools.jar > OS name: Windows 7 > OS architecture: x86 > OS version: 6.1 > Java user name: bmason > Java user home: C:\Users\BMASON > Java user dir: C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\bin > java.specification.name: Java Platform API Specification > java.specification.version: 1.6 > java.runtime.version: 1.6.0_26-b03 > --------- Derby Information -------- > JRE - JDBC: Java SE 6 - JDBC 4.0 > [C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\lib\derby.jar] 10.8.1.2 - (1095077) > [C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\lib\derbytools.jar] 10.8.1.2 - (1095077) > [C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\lib\derbynet.jar] 10.8.1.2 - (1095077) > [C:\Users\BMASON\Sandbox\libs\db-derby-10.8.1.2-bin\lib\derbyclient.jar] 10.8.1.2 - (1095077) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/New Zealand [en_NZ]] > Found support for locale: [cs] > version: 10.8.1.2 - (1095077) > Found support for locale: [de_DE] > version: 10.8.1.2 - (1095077) > Found support for locale: [es] > version: 10.8.1.2 - (1095077) > Found support for locale: [fr] > version: 10.8.1.2 - (1095077) > Found support for locale: [hu] > version: 10.8.1.2 - (1095077) > Found support for locale: [it] > version: 10.8.1.2 - (1095077) > Found support for locale: [ja_JP] > version: 10.8.1.2 - (1095077) > Found support for locale: [ko_KR] > version: 10.8.1.2 - (1095077) > Found support for locale: [pl] > version: 10.8.1.2 - (1095077) > Found support for locale: [pt_BR] > version: 10.8.1.2 - (1095077) > Found support for locale: [ru] > version: 10.8.1.2 - (1095077) > Found support for locale: [zh_CN] > version: 10.8.1.2 - (1095077) > Found support for locale: [zh_TW] > version: 10.8.1.2 - (1095077) > ------------------------------------------------------ > Reporter: Brett Mason > Attachments: InternalDB - broken for 10.8.zip > > > I have been unable to get Derby 10.7.1.1 and 10.8.1.2 to boot the attached 10.5.1.1 database. Derby 10.6.1.0 is however able to use the DB. > I'm not sure if this is a backwards compatibility bug or the result of corruption to the database. Running SYSCS_CHECK_TABLE and SYSCS_COMPRESS_TABLE under 10.6.1.0 found no problems with the database. > NOTE: I have had to remove all data and non-essential tables/columns/triggers/etc prior to attaching this database. > Output when connecting to the DB using ij: > ERROR XJ040: Failed to start database 'C:\Users\BMASON\Sandbox\InternalDB' with class loader sun.misc.Launcher$AppClassLoader@11b86e7, see the next exception for details. > ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored > Full exception from our application: > java.sql.SQLException: Failed to start database 'C:\Users\BMASON\Sandbox\InternalDB' with class loader sun.misc.Launcher$AppClassLoader@93dee9, see the next exception for details. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) > at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) > at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source) > at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source) > at com.ADInstruments.LTS.util.DerbyUtils.exists(DerbyUtils.java:86) > at com.ADInstruments.LTS.InternalDB.InternalDbUtilities.cacheInternalDbVersion(InternalDbUtilities.java:117) > at com.ADInstruments.LTCS.InternalDB.InternalDbStartup.initialiseDatabase(InternalDbStartup.java:23) > at com.ADInstruments.LTCS.StartupTasks$StartupRunnable.initDatabases(StartupTasks.java:35) > at com.ADInstruments.LTCS.StartupTasks$StartupRunnable.run(StartupTasks.java:52) > at java.lang.Thread.run(Thread.java:662) > Caused by: java.sql.SQLException: Failed to start database 'C:\Users\BMASON\Sandbox\InternalDB' with class loader sun.misc.Launcher$AppClassLoader@93dee9, see the next exception for details. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) > ... 17 more > Caused by: java.sql.SQLException: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > ... 14 more > Caused by: ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(Unknown Source) > at org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(Unknown Source) > at org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(Unknown Source) > at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown Source) > at org.apache.derby.impl.store.access.heap.HeapScan.fetchNext(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaHeap(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getAllSPSDescriptors(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropJDBCMetadataSPSes(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSPSes(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisionChange(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTables(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source) > ... 14 more > Caused by: java.io.EOFException > at java.io.DataInputStream.readInt(DataInputStream.java:375) > at org.apache.derby.iapi.sql.dictionary.TriggerDescriptor.readExternal(Unknown Source) > at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source) > at org.apache.derby.iapi.services.io.ArrayUtil.readArrayItems(Unknown Source) > at org.apache.derby.impl.sql.execute.TriggerInfo.readExternal(Unknown Source) > at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source) > at org.apache.derby.impl.sql.execute.WriteCursorConstantAction.readExternal(Unknown Source) > at org.apache.derby.impl.sql.execute.UpdateConstantAction.readExternal(Unknown Source) > at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source) > at org.apache.derby.impl.sql.GenericStorablePreparedStatement.readExternal(Unknown Source) > at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source) > at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source) > ... 39 more -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira