phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <marks1900-pos...@yahoo.com.au>
Subject Re: Getting swamped with Phoenix *.tmp files on SELECT.
Date Fri, 15 Apr 2016 20:42:03 GMT
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.


  
Mime
View raw message