I am using an Ambari HDP distribution of the Phoenix client
(/usr/hdp/2.3.4.0-3485/phoenix/phoenix-4.4.0.2.3.4.0-3485-client.jar), and to
close database connections I am using the standard Java JDBC try-with-resources
process
(http://www.mastertheboss.com/jboss-server/jboss-datasource/using-try-with-resources-to-close-database-connections
,
https://docs.oracle.com/javase/tutorial/essential/exceptions/tryResourceClose.html).
From: Samarth Jain
Sent: Friday, 15 April 2016, 16:03
Subject: Re: Getting swamped with Phoenix *.tmp files on SELECT.
What version of phoenix are you using? Is the application properly closing
statements and result sets?
On Friday, April 15, 2016, wrote:
I am running into an issue where a huge number temporary files are being
created in my C:\Users\myuser\AppData\Local\Temp folder, they are around 20MB
big and never get cleaned up. These *.tmp files grew to around 200GB before I
stopped the server.
Example file names:
7a0967de-9dff-432b-bcfe-de30bc630add5176202498513378657.tmp
813e40e1-afa9-4847-919c-7c55f95f8a475501154042645376476.tmp
1329da43-561d-4e68-9120-56bd650a6ac98781585316402092121.tmp
Currently, I have my Phoenix Client jar deployed to Wildfly 10 as described
here: https://docs.jboss.org/author/display/TEIID/Phoenix+Data+Sources
These *.tmp files only appear when I run SELECT queries.
Any help would be appreciated.
