Late yesterday I was working on a query for a report when the report locked up on me. Now I have 13 blocked threads and my CPU usage has jumped about 20%. All the blocked threads are listed as for reporting but show 0 CPU usage.
I found one thread listed as RUNNABLE that is also a reporting thread that is hovering around 20% CPU usage.
Has anyone seen this before? How can I clear the blocked threads and get my CPU usage back to normal? I’ve tried restarting the reporting module with no affect. I’m trying to avoid restarting the entire gateway but I’m starting to wonder if I will have to.