tmp file in directory hashcursors grows continuosly
Article ID: KB0082315
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.6 |
Description
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
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
Issue/Introduction
tmp file in directory hashcursors grows continuosly
Resolution
Cancelled that query and destroyed the Cache and Statistics for that View. Restarted the DV Server.
Did not notice the tmp file under hashcursors directory after those steps
Did not notice the tmp file under hashcursors directory after those steps
Feedback
Yes
No
Powered by
