[Pgpool-general] problems with pgpool-II

[Tatsuo Ishii]

Hi,

Sorry for late. I was not able to reproduce your problem here. Can you
please be more specific? i.e. pgpool.conf, the PHP script, query,
table data etc.

BTW a bug fix has been committed recently while investigating your
problem. This may or may not be related to your problem.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

----------------------------------------------------------------------
Subject: [Pgpool-committers] pgpool - pgpool-II: Fix auto-deallocation.
From: y-asaba at pgfoundry.org (User Y-asaba)
To: pgpool-committers at pgfoundry.org
Date: Tue,  9 Jan 2007 19:02:50 +0000 (UTC)
X-Mailer: activitymail 1.19, http://search.cpan.org/dist/activitymail/

Log Message:
-----------
Fix auto-deallocation. If a client used PDO interface, pgpool didn't
clean prepared statement.

Modified Files:
--------------
    pgpool-II:
        pool_process_query.c (r1.8 -> r1.9)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_process_query.c.diff?r1=1.8&r2=1.9)
----------------------------------------------------------------------

> Hi,
> 
> I've been trying out pgpool-II, first version 1.1 and later CVS.
> 
> I initially had the problem that it wasn't working with PHP's PDO. I
> searched google and find some mail postings of someone saying the same
> thing, and someone replying that it was fixed in CVS. So I upgraded to
> CVS and things seemed to work ok at first, but I'm still seeing some
> problems.
> 
> 2006-12-29 14:51:16 DEBUG: pid 13652: pool_read_message_length: slot: 1
> length: 5
> 2006-12-29 14:51:16 DEBUG: pid 13652: ReadyForQuery: message length: 5
> 2006-12-29 14:51:16 DEBUG: pid 13652: ReadyForQuery: transaction state: I
> 2006-12-29 14:51:16 DEBUG: pid 13652: pool_process_query: num_fds: 8
> 2006-12-29 14:51:17 ERROR: pid 13660: pool_flush_it: write failed
> (Broken pipe) offset: 0 wlen: 12
> 2006-12-29 14:51:17 DEBUG: pid 13660: read kind from frontend S(53)
> 2006-12-29 14:51:17 DEBUG: pid 13660: pool_process_query: num_fds: 8
> 2006-12-29 14:51:17 ERROR: pid 13660: ProcessFrontendResponse: failed to
> read kind from frontend. fronend abnormally exited
> 2006-12-29 14:51:17 LOG:   pid 13660: do_child: exits with status 1 due
> to error
> 2006-12-29 14:51:17 DEBUG: pid 13634: reap_handler called
> 2006-12-29 14:51:17 DEBUG: pid 13634: reap_handler: call wait3
> 2006-12-29 14:51:17 DEBUG: pid 13634: child 13660 exits with status 256
> by signal 0
> 2006-12-29 14:51:17 DEBUG: pid 13730: I am 13730
> 2006-12-29 14:51:17 DEBUG: pid 13634: fork a new child pid 13730
> 2006-12-29 14:51:17 DEBUG: pid 13634: reap_handler: normally exited
> 
> 
> I suspect you will probably need more information to help me, but I
> don't know what you need.
> I know C and how to use gdb, so I should be able to help you track down
> whatever bug or problem I'm running into.
> 
> --Tim
>