v17 has introduced a facility to start and stop TCP/IP and HTTP(S) listeners on a running database server w.t.h. of the new sp_start_listener and sp_stop_listener system procedures.

For am moment, I thought they could also be used to simulate dropped/re-established connections in a HA demo setup. However, that does not work as expected.

Am I right that this is doomed to fail (once the initial mirror connections have been established) because stopping the listeners does only affect new connections and not those already existing mirror connections? (And it will also create problems when the listeners for the primary server are stopped, thus preventing new connections to that server although the HA system still treats that server as primary because the internal mirror connections are functional?)

FWIW: Stopping all listeners and then dropping the current connection allows also for a nice catch-22 experience...

asked 29 Mar '17, 16:56

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 29 Mar '17, 16:58

Listeners are only used to accept new connections. Existing connections live on until they die or disconnected. {see the "Remarks" section for sp_stop_listener}

You could consider stopping the listener and forcing disconnects on any other existing connections if that fits your requirements.

permanent link

answered 29 Mar '17, 18:59

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 29 Mar '17, 16:56

question was seen: 1,700 times

last updated: 29 Mar '17, 18:59