Postgres Pro
Downloads
Home   >   mailing lists

could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB - Mailing list pgsql-admin

From dbatoCloud Solution
Subject could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Date
Msg-id CAEz7P_s1OK6n=4k0RL=RHeJys0UJqK2VxTCaSY1ddpwmyKgSKA@mail.gmail.com
Whole thread Raw
Responses Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB  (Michael Banck <michael.banck@credativ.de>)
List pgsql-admin
Tree view
Dear All,

I am facing an issue in AWS Aurora PostgreSQL DB where it shows,

Environment: - AWS RDS PostgreSQL 10.11  

##
ERROR: could not write block 1726445 of temporary file: No space left on device
##

Error#
could not write to log file: No space left on device

 

2021-01-12 01:40:03 UTC::@:[29941]:LOG:  database system is shut downPostgres Shared Memory Value: 46679678976 bytes
2021-01-12 01:40:04.250 GMT [30047] LOG:  skipping missing configuration file "/rdsdbdata/db/postgresql.auto.conf"
2021-01-12 01:40:04 UTC::@:[30047]:WARNING:  unrecognized configuration parameter "rds.adaptive_autovacuum"
2021-01-12 01:40:04 UTC::@:[30047]:WARNING:  unrecognized configuration parameter "rds.enable_plan_management"
2021-01-12 01:40:04 UTC::@:[30047]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_calls"
2021-01-12 01:40:04 UTC::@:[30047]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_mean_time_ms"
2021-01-12 01:40:04 UTC::@:[30047]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_stddev_time_ms"
2021-01-12 01:40:04 UTC::@:[30047]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_total_time_ms"
2021-01-12 01:40:04 UTC::@:[30047]:LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-01-12 01:40:04 UTC::@:[30047]:LOG:  listening on IPv6 address "::", port 5432
2021-01-12 01:40:04 UTC::@:[30047]:LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-01-12 01:40:04 UTC::@:[30047]:LOG:  redirecting log output to logging collector process
2021-01-12 01:40:04 UTC::@:[30047]:HINT:  Future log output will appear in directory "/rdsdbdata/log/error".
2021-01-12 02:27:07.156 GMT [1499] LOG:  skipping missing configuration file "/rdsdbdata/db/postgresql.auto.conf"
2021-01-12 02:27:07 UTC::@:[1499]:WARNING:  unrecognized configuration parameter "rds.adaptive_autovacuum"
2021-01-12 02:27:07 UTC::@:[1499]:WARNING:  unrecognized configuration parameter "rds.enable_plan_management"
2021-01-12 02:27:07 UTC::@:[1499]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_calls"
2021-01-12 02:27:07 UTC::@:[1499]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_mean_time_ms"
2021-01-12 02:27:07 UTC::@:[1499]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_stddev_time_ms"
2021-01-12 02:27:07 UTC::@:[1499]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_total_time_ms"
2021-01-12 02:27:07 UTC::@:[1499]:LOG:  database system is shut down
Postgres Shared Memory Value: 46679678976 bytes
2021-01-12 02:27:08.128 GMT [1608] LOG:  skipping missing configuration file "/rdsdbdata/db/postgresql.auto.conf"
2021-01-12 02:27:08 UTC::@:[1608]:WARNING:  unrecognized configuration parameter "rds.adaptive_autovacuum"
2021-01-12 02:27:08 UTC::@:[1608]:WARNING:  unrecognized configuration parameter "rds.enable_plan_management"
2021-01-12 02:27:08 UTC::@:[1608]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_calls"
2021-01-12 02:27:08 UTC::@:[1608]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_mean_time_ms"
2021-01-12 02:27:08 UTC::@:[1608]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_stddev_time_ms"
2021-01-12 02:27:08 UTC::@:[1608]:WARNING:  unrecognized configuration parameter "apg_plan_mgmt.pgss_min_total_time_ms"
2021-01-12 02:27:08 UTC::@:[1608]:LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-01-12 02:27:08 UTC::@:[1608]:LOG:  listening on IPv6 address "::", port 5432
2021-01-12 02:27:08 UTC::@:[1608]:LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-01-12 02:27:08 UTC::@:[1608]:LOG:  redirecting log output to logging collector process
2021-01-12 02:27:08 UTC::@:[1608]:HINT:  Future log output will appear in directory "/rdsdbdata/log/error".
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device

could not write to log file: No space left on device

 

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

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Little help with the server export function
Next
From: Michael Banck
Date:
Subject: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB