SA 10.0.1.4116 / Win64 + mirroring. Recently I've noticed some strange connections than hang around on server and cannot be dropped: an attempt to disconnect them using DROP CONNECTION statement yields 'User "DBA" dropped connection xxx' message on console, but connection itself stays intact. How can I get rid of them without server restart? |
There is a known issue (CR #702733 - 11.0.1.2786, 12.0.1.3713) which allows connections to be 'undroppable' in rare circumstances (usually involving a parallelized query that makes use of a HashFilter). Unfortunately, this fix has not been backported to the 10.0.1 codeline due to 10.0.1's "Archived" or "End-of-Life" status. Setting the connection option 'MAX_QUERY_TASKS' to '1' or restarting the database server is a workaround for the issue in 10.0.1. For more information about this issue, see my response to this question here: http://sqlanywhere-forum.sap.com/questions/6164/connections-that-cannot-be-dropped/6197 2
I'm now on 10.0.1.4239, and I naven't encountered 'undroppable' connections for quite a time, so my problem now appears fixed. But thanks for the info anyway :).
(02 Apr '12, 04:39)
Dmitri
|
Please show us an sa_conn_info() display. I'm just guessing but they may be internal processes that weren't well documented in 10. Does the connection number stay the same, or do they immediately come back to life with a different number?
Hmmm... not sure how I can make them readable, but anyway I'll try...
A bit of afterthought: can internal processes hang around for days? I've never seen it before...