From: | "Mr(dot) Big" <mrbig(at)sneaker(dot)sch(dot)bme(dot)hu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Cannot open segment 1 |
Date: | 1999-11-01 00:51:26 |
Message-ID: | Pine.LNX.3.96.991101014554.7565B-100000@sneaker.sch.bme.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, I've got troubles today with my db, my postmaster freeses at every
10-15 minutes. I looked to the logs, and I've found the next error:
ERROR: cannot open segment 1 of relation pg_proc_oid_index
and sometimes it is followed by:
ERROR: SearchSysCache: recursive use of cache 9
It seems to me, that there's some corruption in the pg_proc_oid_index
relation, but I don't know how to correct it, becouse it's a system index,
and I'm not allowed to drop it, and recreate it - I think this would be
the most easy... Now I'm in troubles, becouse id something want to access
this index relation, all my processes freeze in the startup phrase, I have
to kill the postmaster and start it again.
If someone experienced such things, plz elp me
+--------------------------------------------+
| Nagy Attila |
| mailto:mrbig(at)sneaker(dot)sch(dot)bme(dot)hu |
+--------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Vicherek | 1999-11-01 04:56:13 | userspace fs implementation ? (perhaps with PostgreSQL) |
Previous Message | Michael Black | 1999-10-31 21:42:18 | Not too bright, Request installation assistance. |