Products | Versions |
---|---|
TIBCO Data Virtualization | 7.0.6 |
Analysis:
Tmp file continued to grow under this directory: tmp/hashcursors
No Users were logged into the system
These tmp tables are created when the results of a query are too large to hold in memory and are eventually "spilled to disk”
Generally DV restart would cleared the Temp files but in this instance after the restart tmp files continued to pile up very quickly
Log in to Studio and look at Requests Panel to review if there are any active requests
There will be a bunch of system requests running but they will finish very quickly and also gets cleared by clicking on “Purge Completed Requests”
In this instance, I noticed a Query that was not completing. Reviewed the Query Plan and Identified the view that was executing continuously. It was trying to collect statistics on that view continuously. It was a Full table statistics