URGENT pg_xlog full impossible to restart ...

From: Hervé Piedvache <footcow(at)noos(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: URGENT pg_xlog full impossible to restart ...
Date: 2004-07-17 20:05:40
Message-ID: 200407172205.40739.footcow@noos.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have my database stoping by itself during a vacuum full analyse;

Impossible to restart it ... I have this message :
Jul 17 22:03:09 stats-ugc postgres[7239]: [2-1] LOG: database system was shut
down at 2004-07-17 20:53:06 CEST
Jul 17 22:03:09 stats-ugc postgres[7239]: [3-1] LOG: checkpoint record is at
400/49FFE4B0
Jul 17 22:03:09 stats-ugc postgres[7239]: [4-1] LOG: redo record is at
400/49FFE4B0; undo record is at 0/0; shutdown TRUE
Jul 17 22:03:09 stats-ugc postgres[7239]: [5-1] LOG: next transaction ID:
499350; next OID: 1874767379
Jul 17 22:03:09 stats-ugc postgres[7239]: [6-1] PANIC: could not write to
file "/usr/local/pgsql/data/pg_xlog/xlogtemp.7239": No space left on device
Jul 17 22:03:09 stats-ugc postgres[7236]: [2-1] LOG: startup process (PID
7239) was terminated by signal 6
Jul 17 22:03:09 stats-ugc postgres[7236]: [3-1] LOG: aborting startup due to
startup process failure

How to solve this ??? My pg_xlog partition is full ... :o(

Thanks !
--
Bill Footcow

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2004-07-17 20:26:23 delete/copy on table with foreign keys
Previous Message Steve Crawford 2004-07-17 17:35:10 Re: Recent High CPU