Обсуждение: temporary file - No Space left on device

Поиск
Список
Период
Сортировка

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

Вложения

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: dbatocloud17@gmail.com



On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <dbatocloud17@gmail.com> 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

Вложения

Re: temporary file - No Space left on device

От
Ron
Дата:
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: dbatocloud17@gmail.com



On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <dbatocloud17@gmail.com> 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.
Вложения