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? asked 08 Nov '10, 08:39 Dmitri |
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 answered 30 Mar '12, 15:59 Jeff Albion 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
|
Connections ## 13404 and 1018011895 through 1018011902 are 'undroppable', that is, DROP CONNECTION has no effect on them (first one holds some shared locks - they are still there). Actual user names changed to USERx for a bit of anonimity. answered 08 Nov '10, 17:20 Dmitri I'm hoping Graeme Perrow will step in here; in the meantime, check out this 12.0.0 doc and scroll down to "Name" to see a list of magic connections... dunno if what you're seeing in the high-numbers are in that list (no connection names in V10 or 11). Also, that user connection not being droppable, that is a puzzler. |
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...