[
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:
> [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.
