SHOW RESQUEUE

[Andrew21210]

I realize the SHOW commands are undocumented but I want to find out how to read the output from SHOW RESQUEUE. Here is what I get:

RESOURCETimeout is 60 minutes.
Resource list is unlocked.
==========================================================
This is a local waiter.
status=resWaiting waitTime=0 minutes
waiter Type=unknown (0) timeout value=60 minutes
txnSeqNo=0:1574362415 resourceName=(243.1) lengthLen=5
type=19002 and nameSpace=0
waiter thead id is 937079 condition=-1618228168
mutex=-2127483720 abortFunc=809d4184
==========================================================
This is a local waiter.
status=resWaiting waitTime=2 minutes
waiter Type=unknown (0) timeout value=60 minutes
txnSeqNo=0:1574361412 resourceName=(*NULL*) lengthLen=0
type=57001 and nameSpace=0
waiter thead id is 23 condition=-985421016
mutex=-2127483720 abortFunc=809d4184
==========================================================


I have no idea how to read this or if there is an issue.

 

[marclant]

It gets complex quick. First, you will need to look at show threads to identify what those 2 threads are doing, that should tell you what is doing the waiting for a resource.