Hi Mike, Brett,
Attached thread dump. Here the database size is 20 GB.
Brett Wooldridge-2 wrote:
Do you have a thread dump during the hang? What
OS are you running on?
Brett
Sent from my iPhone
On Jun 7, 2011, at 16:38, Vijender Devakari vijender.devak...@db.com
wrote:
Hi,
Sorry I wasn't clearer. A thead dump is a snapshot of all running
threads in the system, not a stacktrace of failures.
You can generate a threaddump on Windows by running your server from
the command line, and when the hang occurs during backup, pressing
CTRL-Break (CTRL key and Break key at the
Hi,
This is the thread dump which was thrown by SQL Exception
This the logic we are using to backup the database.
Connection conn = dataSource.getConnection();
backupdirectory = dirLocation + / + DateUtils.formatDate(new
Date(), DATE_FORMAT);
CallableStatement stmt =
On 09.06.11 09:27, Brett Wooldridge wrote:
Sorry I wasn't clearer. A thead dump is a snapshot of all running
threads in the system, not a stacktrace of failures.
You can generate a threaddump on Windows by running your server from
the command line, and when the hang occurs during backup,
Hi,
Although I have *no knowledge* of internal derby implementation (I have no
sources), I do have some basic java knowledge, and from the messages in the
dump I can tell you that the stored procedure you're invoking is expecting a
URL.
That means your backupdirectory parameter should be a
Hi,
Well documentation doesn't say that...
SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure
The SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure backs up the
database to a specified backup directory.
Syntax
SYSCS_UTIL.SYSCS_BACKUP_DATABASE(IN BACKUPDIR VARCHAR())
No result is returned
Maybe the documentation is correct and the problem relies on the
d:/db/backup/test path. Does that folder exist ? Does the user running the db
have rights to access it ? Does this user have rights to write to it ? To
create files and subfolders ?
Best Regards,
Florin
-Ursprüngliche
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
Jayaprakash,
We would all like to help you. I think the issue is that there is a
lack of information to properly diagnose the problem. Therefore a
workaround is hard to recommend. From my perspective, the most
important piece of missing information is a thread dump.
There are many resources
Jayaprakash,
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:
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 =
11 matches
Mail list logo