Re: during the maintenance facing error

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Nagaraj Shindagi <nagaraj(dot)shindagi(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: during the maintenance facing error
Date: 2013-11-10 14:44:49
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Luca Ferrari 2013-11-11 16:42:42 using pg_upgrade on FreeBSD for postgresql installed by ports
Previous Message Nagaraj Shindagi 2013-11-10 14:37:41 during the maintenance facing error

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-11-10 16:46:16 Re: UTF8 national character data type support WIP patch and list of open issues.
Previous Message Andres Freund 2013-11-10 14:41:09 Re: logical changeset generation v6.5