<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
I've had some time to look at this again today and the problem was
the local firewalls allowed traffic on port 9694 but on TCP, not UDP
as it apparently requires.<br>
<br>
This solved my issue.<br>
<br>
Best regards,<br>
Andrei<br>
<br>
<br>
<div class="moz-cite-prefix">On 06/30/2014 12:47 PM,
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-gbif@gbif.org">pgpool-gbif@gbif.org</a> wrote:<br>
</div>
<blockquote cite="mid:53B1404D.8060904@gbif.org" type="cite">Hello,
<br>
<br>
Thank you for your reply.
<br>
<br>
I'm using the init script coming with the pgpool RPM package from
the pgdg YUM repository to start/stop pgpool, modified to start
pgpool as root.
<br>
<br>
<a class="moz-txt-link-freetext" href="http://yum.postgresql.org/srpms/9.3/redhat/rhel-6.5-x86_64/">http://yum.postgresql.org/srpms/9.3/redhat/rhel-6.5-x86_64/</a>
<br>
<br>
I've attached that together with the pgpool logs to this post.
Hope this works...
<br>
<br>
Thanks again for your help!
<br>
<br>
Best regards,
<br>
Andrei
<br>
<br>
<br>
<br>
On 06/30/2014 03:56 AM, Yugo Nagata wrote:
<br>
<blockquote type="cite">Hi,
<br>
<br>
On Fri, 27 Jun 2014 18:07:43 +0200
<br>
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-gbif@gbif.org">pgpool-gbif@gbif.org</a> wrote:
<br>
<br>
<blockquote type="cite">Hello,
<br>
<br>
I've installed pgpoolII version 3.3.2 using RPMS provided by
the PGDG
<br>
repository, on Centos6 64 bit servers.
<br>
<br>
On my test rig, I have two pgpool servers in front of 2
postgres servers
<br>
(replication mode). Connection to the DB servers seems to work
fine, but
<br>
I seem to have some issues using the watchdog/heartbeat.
<br>
<br>
Basically when I stop pgpool on one of the pgpool machines
(the one
<br>
having the virtual IP at the moment), the other should
escalate to
<br>
master pgpool. But it only works something like 3 out of 5
attempts -
<br>
without any changes in the configurations.
<br>
</blockquote>
How did you stop pgpool, pgpool stop command, Ctrl+C, or others
such like
<br>
kill command? Anyhow, when pgpool stop normally, this should
notify this
<br>
to the other pgpool and escalation be triggered. I see
pgpool.conf but I think
<br>
there is no problem, though this would be one of the two and
another
<br>
pgpool.conf might have something wrong.
<br>
<br>
If possible, could you please show me your pgpool.log of both
pgpools?
<br>
I might find some missing messages which should be shown.
<br>
<br>
<blockquote type="cite">Other times, I stop the pgpool daemon on
the master pgpool server, and
<br>
the other pgpool server does not escalate - nothing strange is
shown in
<br>
the logs, either, as far as I can tell.
<br>
<br>
For my testing purposes, I'm running pgpool as root.
<br>
<br>
This behaviour is shown regardless of which of the pgpool
servers cedes
<br>
rank.
<br>
<br>
Please find below my configuration.
<br>
<br>
I hope someone can shed some light on this. Thank you!
<br>
<br>
Best regards,
<br>
Andrei
<br>
<br>
------------------------------------
<br>
<br>
listen_addresses = '*'
<br>
port = 9999
<br>
socket_dir = '/var/run/pgpool-II-93'
<br>
pcp_port = 9898
<br>
pcp_socket_dir = '/var/run/pgpool-II-93'
<br>
backend_hostname0 = '192.168.122.131'
<br>
backend_port0 = 5432
<br>
backend_weight0 = 1
<br>
backend_data_directory0 = '/data'
<br>
backend_flag0 = 'ALLOW_TO_FAILOVER'
<br>
backend_hostname1 = '192.168.122.132'
<br>
backend_port1 = 5432
<br>
backend_weight1 = 1
<br>
backend_data_directory1 = '/data'
<br>
backend_flag1 = 'ALLOW_TO_FAILOVER'
<br>
enable_pool_hba = on
<br>
pool_passwd = 'pool_passwd'
<br>
authentication_timeout = 60
<br>
ssl = off
<br>
num_init_children = 32
<br>
max_pool = 4
<br>
child_life_time = 300
<br>
child_max_connections = 0
<br>
connection_life_time = 0
<br>
client_idle_limit = 0
<br>
log_destination = 'syslog'
<br>
print_timestamp = on
<br>
log_connections = off
<br>
log_hostname = off
<br>
log_statement = off
<br>
log_per_node_statement = off
<br>
log_standby_delay = 'none'
<br>
syslog_facility = 'LOCAL0'
<br>
syslog_ident = 'pgpool'
<br>
debug_level = 2
<br>
pid_file_name = '/var/run/pgpool-II-93/pgpool.pid'
<br>
logdir = '/var/run/pgpool-II-93'
<br>
connection_cache = on
<br>
reset_query_list = 'ABORT; DISCARD ALL'
<br>
replication_mode = on
<br>
replicate_select = off
<br>
insert_lock = on
<br>
lobj_lock_table = ''
<br>
replication_stop_on_mismatch = off
<br>
failover_if_affected_tuples_mismatch = off
<br>
load_balance_mode = on
<br>
ignore_leading_white_space = on
<br>
white_function_list = ''
<br>
black_function_list = 'nextval,setval'
<br>
master_slave_mode = off
<br>
master_slave_sub_mode = 'slony'
<br>
sr_check_period = 0
<br>
sr_check_user = 'nobody'
<br>
sr_check_password = ''
<br>
delay_threshold = 0
<br>
follow_master_command = ''
<br>
parallel_mode = off
<br>
pgpool2_hostname = ''
<br>
health_check_period = 0
<br>
health_check_timeout = 20
<br>
health_check_user = 'nobody'
<br>
health_check_password = ''
<br>
health_check_max_retries = 0
<br>
health_check_retry_delay = 1
<br>
failover_command = ''
<br>
failback_command = ''
<br>
fail_over_on_backend_error = on
<br>
search_primary_node_timeout = 10
<br>
recovery_user = 'nobody'
<br>
recovery_password = ''
<br>
recovery_1st_stage_command = ''
<br>
recovery_2nd_stage_command = ''
<br>
recovery_timeout = 90
<br>
client_idle_limit_in_recovery = 0
<br>
use_watchdog = on
<br>
trusted_servers = '192.168.122.1'
<br>
ping_path = '/bin'
<br>
wd_hostname = '192.168.122.133'
<br>
wd_port = 9000
<br>
wd_authkey = ''
<br>
delegate_IP = '192.168.122.140'
<br>
ifconfig_path = '/sbin'
<br>
if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask
255.255.255.0'
<br>
if_down_cmd = 'ifconfig eth0:0 down'
<br>
arping_path = '/usr/sbin'
<br>
arping_cmd = 'arping -U $_IP_$ -w 1'
<br>
clear_memqcache_on_escalation = on
<br>
wd_escalation_command = ''
<br>
wd_lifecheck_method = 'heartbeat'
<br>
wd_interval = 3
<br>
wd_heartbeat_port = 9694
<br>
wd_heartbeat_keepalive = 2
<br>
wd_heartbeat_deadtime = 10
<br>
heartbeat_destination0 = '192.168.122.134'
<br>
heartbeat_destination_port0 = 9694
<br>
heartbeat_device0 = 'eth0'
<br>
wd_life_point = 3
<br>
wd_lifecheck_query = 'SELECT 1'
<br>
wd_lifecheck_dbname = 'template1'
<br>
wd_lifecheck_user = 'nobody'
<br>
wd_lifecheck_password = ''
<br>
other_pgpool_hostname0 = '192.168.122.134'
<br>
other_pgpool_port0 = 9999
<br>
other_wd_port0 = 9000
<br>
relcache_expire = 0
<br>
relcache_size = 256
<br>
check_temp_table = on
<br>
memory_cache_enabled = off
<br>
memqcache_method = 'shmem'
<br>
memqcache_memcached_host = 'localhost'
<br>
memqcache_memcached_port = 11211
<br>
memqcache_total_size = 67108864
<br>
memqcache_max_num_cache = 1000000
<br>
memqcache_expire = 0
<br>
memqcache_auto_cache_invalidation = on
<br>
memqcache_maxcache = 409600
<br>
memqcache_cache_block_size = 1048576
<br>
memqcache_oiddir = '/var/log/pgpool/oiddir'
<br>
white_memqcache_table_list = ''
<br>
black_memqcache_table_list = ''
<br>
<br>
<br>
<br>
<br>
_______________________________________________
<br>
pgpool-general mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
<br>
</blockquote>
<br>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a></pre>
</blockquote>
<br>
</body>
</html>