!!! Urgent: btree: lost page

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

Responses

Browse pgsql-general by date

  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?