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: | 20131110144449.GN28314@alap2.anarazel.de |
Views: | Raw Message | Whole Thread | 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
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 |
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 |