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 down
Postgres Shared Memory Value: 46679678976 bytes2021-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@xxxxxxxxx
