[ https://issues.apache.org/jira/browse/DERBY-5371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13078391#comment-13078391 ]
Rick Hillegas edited comment on DERBY-5371 at 8/3/11 1:50 PM: -------------------------------------------------------------- Hi Mani, I unzipped ess_Prism.zip. The ess_Prism directory contains seg0 and log subdirectories as expected, but it does not contain a service.properties file. Does your copy of ess_Prism contain a service.properties file? Thanks. was (Author: rhillegas): Hi Mani, I unzipped ess_Prism.zip. The ess_Prism directory contains seg0 and log subdirectories as expected, but it does not contain a service.properties file. Does you copy of ess_Prism contain a service.properties file? Thanks. > 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/%3c803c999d-9943-422f-acd8-d1e186446...@jq-consulting.de%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