You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Jayaprakash Kumar (JIRA)" <ji...@apache.org> on 2011/06/10 12:37:58 UTC
[jira] [Issue Comment Edited] (DERBY-5266) Derby Database stored
procedure is failing SYSCS_UTIL.SYSCS_BACKUP_DATABASE -urgent
[ https://issues.apache.org/jira/browse/DERBY-5266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13047125#comment-13047125 ]
Jayaprakash Kumar edited comment on DERBY-5266 at 6/10/11 10:36 AM:
--------------------------------------------------------------------
Hi Mike,
I executed the system function SYSCS_UTIL.SYSCS_CHECK_TABLE as mentioned in the wiki, the result is all tables are OK, there is NO bad index error.
After the above process i executed once again the BackUP function(SYSCS_UTIL.SYSCS_BACKUP_DATABASE) but still the same issue...
ij> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('C:\DatabaseBackup');
ERROR 08006: 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 w
as no architected message
ij>
Derby.log
2011-06-10 09:38:08.187 GMT : Apache Derby Network Server - 10.5.3.0 - (802917) started and ready to accept connections on port 1527
----------------------------------------------------------------
2011-06-10 09:38:34.436 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.5.3.0 - (802917): instance a816c00e-0130-78ea-708c-0000511839b4
on database directory C:\DB\DBDIMB\Database\mbcdb
Database Class Loader started - derby.database.classpath=''
2011-06-10 09:45:03.259 GMT Thread[DRDAConnThread_3,5,main] (XID = 52854284), (SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), (DRDAID = NF000001.H129-938717739631323355{1}), Cleanup action starting
2011-06-10 09:45:03.259 GMT Thread[DRDAConnThread_3,5,main] (XID = 52854284), (SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), (DRDAID = NF000001.H129-938717739631323355{1}), Failed Statement is: CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('C:\DatabaseBackup')
ERROR XSDBB: Unknown page format at page Page(5478,Container(0, 562448)), page dump follows: Hex dump:
00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000030: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000040: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000060: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000080: 0000 0000 0000 0000 0000 0000 0000 0000..........00007f50: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f60: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f70: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f80: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f90: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fa0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
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.acf81e0010x0130x78eax708cx0000511839b41.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.executeStmt(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)
2011-06-10 09:45:03.369 GMT:
Shutting down instance a816c00e-0130-78ea-708c-0000511839b4
----------------------------------------------------------------
Cleanup action completed
Please help, any Workaround or Permanent solution for this issue....
was (Author: jayaprakashkumar):
Hi Mike,
I executed the system function SYSCS_UTIL.SYSCS_CHECK_TABLE as mentioned in the wiki, the result is all tables are OK, there is NO bad index error.
After the above process i executed once again the back function but still the same issue...
ij> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('C:\DatabaseBackup');
ERROR 08006: 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 w
as no architected message
ij>
Derby.log
2011-06-10 09:38:08.187 GMT : Apache Derby Network Server - 10.5.3.0 - (802917) started and ready to accept connections on port 1527
----------------------------------------------------------------
2011-06-10 09:38:34.436 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.5.3.0 - (802917): instance a816c00e-0130-78ea-708c-0000511839b4
on database directory C:\DB\DBDIMB\Database\mbcdb
Database Class Loader started - derby.database.classpath=''
2011-06-10 09:45:03.259 GMT Thread[DRDAConnThread_3,5,main] (XID = 52854284), (SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), (DRDAID = NF000001.H129-938717739631323355{1}), Cleanup action starting
2011-06-10 09:45:03.259 GMT Thread[DRDAConnThread_3,5,main] (XID = 52854284), (SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), (DRDAID = NF000001.H129-938717739631323355{1}), Failed Statement is: CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('C:\DatabaseBackup')
ERROR XSDBB: Unknown page format at page Page(5478,Container(0, 562448)), page dump follows: Hex dump:
00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000030: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000040: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000060: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000080: 0000 0000 0000 0000 0000 0000 0000 0000..........00007f50: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f60: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f70: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f80: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007f90: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fa0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
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.acf81e0010x0130x78eax708cx0000511839b41.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.executeStmt(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)
2011-06-10 09:45:03.369 GMT:
Shutting down instance a816c00e-0130-78ea-708c-0000511839b4
----------------------------------------------------------------
Cleanup action completed
Please help, any Workaround or Permanent solution for this issue....
> 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