Issue Details (XML | Word | Printable)

Key: DERBY-239
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Suresh Thalamati
Reporter: Suresh Thalamati
Votes: 4
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Derby

Need a online backup feature that does not block update operations when online backup is in progress.

Created: 27/Apr/05 02:44 AM   Updated: 01/Jul/09 12:34 AM
Return to search
Component/s: Store
Affects Version/s: 10.1.1.0
Fix Version/s: 10.2.1.6

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

File Attachments:
  Size
Java Archive File Licensed for inclusion in ASF works obtest_customer.jar 2005-12-17 08:21 AM Suresh Thalamati 2 kB
HTML File Licensed for inclusion in ASF works onlinebackup.html 2005-10-07 02:24 AM Suresh Thalamati 28 kB
HTML File Licensed for inclusion in ASF works onlinebackup1.html 2005-12-01 11:24 AM Suresh Thalamati 33 kB
HTML File Licensed for inclusion in ASF works onlinebackup2.html 2006-02-01 08:46 AM Suresh Thalamati 35 kB
File Licensed for inclusion in ASF works onlinebackup_1.diff 2005-10-08 03:49 AM Suresh Thalamati 42 kB
File Licensed for inclusion in ASF works onlinebackup_2.diff 2005-11-01 03:54 AM Suresh Thalamati 0.5 kB
File Licensed for inclusion in ASF works onlinebackup_3.diff 2005-11-15 11:50 AM Suresh Thalamati 35 kB
File Licensed for inclusion in ASF works onlinebackup_4.diff 2005-12-01 05:04 PM Suresh Thalamati 62 kB
File Licensed for inclusion in ASF works onlinebackup_5.diff 2005-12-07 03:53 AM Suresh Thalamati 6 kB
File Licensed for inclusion in ASF works onlinebackup_6.diff 2005-12-16 07:02 PM Suresh Thalamati 33 kB
File Licensed for inclusion in ASF works onlinebackup_7.diff 2006-01-17 10:51 AM Suresh Thalamati 73 kB
File Licensed for inclusion in ASF works onlinebackup_8.diff 2006-01-29 08:03 AM Suresh Thalamati 51 kB
Issue Links:
Reference
 

Resolution Date: 01/Mar/06 04:54 AM

Sub-Tasks  All   Open   
No sub-tasks match this view.

 Description  « Hide
Currently Derby allows users to perfoms online backups using SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure, but while the backup is in progress, update operations are temporarily blocked, but read operations can still proceed.

Blocking update operations can be real issue specifically in client server environments, because user requests will be blocked for a long time if a
backup is in the progress on the server.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Suresh Thalamati made changes - 25/May/05 09:34 AM
Field Original Value New Value
Assignee Suresh Thalamati [ tsuresh ]
Suresh Thalamati made changes - 07/Oct/05 02:24 AM
Attachment onlinebackup.html [ 12314754 ]
Suresh Thalamati made changes - 08/Oct/05 03:49 AM
Attachment onlinebackup_1.diff [ 12314772 ]
Suresh Thalamati made changes - 08/Oct/05 03:49 AM
Status Open [ 1 ] In Progress [ 3 ]
Suresh Thalamati made changes - 01/Nov/05 03:54 AM
Attachment onlinebackup_2.diff [ 12320417 ]
Suresh Thalamati made changes - 15/Nov/05 11:50 AM
Attachment onlinebackup_3.diff [ 12320690 ]
Suresh Thalamati made changes - 01/Dec/05 11:24 AM
Attachment onlinebackup1.html [ 12321063 ]
Suresh Thalamati made changes - 01/Dec/05 05:04 PM
Attachment onlinebackup_4.diff [ 12321067 ]
Suresh Thalamati made changes - 07/Dec/05 03:53 AM
Attachment onlinebackup_5.diff [ 12321175 ]
Suresh Thalamati made changes - 16/Dec/05 07:02 PM
Attachment onlinebackup_6.diff [ 12321364 ]
Suresh Thalamati made changes - 17/Dec/05 08:21 AM
Attachment obtest_customer.jar [ 12321383 ]
Suresh Thalamati made changes - 17/Jan/06 10:51 AM
Attachment onlinebackup_7.diff [ 12321989 ]
Suresh Thalamati made changes - 21/Jan/06 02:50 AM
Link This issue relates to DERBY-523 [ DERBY-523 ]
Suresh Thalamati made changes - 29/Jan/06 08:03 AM
Attachment onlinebackup_8.diff [ 12322460 ]
Mike Matrigali made changes - 30/Jan/06 07:54 AM
Environment
Description Currently Derby allows users to perfoms online backups using SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure, but while the backup is in progress, update operations are temporarily blocked, but read operations can still proceed.

Blocking update operations can be real issue specifically in client server environments, because user requests will be blocked for a long time if a
backup is in the progress on the server.
Currently Derby allows users to perfoms online backups using SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure, but while the backup is in progress, update operations are temporarily blocked, but read operations can still proceed.

Blocking update operations can be real issue specifically in client server environments, because user requests will be blocked for a long time if a
backup is in the progress on the server.
Suresh Thalamati made changes - 01/Feb/06 08:46 AM
Attachment onlinebackup2.html [ 12322522 ]
Suresh Thalamati made changes - 01/Mar/06 04:54 AM
Status In Progress [ 3 ] Resolved [ 5 ]
Fix Version/s 10.2.0.0 [ 11187 ]
Resolution Fixed [ 1 ]
Suresh Thalamati made changes - 13/Jul/06 01:27 AM
Status Resolved [ 5 ] Closed [ 6 ]
Dag H. Wanvik made changes - 01/Jul/09 12:34 AM
Issue Type New Feature [ 2 ] Improvement [ 4 ]