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
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
>>
>
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
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
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
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
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
" ,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
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
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:
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
---------
>> *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?
>>
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
-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
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
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
16 matches
Mail list logo