I am using an Ambari HDP distribution of the Phoenix client (/usr/hdp/, 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:


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.