On Thursday, August 05, 2010 06:26:46 pm Tatsuo Ishii wrote: > > > 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
Alright, we'll move to psycopg built against 8.3 as soon as we can get back to the list with results. _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general