From: | Roomi <roomi(at)RASANEH(dot)safineh(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ERROR: btree: lost page |
Date: | 1999-11-02 07:17:57 |
Message-ID: | Pine.LNX.4.10.9911021047430.3099-100000@RASANEH.safineh.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---------- Forwarded message ----------
Date: Mon, 1 Nov 1999 12:53:21 +0330 (IRT)
From: Roomi <roomi(at)RASANEH(dot)safineh(dot)net>
To: dbi-users(at)fugue(dot)com
Subject: ERROR: btree: lost page
Hi,
i have a huge DB on the web and manage it with some perl scripts.
recently i underestood that some fields of one of th tables make the
postgres not to work proparely.
i found out that in the table X, and row for user Y, the field Z have
problem. when i type : "update X set Z='something' where user='Y' ; " in
psql intractive environment, this error message occures :
"FATAL 1:
btree: lost page in the chain of duplicates"
then the psql don't accept any request and queries!!!
when i delete this user from table X, and re-add him with a new user name,
the problem does not appear!!!
i am really confused . may be this is a bug of postgres?!
plz send ur comments to me
sincerely
mehdi roomi
roomi(at)safineh(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | User & | 1999-11-02 08:38:37 | why don't this create table work? |
Previous Message | Charles Tassell | 1999-11-02 03:33:04 | Re: [GENERAL] users in Postgresql |