Re: [HACKERS] during the maintenance facing error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux