Обсуждение: Large database problems
All, We are having a few problems with a large database in postgres 6.5.2 under Linux 2.2.13 (upgraded from RedHat 6.0). We have a table of around a million books and a number of tables to store words in the book's titles for free text indexing. The books file in base, for instance, is 559M. 1) The first problem came when I tried to pg_dump the database to a file. The file got to about 4M in a couple of seconds and did not grow any more but the pg_dump process started growing until it was 300M or so (256M RAM installed) at which point I got a dumpClasses(): command failed. Explanation from backend: 'unknown protocol character '-' read from backend. (The protocol character is the first character the backend sends in response to a query it receives). '. error. Syslogd then wrote the following repeatedly to /var/log/messages: Nov 10 18:34:53 booksdb logger: FATAL: pq_endmessage failed: errno=32 Nov 10 18:34:53 booksdb logger: pq_flush: send() failed: Broken pipe until I killed the postgres process used by pg_dump (it had a status of SELECT). I restarted postmaster without the "-B 3900" option it previously had, and with "-o -S 512" instead of "-o -S 64000" with no more success. 2) After one such attempt, I found that I could then no longer connect to the db - I keep getting: Connection to database 'booksdb' failed. pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. whenever I try to use psql or pg_dump. I can connect to other dbs OK. Does anyone have any idea what might be going on? Is there any way to recover this database short of rebuilding it? Any help gratefully received! Myles ______________________________________________________ Myles Chippendale - mylesc@paneris.org Net Worker MJ Chippendale Solutions 77 Hurst Street - 01865 791078 Oxford OX4 1HA http://www.paneris.co.uk/mylesc.html Proud to be part of the Paneris collective http://www.paneris.co.uk/ ______________________________________________________
All, Problem solved. We upgraded glibc as well, but didn't recompile readline. Well, at least the problem's fixed. Myles At 09:18 PM 11/10/99 +0000, Myles Chippendale wrote: >All, > >We are having a few problems with a large database in postgres 6.5.2 >under Linux 2.2.13 (upgraded from RedHat 6.0). > [snip - problems such as: > dumpClasses(): command failed. Explanation from backend: 'unknown > protocol character '-' read from backend. (The protocol character is > the first character the backend sends in response to a query it > receives). > '. > >error. Syslogd then wrote the following repeatedly to /var/log/messages: > > Nov 10 18:34:53 booksdb logger: FATAL: pq_endmessage failed: errno=32 > Nov 10 18:34:53 booksdb logger: pq_flush: send() failed: Broken pipe > >until I killed the postgres process used by pg_dump (it had a status of ]