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.