> > Seems like pgpool issue. What I am wondering is this line: > > > 2010-08-02 13:56:21 DEBUG: pid 19720: AsciiRow: len: 1 data: t > > > > This suggests that your DB application uses very old PostgreSQL > > protocol(call version 2 protocol), implemented in PostgreSQL 7.3 or > > before. But you said your PostgreSQL is 8.4.4. Is there anything > > special with your DB application? > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > English: http://www.sraoss.co.jp/index_en.php > > Japanese: http://www.sraoss.co.jp > > >Is there anything special with your DB application? > > Ya, to put it nicely, it's old as dirt thanks to about a decade of bad > decisions by people who shouldn't be allowed to decide what to have for lunch. > > Sorry, I forgot to add the primary user of that table is a custom ordering > system that currently runs Python 1.5 using _pg that was most likely built > against PostgreSQL before 7.2 > > I can try to see if we can move it to using something built against 8.3 (or > 8.4 if I can convince it to install on RHEL2.1) though, maybe in a week or > two. Is it possible that that is confusing pgpool?
I think it's possible. Version 2 protocol is hard to manage, fragile and the code for the protcol in pgpool-II is complex. Using 8.3 or 8.4 (whatever version 7.4 or later) will make pgpool-II more robust and efficient. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
