[pgpool-general: 2266] Re: Cannot accept() new connection. all backends are down
Tatsuo Ishii
ishii at postgresql.org
Sat Nov 9 07:48:43 JST 2013
Have you tried starting pgpool with -D option?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Someone can help me?
>
>
> 2013/11/6 Anderson Fonseca <anderson.fonseca.costa at gmail.com>
>
>> Thaks by answer!
>>
>> I tried to start with -D but the problem persists.
>>
>> The full log (startup and error when try to connect):
>>
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> logdir
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '/var/log/postgresql' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> connection_cache
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> reset_query_list
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'ABORT; DISCARD ALL' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> extract_string_tokens: token: ABORT
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> extract_string_tokens: token: DISCARD ALL
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> replication_mode
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> replicate_select
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> replicate_select: 0
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> insert_lock
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> lobj_lock_table
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> replication_stop_on_mismatch
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> replication_stop_on_mismatch: 0
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> failover_if_affected_tuples_mismatch
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> failover_if_affected_tuples_mismatch: 0
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> load_balance_mode
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> ignore_leading_white_space
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> white_function_list
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> black_function_list
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'nextval,setval' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> extract_string_tokens: token: nextval
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> extract_string_tokens: token: setval
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> add_to_patterns: regex pattern: ^nextval$
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> add_to_patterns: regex pattern: ^setval$
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> master_slave_mode
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> master_slave_sub_mode
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'slony' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> sr_check_period
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> sr_check_user
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'nobody' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> sr_check_password
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> delay_threshold
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> follow_master_command
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> parallel_mode
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> pgpool2_hostname
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> system_db_hostname
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'localhost' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> system_db_port
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 5432 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> system_db_dbname
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'pgpool' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> system_db_schema
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'pgpool_catalog' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> system_db_user
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'pgpool' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> system_db_password
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> health_check_period
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> health_check_timeout
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 20 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> health_check_user
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'nobody' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> health_check_password
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> health_check_max_retries
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> health_check_retry_delay
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 1 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> failover_command
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> failback_command
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> fail_over_on_backend_error
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> search_primary_node_timeout
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 10 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> recovery_user
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'nobody' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> recovery_password
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> recovery_1st_stage_command
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> recovery_2nd_stage_command
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> recovery_timeout
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 90 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> client_idle_limit_in_recovery
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> use_watchdog
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> trusted_servers
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> ping_path
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '/bin' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_hostname
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_port
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 9000 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_authkey
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> delegate_IP
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> ifconfig_path
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '/sbin' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> if_up_cmd
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> if_down_cmd
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'ifconfig eth0:0 down' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> arping_path
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '/usr/sbin' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> arping_cmd
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'arping -U $_IP_$ -w 1' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> clear_memqcache_on_escalation
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_escalation_command
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_lifecheck_method
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'heartbeat' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_interval
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 10 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_heartbeat_port
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 9694 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_heartbeat_keepalive
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 2 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_heartbeat_deadtime
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 30 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> heartbeat_destination0
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'host0_ip1' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> heartbeat_destination_port0
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 9694 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> heartbeat_device0
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_life_point
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 3 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_lifecheck_query
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'SELECT 1' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_lifecheck_dbname
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'template1' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_lifecheck_user
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'nobody' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> wd_lifecheck_password
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> relcache_expire
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> relcache_size
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 256 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> check_temp_table
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memory_cache_enabled
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: off kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_method
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'shmem' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_memcached_host
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 'localhost' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_memcached_port
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 11211 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_total_size
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 67108864 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_max_num_cache
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 1000000 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_expire
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 0 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_auto_cache_invalidation
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: on kind: 1
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_maxcache
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 409600 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_cache_block_size
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: 1048576 kind: 2
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> memqcache_oiddir
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '/var/log/pgpool/oiddir' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> white_memqcache_table_list
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202: key:
>> black_memqcache_table_list
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> value: '' kind: 4
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> num_backends: 0 total_weight: 0.000000
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3217: I am
>> 3217
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3217:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3216: I am
>> 3216
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3216:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3215: I am
>> 3215
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3214: I am
>> 3214
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3214:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3220: I am
>> 3220
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3220:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3215:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3221: I am
>> 3221
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3221:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3222: I am
>> 3222
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3222:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3223: I am
>> 3223
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3223:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3224: I am
>> 3224
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3224:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3225: I am
>> 3225
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3225:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3218: I am
>> 3218
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3218:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3226: I am
>> 3226
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3226:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3219: I am
>> 3219
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3219:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3227: I am
>> 3227
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3227:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3228: I am
>> 3228
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3228:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3229: I am
>> 3229
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3229:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3230: I am
>> 3230
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3230:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3233: I am
>> 3233
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3233:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3232: I am
>> 3232
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3232:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3231: I am
>> 3231
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3231:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3237: I am
>> 3237
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3237:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3235: I am
>> 3235
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3238: I am
>> 3238
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3238:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3239: I am
>> 3239
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3239:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3240: I am
>> 3240
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3241: I am
>> 3241
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3241:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3234: I am
>> 3234
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3234:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3242: I am
>> 3242
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3242:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3243: I am
>> 3243
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3243:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3244: I am
>> 3244
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3244:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3245: I am
>> 3245
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3245:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 LOG: pid 3202:
>> pgpool-II successfully started. version 3.3.1 (tokakiboshi)
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3236: I am
>> 3236
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3236:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3240:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3235:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3202:
>> find_primary_node: not in streaming replication mode
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3247: I am
>> 3247
>> Nov 6 10:29:09 debpg01 pgpool: 2013-11-06 10:29:09 DEBUG: pid 3247:
>> pool_initialize_private_backend_status: initialize backend status
>> Nov 6 10:29:14 debpg01 kernel: [ 1034.341968] atkbd.c: Spurious NAK on
>> isa0060/serio0. Some program might be trying access hardware directly.
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 LOG: pid 3243:
>> Cannot accept() new connection. all backends are down
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3202:
>> reap_handler called
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3202:
>> reap_handler: call wait3
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3202: child
>> 3243 exits with status 256
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3202: fork
>> a new child pid 3248
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3202:
>> reap_handler: normally exited
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3248: I am
>> 3248
>> Nov 6 10:29:17 debpg01 pgpool: 2013-11-06 10:29:17 DEBUG: pid 3248:
>> pool_initialize_private_backend_status: initialize backend status
>>
>>
>>
>> 2013/11/5 Tatsuo Ishii <ishii at postgresql.org>
>>
>>> 1) pgpool thinks all backends down because the status file says. If
>>> you think PostgreSQL are all healthy, try to start pgoool with -D
>>> option (discard status file).
>>>
>>> 2) There are configuration mistakes which prevent from pgpool
>>> connecting to PostgreSQL. To find the cause, a full log from
>>> pgpool starts up is needed (partial log below is not useful).
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese: http://www.sraoss.co.jp
>>>
>>> > Hi all,
>>> >
>>> > I'm with a problem and have no idea how may I fix.
>>> >
>>> > I'm trying to install a pgpool-II to be only a connection pool (not
>>> > replication, master slave...), only connection pool.
>>> >
>>> > When I try to connect to database directly by the port of database, it
>>> > works, but when I try to connect by the port of a pgpool it does not
>>> > work.
>>> >
>>> > Enviorement:
>>> > Debian 6
>>> > Postgresql 9.3
>>> > pgpool-II 3.3.1-1.pgdg60+1
>>> >
>>> > Log:
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 LOG: pid 10333:
>>> > Cannot accept() new connection. all backends are down
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10284:
>>> > reap_handler called
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10284:
>>> > reap_handler: call wait3
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10284:
>>> > child 10333 exits with status 256
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10284:
>>> > fork a new child pid 10456
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10284:
>>> > reap_handler: normally exited
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10456: I
>>> am 10456
>>> > Nov 5 15:31:13 debpg01 pgpool: 2013-11-05 15:31:13 DEBUG: pid 10456:
>>> > pool_initialize_private_backend_status: initialize backend status
>>> > _______________________________________________
>>> > pgpool-general mailing list
>>> > pgpool-general at pgpool.net
>>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>
>>
>>
More information about the pgpool-general
mailing list