[pgpool-general: 2265] Re: Cannot accept() new connection. all backends are down

Anderson Fonseca anderson.fonseca.costa at gmail.com
Sat Nov 9 02:20:30 JST 2013 

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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131108/d8ae8a06/attachment-0001.html>

More information about the pgpool-general mailing list