Re: during the maintenance facing error

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: during the maintenance facing error
Дата
Msg-id 20131110144449.GN28314@alap2.anarazel.de
обсуждение исходный текст
Ответ на during the maintenance facing error  (Nagaraj Shindagi <nagaraj.shindagi@gmail.com>)
Список pgsql-hackers
Hi,

On 2013-11-10 20:07:41 +0530, Nagaraj Shindagi wrote:
> This is nagaraj, while  i am doing the maintenance of the database i am
> facing this problem, after this error it will stop and i am not able to
> take backup of the database.

What do you mean with "it will stop"? You should still be able to
communicate with the database, right?

> "ERROR:  could not read block 984505 in file "base/16393/2850139.7": read
> only 4096 of 8192 bytes"

Hm. A couple of questions:
* which operating system
* which file system (cifs? veritas?)
* Could you do a "ls -l base/16393/2850139.*" in the server's datadir (SHOW
  data_directory;) and send the output?

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: logical changeset generation v6.5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UTF8 national character data type support WIP patch and list of open issues.