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
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" |