Re: pg_xlog disk full error, i need help - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_xlog disk full error, i need help
Date
Msg-id 29238.1112025984@sss.pgh.pa.us
Whole thread Raw
In response to pg_xlog disk full error, i need help  ("Janning Vygen" <vygen@gmx.de>)
Responses Re: pg_xlog disk full error, i need help
List pgsql-general
"Janning Vygen" <vygen@gmx.de> writes:
> My disk was running full with 100 GB (!) of data/pg_xlog/ files.

The only way for pg_xlog to bloat vastly beyond what it's supposed to be
(which is to say, about twice your checkpoint_segments setting) is if
checkpoints are somehow blocked from happening.  The only mechanism I
know about for that is that in 7.4.* (maybe 7.3.* too) a very large
btree CREATE INDEX or REINDEX operation can block checkpoints until it
completes.  Did you have something like that going on?

Anyway, replaying that much log is gonna take awhile :-(.  I think you
have only two choices:
1. Grin and bear it.
2. Kill the replay process, then use pg_resetxlog to throw away the xlog.
   Then pray you didn't lose anything critical by doing so.

If you know that there was nothing going on except the supposed index
build, then you can be pretty sure that #2 will lose nothing except the
incomplete index, so it might be a workable alternative.

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Parallel Query should be a top priority
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: US DoD FOSS Recommendation