From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: weird problem |
Date: | 2003-07-10 01:53:46 |
Message-ID: | 20030710015345.GA25328@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Jul 10, 2003 at 11:45:09AM +1000, Gavin Sherry wrote:
> On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote:
>
> > Just saw this on our demo server:
> >
> > root(at)phppgadmin:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473
> > phppgadmin
> > psql: FATAL: cannot open segment 1 of relation
> > pg_trigger_tgrelid_tgname_index (target block 8310112): No such file or
> > directory
>
> Seems like a hosed file system to me. You'll probably need to go to
> backups and should do some hardware tests.
Hmm... I was thinking the index could be somehow corrupted. However,
it's strange that all databases have the same problem, since pg_trigger
is not shared across databases.
Have you tried reindexing pg_trigger?
> Which file system is this running on. There seem to be a large number of
> people on IRC will similar problems when running on ReiserFS.
Well, older versions of ReiserFS corrupted data for me after crashes
(not PG data though -- CUPS config files and stuff). I supposed newer
versions were fixed, and I think Cristopher runs FreeBSD anyway?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Uno puede defenderse de los ataques; contra los elogios se esta indefenso"
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-07-10 02:05:05 | Re: weird problem |
Previous Message | Gavin Sherry | 2003-07-10 01:45:09 | Re: weird problem |