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 по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Aclitem "high level description"
Следующее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: Fixed directory locations in installs