From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Meszaros Attila <tilla(at)draconis(dot)elte(dot)hu> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Recovery error |
Date: | 2001-08-07 18:10:04 |
Message-ID: | 8737.997207804@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Meszaros Attila <tilla(at)draconis(dot)elte(dot)hu> writes:
> Accidentally I've ran out of disk space during intensive database write
> operations. At the begining the backend went to recovery mode a few times,
> and continued the work, but finally it has terribly died
> ( Segfault at backend/utils/mmgr/mcxt.c 222 )
A backtrace from that segfault might be interesting, if you can provide
one.
> [version: postgres 7.1 beta6
> OK, I know this is very old... I do the upgrade soon,
I suggest "now", not "soon" :-(. The betas had some bugs in logfile
recovery, and I think you've been bit by one. This looks familiar:
> FATAL 2: XLogWrite: write request is past end of log
You might be able to recover your data by updating to 7.1.2 and running
contrib/pg_resetxlog before you start the new postmaster.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-07 18:17:48 | Re: contrib/postgis spatial extensions |
Previous Message | Tom Lane | 2001-08-07 18:01:07 | Re: CURRENT OF cursor without OIDs |