Subject | Using service manager to backup a database |
---|---|
Author | tradesignalenterprise |
Post date | 2002-11-07T09:34:46Z |
Hi there,
I have problems using the service manager to backup a database.
I have a dedicated thread that uses isc_service_attach, then
isc_service_start with the action isc_action_svc_backup. This
succeeds, so I may retrieve verbose results with isc_service_query.
In the end, I detach from the service manager and terminate this
thread.
Everything works fine as long as the backup is successful.
But when there is not enough space left for the backup file (e.g.
trying to back up a large DB onto a diskette), the server starts to
behave strangely.
Transactions (runnning in another thread) doesn't succeed anymore,
and the database connection is rendered useless.
I keep getting this error:
Unable to complete network request to host "localhost". (Unsuccessful
execution caused by a system error that precludes
successful execution of subsequent statements).
I think it should be possible to use the service manager to backup
AND to handle possible errors gracefully? Is this a known bug or is
it just me doing things wrong?
Version: 6.2.794
Regards,
Ingo Hunsinger
I have problems using the service manager to backup a database.
I have a dedicated thread that uses isc_service_attach, then
isc_service_start with the action isc_action_svc_backup. This
succeeds, so I may retrieve verbose results with isc_service_query.
In the end, I detach from the service manager and terminate this
thread.
Everything works fine as long as the backup is successful.
But when there is not enough space left for the backup file (e.g.
trying to back up a large DB onto a diskette), the server starts to
behave strangely.
Transactions (runnning in another thread) doesn't succeed anymore,
and the database connection is rendered useless.
I keep getting this error:
Unable to complete network request to host "localhost". (Unsuccessful
execution caused by a system error that precludes
successful execution of subsequent statements).
I think it should be possible to use the service manager to backup
AND to handle possible errors gracefully? Is this a known bug or is
it just me doing things wrong?
Version: 6.2.794
Regards,
Ingo Hunsinger