DB Corruption after running out of disk space?
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
NVM, I guess that I just didn't wait long enough for the re-index operation
to complete... We're good now...
On Fri, Oct 14, 2016 at 6:45 AM, Deven Phillips <deven.phillips@gmail.com>
wrote:
Show quoted text
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_16421I 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