Hung Threads when executing query

Options
hr.prasan
hr.prasan
edited September 28, 2017 in Documentum #1

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)

Tagged:

Categories