Skip site navigation (1) Skip section navigation (2)

Re: URGENT: Out of disk space pg_xlog

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jeremy Haile <jhaile(at)fastmail(dot)fm>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: URGENT: Out of disk space pg_xlog
Date: 2006-12-23 18:13:51
Message-ID: 200612231813.kBNIDpK24705@momjian.us (view raw or flat)
Thread:
Lists: pgsql-performance
Jeremy Haile wrote:
> > > Once you free some space on the data partition and restart, you should
> > > be good to go --- there will be no loss of committed transactions, since
> > > all the operations are in pg_xlog.  Might take a little while to replay
> > > all that log though :-(
> > 
> > Amazing that all works.  What I did not see is confirmation from the
> > user that the data directory filled up _before_ pg_xlog filled up.
> 
> After I freed up space on the pg_xlog partition and restarted, it took
> some time to replay all of the log (15-20 minutes) and everything
> recovered with no data corruption!  However, the theory about the data
> partition filling up first didn't happen in my case.  The data partition
> was (and still is) less than 50% utilized.  My pg_xlog files typically
> run around 400MB, but with the long running update filled up the entire
> 10GB partition.  (which is now a 70 GB partition)  
> 
> So, I'm still not sure what caused the problem.  When I get back to work
> (or maybe sooner), I'll take a look in the PG logs and post anything
> that looks suspicious here.  Thanks for all of your comments and
> suggestions.  Even though I haven't figured out the root of the problem
> yet, they've been very informative.

The bottom line is that we know of now cases where a long-running
transaction would delay recycling of the WAL files, so there is
certainly something not understood here.

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-performance by date

Next:From: Kevin KempterDate: 2006-12-24 19:15:18
Subject: Questions about planner methods
Previous:From: Jeremy HaileDate: 2006-12-23 17:32:48
Subject: Re: URGENT: Out of disk space pg_xlog

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group