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