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
Stack Trace
[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.
at com.documentum.fc.client.impl.session.Session.getServer(Session.java:3494)
at com.documentum.fc.client.impl.session.Session.getServerVersion(Session.java:850)
at com.documentum.fc.client.impl.session.SessionHandle.getServerVersion(SessionHandle.java:302)
at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:138)
at com.documentum.fc.client.DfQuery.execute(DfQuery.java:211)
at com.abc.documentum.DocumentumMethods.execQuery(DocumentumMethods.java:214)
