[
https://issues.apache.org/jira/browse/DERBY-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12572852#action_12572852
]
Jørgen Løland commented on DERBY-3428:
--------------------------------------
I tried the following:
---8<----
term1: start NS
term2: boot database '//localhost/test'
term3: shutdown '//localhost/test'
term2: show tables
ERROR 08006: A network protocol error was encountered and the connection has
been terminated: the requested command encountered an unarchitected and
implementation-specific condition for which there was no architected message
--->8------
Hence, this is the message you get when you try to do something with a
connection to a database that has been closed. It is not replication-specific.
I'll open a new jira for this.
> 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, Derby3428_v1.diff,
> Derby3428_v1.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.
