db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jayaprakash Kumar <jayaprakash.ku...@db.com>
Subject Fw: Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup
Date Thu, 09 Jun 2011 14:55:49 GMT
Hi Team,

Further on this issue i am attaching the derby.log file.


Database Class Loader started - derby.database.classpath=''
2011-06-09 14:02:10.527 GMT Thread[DRDAConnThread_4,5,main] (XID = 
821264864), (SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), 
(DRDAID = NF000001.G4EA-4197072070104639719{2}), Cleanup action starting
2011-06-09 14:02:10.527 GMT Thread[DRDAConnThread_4,5,main] (XID = 
821264864), (SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), 
(DRDAID = NF000001.G4EA-4197072070104639719{2}), Failed Statement is: CALL 
SYSCS_UTIL.SYSCS_BACKUP_DATABASE('C:\DatabaseBackup')
ERROR XSDB1: Unknown page format at page Page(194123,Container(0, 1217))
        at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at 
org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(Unknown 
Source)
        at 
org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown 
Source)
        at 
org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown Source)
        at 
org.apache.derby.impl.store.raw.data.FileContainer.getLatchedPage(Unknown 
Source)
        at 
org.apache.derby.impl.store.raw.data.RAFContainer.privBackupContainer(Unknown 
Source)
        at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown 
Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at 
org.apache.derby.impl.store.raw.data.RAFContainer.backupContainer(Unknown 
Source)
        at 
org.apache.derby.impl.store.raw.data.BaseContainerHandle.backupContainer(Unknown 
Source)
        at 
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.backupDataFiles(Unknown 
Source)
        at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
        at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
        at 
org.apache.derby.impl.store.access.RAMAccessManager.backup(Unknown Source)
        at org.apache.derby.impl.db.BasicDatabase.backup(Unknown Source)
        at 
org.apache.derby.catalog.SystemProcedures.SYSCS_BACKUP_DATABASE(Unknown 
Source)
        at 
org.apache.derby.exe.ac48d7402ax0130x74adx5909xfffffe3e043d0.g0(Unknown 
Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at 
org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown 
Source)
        at 
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown 
Source)
        at 
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
        at 
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown 
Source)
        at 
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown 
Source)
        at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
        at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown 
Source)
        at 
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(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 XBM0U: No class was registered for identifier 0.
        at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.classFromIdentifier(Unknown 
Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.newInstanceFromIdentifier(Unknown 
Source)
        at 
org.apache.derby.iapi.services.monitor.Monitor.newInstanceFromIdentifier(Unknown 
Source)
        ... 31 more
============= begin nested exception, level (1) ===========
ERROR XBM0U: No class was registered for identifier 0.
        at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)




Regards,
Jayaprakash Kumar,
-------------------------------------------------------------------------
Deutsche Bank AG
Alfred-Herrhausen-Allee 16-24, 65760 Eschborn, Germany
Direct : +49(69)910-65832
MBC Hotline : +49 6991061400
***********************************************************
?This mail is transmitted to you on behalf of HCL Technologies. 
Diese Post wird Ihnen im Namen der HCL Technologies ├╝bermittelt?

----- Forwarded by Jayaprakash Kumar/ext/dbcom on 09/06/2011 16:54 -----

Jayaprakash Kumar/ext/dbcom 
09/06/2011 15:09

To
derby-user@db.apache.org
cc

Subject
Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is 
failing to take database backup





Hi Team 

We are facing the problem with derby Backup Database procedure function 
SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?) and 
this function failed to take the backup of the database and throws below 
error message.

Error Log:-
com.db.mbc.scheduler.jobs.JobExecutionException: Error in performing 
backup database :A network protocol error was encountered and the 
connection has been terminated: the requested command encountered an 
unarchitected and implementation-specific condition for which there was no 
architected message 
        at 
com.db.mbc.scheduler.jobs.DBBackupScheduleJob.backUpDB(DBBackupScheduleJob.java:155) 

        at 
com.db.mbc.scheduler.jobs.DBBackupScheduleJob.executeJob(DBBackupScheduleJob.java:88) 

        at 
com.db.mbc.scheduler.jobs.BaseScheduleJob.execute(BaseScheduleJob.java:97) 

        at 
com.db.mbc.base.job.SpringAwareJobActionListener.actionFired(SpringAwareJobActionListener.java:73)


        at 
com.topgear.executer.impl.StdJobExecutionShell.run(StdJobExecutionShell.java:207) 

        at 
com.topgear.threadpool.impl.StdThreadPool.run(StdThreadPool.java:168) 
        at java.lang.Thread.run(Thread.java:595) 
Job execution COMPLETED with result [true] 


-- Its look like bug in derby database.

-- Some one noticed about this error before but no one suggested work 
around for this issue. This issue highly  blocking the customers to take 
the database backup in production.



Regards,
Jayaprakash Kumar,
-------------------------------------------------------------------------
Deutsche Bank AG
Alfred-Herrhausen-Allee 16-24, 65760 Eschborn, Germany
Direct : +49(69)910-65832
MBC Hotline : +49 6991061400
***********************************************************
?This mail is transmitted to you on behalf of HCL Technologies. 
Diese Post wird Ihnen im Namen der HCL Technologies ├╝bermittelt?


---

This e-mail may contain confidential and/or privileged information. If you 
are not the intended recipient (or have received this e-mail in error) 
please notify the sender immediately and destroy this e-mail. Any 
unauthorized copying, disclosure or distribution of the material in this 
e-mail is strictly forbidden.
Mime
View raw message