Re: writing block 6850 of relation 1663/17231/1259

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Mudit Mishra <Mudit(dot)Mishra(at)suk(dot)sas(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: writing block 6850 of relation 1663/17231/1259
Date: 2011-09-13 04:46:40
Message-ID: 4E6EE030.6060902@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/09/2011 10:37 PM, Mudit Mishra wrote:
> Can anyone help me to fix this issue?
>
> I keep getting following errors in the log. I do not have a backup of the database and want to recover the database as much as possible from this error.
>
> 2011-09-09 11:06:39 PANIC: xlog flush request 2/190490D8 is not satisfied --- flushed only to 2/19004190
> 2011-09-09 11:06:39 CONTEXT: writing block 6850 of relation 1663/17231/1259

Before you do ANYTHING else, copy your data directory to other storage.
Do not try to "fix" anything until you have made a copy of your data
directory. Copy it while the server is stopped.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-09-13 05:43:38 Re: 9.0, 9.1 RPM based parallel execution?
Previous Message pasman pasmański 2011-09-13 04:04:45 Re: Compatibility 9.1rc and 9.1.0