db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Florin.Herin...@sungard.com>
Subject AW: Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup
Date Thu, 09 Jun 2011 14:48:37 GMT


the exception stack trace you sent is from your own classes. Were there any exception logged
by the derby itself ? Or at least you should log the full stack trace of the SQLException
you received.


I think you should not swallow up the original stacktrace but print it too:



} catch (SQLException exp) {

            log.error("Error in performing backup database :" +

exp.getMessage(), exp); // <-- add the original exception to the logger, if you're using








Von: Jayaprakash Kumar [mailto:jayaprakash.kumar@db.com] 
Gesendet: Donnerstag, 9. Juni 2011 15:10
An: derby-user@db.apache.org
Betreff: 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(?)
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. 

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.

View raw message