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 "Kim Haase (JIRA)" <ji...@apache.org> on 2008/02/07 22:39:10 UTC
[jira] Commented: (DERBY-2969) Admin Guide: Document that online
backup is non-blocking
[ 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.