pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sander Steffann <sander@steffann.nl>
Cc: pgsql-admin@postgresql.org
Subject: Re: Less available diskspace after crashed CLUSTER
Date: Sat, 15 Jan 2005 13:01:17 -0500
Message-ID: <10233.1105812077@sss.pgh.pa.us> (raw)
In-Reply-To: <003201c4fb14$b7377840$64c8a8c0@balefirehome>
References: <003201c4fb14$b7377840$64c8a8c0@balefirehome>

"Sander Steffann" <sander@steffann.nl> writes:
> 2005-01-15 15:17:46 [30605] PANIC:  PANIC:  could not write to file 
> "/var/lib/pgsql/data/pg_xlog/xlogtemp.30605": Geen ruimte over op apparaat
> STATEMENT:  CLUSTER;

Hmm.  I wonder why we have XLogFileInit forcing a PANIC for this.  At
one time it was called only from critical sections and so the error
would become a panic anyway, but that's not true anymore...

> The database is running nice again, but I have the feeling I lost some 
> diskspace... I suspected a temp file, so I stopped the postmaster, looked in 
> /var/lib/pgsql/data/base/17142/pgsql_tmp, found one file and deleted it. But 
> now I still have 1G less available diskspace than before the CLUSTER.

> Where should I look next? I would like the diskspace back :-)

I'm guessing that the new table/index files created during the CLUSTER
didn't get released after the PANIC.  Look for files that are not
referenced by any relfilenode value in pg_class.  Don't forget that
there may be multiple sections (filenode.1, etc).  See
http://developer.postgresql.org/docs/postgres/storage.html
(which is for 8.0, but everything except the material on tablespaces
applies to 7.4).

Also, did you get rid of the xlog temp file mentioned in the message?

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <10233.1105812077@sss.pgh.pa.us>
Permalink:  ../10233.1105812077@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/10233.1105812077@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, sander@steffann.nl
  Subject: Re: Less available diskspace after crashed CLUSTER
  In-Reply-To: <10233.1105812077@sss.pgh.pa.us>
  References: <003201c4fb14$b7377840$64c8a8c0@balefirehome> <10233.1105812077@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox