Re: tmp files

2018-03-21 Thread Josh Elser
I've just discovered that Phoenix continue to create .tmp files in /tmp directory causing the disk to run out of space...is there a way to change this directory and run a cleanup?? Best, Flavio

Re: tmp files

2018-03-21 Thread Flavio Pompermaier
a.io.tmpdir system property. > > > On 3/20/18 12:47 PM, Flavio Pompermaier wrote: > >> Hi to all, >> I've just discovered that Phoenix continue to create .tmp files in /tmp >> directory causing the disk to run out of space...is there a way to change >> this directory and run a cleanup?? >> >> Best, >> Flavio >> >

Re: tmp files

2018-03-20 Thread Josh Elser
Are they ResultSpooler files? If so, you want to set `phoenix.spool.directory` which defaults to the java.io.tmpdir system property. On 3/20/18 12:47 PM, Flavio Pompermaier wrote: Hi to all, I've just discovered that Phoenix continue to create .tmp files in /tmp directory causing the disk

tmp files

2018-03-20 Thread Flavio Pompermaier
Hi to all, I've just discovered that Phoenix continue to create .tmp files in /tmp directory causing the disk to run out of space...is there a way to change this directory and run a cleanup?? Best, Flavio

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-21 Thread marks1900-post01
k either, please file a JIRA and one of us will take a look at it. - Samarth On Wed, Apr 20, 2016 at 1:41 PM, wrote: So I did some debugging and found the code responsible for this *.tmp files being created. https://github.com/hortonworks/phoenix-release/blob/HDP-2.4.0.0-tag/phoenix-core/src/main/jav

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-21 Thread Samarth Jain
a look at it. - Samarth On Wed, Apr 20, 2016 at 1:41 PM, <marks1900-pos...@yahoo.com.au> wrote: > So I did some debugging and found the code responsible for this *.tmp > files being created. > > > https://github.com/hortonworks/phoenix-release/blob/HDP-2.4.0.0-tag/phoenix-c

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-19 Thread Samarth Jain
D" > + " AND TS1.BRAND_ID = TSE.BRAND_ID" > + " GROUP BY TSE.ID" > + " ,TSE.CLIENT_ID" > + " ,TSE.BRAND_ID" > + " ,TSE.SITE_ID" > + " ,TSE.EMAIL" > + " ) AS TR" > + " LEFT OUTER

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-18 Thread marks1900-post01
"      ,TSE.CLIENT_ID"    + "      ,TSE.BRAND_ID"    + "       ,TSE.SITE_ID"    + "      ,TSE.EMAIL"    + "  ) AS TR"    + "  LEFT OUTER JOIN user.SESSION TS2"    + "      ON TS2.EMAIL = TR.EMAIL"    + "      AND TS2.BR

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-18 Thread Samarth Jain
Marks, FWIW, we had a problem with tmp files left over in case of failures - https://issues.apache.org/jira/browse/PHOENIX-1448. But this has been fixed since 4.2.1 release. To help us, can you post a sample query where you are seeing tmp files left over? Are you sure the application is cleanly

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-18 Thread marks1900-post01
Currently I am running out of disk space as a direct result of these spool temp files (350GB +), any ideas on how to address this?  These .tmp files never seem to be cleaned up after each query.  Is there any work-around? From: Samarth Jain <samarth.j...@gmail.com> To:

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-18 Thread marks1900-post01
r01:/hbase-unsecure  true  10485760  phoenix      SELECT 1 FROM SYSTEM.CATALOG LIMIT 1  -- Sent: Friday, 15 April 2016, 16:51 Subject: Re: Getting swamped with Phoenix *.tmp files on SELECT. We ran into something similar, here is the ticket  https://issues.apache.org/jira/browse/PHOEN

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-15 Thread Samarth Jain
--------- >> *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? >>

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-15 Thread Alok Singh
tions/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 > sta

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-15 Thread marks1900-post01
-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

Re: Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-15 Thread Samarth Jain
a\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-7c55f95f8a47550115

Getting swamped with Phoenix *.tmp files on SELECT.

2016-04-15 Thread marks1900-post01
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