Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Bruce. If I upgrade the pg sql will it fix the problem - quite happy to do if it does. Else need way to recover the database.  

After some googling I found that 1259 represents PG_CLASS table. This drift me towards the conclusion that this table is in unstable state. 

I have run pg_resetxlog couple of times without any switches like -o,-x,-l and it has not helped. I'm going to run it again with switches and see how it goes.

Thanks,
Mudit

-----Original Message-----
From: Bruce Momjian [mailto:bruce@xxxxxxxxxx] 
Sent: 12 September 2011 02:37
To: Mudit Mishra
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  writing block 6850 of relation 1663/17231/1259

Mudit Mishra wrote:
> Sorry forgot to change title. 
> 
> Any help will be greatly received!
> 
> 
> -----Original Message-----
> From: Mudit Mishra
> Sent: 11 September 2011 14:39
> To: pgsql-general@xxxxxxxxxxxxxx
> Subject: RE:  COPY FROM (query) in plpgsql
> 
> Hi All,
> 
> 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
> 
> 
> OS:  Windows 2003 server
> pgsql version: 
> Welcome to psql 8.0.3, the PostgreSQL interactive terminal.

FYI, that is a very old version of Postgres and you have not even minor-upgraded it in years.

-- 
  Bruce Momjian  <bruce@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux