[pgpool-hackers: 2047] Re: pgpool-hackers Digest, Vol 64, Issue 17
Sergey Kim
skim at odin.com
Fri Feb 17 14:25:18 JST 2017
Hi Muhammad,
my opinion here is if the if_down_cmd returns OK status then the Pgpool is not responsible for any other validations. It it returns not OK then probably it makes sens to repeat the if_down_cmd several times until succeed or total failure.
Sergey Kim,
HA Architect.
skim at odin.com
ODIN Ingram Micro Cloud
________________________________
From: pgpool-hackers-bounces at pgpool.net <pgpool-hackers-bounces at pgpool.net> on behalf of pgpool-hackers-request at pgpool.net <pgpool-hackers-request at pgpool.net>
Sent: Friday, February 17, 2017 6:00 AM
To: pgpool-hackers at pgpool.net
Subject: pgpool-hackers Digest, Vol 64, Issue 17
Send pgpool-hackers mailing list submissions to
pgpool-hackers at pgpool.net
To subscribe or unsubscribe via the World Wide Web, visit
http://www.sraoss.jp/mailman/listinfo/pgpool-hackers
or, via email, send a message with subject or body 'help' to
pgpool-hackers-request at pgpool.net
You can reach the person managing the list at
pgpool-hackers-owner at pgpool.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of pgpool-hackers digest..."
Today's Topics:
1. [pgpool-hackers: 2045] pgpool-II buildfarm results
(buildfarm at pgpool.net)
2. [pgpool-hackers: 2046] Pgpool-II should not perform ping test
after bringing down the VIP (Muhammad Usama)
----------------------------------------------------------------------
Message: 1
Date: Thu, 16 Feb 2017 16:10:20 +0900 (JST)
From: buildfarm at pgpool.net
To: <pgpool-hackers at pgpool.net>
Subject: [pgpool-hackers: 2045] pgpool-II buildfarm results
Message-ID: <20170216071020.4FE4910224D at pgpool-II-buildfarm>
=========================================================================
* V3_4_STABLE PostgreSQL 9.4 CentOS6
testing 004.watchdog...timeout.
=========================================================================
pgpool-II buildfarm
start: Thu Feb 16 08:00:32 JST 2017
* Target branch: master
PostgreSQL: 9.3.16
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: master
PostgreSQL: 9.4.11
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: V3_5_STABLE
PostgreSQL: 9.3.16
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: V3_5_STABLE
PostgreSQL: 9.4.11
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: V3_4_STABLE
PostgreSQL: 9.3.16
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 26 ok:26 failed:0 timeout:0
* Target branch: V3_4_STABLE
PostgreSQL: 9.4.11
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...timeout.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 25 ok:25 failed:0 timeout:1
* Target branch: V3_3_STABLE
PostgreSQL: 9.3.16
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 22 ok:22 failed:0 timeout:0
* Target branch: V3_3_STABLE
PostgreSQL: 9.4.11
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 22 ok:22 failed:0 timeout:0
* Target branch: V3_2_STABLE
PostgreSQL: 9.3.16
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: V3_2_STABLE
PostgreSQL: 9.4.11
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: V3_1_STABLE
PostgreSQL: 9.3.16
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: V3_1_STABLE
PostgreSQL: 9.4.11
OS: CentOS release 6.8 (Final) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: master
PostgreSQL: 9.3.16
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: master
PostgreSQL: 9.4.11
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: V3_5_STABLE
PostgreSQL: 9.3.16
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: V3_5_STABLE
PostgreSQL: 9.4.11
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
out of 29 ok:29 failed:0 timeout:0
* Target branch: V3_4_STABLE
PostgreSQL: 9.3.16
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 26 ok:26 failed:0 timeout:0
* Target branch: V3_4_STABLE
PostgreSQL: 9.4.11
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 26 ok:26 failed:0 timeout:0
* Target branch: V3_3_STABLE
PostgreSQL: 9.3.16
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 22 ok:22 failed:0 timeout:0
* Target branch: V3_3_STABLE
PostgreSQL: 9.4.11
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 010.rewrite_timestamp...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
out of 22 ok:22 failed:0 timeout:0
* Target branch: V3_2_STABLE
PostgreSQL: 9.3.16
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: V3_2_STABLE
PostgreSQL: 9.4.11
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: V3_1_STABLE
PostgreSQL: 9.3.16
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
* Target branch: V3_1_STABLE
PostgreSQL: 9.4.11
OS: CentOS Linux release 7.3.1611 (Core) (3.13.0-24-generic)
** Regression test
make...ok
end: Thu Feb 16 16:10:19 JST 2017
------------------------------
Message: 2
Date: Thu, 16 Feb 2017 14:05:21 +0500
From: Muhammad Usama <m.usama at gmail.com>
To: Tatsuo Ishii <ishii at sraoss.co.jp>, pgpool-hackers
<pgpool-hackers at pgpool.net>
Subject: [pgpool-hackers: 2046] Pgpool-II should not perform ping test
after bringing down the VIP
Message-ID:
<CAEJvTzX_LpJsT8UQCd+ixnf0i0tONwv7iiubH3adNk9nRzp-bw at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hi
At the time de-escalation from the master watchdog node, Pgpool-II should
not perform the ping test to verify if the VIP is successfully brought down
or not.
The reason is, if the newly elected master watchdog node acquires the VIP
while the resigning Pgpool-II node is still performing the de-escalation
steps or doing the ping test on VIP. The resigning Pgpool-II will
falsely assume that it has failed to bring down the delegate IP, after
getting the positive ping result from the new master node that has already
acquired that VIP.
Comments and suggestions are welcome.
Kind regards
Muhammad Usama
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20170216/0852ae72/attachment-0001.html>
------------------------------
_______________________________________________
pgpool-hackers mailing list
pgpool-hackers at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-hackers
pgpool-hackers Info Page<http://www.pgpool.net/mailman/listinfo/pgpool-hackers>
www.pgpool.net
To see the collection of prior postings to the list, visit the pgpool-hackers Archives. Using pgpool-hackers: To post a message to all the list ...
End of pgpool-hackers Digest, Vol 64, Issue 17
**********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20170217/6ec2b743/attachment-0001.html>
More information about the pgpool-hackers
mailing list