[Pgpool-general] pgpool-II 2.3.x problem

[Tatsuo Ishii]

I have decided the version number be 2.3.2.1.
The reason why it was not 2.3.3 was, the difference is just one bug
fix, and I don't think it's worth to bump up "real" version number:-)

New tar ball can be downloaded from:
http://pgfoundry.org/frs/download.php/2566/pgpool-II-2.3.2.1.tar.gz
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
> It is identfied that pgpool-II 2.3.x has a problem with erroneous
> query processing. For example, you might see following symptom:
> 
> pool_test=# aaa;
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> 
> >From pgpool log:
> 
> 2010-02-10 12:55:36 LOG:   pid 41240: SimpleQuery: Error or notice
> message from backend: : DB node id: 0 backend pid: 41244 statement:
> aaa; message: syntax error at or near "aaa"
> 2010-02-10 12:55:36 DEBUG: pid 41240: wait_for_query_response: waiting
> for backend 1 completing the query
> 2010-02-10 12:55:36 LOG:   pid 41240: SimpleQuery: Error or notice
> message from backend: : DB node id: 1 backend pid: 41245 statement:
> aaa; message: syntax error at or near "aaa"
> 2010-02-10 12:55:36 DEBUG: pid 41240: read_kind_from_backend: read
> kind from 0 th backend ^@ NUM_BACKENDS: 2
> 2010-02-10 12:55:36 DEBUG: pid 41240: read_kind_from_backend: read
> kind from 1 th backend ^@ NUM_BACKENDS: 2
> 2010-02-10 12:55:36 ERROR: pid 41240: pool_process_query: kind is 0!
> 2010-02-10 12:55:36 LOG:   pid 41240: do_child: exits with status 1 due to error
> 2010-02-10 12:55:36 DEBUG: pid 41241: I am 41241 accept fd 5
> 2010-02-10 12:55:36 DEBUG: pid 41238: reap_handler called
> 
> This is caused by error/notice message extraction process. So it
> possible that any query involves error or notice is suffered by this
> bug. Any data corrpution or data inconsistency does not happen
> because of this bug.
> 
> Please note that this problem will not happen if pgpool is compiled by
> older version of gcc. That's one of the reasons why I didn't notice
> until today (my gcc is 3.3.6). So you may or may not see the bug
> depending on the version of gcc.
> 
> I will release pgpool-II 2.3.3 soon. If you hurry, please use included
> patches.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp