[pgpool-general: 2235] Re: Cannot accept() new connection. all backends are down
Anderson Fonseca
anderson.fonseca.costa at gmail.com
Wed Nov 6 21:52:40 JST 2013
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/20131106/9ac49a24/attachment-0001.html>
More information about the pgpool-general
mailing list