[Pgpool-general] Curren situation? (was: Current problems in pgpool2.1b2+segfault patch)
Nico -telmich- Schottelius
nico-pgpool at schottelius.org
Fri Jul 25 10:36:53 UTC 2008
Hello!
Just wanted to ask, which of the following issues are fixed in 2.1?
Sincerly,
Nico
Nico -telmich- Schottelius [Tue, Jun 03, 2008 at 06:32:14PM +0200]:
> Hello!
>
> Currently I had to disable pgpool, because of the following problems:
>
> - no real logging support
>
> - 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.
>
> Sincerly
>
> Nico
>
> --
> Think about Free and Open Source Software (FOSS).
> http://nico.schottelius.org/documentations/foss/the-term-foss/
>
> PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
--
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/
PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080725/bc06ee2d/attachment.bin
More information about the Pgpool-general
mailing list