DB Corruption after running out of disk space? - Mailing list pgsql-general

From Deven Phillips
Subject DB Corruption after running out of disk space?
Date
Msg-id CAJw+4NDoKwXwjjdgT0_D+99LHiiKn6y5MaG6hMwfY84AbLZdFg@mail.gmail.com
Whole thread Raw
Responses Re: DB Corruption after running out of disk space?  (Deven Phillips <deven.phillips@gmail.com>)
List pgsql-general
Here's hoping someone can help me... Overnight, our primary database server (part of a master/slave replication pair) ran out of disk space. I have cleaned up space now, but while performing some VACUUM ANALYZE commands I find that there is some corruption.

I'm getting messages like: ERROR:  missing chunk number 0 for toast value 304627805 in pg_toast_16421

I searched around and previous posts to the mailing list suggested a re-index of the pg_toast.pg_toast_16421 table, which I did to no effect. Still getting the error.

Any suggestions or ideas would be appreciated.

Thanks in advance!

Deven Phillips

pgsql-general by date:

Previous
From: "Jaisingkar, Piyush"
Date:
Subject: Re: Passing of where clause to remote table in FDW
Next
From: Deven Phillips
Date:
Subject: Re: DB Corruption after running out of disk space?