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 "V.Narayanan (JIRA)" <ji...@apache.org> on 2008/04/16 08:50:21 UTC
[jira] Commented: (DERBY-3617) failover on slave hangs after
stopmaster on master.
[ https://issues.apache.org/jira/browse/DERBY-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12589437#action_12589437 ]
V.Narayanan commented on DERBY-3617:
------------------------------------
I tried a simple run without authentication enabled and and without executing any transactions
it seemed to work.
I will try this again with authentication enabled and after executing some transactions.
On the master
------------------
vn@vn-laptop:~/work/workspaces/Dery3617/master$ java org.apache.derby.tools.ij
ij version 10.5
ij> connect 'jdbc:derby://localhost:1527/replicationdb';
ij> connect 'jdbc:derby://localhost:1527/replicationdb;startMaster=true;slaveHost=localhost;slavePort=8001';
ij(CONNECTION1)> connect 'jdbc:derby://localhost:1527/replicationdb;stopMaster=true;slaveHost=localhost;slavePort=8001';
ij(CONNECTION2)>
On the slave
---------------
vn@vn-laptop:~/work/workspaces/Dery3617/slave$ java org.apache.derby.tools.ij
ij version 10.5
ij> connect 'jdbc:derby://localhost:1528/replicationdb;startSlave=true;slaveHost=localhost;slavePort=8001';
ERROR XRE08: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE08, SQLERRMC: Replication slave mode started successfully for database 'replicationdb'. Connection refused because the database is in replication slave mode.
ij> connect 'jdbc:derby://localhost:1528/replicationdb;failover=true';
ERROR XRE11: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE11, SQLERRMC: failoverreplicationdbXRE11
ij>
> failover on slave hangs after stopmaster on master.
> ---------------------------------------------------
>
> Key: DERBY-3617
> URL: https://issues.apache.org/jira/browse/DERBY-3617
> Project: Derby
> Issue Type: Bug
> Components: Replication
> Affects Versions: 10.5.0.0
> Environment: OS: Fedora release 7 (Moonshine) 32bits - Linux 2.6.23.15-80.fc7PAE #1 SMP Sun Feb 10 17:14:36 EST 2008 GNU/Linux
> JVM: java version "1.6.0_01"
> Java(TM) SE Runtime Environment (build 1.6.0_01-b06)
> Java HotSpot(TM) Server VM (build 1.6.0_01-b06, mixed mode)
> SVN: 647063
> Reporter: Ole Solberg
> Assignee: V.Narayanan
> Priority: Minor
> Attachments: db_master-derby.log, db_slave-derby.log, log.out
>
>
> 0. Master and slave in repl. mode.
> 1. master: stopmaster
> 2. slave failover.
> hangs.....
> According to "Functional Specification for Derby Replication" Rev. 9.0:
> "Failover": "... . The command is only accepted on the slave if the network conection with the master is down." so expecting failover to return valid Connection.
> However, failover never finish.
> See attached master and slave derby.log and testrun log.out.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.