Hung Threads when executing query
We are having a weird issue where we get hung threads randomly and that brings down the whole application. It doesn't happen often and we are not able to replicate it . The query that runs is a simple query and in normal situations it runs within milliseconds.
SELECT r_object_id FROM dm_folder WHERE any r_folder_path IN ('/ABC/Temp','/ABC/Temp/CDB','/ABC/Temp/Title','/ABC/TRASH').
It seems to be an issue with the application not being able to get a session maybe. Any ideas from anybody.
We get a huge number of threads hung like the below
[9/26/17 11:08:37:015 EDT] 00000022 ThreadMonitor W WSVR0605W: Thread "WebContainer : 1" (0000008e) has been active for 714135 milliseconds and may be hung. There is/are 3 thread(s) in total in the server that may be hung.