pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Disaster recovery: pg_class
3+ messages / 2 participants
[nested] [flat]

* Disaster recovery: pg_class
@ 2006-10-13 09:29  Enrico <scotty@linuxtime.it>
  0 siblings, 1 reply; 3+ messages in thread

From: Enrico @ 2006-10-13 09:29 UTC (permalink / raw)
  To: pgsql-admin

After a system crash, I have this error:

 SELECT * from mytable;
 WARNING:  could not write block 14 of 1663/1743558/1259
 DETAIL:  Multiple failures --- write error may be permanent.
 ERROR:  xlog flush request 4/D43E0A00 is not satisfied --- flushed only to 4/D42700F0
 CONTEXT:  writing block 14 of relation 1663/1743558/1

I searched for 1259 oid, and I found that 1259 links to pg_class table.
Is there any way to restore my pg_class table?

Thanks in advantage.

Enrico

-- 
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Disaster recovery: pg_class
@ 2006-10-13 14:30  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Enrico <scotty@linuxtime.it>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2006-10-13 14:30 UTC (permalink / raw)
  To: Enrico <scotty@linuxtime.it>; +Cc: pgsql-admin

Enrico <scotty@linuxtime.it> writes:
> After a system crash, I have this error:
>  SELECT * from mytable;
>  WARNING:  could not write block 14 of 1663/1743558/1259
>  DETAIL:  Multiple failures --- write error may be permanent.
>  ERROR:  xlog flush request 4/D43E0A00 is not satisfied --- flushed only to 4/D42700F0
>  CONTEXT:  writing block 14 of relation 1663/1743558/1

I'm not convinced there's anything much there you need to fix.  You
should look into why the filesystem seems to have lost part of your WAL
file --- that strongly suggests that the disk or kernel is lying about
write ordering, which will cause you problems eventually.  But this
message per se will go away as soon as the WAL endpoint moves another
1.5Mb.  Unless there's other corruption elsewhere you'll be fine.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Disaster recovery: pg_class
@ 2006-10-13 14:59  Enrico <scotty@linuxtime.it>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Enrico @ 2006-10-13 14:59 UTC (permalink / raw)
  To: pgsql-admin

> I'm not convinced there's anything much there you need to fix.  You
> should look into why the filesystem seems to have lost part of your WAL
> file --- that strongly suggests that the disk or kernel is lying about
> write ordering, which will cause you problems eventually.  But this
> message per se will go away as soon as the WAL endpoint moves another
> 1.5Mb.  Unless there's other corruption elsewhere you'll be fine.
> 
> 			regards, tom lane



Hi Tom, 
I think that the system crash is due to a ram failure, 
my server doesn't start if is present a specific bank of ram,
and without it, it works fine.

I watched logs and in the /var/mail/postgres and I've seen this error that matchs in time with system crash.

pg_dump: ERROR:  invalid memory alloc request size 18446744073709551613

regards 
Enrico



-- 
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-10-13 14:59 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-13 09:29 Disaster recovery: pg_class Enrico <scotty@linuxtime.it>
2006-10-13 14:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-10-13 14:59   ` Enrico <scotty@linuxtime.it>

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