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 "Ole Solberg (JIRA)" <ji...@apache.org> on 2009/10/22 12:54:59 UTC

[jira] Created: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

Enable distributed replication testing - master server, slave server and test client running on different hosts.
----------------------------------------------------------------------------------------------------------------

                 Key: DERBY-4417
                 URL: https://issues.apache.org/jira/browse/DERBY-4417
             Project: Derby
          Issue Type: Sub-task
            Reporter: Ole Solberg
            Assignee: Ole Solberg




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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Issue & fix info:   (was: [Patch Available])

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY-4417_P2_p1.diff.txt, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Attachment: DERBY_distr_repl_D-start_script.txt

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Commented: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg commented on DERBY-4417:
------------------------------------

Committed DERBY-4417_P1_p1.diff to trunk as revision 894607.

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Issue & fix info:   (was: [Patch Available])

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Attachment: DERBY_distr_repl_C-replicationtest.properties
                DERBY_distr_repl_B.diff.txt
                DERBY_distr_repl_A.diff.txt

Attaching preliminary patches to run distributed replication testing - i.e. master server, slave server and test client running on different hosts.


DERBY_distr_repl_A.diff.txt
-------------------------------------
M      java/testing/org/apache/derbyTesting/functionTests/tests/multi/StressMultiTest.java

  Factoring out decorator code to make it available for cases when running against an 
  already existing server.
  Added clientSuite() to experiment with different number of threads and running time 
  on client/server.


DERBY_distr_repl_B.diff.txt
-------------------------------------
A      java/testing/org/apache/derbyTesting/functionTests/tests/multi/XStressMultiTest.java
  Run StressMultiTest against an existing server.

A      java/testing/org/apache/derbyTesting/functionTests/tests/multi/StressMultiClient50x59.java
  Experimenting with various settings for standard (localhost) StressMultiTest. Using
  clientServer() added in StressMultiTest().

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/StandardTests.java
  Added stressMultiTest() that sets up the XStressMultiTest suite.

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationTestRun.java
  Set to run without SecurityManager.

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun.java
  Enable to use jvms specified in replicationtest.properties file.
  NB. This needs further work to combine original use of BaseTestCase.getJavaExecutableName()
      and jvms specified in replicationtest.properties file.

A      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationTestRunStress.java
  Replication test load using StandardTest.stressMultiTest = XStressMultiTest.

M      java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Full.java
  Added initEnvironment() to get replication test configuration parameters from
  replicationtest.properties file located in "user.dir".


DERBY_distr_repl_C-replicationtest.properties
---------------------------------------------------------------
  Example replicationtest.properties to be copied to "user.dir" before starting distributed replication tests.


DERBY_distr_repl_D-start_script.txt
------------------------------------------------
  Example script to set up and run a distributed replication test.
  


> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Attachment: DERBY-4417_P1_p1.diff

DERBY-4417_P1_p1.diff.txt:
--------------------------
This patch is a preparation for patches to enable distributed replication testing.
The patch touches only java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun.java:

1. Allow a plain class w/main(), i.e. NOT using JUnit, as a client load when running distributed.

2. Introduced THREADS, MINUTES in preparation for the ReplicationTestRunStress/StressMultiTest load client.

3. Removed using pre-installed dummy ij script - still creates the script in ${HOME}.

 . Various cleanups: 
   - Removing unused code.
   - Introduced ReplicationRun.get{Master|Slave}JavaExecutableName() to handle
     the equivalent of BaseTestCase.getJavaExecutableName() also when running
     distributed: allowing jvms to be specified in replicationtest.properties.


org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationSuite and
org.apache.derbyTesting.functionTests.suites.All ran OK.
org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Distributed
also ran OK with various loads.

Planning to commit later today.


> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

          Component/s: Test
                       Replication
    Affects Version/s: 10.6.0.0

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Issue & fix info: [Patch Available]

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY-4417_P2_p1.diff.txt, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Issue & fix info: [Patch Available]

DERBY-4417_P1_p1.diff.txt intended for commit.

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Commented: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

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

Thanks, Ole! 
I know you said these are preliminary, so my comments may be premature. 
Just browsing through I noticed that you use System.out.println; is there a reason why you don't use
the println that's available (inherited) from BaseTestCase (prints conditionally if verbose set, i.e. derby.tests.debug).
I also notice that StressMultiClient50x59 is misnamed; it actually uses 100 by 30, should these numbers be parameterizable? And/or rename test? I this the name XStressMultiTest a could be more descriptive? 

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Commented: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg commented on DERBY-4417:
------------------------------------

Thanks, Dag!
I will fix these in the next upload of the patch - the printlns are from my testing, so are the name/"param" mismatch.
It's a good idea to make those numbers parameterizable. I agree the test should be renamed.


> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Updated: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg updated DERBY-4417:
-------------------------------

    Attachment: DERBY-4417_P2_p1.diff.txt

DERBY-4417_P2_p1.diff.txt:
---------------------------
This patch enables the ReplicationRun_Distributed test, reading a replication configuration from 
the replicationtest.properties file.

1. java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/ReplicationRun_Distributed.java
   - Write the "dummy" ij script 'ij_dummy_script.sql'.
   - Read replication configuration from  '${user.dir}/replicationtest.properties'.
   - Replace  System.out.println() with Utils.DEBUG()

2. java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/SimplePerfTest.java
   - Enable specifying database path name for test client connection.

3. java/testing/org/apache/derbyTesting/functionTests/tests/replicationTests/SimplePerfTest_Verify.java
   Added. A simple verificationclient for SimplePerfTest.java just asserting correct number of rows in 
   the test database (slave or master).

4. java/testing/org/apache/derbyTesting/junit/TestConfiguration.java
   - added existingServerSuite(..., dbPath).Ditto for clientExistingServerSuite(), existingServerDecorator()
     and TestConfiguration().

5. java/testing/org/apache/derbyTesting/junit/ServerSetup.java
   - added getNewConfiguration(..., dbPath) and ditto for ServerSetup().

Depends on DERBY-4417_P1_p1.diff.

Ran OK on suites.All and org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Distributed.

ReplicationRun_Distributed is not wired into suites.All. It is intended to be run "manually".


> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY-4417_P2_p1.diff.txt, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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


[jira] Commented: (DERBY-4417) Enable distributed replication testing - master server, slave server and test client running on different hosts.

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

Ole Solberg commented on DERBY-4417:
------------------------------------

Committed  DERBY-4417_P2_p1.diff.txt to trunk  as revision 895582.

> Enable distributed replication testing - master server, slave server and test client running on different hosts.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4417
>                 URL: https://issues.apache.org/jira/browse/DERBY-4417
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Replication, Test
>    Affects Versions: 10.6.0.0
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4417_P1_p1.diff, DERBY-4417_P2_p1.diff.txt, DERBY_distr_repl_A.diff.txt, DERBY_distr_repl_B.diff.txt, DERBY_distr_repl_C-replicationtest.properties, DERBY_distr_repl_D-start_script.txt
>
>


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