[pgpool-general: 511] Re: PgPool Config

[David Kerr]

Right it stays at "accept connection" and never moves off of it.

I wonder if it has something to do with logging to syslog, or possibly 
logging hostname? (does it do it's reverse dns lookup at the accept 
connection phase?)

Since yesterday, I've had more problems with it locking up on "accept 
connection"

I think I've solved it by doing one of the following:
1. Stopped logging to syslog
2. Run as root

I'm not sure which of those got my by the problem, but this morning 
things are still working so that's a positive sign.

Dave


On 05/25/2012 05:09 AM, Tatsuo Ishii wrote:
> I tried but was unable to reproduce your problem.
> The state change of ps is something like this:
>
> "wait for connection request" ->accept(2) connection from client ->
> "accept connection" ->  connects to backend ->  "t-ishii test [local]
> idle" ...
>
> So "accept connection" lasts very short period and usually cannot be
> observed. The process "accept connection" lasts long?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>> No immediate idea for now. I will investigate this.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> Yes! Any idea why?
>>>
>>> Thanks
>>>
>>> Dave
>>>
>>>
>>> On 5/24/2012 5:14 PM, Tatsuo Ishii wrote:
>>>> If you change to:
>>>>
>>>> connection_cache = on
>>>>
>>>> psql does not hang?
>>>> --
>>>> Tatsuo Ishii
>>>> SRA OSS, Inc. Japan
>>>> English: http://www.sraoss.co.jp/index_en.php
>>>> Japanese: http://www.sraoss.co.jp
>>>>
>>>>> Howdy,
>>>>>
>>>>> I'm trying to use pgpool to facilitate failover and also to load
>>>>> balance my Postgres nodes.
>>>>>
>>>>> I don't want to use the pooling if possible.
>>>>>
>>>>> I'm seeing connections hang when i try psql -h<bla>
>>>>>
>>>>> On my pgpool system i have two types of PgPool processes:
>>>>>
>>>>> postgres 15949 15894 0 16:07 ?  00:00:00 pgpool: wait for connection
>>>>> request
>>>>> and
>>>>> postgres 15950 15894 0 16:07 ?  00:00:00 pgpool: accept connection
>>>>>
>>>>> What's the "accept connection"?
>>>>>
>>>>> I've attached some relevent paramters that i've changed. (if it's not
>>>>> here it's default)
>>>>>
>>>>> listen_addresses = '*'
>>>>> port = 15432
>>>>> backend_hostname0 = 'masterpg'
>>>>> backend_port0 = 15432
>>>>> backend_weight0 = 0
>>>>> backend_data_directory0 = '/db/9.1/data'
>>>>> backend_flag0 = 'ALLOW_TO_FAILOVER'
>>>>> backend_hostname1 = 'standbypg'
>>>>> backend_port1 = 25432
>>>>> backend_weight1 = 0
>>>>> backend_data_directory1 = '/db2/9.1/data'
>>>>> backend_flag1 = 'ALLOW_TO_FAILOVER'
>>>>> enable_pool_hba = on
>>>>> num_init_children = 100
>>>>> max_pool = 4
>>>>> child_life_time = 300
>>>>> child_max_connections = 0
>>>>> connection_life_time = 0
>>>>> client_idle_limit = 0
>>>>> connection_cache = off
>>>>> reset_query_list = 'ABORT; DISCARD ALL'
>>>>> replication_mode = off
>>>>> load_balance_mode = on
>>>>> ignore_leading_white_space = on
>>>>> white_function_list = ''
>>>>> black_function_list = 'currval,lastval,nextval,setval'
>>>>> master_slave_mode = on
>>>>> master_slave_sub_mode = 'stream'
>>>>> sr_check_period = 10
>>>>> sr_check_user = 'pgpool'
>>>>> sr_check_password = ''
>>>>> delay_threshold = 10000000
>>>>> parallel_mode = off
>>>>> health_check_period = 10
>>>>> health_check_timeout = 20
>>>>> health_check_user = 'pgpool'
>>>>> health_check_password = ''
>>>>> failover_command = '/var/lib/pgsql/bin/failover_command.ksh %H %D %d
>>>>> %P'
>>>>> failback_command = ''
>>>>> fail_over_on_backend_error = on
>>>>> _______________________________________________
>>>>> pgpool-general mailing list
>>>>> pgpool-general at pgpool.net
>>>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>>
>>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>