temporary file - No Space left on device

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

temporary file - No Space left on device

dbatoCloud Solution

Dear All,


 We have been facing temporary file - no space left issue on postgreSQL 10.13.


Please help

 

Error:touchstone.i131_core_contact_pref_center_unsub_0_9.I131_core_contact_pref_center_unsub - tDBRow_8 ERROR: could not write block 196055 of temporary file: No space left on device
org.postgresql.util.PSQLException: ERROR: could not write block 196055 of temporary file: No space left on device
approx IST time 2021-02-14 06:24:36


The below temporary file current usage#

image.png



Regards,
Ashok

Reply | Threaded
Open this post in threaded view
|

Re: temporary file - No Space left on device

dbatoCloud Solution
Hi All,
Just for your update,  the below temporary file size usage . Please let me know how to reduce this size

image.png

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: [hidden email]



On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <[hidden email]> wrote:

Dear All,


 We have been facing temporary file - no space left issue on postgreSQL 10.13.


Please help

 

Error:touchstone.i131_core_contact_pref_center_unsub_0_9.I131_core_contact_pref_center_unsub - tDBRow_8 ERROR: could not write block 196055 of temporary file: No space left on device
org.postgresql.util.PSQLException: ERROR: could not write block 196055 of temporary file: No space left on device
approx IST time 2021-02-14 06:24:36


The below temporary file current usage#

image.png



Regards,
Ashok

Reply | Threaded
Open this post in threaded view
|

Re: temporary file - No Space left on device

Ron-2
Some giant, poorly written query is running.

On 2/15/21 4:54 AM, dbatoCloud Solution wrote:
Hi All,
Just for your update,  the below temporary file size usage . Please let me know how to reduce this size

image.png

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: [hidden email]



On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <[hidden email]> wrote:

Dear All,


 We have been facing temporary file - no space left issue on postgreSQL 10.13.


Please help

 

Error:touchstone.i131_core_contact_pref_center_unsub_0_9.I131_core_contact_pref_center_unsub - tDBRow_8 ERROR: could not write block 196055 of temporary file: No space left on device
org.postgresql.util.PSQLException: ERROR: could not write block 196055 of temporary file: No space left on device
approx IST time 2021-02-14 06:24:36


The below temporary file current usage#

image.png



Regards,
Ashok


--
Angular momentum makes the world go 'round.