[
https://issues.apache.org/jira/browse/DERBY-5371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13079978#comment-13079978
]
Rick Hillegas commented on DERBY-5371:
--------------------------------------
The ess_Prism database version level is 10.5. When I try to boot it with the
debug version of the head of the 10.8 branch, I see the following error:
java version "1.6.0_17"
Java(TM) SE Runtime Environment (build 1.6.0_17-b04-248-9M3125)
Java HotSpot(TM) 64-Bit Server VM (build 14.3-b01-101, mixed mode)
ij version 10.8
ij> connect 'jdbc:derby:ess_Prism';
ERROR XJ040: Failed to start database 'ess_Prism' with class loader
sun.misc.Launcher$AppClassLoader@2c2bbd86, see the next exception for details.
ERROR XJ001: Java exception: 'ASSERT FAILED Index row
(getProcedureColumns,8000000d-00d0-fd77-3ed8-000a0a0b1900,(18,13)) not found in
conglomerateid 593Current scan =
btree = BTREE: containerid = Container(0, 593);nKeyFields =
3;nUniqueColumns = 2;allowDuplicates = false
scan direction = forward
(scan_state:SCAN_DONE
rh:null
key:null)
init_rawtran = 2234
init_hold = false
init_forUpdate = true
init_useUpdateLocks = false
init_scanColumnList = null
init_scanColumnList.size() = 0
init_template =
col[0]=getProcedureColumnscol[1]=8000000d-00d0-fd77-3ed8-000a0a0b1900col[2]=(34,6)
init_startKeyValue =
col[0]=getProcedureColumnscol[1]=8000000d-00d0-fd77-3ed8-000a0a0b1900col[2]=(18,13)
init_startSearchOperator = GE
init_qualifier[] = null
init_stopKeyValue =
col[0]=getProcedureColumnscol[1]=8000000d-00d0-fd77-3ed8-000a0a0b1900col[2]=(18,13)
init_stopSearchOperator = GT
stat_numpages_visited = 2
stat_numrows_visited = 1
stat_numrows_qualified = 0
stat_numdeleted_rows_visited = 0:
org.apache.derby.shared.common.sanity.AssertFailure'.
> Database fails to boot, complaining that the getProcedureColumns() system
> procedure already exists
> --------------------------------------------------------------------------------------------------
>
> Key: DERBY-5371
> URL: https://issues.apache.org/jira/browse/DERBY-5371
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.8.1.2
> Reporter: Rick Hillegas
> Attachments: ess_Prism.zip
>
>
> Database boot fails while trying to create system procedures. This was
> reported on derby-dev by Mani Afschar Yazdi:
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/201108.mbox/%[email protected]%3E
> Here is the stack trace which Mani sees:
> Fri Jul 29 00:00:48 CEST 2011:
> Booten von Derby Version The Apache Software Foundation - Apache Derby -
> 10.8.1.2 - (1095077): Instanz 361e1010-0131-7290-3e0d-000071c3e7f1
> für Datenbankverzeichnis /var/derby/ess_Orca0 mit Klassenladeprogrammn
> sun.misc.Launcher$AppClassLoader@7d772e
> java.vendor=Sun Microsystems Inc.
> java.runtime.version=1.6.0_14-b08
> user.dir=/var/derby
> derby.system.home=/var/derby
> Das Ladeprogramm für Datenbankklassen wurde gestartet -
> derby.database.classpath=''
> ----------------------------------------------------------------
> Fri Jul 29 00:00:51 CEST 2011:
> Booten von Derby Version The Apache Software Foundation - Apache Derby -
> 10.8.1.2 - (1095077): Instanz 362d905d-0131-7290-3e0d-000071c3e7f1
> für Datenbankverzeichnis /var/derby/ess_winmm mit Klassenladeprogrammn
> sun.misc.Launcher$AppClassLoader@7d772e
> java.vendor=Sun Microsystems Inc.
> java.runtime.version=1.6.0_14-b08
> user.dir=/var/derby
> derby.system.home=/var/derby
> Das Ladeprogramm für Datenbankklassen wurde gestartet -
> derby.database.classpath=''
> ----------------------------------------------------------------
> Fri Jul 29 00:00:54 CEST 2011:
> Booten von Derby Version The Apache Software Foundation - Apache Derby -
> 10.8.1.2 - (1095077): Instanz 36e4d0a3-0131-7290-3e0d-000071c3e7f1
> für Datenbankverzeichnis /var/derby/ess_Prism mit Klassenladeprogrammn
> sun.misc.Launcher$AppClassLoader@7d772e
> java.vendor=Sun Microsystems Inc.
> java.runtime.version=1.6.0_14-b08
> user.dir=/var/derby
> derby.system.home=/var/derby
> Das Ladeprogramm für Datenbankklassen wurde gestartet -
> derby.database.classpath=''
> WARNUNG: Beim Löschen einer Zeile aus einer Tabelle wurde die Indexzeile für
> die Zeile (18,13) der Basistabelle im Index mit der Konglomerat-ID 593 nicht
> gefunden. Dieser Fehler wurde automatisch im Rahmen der Löschoperation
> behoben.
> ----------------------------------------------------------------
> Fri Jul 29 00:00:55 CEST 2011:
> Die Instanz 36e4d0a3-0131-7290-3e0d-000071c3e7f1 mit Klassenladeprogrammn
> /var/derby/ess_Prism wird heruntergefahren
> Fri Jul 29 00:00:55 CEST 2011 Thread[DRDAConnThread_16,5,main] Cleanup action
> starting
> java.sql.SQLException: Die Datenbank 'ess_Prism' konnte nicht mit dem
> Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet werden.
> Details können Sie der nächsten Ausnahme entnehmen.
> 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.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(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.AutoloadedDriver.connect(Unknown Source)
> at org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Caused by: java.sql.SQLException: Die Datenbank 'ess_Prism' konnte nicht mit
> dem Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet
> werden. Details können Sie der nächsten Ausnahme entnehmen.
> 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: Statement 'getProcedureColumns' ist bereits
> in Schema 'SYS' vorhanden.
> 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 X0Y32: Statement 'getProcedureColumns' ist bereits in Schema
> 'SYS' vorhanden.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(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
> ============= begin nested exception, level (1) ===========
> java.sql.SQLException: Statement 'getProcedureColumns' ist bereits in Schema
> 'SYS' vorhanden.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(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.AutoloadedDriver.connect(Unknown Source)
> at org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Caused by: java.sql.SQLException: Statement 'getProcedureColumns' ist bereits
> in Schema 'SYS' vorhanden.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 16 more
> Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema
> 'SYS' vorhanden.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(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
> ============= end nested exception, level (1) ===========
> ============= begin nested exception, level (2) ===========
> java.sql.SQLException: Statement 'getProcedureColumns' ist bereits in Schema
> 'SYS' vorhanden.
> 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)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(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.AutoloadedDriver.connect(Unknown Source)
> at org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema
> 'SYS' vorhanden.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(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
> ============= end nested exception, level (2) ===========
> ============= begin nested exception, level (3) ===========
> ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema 'SYS'
> vorhanden.
> ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema 'SYS'
> vorhanden.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(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)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(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.AutoloadedDriver.connect(Unknown Source)
> at org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> ============= end nested exception, level (3) ===========
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
