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 "Jørgen Løland (JIRA)" <ji...@apache.org> on 2008/10/24 15:21:44 UTC

[jira] Created: (DERBY-3921) Replication: Test replication of encrypted databases

Replication: Test replication of encrypted databases
----------------------------------------------------

                 Key: DERBY-3921
                 URL: https://issues.apache.org/jira/browse/DERBY-3921
             Project: Derby
          Issue Type: Test
            Reporter: Jørgen Løland


It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-3921:
-------------------------------

    Attachment: DERBY-3921_diff-v5.txt

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.0.0
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Commented: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711618#action_12711618 ] 

Rick Hillegas commented on DERBY-3921:
--------------------------------------

Hi Ole: Sorry for not promptly reviewing your revised patch. I applied it and it seemed to me that the chunks which failed did not affect the point of the patch: adding a test for replication of encrypted databases. The regression test suite ran cleanly for me. I think this is a good increment. I have committed the revised patch at subversion revision 777105.

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Reopened: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik reopened DERBY-3921:
----------------------------------


Reopening to backport to 10.5 branch.

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Improvement
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Closed: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik closed DERBY-3921.
--------------------------------

    Resolution: Fixed

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Improvement
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>             Fix For: 10.5.2.1, 10.6.0.0
>
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-3921:
-------------------------------

    Attachment: DERBY-3921_diff.txt
                DERBY-3921_stat.txt

Attaching a patch for testing replication on encrypted databases.

The patch also contains a couple of additional changes 
- cleanup of support mechanisms for replication and
- a simple test for indexing in replicated databases.



M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun.java
       - Adding support for running replication tests on encrypted databases. (DERBY-3921.) 
         Adding a support method (makeReadyForReplication()) which handles all setup to run
         a test on a replicated database.
         Use of this has been only partially implemented (Only in the tests touched by this patch.)
         Will simplify more of the replicationtests to use this later on.
       - Adding support to run a simple (short time) replication load by default.
         To use the previous default load use '-Dderby.tests.replSimpleLoad'.

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_3.java
       Adding support for running replication tests on encrypted databases. (DERBY-3921.) 

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_3_p4.java
       Adding support for running replication tests on encrypted databases. (DERBY-3921.) 

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local.java
       testReplication_Local_existingTestsAsReplLoad() renamed to testReplication_Local_TestStraightReplication()

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_3_p1.java
M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_3_p3.java
       Using param 'replicationTest=null' to NOT run any replication load.       

A      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_3_p5.java
       Test DERBY-3924 verifying the fix for DERBY-3878: test for restart of slave after master has crashed.

A      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_3_p6.java
       Test for DERBY-3896: failure in LogicalUndoOperation.doMe()  when starting slave with uncommitted 
       transactions on the master. 
       - testReplication_Local_3_p6_DERBY_3896() should be enabled when DERBY-3896 is fixed.


A      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_1Indexing.java
       Simple test to verify indexes are replicated.


A      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_Encrypted_1.java
       DERBY-3921: Testing replication of encrypted databases.


M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Local_StateTest_part2.java
       Renaming some package internal methods.


M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationSuite.java
       Enabling new tests: 
       - ReplicationRun_Local_Encrypted_1 - test for DERBY-3921 / test replication of encrypted db.,
       - ReplicationRun_Local_3_p5 - test for DERBY-3924 / replication: test for restart of slave after master has crashed, 
       - ReplicationRun_Local_3_p6 - test for DERBY-3896 / replication: failure in LogicalUndoOperation.doMe() 
         when starting slave with uncommitted transactions on the master.
       - ReplicationRun_Local_1Indexing - simple test on indexing with replication, 
       


> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-3921:
-------------------------------

    Derby Info: [Patch Available]

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Commented: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12736854#action_12736854 ] 

Dag H. Wanvik commented on DERBY-3921:
--------------------------------------

Backported to 10.5 branch as svn 799091, closing.


> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Improvement
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>             Fix For: 10.5.2.1, 10.6.0.0
>
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Commented: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710825#action_12710825 ] 

Dag H. Wanvik commented on DERBY-3921:
--------------------------------------

Tried to look at this patch, but it could no longer be applied..


> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-3921:
---------------------------------

    Issue Type: Improvement  (was: Test)

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Improvement
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Commented: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680177#action_12680177 ] 

Rick Hillegas commented on DERBY-3921:
--------------------------------------

Thanks for the patch Ole. The replication suite ran cleanly for me after applying these changes. I have a couple small comments on the patch:

Style: In a number of these tests, the setUp() and tearDown() overrides don't seem to do anything. I'd be inclined to remove these methods.

Headers: I like the fact that some of the test cases have JIRA numbers embedded in their names. This helps connect the test cases with the issues. It would be even more helpful if the test cases had header comments which explained more about what was being tested.

Factoring: I see a lot of instances of code like this, which I'd recommend abstracting into a shared method:

+           URL = DB_PROTOCOL
+                +"://"+masterServerHost
+                +":"+masterServerPort+"/"
+                +masterDatabasePath+FS+masterDbSubPath+FS+replicatedDb
+                +useEncryption(false);

Thanks.



> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.0.0
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Closed: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg closed DERBY-3921.
------------------------------

    Resolution: Fixed

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Improvement
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-3921:
---------------------------------

    Fix Version/s: 10.6.0.0
                   10.5.2.1

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Improvement
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>             Fix For: 10.5.2.1, 10.6.0.0
>
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-3921:
-------------------------------

          Component/s: Test
    Affects Version/s: 10.5.0.0

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.0.0
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Commented: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680831#action_12680831 ] 

Ole Solberg commented on DERBY-3921:
------------------------------------

Thanks for your review Rick.

I have uploaded DERBY-3921_diff-v5.txt which should take care of your comments:
- cleaned up setUp(), tearDown(),
- added more header comments in test cases being part of this patch,
- refactored 'URL = DB_PROTOCOL ....." code.

I will add more header comments in other test cases as part of  DERBY-4026.

Reran tests.


Thanks.


> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.0.0
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3921:
----------------------------------

    Component/s: Replication

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication
>            Reporter: Jørgen Løland
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Assigned: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg reassigned DERBY-3921:
----------------------------------

    Assignee: Ole Solberg

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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


[jira] Updated: (DERBY-3921) Replication: Test replication of encrypted databases

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-3921:
-------------------------------

    Derby Info:   (was: [Patch Available])

> Replication: Test replication of encrypted databases
> ----------------------------------------------------
>
>                 Key: DERBY-3921
>                 URL: https://issues.apache.org/jira/browse/DERBY-3921
>             Project: Derby
>          Issue Type: Test
>          Components: Replication, Test
>    Affects Versions: 10.5.1.1
>            Reporter: Jørgen Løland
>            Assignee: Ole Solberg
>         Attachments: DERBY-3921_diff-v5.txt, DERBY-3921_diff.txt, DERBY-3921_stat.txt
>
>
> It should be possible to replicate encrypted databases. Tests are needed to ensure that this works.

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