Hi, Sorry for the delay.
From: Nico -telmich- Schottelius <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
