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.