From derby-dev-return-89705-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri Aug 5 13:24:52 2011 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 2ABBF7F94 for ; Fri, 5 Aug 2011 13:24:52 +0000 (UTC) Received: (qmail 35774 invoked by uid 500); 5 Aug 2011 13:24:51 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 35146 invoked by uid 500); 5 Aug 2011 13:24:51 -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 34773 invoked by uid 99); 5 Aug 2011 13:24:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Aug 2011 13:24: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; Fri, 05 Aug 2011 13:24:47 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 41212A9D20 for ; Fri, 5 Aug 2011 13:24:27 +0000 (UTC) Date: Fri, 5 Aug 2011 13:24:27 +0000 (UTC) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Message-ID: <121561722.11545.1312550667263.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1929646950.1569.1312296207324.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (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 [ https://issues.apache.org/jira/browse/DERBY-5371?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1307= 9963#comment-13079963 ]=20 Rick Hillegas commented on DERBY-5371: -------------------------------------- I see this problem when I run the following script using 10.8.1.2: connect 'jdbc:derby:ess_Prism'; Here is the English version of the error log output: ---------------------------------------------------------------- Fri Aug 05 06:16:10 PDT 2011: Booting Derby version The Apache Software Foundation - Apache Derby - 10.8.= 1.2 - (1095077): instance a816c00e-0131-9a16-2cec-000004399c50=20 on database directory /Users/rh161140/derby/mainline/ess_Prism with class = loader sun.misc.Launcher$AppClassLoader@2c2bbd86=20 Loaded from file:/Users/rh161140/derby/upgradeReleases/10.8.1.2/derby.jar java.vendor=3DApple Inc. java.runtime.version=3D1.6.0_17-b04-248-9M3125 user.dir=3D/Users/rh161140/derby/mainline derby.system.home=3Dnull Database Class Loader started - derby.database.classpath=3D'' WARNING: While deleting a row from a table the index row for base table row= (18,13) was not found in index with conglomerate id 593. This problem has= automatically been corrected as part of the delete operation. ---------------------------------------------------------------- Fri Aug 05 06:16:10 PDT 2011: Shutting down instance a816c00e-0131-9a16-2cec-000004399c50 on database dir= ectory /Users/rh161140/derby/mainline/ess_Prism with class loader sun.misc.= Launcher$AppClassLoader@2c2bbd86=20 Fri Aug 05 06:16:10 PDT 2011 Thread[main,5,main] Cleanup action starting java.sql.SQLException: Failed to start database 'ess_Prism' with class load= er sun.misc.Launcher$AppClassLoader@2c2bbd86, see the next exception for de= tails. =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn= own Source) =09at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) =09at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Sourc= e) =09at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source) =09at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) =09at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) =09at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) =09at java.sql.DriverManager.getConnection(DriverManager.java:582) =09at java.sql.DriverManager.getConnection(DriverManager.java:154) =09at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) =09at org.apache.derby.tools.ij.main(Unknown Source) Caused by: java.sql.SQLException: Failed to start database 'ess_Prism' with= class loader sun.misc.Launcher$AppClassLoader@2c2bbd86, see the next excep= tion for details. =09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow= n Source) =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport= AcrossDRDA(Unknown Source) =09... 21 more Caused by: java.sql.SQLException: Statement 'getProcedureColumns' already e= xists in Schema 'SYS'. =09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow= n Source) =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport= AcrossDRDA(Unknown Source) =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn= own Source) =09at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source= ) =09... 18 more Caused by: ERROR X0Y32: Statement 'getProcedureColumns' already exists in S= chema 'SYS'. =09at org.apache.derby.iapi.error.StandardException.newException(Unknown So= urce) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor= (Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unk= nown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(= Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSP= Ses(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisionChang= e(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown = Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTa= bles(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Sou= rce) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknow= n Source) =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unkn= own Source) =09at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknow= n Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderServi= ce(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndSta= rtService(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentSer= vice(Unknown Source) =09at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService= (Unknown Source) =09... 18 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' already exists in Sc= hema 'SYS'. =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn= own Source) =09at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source= ) =09at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Sourc= e) =09at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source) =09at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) =09at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) =09at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) =09at java.sql.DriverManager.getConnection(DriverManager.java:582) =09at java.sql.DriverManager.getConnection(DriverManager.java:154) =09at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) =09at org.apache.derby.tools.ij.main(Unknown Source) Caused by: java.sql.SQLException: Statement 'getProcedureColumns' already e= xists in Schema 'SYS'. =09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow= n Source) =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport= AcrossDRDA(Unknown Source) =09... 20 more Caused by: ERROR X0Y32: Statement 'getProcedureColumns' already exists in S= chema 'SYS'. =09at org.apache.derby.iapi.error.StandardException.newException(Unknown So= urce) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor= (Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unk= nown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(= Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSP= Ses(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisionChang= e(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown = Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTa= bles(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Sou= rce) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknow= n Source) =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unkn= own Source) =09at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknow= n Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderServi= ce(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndSta= rtService(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentSer= vice(Unknown Source) =09at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService= (Unknown Source) =09... 18 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' already exists in Sc= hema 'SYS'. =09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow= n Source) =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport= AcrossDRDA(Unknown Source) =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn= own Source) =09at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source= ) =09at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Sourc= e) =09at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source) =09at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) =09at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) =09at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) =09at java.sql.DriverManager.getConnection(DriverManager.java:582) =09at java.sql.DriverManager.getConnection(DriverManager.java:154) =09at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) =09at org.apache.derby.tools.ij.main(Unknown Source) Caused by: ERROR X0Y32: Statement 'getProcedureColumns' already exists in S= chema 'SYS'. =09at org.apache.derby.iapi.error.StandardException.newException(Unknown So= urce) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor= (Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unk= nown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(= Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSP= Ses(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisionChang= e(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown = Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTa= bles(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Sou= rce) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknow= n Source) =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unkn= own Source) =09at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknow= n Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderServi= ce(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndSta= rtService(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentSer= vice(Unknown Source) =09at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService= (Unknown Source) =09... 18 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' already exists in Schema 'SYS'= . =09at org.apache.derby.iapi.error.StandardException.newException(Unknown So= urce) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor= (Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPSSet(Unk= nown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSystemSps(= Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSP= Ses(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisionChang= e(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown = Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTa= bles(Unknown Source) =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Sou= rce) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknow= n Source) =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unkn= own Source) =09at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Sourc= e) =09at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown = Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknow= n Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderServi= ce(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndSta= rtService(Unknown Source) =09at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentSer= vice(Unknown Source) =09at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService= (Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Sourc= e) =09at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source) =09at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source) =09at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) =09at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) =09at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) =09at java.sql.DriverManager.getConnection(DriverManager.java:582) =09at java.sql.DriverManager.getConnection(DriverManager.java:154) =09at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) =09at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) =09at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) =09at org.apache.derby.tools.ij.main(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 Cleanup action completed > 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 re= ported on derby-dev by Mani Afschar Yazdi: http://mail-archives.apache.org/= mod_mbox/db-derby-dev/201108.mbox/%3C803C999D-9943-422F-ACD8-D1E18644634C@j= q-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 Klassenladeprogr= ammn 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.databa= se.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 Klassenladeprogr= ammn 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.databa= se.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 Klassenladeprogr= ammn 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.databa= se.classpath=3D'' > WARNUNG: Beim L=C3=B6schen einer Zeile aus einer Tabelle wurde die Indexz= eile f=C3=BCr die Zeile (18,13) der Basistabelle im Index mit der Konglomer= at-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 ac= tion starting > java.sql.SQLException: Die Datenbank 'ess_Prism' konnte nicht mit dem Kla= ssenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet werden. = Details k=C3=B6nnen Sie der n=C3=A4chsten Ausnahme entnehmen. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcepti= on(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown S= ource) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Sourc= e) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknow= n Source) > at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Sour= ce) > at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown So= urce) > at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown So= urce) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown S= ource) > 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 Sou= rce) > at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseN= ame(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(Unkn= own 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 gestart= et werden. Details k=C3=B6nnen Sie der n=C3=A4chsten Ausnahme entnehmen. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException= (Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTr= ansportAcrossDRDA(Unknown Source) > ... 17 more > Caused by: java.sql.SQLException: Statement 'getProcedureColumns' ist ber= eits in Schema 'SYS' vorhanden. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException= (Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTr= ansportAcrossDRDA(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcepti= on(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown= Source) > ... 14 more > Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Sc= hema 'SYS' vorhanden. > at org.apache.derby.iapi.error.StandardException.newException(Unk= nown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDes= criptor(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPS= Set(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSys= temSps(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMet= adataSPSes(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisi= onChange(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(U= nknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDicti= onaryTables(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unkn= own Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule= (Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModu= le(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService= (Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startProvid= erService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.findProvide= rAndStartService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startPersis= tentService(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.startPersistent= Service(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 Sch= ema 'SYS' vorhanden. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcepti= on(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown= Source) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknow= n Source) > at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Sour= ce) > at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown So= urce) > at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown So= urce) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown S= ource) > 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 Sou= rce) > at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseN= ame(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(Unkn= own Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Statement 'getProcedureColumns' ist ber= eits in Schema 'SYS' vorhanden. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException= (Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTr= ansportAcrossDRDA(Unknown Source) > ... 16 more > Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Sc= hema 'SYS' vorhanden. > at org.apache.derby.iapi.error.StandardException.newException(Unk= nown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDes= criptor(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPS= Set(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSys= temSps(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMet= adataSPSes(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisi= onChange(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(U= nknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDicti= onaryTables(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unkn= own Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule= (Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModu= le(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService= (Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startProvid= erService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.findProvide= rAndStartService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startPersis= tentService(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.startPersistent= Service(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 Sch= ema 'SYS' vorhanden. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException= (Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTr= ansportAcrossDRDA(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcepti= on(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown= Source) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknow= n Source) > at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Sour= ce) > at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown So= urce) > at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown So= urce) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown S= ource) > 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 Sou= rce) > at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseN= ame(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(Unkn= own Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Sc= hema 'SYS' vorhanden. > at org.apache.derby.iapi.error.StandardException.newException(Unk= nown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDes= criptor(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPS= Set(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSys= temSps(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMet= adataSPSes(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisi= onChange(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(U= nknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDicti= onaryTables(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unkn= own Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule= (Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModu= le(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService= (Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startProvid= erService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.findProvide= rAndStartService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startPersis= tentService(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.startPersistent= Service(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' = vorhanden. > ERROR X0Y32: Statement 'getProcedureColumns' ist bereits in Schema 'SYS' = vorhanden. > at org.apache.derby.iapi.error.StandardException.newException(Unk= nown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDes= criptor(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSPS= Set(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.createSys= temSps(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMet= adataSPSes(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisi= onChange(Unknown Source) > at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(U= nknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDicti= onaryTables(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unkn= own Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule= (Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModu= le(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknow= n Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(U= nknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService= (Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startProvid= erService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.findProvide= rAndStartService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startPersis= tentService(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.startPersistent= Service(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknow= n Source) > at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Sour= ce) > at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown So= urce) > at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown So= urce) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown S= ource) > 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 Sou= rce) > at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseN= ame(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(Unkn= own 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