Stuck Threads

I am having an issue that is causing threads to get stuck and never
terminate. It appears that the SQL Server driver is locking the thread and
never ending. This is causing the servers to need a reboot after a while. I
am pretty sure this has to do with slow queries but those should respect
the timeout of the server. I am trying to determine why I am getting the
slow queries (if that is even the issue).

Anyone have a suggestion?

https://lh3.googleusercontent.com/-Xc9FniaNo-w/WBekfQX-8qI/AAAAAAAAB3o/2jprNkSPs5oS0t1j25NFJqPq0crrZtE2wCLcB/s1600/Running%2BTransactions%253A%2BWebRequest%2B-%2BFusionReactor%2B-%2Bfusionreactor%2B2016-10-31%2B13-02-24.png

java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.socketRead0 http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=socketRead0&lineNo=-2(Native Method)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=150(SocketInputStream.java:150 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=121(SocketInputStream.java:121 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSChannel http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel&method=read&lineNo=1782(IOBuffer.java:1782 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSReader http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader.readPacket http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader&method=readPacket&lineNo=4881(IOBuffer.java:4881 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)

I am noticing that these happened durrrng SQL backups, which explains why
the queries ran longer. It does not explain why they are still running
since this morninga at 12:45On Monday, October 31, 2016 at 1:07:57 PM UTC-7, Lyle Karstensen wrote:

I am having an issue that is causing threads to get stuck and never
terminate. It appears that the SQL Server driver is locking the thread and
never ending. This is causing the servers to need a reboot after a while. I
am pretty sure this has to do with slow queries but those should respect
the timeout of the server. I am trying to determine why I am getting the
slow queries (if that is even the issue).

Anyone have a suggestion?

https://lh3.googleusercontent.com/-Xc9FniaNo-w/WBekfQX-8qI/AAAAAAAAB3o/2jprNkSPs5oS0t1j25NFJqPq0crrZtE2wCLcB/s1600/Running%2BTransactions%253A%2BWebRequest%2B-%2BFusionReactor%2B-%2Bfusionreactor%2B2016-10-31%2B13-02-24.png

java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.socketRead0 http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=socketRead0&lineNo=-2(Native Method)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=150(SocketInputStream.java:150 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=121(SocketInputStream.java:121 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSChannel http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel&method=read&lineNo=1782(IOBuffer.java:1782 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSReader http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader.readPacket http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader&method=readPacket&lineNo=4881(IOBuffer.java:4881 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)

Hi,

I have run into similar problems in the past with Railo and ACF where the
CF server was still waiting for a response back from SQL Server when the
request timed out. This result in similar sounding stuck threads that can
only be stopped with a restart of CF. The following article may be of
interest:

We solved our problem by carefully setting timeouts on certain queries to
ensure that they resolved one way or another before the request timed out.
The other option is to increase the request timeout, but I guess that is
not always suitable.

Hope this information helps.

All the best,

MartinOn Monday, 31 October 2016 20:30:53 UTC, Lyle Karstensen wrote:

I am noticing that these happened durrrng SQL backups, which explains why
the queries ran longer. It does not explain why they are still running
since this morninga at 12:45

On Monday, October 31, 2016 at 1:07:57 PM UTC-7, Lyle Karstensen wrote:

I am having an issue that is causing threads to get stuck and never
terminate. It appears that the SQL Server driver is locking the thread and
never ending. This is causing the servers to need a reboot after a while. I
am pretty sure this has to do with slow queries but those should respect
the timeout of the server. I am trying to determine why I am getting the
slow queries (if that is even the issue).

Anyone have a suggestion?

https://lh3.googleusercontent.com/-Xc9FniaNo-w/WBekfQX-8qI/AAAAAAAAB3o/2jprNkSPs5oS0t1j25NFJqPq0crrZtE2wCLcB/s1600/Running%2BTransactions%253A%2BWebRequest%2B-%2BFusionReactor%2B-%2Bfusionreactor%2B2016-10-31%2B13-02-24.png

java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.socketRead0 http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=socketRead0&lineNo=-2(Native Method)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=150(SocketInputStream.java:150 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=121(SocketInputStream.java:121 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSChannel http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel&method=read&lineNo=1782(IOBuffer.java:1782 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSReader http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader.readPacket http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader&method=readPacket&lineNo=4881(IOBuffer.java:4881 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)

Thanks for the reply. I set our timeout on all queries to 5 seconds less
then the request timeout to help prevent this and it does not work. I will
read the link and see if it helps.On Tuesday, November 1, 2016 at 3:20:34 AM UTC-7, mar...@cubicstate.com wrote:

Hi,

I have run into similar problems in the past with Railo and ACF where the
CF server was still waiting for a response back from SQL Server when the
request timed out. This result in similar sounding stuck threads that can
only be stopped with a restart of CF. The following article may be of
interest:

CF911: Lies, Damned Lies, and CF Request Timeouts...What You May Not Realize - Charlie Arehart - Server Troubleshooting

We solved our problem by carefully setting timeouts on certain queries to
ensure that they resolved one way or another before the request timed out.
The other option is to increase the request timeout, but I guess that is
not always suitable.

Hope this information helps.

All the best,

Martin

On Monday, 31 October 2016 20:30:53 UTC, Lyle Karstensen wrote:

I am noticing that these happened durrrng SQL backups, which explains why
the queries ran longer. It does not explain why they are still running
since this morninga at 12:45

On Monday, October 31, 2016 at 1:07:57 PM UTC-7, Lyle Karstensen wrote:

I am having an issue that is causing threads to get stuck and never
terminate. It appears that the SQL Server driver is locking the thread and
never ending. This is causing the servers to need a reboot after a while. I
am pretty sure this has to do with slow queries but those should respect
the timeout of the server. I am trying to determine why I am getting the
slow queries (if that is even the issue).

Anyone have a suggestion?

https://lh3.googleusercontent.com/-Xc9FniaNo-w/WBekfQX-8qI/AAAAAAAAB3o/2jprNkSPs5oS0t1j25NFJqPq0crrZtE2wCLcB/s1600/Running%2BTransactions%253A%2BWebRequest%2B-%2BFusionReactor%2B-%2Bfusionreactor%2B2016-10-31%2B13-02-24.png

java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.socketRead0 http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=socketRead0&lineNo=-2(Native Method)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=150(SocketInputStream.java:150 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
java.net.SocketInputStream http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=java.net.SocketInputStream&method=read&lineNo=121(SocketInputStream.java:121 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSChannel http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel.read http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSChannel&method=read&lineNo=1782(IOBuffer.java:1782 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)
com.microsoft.sqlserver.jdbc.TDSReader http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader.readPacket http://web-0:8800/fusionreactor/findex.htm?p=decompile&classname=com.microsoft.sqlserver.jdbc.TDSReader&method=readPacket&lineNo=4881(IOBuffer.java:4881 http://web-0:8800/fusionreactor/findex.htm?p=debugUnavailable)