db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2969) Admin Guide: Document that online backup is non-blocking
Date Thu, 07 Feb 2008 21:39:10 GMT

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

Kim Haase commented on DERBY-2969:
----------------------------------

I see what you mean, I think. The introductory material in "Online backups" (http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup63476.html)
does not contain this information, nor does http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup01.html,
which contains the sentence you cite.

It will probably help if we change

"Use online backups to back up a database while it is running."

to

"Use online backups to back up a database while it is running, without blocking transactions."

The topic http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup01.html discusses a
few situations in which blocking does occur (for unlogged operations, that is) but does not
state explicitly that for all but these cases, transactions are not blocked. 

Would it be correct to change the sentence you cite as follows?

"The SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure puts the database into a state in which
it can be safely copied, without blocking transactions (except in a few cases mentioned in
"Unlogged operations"). The procedure then copies the entire original database directory (including
data files, online transaction log files, and jar files) to the specified backup directory."

Would any other changes be useful, or is that enough? 

I'll file a patch that includes these changes, in the meantime.

> Admin Guide: Document that online backup is non-blocking
> --------------------------------------------------------
>
>                 Key: DERBY-2969
>                 URL: https://issues.apache.org/jira/browse/DERBY-2969
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Jørgen Løland
>            Priority: Minor
>
> The Admin Guide does not mention that the online backup functionality is non-blocking.
The information that a backup can be made without blocking transactions may be of great interest
to administrators.
> Furthermore, this sentence implies that online backup is performed by *blocking* updates:
> "The SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure puts the database into a state in which
it can be safely copied, then copies the entire original database directory (including data
files, online transaction log files, and jar files) to the specified backup directory.
> Admin guide, online backup:
> http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup63476.html

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message