pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
during the maintenance facing error 2+ messages / 2 participants [nested] [flat]
* during the maintenance facing error @ 2013-11-10 14:37 Nagaraj Shindagi <nagaraj.shindagi@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Nagaraj Shindagi @ 2013-11-10 14:37 UTC (permalink / raw) To: pgsql-hackers@postgresql.org; pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: during the maintenance facing error @ 2013-11-10 14:44 Andres Freund <andres@2ndquadrant.com> parent: Nagaraj Shindagi <nagaraj.shindagi@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Andres Freund @ 2013-11-10 14:44 UTC (permalink / raw) To: Nagaraj Shindagi <nagaraj.shindagi@gmail.com>; +Cc: pgsql-hackers@postgresql.org; pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-11-10 14:44 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2013-11-10 14:37 during the maintenance facing error Nagaraj Shindagi <nagaraj.shindagi@gmail.com> 2013-11-10 14:44 ` Andres Freund <andres@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox