Re: RDS No free space - Mailing list pgsql-admin

From Jeff Janes
Subject Re: RDS No free space
Date
Msg-id CAMkU=1yhRcorAs9HiUfNRXRLDDAW4C0Ya3Y=gqaXoizW-+T=xA@mail.gmail.com
Whole thread Raw
In response to RDS No free space  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
On Sun, May 21, 2023 at 1:15 PM Wells Oliver <wells.oliver@gmail.com> wrote:
I am seeing a lot of this morning:

ERROR: could not extend file "base/16411/616989679.62": No space left on devi2023-05-21 17:11:45 UTC::@:[386]:LOG: all server processes terminated; reinitializing

2023-05-21 17:04:02 UTC:172.31.21.22(55060):woliver@db:[31430]:ERROR: could not extend file "base/16411/616989585.45": No space left on device

The 'all server processes terminated' message indicates that there has been a PANIC, not merely an ERROR.  Was there also an earlier PANIC message?




Etc

However, when I can connect, the DB is well below the provisioned space.

Do objects with those relfilenodes exist? What statements were executing when the errors were thrown? (the statement text should be included in the error message)

Cheers,

Jeff

pgsql-admin by date:

Previous
From: André Rodrigues
Date:
Subject: Logical Replication
Next
From: Jeff Janes
Date:
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS