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 "Suresh Thalamati (JIRA)" <de...@db.apache.org> on 2006/01/17 02:52:21 UTC

[jira] Updated: (DERBY-239) Need a online backup feature that does not block update operations when online backup is in progress.

     [ http://issues.apache.org/jira/browse/DERBY-239?page=all ]

Suresh Thalamati updated DERBY-239:
-----------------------------------

    Attachment: onlinebackup_7.diff

This patch addresses the issues raised by Øystein in his review of previous
online backup patches 3-6. 

- changed the backup procedures names with ONLINE to NOWAIT 
- removed the transaction Idle restriction to run backup procedures.
- removed implicit commit/rollbacks.
- Added a new lesser impact restriction, which only disallows backup call only if
  there are unlogged operations executed in the same transaction before the backup. 
- Removed casting to  RawTransaction. 
- fixed Names and Comments. 
- Enhanced the tests with addional test cases suggested by  Øystein.


TESTS : derbyall test suite passed on Windows XP/JDK142

It would be great if some can review and commit this patch. 


svn stat:
M      java\engine\org\apache\derby\impl\sql\catalog\DataDictionaryImpl.java
M      java\engine\org\apache\derby\impl\db\BasicDatabase.java
M      java\engine\org\apache\derby\impl\store\raw\xact\Xact.java
M      java\engine\org\apache\derby\impl\store\raw\xact\XactFactory.java
M      java\engine\org\apache\derby\impl\store\raw\RawStore.java
M      java\engine\org\apache\derby\impl\store\raw\data\BaseDataFileFactory.java

M      java\engine\org\apache\derby\impl\store\raw\data\RFResource.java
M      java\engine\org\apache\derby\iapi\store\access\AccessFactory.java
M      java\engine\org\apache\derby\iapi\store\raw\xact\RawTransaction.java
M      java\engine\org\apache\derby\iapi\store\raw\xact\TransactionFactory.java
M      java\engine\org\apache\derby\iapi\store\raw\RawStoreFactory.java
M      java\engine\org\apache\derby\iapi\reference\SQLState.java
M      java\engine\org\apache\derby\catalog\SystemProcedures.java
M      java\engine\org\apache\derby\loc\messages_en.properties
M      java\testing\org\apache\derbyTesting\functionTests\tests\store\OnlineBackupTest1.java
M      java\testing\org\apache\derbyTesting\functionTests\tests\store\onlineBackupTest2.sql
M      java\testing\org\apache\derbyTesting\functionTests\tests\store\OnlineBackupTest3.java
M      java\testing\org\apache\derbyTesting\functionTests\master\OnlineBackupTest1.out
M      java\testing\org\apache\derbyTesting\functionTests\master\onlineBackupTest2.out
M      java\testing\org\apache\derbyTesting\functionTests\master\OnlineBackupTest3.out


> Need a online backup feature  that does not block update operations   when online backup is in progress.
> --------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-239
>          URL: http://issues.apache.org/jira/browse/DERBY-239
>      Project: Derby
>         Type: New Feature
>   Components: Store
>     Versions: 10.1.1.0
>     Reporter: Suresh Thalamati
>     Assignee: Suresh Thalamati
>  Attachments: obtest_customer.jar, onlinebackup.html, onlinebackup1.html, onlinebackup_1.diff, onlinebackup_2.diff, onlinebackup_3.diff, onlinebackup_4.diff, onlinebackup_5.diff, onlinebackup_6.diff, onlinebackup_7.diff
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Re: [jira] Updated: (DERBY-239) Need a online backup feature that does not block update operations when online backup is in progress.

Posted by Mike Matrigali <mi...@sbcglobal.net>.
I have run tests and committed this patch as svn 370530

Suresh Thalamati (JIRA) wrote:
>      [ http://issues.apache.org/jira/browse/DERBY-239?page=all ]
> 
> Suresh Thalamati updated DERBY-239:
> -----------------------------------
> 
>     Attachment: onlinebackup_7.diff
> 
> This patch addresses the issues raised by Øystein in his review of previous
> online backup patches 3-6. 
> 
> - changed the backup procedures names with ONLINE to NOWAIT 
> - removed the transaction Idle restriction to run backup procedures.
> - removed implicit commit/rollbacks.
> - Added a new lesser impact restriction, which only disallows backup call only if
>   there are unlogged operations executed in the same transaction before the backup. 
> - Removed casting to  RawTransaction. 
> - fixed Names and Comments. 
> - Enhanced the tests with addional test cases suggested by  Øystein.
> 
> 
> TESTS : derbyall test suite passed on Windows XP/JDK142
> 
> It would be great if some can review and commit this patch. 
> 
> 
> svn stat:
> M      java\engine\org\apache\derby\impl\sql\catalog\DataDictionaryImpl.java
> M      java\engine\org\apache\derby\impl\db\BasicDatabase.java
> M      java\engine\org\apache\derby\impl\store\raw\xact\Xact.java
> M      java\engine\org\apache\derby\impl\store\raw\xact\XactFactory.java
> M      java\engine\org\apache\derby\impl\store\raw\RawStore.java
> M      java\engine\org\apache\derby\impl\store\raw\data\BaseDataFileFactory.java
> 
> M      java\engine\org\apache\derby\impl\store\raw\data\RFResource.java
> M      java\engine\org\apache\derby\iapi\store\access\AccessFactory.java
> M      java\engine\org\apache\derby\iapi\store\raw\xact\RawTransaction.java
> M      java\engine\org\apache\derby\iapi\store\raw\xact\TransactionFactory.java
> M      java\engine\org\apache\derby\iapi\store\raw\RawStoreFactory.java
> M      java\engine\org\apache\derby\iapi\reference\SQLState.java
> M      java\engine\org\apache\derby\catalog\SystemProcedures.java
> M      java\engine\org\apache\derby\loc\messages_en.properties
> M      java\testing\org\apache\derbyTesting\functionTests\tests\store\OnlineBackupTest1.java
> M      java\testing\org\apache\derbyTesting\functionTests\tests\store\onlineBackupTest2.sql
> M      java\testing\org\apache\derbyTesting\functionTests\tests\store\OnlineBackupTest3.java
> M      java\testing\org\apache\derbyTesting\functionTests\master\OnlineBackupTest1.out
> M      java\testing\org\apache\derbyTesting\functionTests\master\onlineBackupTest2.out
> M      java\testing\org\apache\derbyTesting\functionTests\master\OnlineBackupTest3.out
> 
> 
> 
>>Need a online backup feature  that does not block update operations   when online backup is in progress.
>>--------------------------------------------------------------------------------------------------------
>>
>>         Key: DERBY-239
>>         URL: http://issues.apache.org/jira/browse/DERBY-239
>>     Project: Derby
>>        Type: New Feature
>>  Components: Store
>>    Versions: 10.1.1.0
>>    Reporter: Suresh Thalamati
>>    Assignee: Suresh Thalamati
>> Attachments: obtest_customer.jar, onlinebackup.html, onlinebackup1.html, onlinebackup_1.diff, onlinebackup_2.diff, onlinebackup_3.diff, onlinebackup_4.diff, onlinebackup_5.diff, onlinebackup_6.diff, onlinebackup_7.diff
>>
>>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.
> 
>