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/02/27 08:04:51 UTC
[jira] Commented: (DERBY-3394) 'NetworkServerControl shutdown' does
not complete on master server after 'failover'.
[ https://issues.apache.org/jira/browse/DERBY-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12572806#action_12572806 ]
Jørgen Løland commented on DERBY-3394:
--------------------------------------
I just tried to start a Derby server and immediately shut it down through an ij connection, i.e. no booting of databases, no replication involved what so ever. ij reports that the system is shut down, but nothing happens on the server. Seems like this issue is bigger than replication.
> '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:
> [os136789@supra05: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:
> [os136789@urd11: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.