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

Поиск
Список
Период
Сортировка
От dbatoCloud Solution
Тема could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Дата
Msg-id CAEz7P_s1OK6n=4k0RL=RHeJys0UJqK2VxTCaSY1ddpwmyKgSKA@mail.gmail.com
обсуждение исходный текст
Ответы Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB  (Michael Banck <michael.banck@credativ.de>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: Little help with the server export function
Следующее
От: Michael Banck
Дата:
Сообщение: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB