| 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: | Whole Thread | Raw Message | 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. |