db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jayaprakash Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5266) Derby Database stored procedure is failing SYSCS_UTIL.SYSCS_BACKUP_DATABASE -urgent
Date Thu, 09 Jun 2011 14:05:59 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13046551#comment-13046551
] 

Jayaprakash Kumar commented on DERBY-5266:
------------------------------------------

Hi Kristian,

The derby.log created in the server, below is the attached log.

Apache Derby Network Server - 10.4.1.3 - (648739) started and ready to accept connections
on port 1527 at 2011-06-09 13:52:55.780 GMT 
----------------------------------------------------------------
2011-06-09 13:53:10.483 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby - 10.4.1.3 - (648739):
instance a816c00e-0130-74ad-5909-fffffe3e043d
on database directory C:\DB\DBDIMB\Database\mbcdb  

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)
	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)
	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)
============= end nested exception, level (1) ===========

2011-06-09 14:02:10.699 GMT:
Shutting down instance a816c00e-0130-74ad-5909-fffffe3e043d
----------------------------------------------------------------
Cleanup action completed

> 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

Mime
View raw message