[Pgpool-general] Pgpool 3.1 errors

[Guillaume Lelarge]

On Tue, 2011-10-04 at 14:36 +0200, Olivier NOEL wrote:
> 2011/10/4 Olivier NOEL <nolivfr at gmail.com>:
> > 2011/10/4 Olivier NOEL <nolivfr at gmail.com>:
> >
> >>> The conf file you're using is a 3.0 one. I hope you don't use that for
> >>> 3.1, as it may not work at all.
> >>
> >> The conf file is essentially the same, no real differences, with the
> >> exception of backend_socket_dir, which is deprecated
> >>
> >>> Your num_init_children seems way too big. 1000... it means pgpool will
> >>> launch 1000 subprocesses when it starts. Kinda crazy :) Moreover, with
> >>> the max_pool at 8, it means pgpool can have 8000 connections to your
> >>> PostgreSQL server. Have you really configured PostgreSQL with a
> >>> max_connections of 8000?
> >>
> >> Each Postgresql have a max_connections of 1000 (we have above 600
> >> connections per , we planned to have 8 servers. Actually max_pool is
> >> at 3
> >>
> >>> On the load balancing configuration, you didn't deny load balancing of
> >>> nextval and setval, which is obviously an error.
> >>
> >> I use white_function_list for that, I have about 450 functions that
> >> are DDL/DML requests, so I only list the read only functions
> >>
> >>> On your backend configuration, you set backend_hostname0, and then go
> >>> directly to backend_hostname7. It may be an issue. Try to set them in
> >>> order (O, then 1, then 2). Not sure it has a real value, I never tried
> >>> that, but it works for me when they are set in order, and without hole.
> >>
> >> It doesn't seems to disturb pgpool, but it was having problem starting
> >> without a node 0.
> >
> > Ok, I tried with a 3.1 config file, and I have this error :
> >
> > 2011-10-04 13:35:44 ERROR: pid 1251: add_to_patterns: invalid regex
> > pattern: ^getuseruid$
> >
> > config :
> >
> > white_function_list = 'getuseruid'
> >                                   # Comma separated list of function names
> >                                   # that don't write to database
> >                                   # Regexp are accepted
> > black_function_list = ''
> >
> 
> The above error is on FreeBSD.
> 
> On Debian pgpool starts, on FreeBSD, pgpool won't start. Missing dependency?
> 
> Pgpool on both OS are compiled : one from sources (Debian) and one
> from ports (FreeBSD).
> 

On 3.1, black_function_list and white_function_list are regular
expressions. I guess the patch wasn't checked on BSD (the patch coder
worked on Linux). But this is a bug that should be fixed.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com