pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDisaster recovery: pg_class
3+ messages / 2 participants
[nested] [flat]
* Disaster recovery: pg_class
@ 2006-10-13 09:29 Enrico <scotty@linuxtime.it>
2006-10-13 14:30 ` Re: Disaster recovery: pg_class Tom Lane <tgl@sss.pgh.pa.us>
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 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 ` Re: Disaster recovery: pg_class 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 09:29 Disaster recovery: pg_class Enrico <scotty@linuxtime.it>
2006-10-13 14:30 ` Re: Disaster recovery: pg_class Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-10-13 14:59 ` Enrico <scotty@linuxtime.it>
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