[ https://issues.apache.org/jira/browse/DERBY-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12571704#action_12571704 ]
V.Narayanan commented on DERBY-3428: ------------------------------------ Narayanan says >During the course of developing this patch I observed that we should have a >tearDown method on >the transmitter that the log shipper could call when it does a stopShipment. >This would basically >bring down the socket and the associated streams. I am *not* submitting this >as part of this patch. Jorgen says >You mention that stream.close is not handled in this patch, so I guess a >follow-up patch (or patch in >another jira) is needed anyway. I submitted a patch for resolving this issue in Derby-3364. Derby-3364 was basically due to unsatisfactory cleanup upon replication failover attempts (A failover attempt can basically succeed or fail, cleanup needs to be done either way.) > Doing a replication failover should shutdown the database and the connection > should no longer be available > ---------------------------------------------------------------------------------------------------------- > > Key: DERBY-3428 > URL: https://issues.apache.org/jira/browse/DERBY-3428 > Project: Derby > Issue Type: Bug > Components: Replication > Affects Versions: 10.4.0.0 > Reporter: V.Narayanan > Assignee: V.Narayanan > Attachments: Derby3428.diff, Derby3428.stat > > > Oystein says (as part of comments in Derby-3205) > After executing a failover, I am told that the database is shut down, but I > still able to use the connection to access the database: > ij version 10.4 > ij> connect 'jdbc:derby:masterDB;user=oystein;password=pass'; > ij> call syscs_util.syscs_freeze_database(); > 0 rows inserted/updated/deleted > ij> connect > 'jdbc:derby:masterDB;user=oystein;password=pass;startMaster=true;slaveHost=localhost'; > ij(CONNECTION1)> call syscs_util.syscs_unfreeze_database(); > 0 rows inserted/updated/deleted > ij(CONNECTION1)> connect > 'jdbc:derby:masterDB;user=oystein;password=pass;failover=true'; > ERROR XRE20: Failover performed successfully for database 'null', the > database has been shutdown. > ij(CONNECTION1)> select * from t; > I > ----------- > 1 > 2 > 3 > 4 > 5 > 6 > 7 > 8 > 9 > 10 > 10 > 11 rows selected > ij(CONNECTION1)> -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.