[
https://issues.apache.org/jira/browse/DERBY-5266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13046672#comment-13046672
]
Mike Matrigali commented on DERBY-5266:
---------------------------------------
also you could look at DERBY-5234 for the kind of information that you could
provide that might help understand what is going
on.
> Derby Database stored procedure is failing SYSCS_UTIL.SYSCS_BACKUP_DATABASE
> -urgent
> -----------------------------------------------------------------------------------
>
> Key: DERBY-5266
> URL: https://issues.apache.org/jira/browse/DERBY-5266
> Project: Derby
> Issue Type: Bug
> Components: Services
> Affects Versions: 10.5.3.0
> Environment: We are using Windows 2003 server, Windows XP and Windows
> 7
> Reporter: Jayaprakash Kumar
> Priority: Blocker
> Labels: Backup, Database, Derby, issue
>
> 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.
> Below is the java code logic calling the procedure function.
> Connection conn = dataSource.getConnection();
> backupdirectory = dirLocation + "/" + DateUtils.formatDate(new
> Date(), DATE_FORMAT);
> CallableStatement stmt = conn.prepareCall("CALL
> SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)");
> stmt.setString(1, backupdirectory);
> stmt.execute();
> stmt.close();
> } catch (SQLException exp) {
> log.error("Error in performing backup database :" +
> exp.getMessage());
> }
> Pls see the Threaddump below.
> Job logger created for job 20110426115633543103
> Job execution started. Job program:
> [com.db.mbc.scheduler.jobs.DBBackupScheduleJob], Job parameters: [8501, 1942,
> 2011-04-26, 11:54:00,
> <parameter><dirLocator>d:/db/backup/test</dirLocator></parameter>, DBBP]
> Job Executer Signalling is not running...
> Job Executer Signalling is not running...
> Job Executer Signalling is not running...
> Job Executer Signalling is not running...
> Job Executer Signalling is not running...
> Job Executer Signalling is not running...
> 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
> 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
> 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]
> Job logger created for job 20110426115633543103
> Job execution started. Job program:
> [com.db.mbc.scheduler.jobs.DBBackupScheduleJob], Job parameters: [8501, 1942,
> 2011-04-26, 11:54:00,
> <parameter><dirLocator>d:/db/backup/test</dirLocator></parameter>, DBBP]
> 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
> 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
> 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]
> Job logger created for job 20110426115633543103
> Job execution started. Job program:
> [com.db.mbc.scheduler.jobs.DBBackupScheduleJob], Job parameters: [8501, 1942,
> 2011-04-26, 11:54:00,
> <parameter><dirLocator>d:/db/backup/test</dirLocator></parameter>, DBBP]
> 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
> 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
> 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]
> Job logger created for job 20110426115633543103
> Job execution started. Job program:
> [com.db.mbc.scheduler.jobs.DBBackupScheduleJob], Job parameters: [8501, 1942,
> 2011-04-26, 11:54:00,
> <parameter><dirLocator>d:/db/backup/test</dirLocator></parameter>, DBBP]
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
