| 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: | Whole Thread | Raw Message | 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" |