db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mani Afschar Yazdi <mani.afsc...@jq-consulting.de>
Subject BUG
Date Mon, 01 Aug 2011 17:42:15 GMT
Hello,

I use Derby extensivly and I have a problem with the attached  
database. DB name is ess_Prism, driver is embedded or net, both have  
the same behavoir. I use Apache Derby Network Server 10.8.1.2 -  
(1095077) in Client/Server mode. It runs on Linux ubuntu. Java  
runtime Java(TM) SE Runtime Environment (build 1.6.0_14-b08).

I set up the database many times by creating a new one and inserting  
the values. It works for the first few days, after a while this  
strange error occurs (I added some more lines before the exception to  
see what happened before):


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.wrapArgsForTransportAcr 
ossDRDA(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.wrapArgsForTransportAcr 
ossDRDA(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.loadDictionaryTable 
s(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.findProviderAndStartS 
ervice(Unknown Source)
         at  
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentServic 
e(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.wrapArgsForTransportAcr 
ossDRDA(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.loadDictionaryTable 
s(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.findProviderAndStartS 
ervice(Unknown Source)
         at  
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentServic 
e(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.wrapArgsForTransportAcr 
ossDRDA(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.loadDictionaryTable 
s(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.findProviderAndStartS 
ervice(Unknown Source)
         at  
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentServic 
e(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.loadDictionaryTable 
s(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.findProviderAndStartS 
ervice(Unknown Source)
         at  
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentServic 
e(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) ===========
Cleanup action completed
Fri Jul 29 00:00:55 CEST 2011 Thread[DRDAConnThread_16,5,main]  
(DATABASE = ess_Prism), (DRDAID = {750}), 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.


Other databases had the same error once after a database crash. After  
resetup they wok perfectly for more than 3 month, just this one does  
not work. Also a database backup with CALL  
SYSCS_UTIL.SYSCS_BACKUP_DATABASE('backup') will be corrupt after this  
error occured. Can you give me any advice?

Thanks
Mani







Mani Afschar Yazdi
JNet Quality Consulting GmbH
Geschäftsführer

Wilhelm-Riehl-Str. 13
80687 München

Tel: 0179 / 788 09 69

mani.afschar@jq-consulting.de
www.jq-consulting.de
www.sell-force.de


******************************************************************

JNet Quality Consulting GmbH, Sitz: München, Amtsgericht München HR  
B 13 51 82. Geschäftsführer: Mani Afschar Yazdi
Der Inhalt dieser E-Mail oder eventueller Anhänge ist ausschließlich  
für den bezeichneten Adressaten bestimmt. Wenn Sie nicht der  
vorgesehene Adressat dieser E-Mail oder dessen Vertreter sein  
sollten, so beachten Sie bitte, dass jede Form der Kenntnisnahme,  
Veröffentlichung, Vervielfältigung oder Weitergabe des Inhalts  
dieser E-Mail unzulässig ist. Wir bitten Sie, sich in diesem Fall mit  
dem Absender der E-Mail in Verbindung zu setzen.
The information contained in this email is intended solely for the  
addressee. If you are not the intended recipient, any form of  
disclosure, reproduction, distribution or any action taken or  
refrained from in reliance on it, is prohibited and may be unlawful.  
Please notify the sender immediately.

******************************************************************








Mime
View raw message