'NetworkServerControl shutdown' does not complete on master server after 
'failover'.
------------------------------------------------------------------------------------

                 Key: DERBY-3394
                 URL: https://issues.apache.org/jira/browse/DERBY-3394
             Project: Derby
          Issue Type: Bug
          Components: Replication
    Affects Versions: 10.4.0.0
         Environment: svn r618655 + derby-3361-1b.diff
            Reporter: Ole Solberg


Master and slave servers startet.

Copy db from master to slave:
Master:
CONNECT 'jdbc:derby://urd11:8888/test';
call syscs_util.syscs_freeze_database();

In slave db directory:
scp -r urd11:/export/home/tmp/os136789/Replication_common_Trunk/master/test ./

Master:
CONNECT 'jdbc:derby://urd11:8888/test';
call syscs_util.syscs_unfreeze_database(); -- Should be done by startMaster....

Slave:
CONNECT 
'jdbc:derby://urd12:9999/test;startSlave=true;slaveHost=urd12;slavePort=8989';
ERROR XRE08: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE08, SQLERRMC: 
Replication slave mode started successfully for database 'test'. Connection 
refused because the database is in replication slave mode. 

Master:
CONNECT 
'jdbc:derby://urd11:8888/test;startMaster=true;slaveHost=urd12;slavePort=8989';
(OK.)


Run "insert and select test" on master db. OK.


Master:
CONNECT 'jdbc:derby://urd11:8888/test;failover=true';
ERROR XRE20: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE20, SQLERRMC: Failover 
performed successfully for database 'test', the database has been shutdown.
(OK.)

Slave derby.log:
Failover perfomed successfully for database 'test'.

Master derby.log:
2008-02-06 12:17:10.602 GMT Thread[DRDAConnThread_2,5,main] (DATABASE = test), 
(DRDAID = {5}), Failover performed successfully for database 'test', the 
database has been shutdown.

Connections to master db are ok:
[EMAIL PROTECTED]:common_Trunk] java org.apache.derby.tools.ij
ij version 10.4
ij> DRIVER 'org.apache.derby.jdbc.ClientDriver';
ij> CONNECT 'jdbc:derby://urd11:8888/test';
ij> select * from t;
K          |S                                                                   
                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
1          |1111111                                                             
                                                            
.
600        |600                                                                 
                                                            

21 rows selected

Master derby.log: no change....


On master host: attempted shutdown is not completed. 
<=====================================
.NetworkServerControl shutdown
Apache Derby Network Server - 10.4.0.0 alpha - (618655M) shutdown at 2008-02-06 
12:19:21.586 GMT

But the server is still running:
[EMAIL PROTECTED]:master] ps auxwww | grep drda
os136789 12797  0.4  2.7 192872 28652 pts/0  Sl   13:12   0:02 java -cp 
/home/os136789/Replication/common_Trunk/trunk/jars/insane/derbynet.jar 
org.apache.derby.drda.NetworkServerControl start -h 0.0.0.0 -p 8888 
-noSecurityManager

Master derby.log: no change....

Connections to the db now are refused:
CONNECT 'jdbc:derby://urd11:8888/test';
ERROR 08001: java.net.ConnectException : Error connecting to server urd11 on 
port 8888 with message Connection refused.


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

Reply via email to