[ 
https://issues.apache.org/jira/browse/DERBY-5371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rick Hillegas updated DERBY-5371:
---------------------------------

    Attachment: derby-5371-patch.tar

A corrupted index (SYSSTATEMENTS_INDEX2) is preventing the database from 
booting. I don't know how the index became corrupted. Mani reports on 
derby-user that he soft-upgraded the database from 10.5 to 10.6 and then to 
10.8.

-----------------------------

Attaching derby-5371-patch.tar. This tarball contains the conglomerates for 
SYSSTATEMENTS and its indexes from a freshly created 10.5 database. If you 
perform the following steps, the database can be repaired to the point that 
SYSCS_UTIL.SYSCS_CHECK_TABLE runs cleanly:

1) Change directory to the parent directory of ess_Prism.

2) Then untar derby-5371-patch.tar.

-----------------------------

After performing the steps above, I can boot the database using 10.8.1.2 and 
run the following script:

connect 'jdbc:derby:ess_Prism';

select schemaname, tablename, syscs_util.syscs_check_table( schemaname, 
tablename ) 
from sys.sysschemas s, sys.systables t 
where s.schemaid = t.schemaid;

This produces the following output:

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';
ij> select schemaname, tablename, syscs_util.syscs_check_table( schemaname, 
tablename ) 
from sys.sysschemas s, sys.systables t 
where s.schemaid = t.schemaid;
SCHEMANAME                                                                      
                                                |TABLENAME                      
                                                                                
                 |3          
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
APP                                                                             
                                                |ACCOUNT                        
                                                                                
                 |1          
APP                                                                             
                                                |ACTIVITY                       
                                                                                
                 |1          
APP                                                                             
                                                |ARTICLE                        
                                                                                
                 |1          
APP                                                                             
                                                |COMPANY                        
                                                                                
                 |1          
APP                                                                             
                                                |COMPANY_LINK                   
                                                                                
                 |1          
APP                                                                             
                                                |CONTACT                        
                                                                                
                 |1          
APP                                                                             
                                                |CONTACT_LINK                   
                                                                                
                 |1          
APP                                                                             
                                                |CONTACT_POSITION               
                                                                                
                 |1          
APP                                                                             
                                                |FILE                           
                                                                                
                 |1          
APP                                                                             
                                                |GALLERY                        
                                                                                
                 |1          
APP                                                                             
                                                |HTML                           
                                                                                
                 |1          
APP                                                                             
                                                |IMAGE                          
                                                                                
                 |1          
APP                                                                             
                                                |INVOICE                        
                                                                                
                 |1          
APP                                                                             
                                                |INVOICE_POSITION               
                                                                                
                 |1          
APP                                                                             
                                                |KEYWORD                        
                                                                                
                 |1          
APP                                                                             
                                                |LANGUAGE                       
                                                                                
                 |1          
APP                                                                             
                                                |NEWS                           
                                                                                
                 |1          
APP                                                                             
                                                |OFFER                          
                                                                                
                 |1          
APP                                                                             
                                                |ORDERS                         
                                                                                
                 |1          
APP                                                                             
                                                |ORDERS_POSITION                
                                                                                
                 |1          
APP                                                                             
                                                |ORDERS_POSITION_OPTION         
                                                                                
                 |1          
APP                                                                             
                                                |PRICE                          
                                                                                
                 |1          
APP                                                                             
                                                |PRODUCT                        
                                                                                
                 |1          
APP                                                                             
                                                |PRODUCT_CATEGORY               
                                                                                
                 |1          
APP                                                                             
                                                |PRODUCT_CATEGORY_LINK          
                                                                                
                 |1          
APP                                                                             
                                                |PRODUCT_OPTION_CATEGORY        
                                                                                
                 |1          
APP                                                                             
                                                |PRODUCT_OPTION_LINK            
                                                                                
                 |1          
APP                                                                             
                                                |PRODUCT_OPTION_VALUE           
                                                                                
                 |1          
APP                                                                             
                                                |PROPERTY                       
                                                                                
                 |1          
APP                                                                             
                                                |STORE                          
                                                                                
                 |1          
SYS                                                                             
                                                |SYSALIASES                     
                                                                                
                 |1          
SYS                                                                             
                                                |SYSCHECKS                      
                                                                                
                 |1          
SYS                                                                             
                                                |SYSCOLPERMS                    
                                                                                
                 |1          
SYS                                                                             
                                                |SYSCOLUMNS                     
                                                                                
                 |1          
SYS                                                                             
                                                |SYSCONGLOMERATES               
                                                                                
                 |1          
SYS                                                                             
                                                |SYSCONSTRAINTS                 
                                                                                
                 |1          
SYS                                                                             
                                                |SYSDEPENDS                     
                                                                                
                 |1          
SYSIBM                                                                          
                                                |SYSDUMMY1                      
                                                                                
                 |1          
SYS                                                                             
                                                |SYSFILES                       
                                                                                
                 |1          
SYS                                                                             
                                                |SYSFOREIGNKEYS                 
                                                                                
                 |1          
SYS                                                                             
                                                |SYSKEYS                        
                                                                                
                 |1          
SYS                                                                             
                                                |SYSROLES                       
                                                                                
                 |1          
SYS                                                                             
                                                |SYSROUTINEPERMS                
                                                                                
                 |1          
SYS                                                                             
                                                |SYSSCHEMAS                     
                                                                                
                 |1          
SYS                                                                             
                                                |SYSSTATEMENTS                  
                                                                                
                 |1          
SYS                                                                             
                                                |SYSSTATISTICS                  
                                                                                
                 |1          
SYS                                                                             
                                                |SYSTABLEPERMS                  
                                                                                
                 |1          
SYS                                                                             
                                                |SYSTABLES                      
                                                                                
                 |1          
SYS                                                                             
                                                |SYSTRIGGERS                    
                                                                                
                 |1          
SYS                                                                             
                                                |SYSVIEWS                       
                                                                                
                 |1          
APP                                                                             
                                                |TIME                           
                                                                                
                 |1          
APP                                                                             
                                                |TRASH                          
                                                                                
                 |1          

52 rows selected


> 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: derby-5371-patch.tar, 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


Reply via email to