db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "V.Narayanan (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3447) Shutdown on a database without stopping replication hangs
Date Sun, 16 Mar 2008 09:30:25 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12579176#action_12579176

V.Narayanan commented on DERBY-3447:

I was able to quit ij with authentication enabled on both the master
and slave with patch v3.

On the Master

vn@vn-laptop:~/work/workspaces/Derby3447_1/master$ java org.apache.derby.tools.ij
ij version 10.5
ij>  connect 'jdbc:derby:mydb;create=true;user=oystein;password=pass';
ij>  call syscs_util.syscs_freeze_database();
0 rows inserted/updated/deleted
ij> connect 'jdbc:derby:mydb;user=oystein;password=pass;startMaster=true;slaveHost=localhost;slavePort=8001';
ij(CONNECTION1)> create table narayanan(i int, name varchar(30));
0 rows inserted/updated/deleted
ij(CONNECTION1)> insert into narayanan values(2,'n1');
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into narayanan values(3, 'n2');
1 row inserted/updated/deleted
ij(CONNECTION1)> quit;

On the slave

ij version 10.5
ij>  connect 'jdbc:derby:mydb;user=oystein;password=pass;startSlave=true;slaveHost=localhost;slavePort=8001';
ERROR XRE08: Replication slave mode started successfully for database 'mydb'. Connection refused
because the database is in replication slave mode. 
ij> quit;

I tried it in both orders also (i.e.) first trying a quit on the master and then a quit on
the slave
and vice versa.

I also tried quit without executing any transactions on the master and in both orders.

It worked fine for me in all the cases with patch v3.

> Shutdown on a database without stopping replication hangs
> ---------------------------------------------------------
>                 Key: DERBY-3447
>                 URL: https://issues.apache.org/jira/browse/DERBY-3447
>             Project: Derby
>          Issue Type: Bug
>          Components: Replication
>    Affects Versions:
>            Reporter: V.Narayanan
>            Assignee: V.Narayanan
>         Attachments: Derby3447_v1.diff, Derby3447_v1.stat, Derby3447_v2.diff, Derby3447_v2.stat,
Derby3447_v3.diff, Derby3447_v3.stat

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

View raw message