ERROR: heapgettup: failed ReadBuffer

From: jihuang <jihuang(at)iis(dot)sinica(dot)edu(dot)tw>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ERROR: heapgettup: failed ReadBuffer
Date: 2004-05-03 10:12:21
Message-ID: 40961B05.9080109@iis.sinica.edu.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I put 360000+ rows in a table , and now any select , update , analyze
... command fail.
the log shows "ERROR: heapgettup: failed ReadBuffer",
but any INSERT sql command success.

the table schema is

row | type | modifiers
---------------+-----------------------------+----------
test_id | integer | not null
snapshot | timestamp without time zone |
ip_client | inet |
ip_server | inet |
conn_time | integer |
response_time | integer |
response_head | character varying |
Check constraints:
"invalid_conn_time" CHECK (conn_time >= 0)
"invalid_resp_time" CHECK (response_time >= 0)

I didn't create any index,
any one know why or suggestion to save the un-readable database?

or anything I mis-configuration ??

Thanks for your help.

June-Yen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-05-03 11:38:00 Re: Fixed directory locations in installs
Previous Message Fabien COELHO 2004-05-03 09:39:08 Aclitem "high level description"