Обсуждение: during the maintenance facing error

Поиск
Список
Период
Сортировка

during the maintenance facing error

От
Nagaraj Shindagi
Дата:
hi

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.

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

Please help me to solve this issue

thanks in advance
--
Nagaraj V Shindagi

Re: [HACKERS] during the maintenance facing error

От
Andres Freund
Дата:
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