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 2A82F6DFB for ; Tue, 2 Aug 2011 14:43:52 +0000 (UTC) Received: (qmail 8731 invoked by uid 500); 2 Aug 2011 14:43:51 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 8138 invoked by uid 500); 2 Aug 2011 14:43:50 -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 7966 invoked by uid 99); 2 Aug 2011 14:43:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Aug 2011 14:43:50 +0000 X-ASF-Spam-Status: No, hits=-2000.7 required=5.0 tests=ALL_TRUSTED,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; Tue, 02 Aug 2011 14:43:48 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 4FFFB9A2D2 for ; Tue, 2 Aug 2011 14:43:27 +0000 (UTC) Date: Tue, 2 Aug 2011 14:43:27 +0000 (UTC) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Message-ID: <1929646950.1569.1312296207324.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Created] (DERBY-5371) Database fails to boot, complaining that the getProcedureColumns() system procedure already exists MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Database fails to boot, complaining that the getProcedureColumns() system p= rocedure 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 Database boot fails while trying to create system procedures. This was repo= rted on derby-dev by Mani Afschar Yazdi: http://mail-archives.apache.org/mo= d_mbox/db-derby-dev/201108.mbox/%3C803C999D-9943-422F-ACD8-D1E18644634C@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=C3=BCr Datenbankverzeichnis /var/derby/ess_Orca0 mit Klassenladeprogram= mn sun.misc.Launcher$AppClassLoader@7d772e java.vendor=3DSun Microsystems Inc. java.runtime.version=3D1.6.0_14-b08 user.dir=3D/var/derby derby.system.home=3D/var/derby Das Ladeprogramm f=C3=BCr Datenbankklassen wurde gestartet - derby.database= .classpath=3D'' ---------------------------------------------------------------- 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=C3=BCr Datenbankverzeichnis /var/derby/ess_winmm mit Klassenladeprogram= mn sun.misc.Launcher$AppClassLoader@7d772e java.vendor=3DSun Microsystems Inc. java.runtime.version=3D1.6.0_14-b08 user.dir=3D/var/derby derby.system.home=3D/var/derby Das Ladeprogramm f=C3=BCr Datenbankklassen wurde gestartet - derby.database= .classpath=3D'' ---------------------------------------------------------------- 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=C3=BCr Datenbankverzeichnis /var/derby/ess_Prism mit Klassenladeprogram= mn sun.misc.Launcher$AppClassLoader@7d772e java.vendor=3DSun Microsystems Inc. java.runtime.version=3D1.6.0_14-b08 user.dir=3D/var/derby derby.system.home=3D/var/derby Das Ladeprogramm f=C3=BCr Datenbankklassen wurde gestartet - derby.database= .classpath=3D'' WARNUNG: Beim L=C3=B6schen einer Zeile aus einer Tabelle wurde die Indexzei= le f=C3=BCr die Zeile (18,13) der Basistabelle im Index mit der Konglomerat= -ID 593 nicht gefunden. Dieser Fehler wurde automatisch im Rahmen der L=C3= =B6schoperation 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 acti= on starting java.sql.SQLException: Die Datenbank 'ess_Prism' konnte nicht mit dem Klass= enladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet werden. De= tails k=C3=B6nnen Sie der n=C3=A4chsten Ausnahme entnehmen. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException= (Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Sou= rce) 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 Sour= ce) at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Sour= ce) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Sou= rce) 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 Sourc= e) at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseNam= e(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(U= nknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown So= urce) at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Un= known Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknow= n Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) Caused by: java.sql.SQLException: Die Datenbank 'ess_Prism' konnte nicht mi= t dem Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet= werden. Details k=C3=B6nnen Sie der n=C3=A4chsten Ausnahme entnehmen. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(U= nknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTran= sportAcrossDRDA(Unknown Source) ... 17 more Caused by: java.sql.SQLException: Statement 'getProcedureColumns' ist berei= ts in Schema 'SYS' vorhanden. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(U= nknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTran= sportAcrossDRDA(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException= (Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown S= ource) ... 14 more Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Sche= ma 'SYS' vorhanden. at org.apache.derby.iapi.error.StandardException.newException(Unkno= wn Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescr= iptor(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSe= t(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSyste= mSps(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetad= ataSPSes(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevision= Change(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unk= nown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDiction= aryTables(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknow= n Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown = Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(U= nknown 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(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(U= nknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startProvider= Service(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderA= ndStartService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startPersiste= ntService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startPersistentSe= rvice(Unknown Source) ... 14 more =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level (1) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D java.sql.SQLException: Statement 'getProcedureColumns' ist bereits in Schem= a 'SYS' vorhanden. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException= (Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown S= ource) 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 Sour= ce) at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Sour= ce) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Sou= rce) 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 Sourc= e) at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseNam= e(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(U= nknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown So= urce) at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Un= known Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknow= n Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) Caused by: java.sql.SQLException: Statement 'getProcedureColumns' ist berei= ts in Schema 'SYS' vorhanden. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(U= nknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTran= sportAcrossDRDA(Unknown Source) ... 16 more Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Sche= ma 'SYS' vorhanden. at org.apache.derby.iapi.error.StandardException.newException(Unkno= wn Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescr= iptor(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSe= t(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSyste= mSps(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetad= ataSPSes(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevision= Change(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unk= nown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDiction= aryTables(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknow= n Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown = Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(U= nknown 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(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(U= nknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startProvider= Service(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderA= ndStartService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startPersiste= ntService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startPersistentSe= rvice(Unknown Source) ... 14 more =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D end nested exception, level (1) =3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level (2) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D java.sql.SQLException: Statement 'getProcedureColumns' ist bereits in Schem= a 'SYS' vorhanden. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(U= nknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTran= sportAcrossDRDA(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException= (Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown S= ource) 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 Sour= ce) at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Sour= ce) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Sou= rce) 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 Sourc= e) at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseNam= e(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(U= nknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown So= urce) at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Un= known Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknow= n Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Sche= ma 'SYS' vorhanden. at org.apache.derby.iapi.error.StandardException.newException(Unkno= wn Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescr= iptor(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSe= t(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSyste= mSps(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetad= ataSPSes(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevision= Change(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unk= nown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDiction= aryTables(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknow= n Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown = Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(U= nknown 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(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(U= nknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startProvider= Service(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderA= ndStartService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startPersiste= ntService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startPersistentSe= rvice(Unknown Source) ... 14 more =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D end nested exception, level (2) =3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level (3) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema 'SYS' vo= rhanden. ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema 'SYS' vo= rhanden. at org.apache.derby.iapi.error.StandardException.newException(Unkno= wn Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescr= iptor(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSe= t(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSyste= mSps(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetad= ataSPSes(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevision= Change(Unknown Source) at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unk= nown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDiction= aryTables(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknow= n Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown = Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(U= nknown 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(Unk= nown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(U= nknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startProvider= Service(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderA= ndStartService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startPersiste= ntService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startPersistentSe= rvice(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 Sour= ce) at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Sour= ce) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Sou= rce) 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 Sourc= e) at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseNam= e(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(U= nknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown So= urce) at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Un= known Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknow= n Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D end nested exception, level (3) =3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira