Re: RDS No free space

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: RDS No free space
Date: 2023-05-22 19:07:11
Message-ID: CAMkU=1yhRcorAs9HiUfNRXRLDDAW4C0Ya3Y=gqaXoizW-+T=xA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, May 21, 2023 at 1:15 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)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(at)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

>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2023-05-22 19:40:47 Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Previous Message André Rodrigues 2023-05-22 18:58:12 Logical Replication