Date: Sun, 10 Nov 2013 15:44:49 +0100
From: Andres Freund <andres@2ndquadrant.com>
To: Nagaraj Shindagi <nagaraj.shindagi@gmail.com>
Cc: pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: during the maintenance facing error
Message-ID: <20131110144449.GN28314@alap2.anarazel.de>
References: 
 <CAB76fAxO9o1PxBQmkqjMFGo8XUAw3=2Qtaqc6uzmPqKQo0zb=w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAB76fAxO9o1PxBQmkqjMFGo8XUAw3=2Qtaqc6uzmPqKQo0zb=w@mail.gmail.com>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

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-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers