From: | Roomi <roomi(at)RASANEH(dot)safineh(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, jeff(at)hub(dot)org, dbi-users(at)isc(dot)org |
Subject: | !!! Urgent: btree: lost page |
Date: | 1999-11-04 06:41:53 |
Message-ID: | Pine.LNX.4.10.9911041004520.4504-100000@RASANEH.safineh.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I manage an ISP users with postgres 6.3 on REdhat linux 6.1
recently i have seen some problem in my database.
when i wanna update one of my tables for a special user, ( user is a
field in my Database ), i get this error:
"FATAL 1:
btree: lost page in the chain of duplicates"
this occur for one 3 user of 1000 only. !!!
also, user is a primary key so there is an INDEX for this field in
database.
after that, all the connections to postgres will be disabled. and i
get this message :
"
db do faild: PQexec() -- request was sent to backend but backend
closed the channel before responding.
this probably means that the backend terminated abnormally befor or while
processing the request.
DBD::Pg::db do failed: PQexec() --there is no connection to bachend.
"
plz send ur comments & hints to me.
sincerely
mehdi roomi
roomi(at)safineh(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | postgres | 1999-11-04 08:09:29 | Re: [GENERAL] users in Postgresql |
Previous Message | Gene Selkov, Jr. | 1999-11-04 05:23:12 | Re: [GENERAL] indexed regex select optimisation missing? |