ERROR: heapgettup: failed ReadBuffer
| От | jihuang |
|---|---|
| Тема | ERROR: heapgettup: failed ReadBuffer |
| Дата | |
| Msg-id | 40961B05.9080109@iis.sinica.edu.tw обсуждение исходный текст |
| Ответ на | Re: PITR Phase 2 - Design Planning (Peter Galbavy <peter.galbavy@knowtion.net>) |
| Ответы |
Re: ERROR: heapgettup: failed ReadBuffer
|
| Список | 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 nullsnapshot
| 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
В списке pgsql-hackers по дате отправления: