[pgpool-general: 2271] Re: Cannot accept() new connection. all backends are down
Anderson Fonseca
anderson.fonseca.costa at gmail.com
Mon Nov 11 21:05:20 JST 2013
Yes, but the problem still occurs.
2013/11/8 Tatsuo Ishii <ishii at postgresql.org>
> 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
> >>>
> >>
> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131111/d439728f/attachment-0001.html>
More information about the pgpool-general
mailing list