I’m seeing named queries hanging in the gateway active query status screen when the client calling window is closed before the query results are returned. They will remain under the active query heading until manually cancelled.
SQL Server 12.0.5
The next time this happens, could you get a thread dump via Status -> Diagnostics -> Threads?
Can you clarify what you mean by the “client calling window”?
It sounds like you have a window open in the client, which executes the named query, and then, when closing the window, the query itself still shows within active queries until cancelling. Does that sound right?
So far I’ve had no luck in reproducing this behavior repeating the above. Is the named query executing from script or some binding? (albeit shouldn’t make much difference)
Yes, your description is correct. It just runs from a named query binding on a custom dataset property. It’s a complex query and the results can take a few seconds to come back so it’s not too hard for a user to open and close the window before the results have returned.
I did send a thread dump to Paul via a direct message. I can try to capture another example with multiple stuck in this condition.
Hi Tim, sorry for the delayed reply. Could you email email@example.com and reference this post? Also, if you can, please redo the test and attach the new thread dumps to the email. Thanks.