[Pgpool-general] Current problems in pgpool2.1b2+segfault patch

[Yoshiyuki Asaba]

Hi,

Sorry for the delay.

From: Nico -telmich- Schottelius <nico-pgpool at schottelius.org>
Subject: [Pgpool-general] Current problems in pgpool2.1b2+segfault patch
Date: Tue, 3 Jun 2008 18:32:14 +0200

> Currently I had to disable pgpool, because of the following problems:
> 
> - no real logging support

We need to rewrite user-friendly log messages.

> - too often disconnects: 
> 
> 2008-05-30 09:45:19 LOG:   pid 15208: statement: begin; select data from php_sessions where session_id = 'cd4752abe
> 216370eeec09e8dde9354f7' for update; 
> 2008-05-30 09:45:19 LOG:   pid 15252: statement: begin; select data from php_sessions where session_id = '87df8fc96
> 924eba9999f2aceb3dfbd5b' for update; 
> 2008-05-30 09:45:19 LOG:   pid 14567: statement:  RESET ALL
> 2008-05-30 09:45:19 LOG:   pid 14567: statement:  SET SESSION AUTHORIZATION DEFAULT
> 2008-05-30 09:45:19 ERROR: pid 15252: pool_process_query: 1 th kind C does not match with master connection kind D
> 2008-05-30 09:45:19 LOG:   pid 15252: notice_backend_error: 1 fail over request from pid 15252
> 2008-05-30 09:45:19 LOG:   pid 5045: starting degeneration. shutdown host 62.65.130.180(6543)
> 
> There are just too many situations, when a node is disconnected
> 
> - problems on syncing, even with PITR: As the applications do not release the connection
>   from pgpool, the pgp_recovery_node only works if I restart pgpool and insert
>   an iptables -j REJECT to the right port before the whole sync
>    -> more downtime than just for PITR
> 
> - connection problems when one backend is down / the available connections
>   at the backends are full: no answer from pgpool
> 
> - no / wrong reuse of existing connections: pgpool opens up to the maximum number
>   of connections persistent to the backends, but does NOT reuse them until all
>   are opened (afaics) -> leads to strange behaviour if the last made connections
>   (see above)
> 
> Currently I just setup a BIG server instead of a cluster with a cold-standby node.
> 
> If I see imrovements in pgpool I'll give it a try again, but the pgpool-II 2.1b2
> version is not usable yet.

I'm sorry. However your reports were valuable. We make an effort to
improve pgpool-II. Advice and feature requests are welcome.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp