[pgpool-general: 3907] Understanding node info and watchdog info

[Thomas Bach]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hi there,

I configured pgpool-IIpgpool-II version 3.3.2 (tokakiboshi) and
Postgres to run on two separate machines in replication mode. I just
recently configured watchdog. At some point the two databases diverged
which is ok because I am currently in the testing phase.

Now on host02 I query watchdog and obtain

host02 # pcp_watchdog_info -v 1 host01 9898 root ****
Hostname     : host01
Pgpool port  : 5432
Watchdog port: 9000
Status       : 2
host02 # pcp_watchdog_info -v 1 host02 9898 root ****
Hostname     : host02
Pgpool port  : 5432
Watchdog port: 9000
Status       : 3

So host02 is active. I obtain the exact same results when issuing
these queries from host01.

Anyway, when querying pcp_node_info I obtain the following:

host02 # pcp_node_info -v 1 host01 9898 root **** 0
Hostname: host01
Port    : 5433
Status  : 1          <----------------------
Weight  : 1.000000
host02 # pcp_node_info -v 1 host01 9898 root **** 1
Hostname: host02
Port    : 5433
Status  : 1
Weight  : 0.000000
host02 # pcp_node_info -v 1 host02 9898 root **** 0
Hostname: host01
Port    : 5433
Status  : 3         <----------------------
Weight  : 0.000000
host02 # pcp_node_info -v 1 host02 9898 root **** 1
Hostname: host02
Port    : 5433
Status  : 1
Weight  : 1.000000

So, as host02 sees it, host01 is down. But for host01 both itself as
well as host02 are perfectly sane.

1) Is such a state intended? I.e. is pgpool-II fully operational in
this mode?

2) What will happen when I do an insert via host02? Will it replicate
to host01?

3) And even more interesting: what will happen when I do an insert via
host01?

4) What ways do I have at hand to resolve this issue?

Regards

	Thomas.

- -- 
ilexius GmbH
Thomas Bach
Unter den Eichen 5
Haus i
65195 Wiesbaden
Fon: +49-(0)611 - 180 33 49
Fax: +49-(0)611 - 236 80 84 29
- -------------------------------------
ilexius GmbH
vertreten durch die Geschäftsleitung:
Thomas Schlüter und Sebastian Koch
Registergericht: Wiesbaden
Handelsregister: HRB 21723
Steuernummer: 040 236 22640
Ust-IdNr.: DE240822836
- ------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJVvicdAAoJEOpECs8ANDYkIrgP/0YW62GF3FuATWbEtwfomo8w
o03nFvUnklTLKSFkF1Au9fKU4YIE+Ifm868rWlotW50mL7qbIy3hS+uyV/7sFOUW
87f7bGWrKvI9G73a+5c8002cTzA7te7CQr7T2gxsWAunOpcZFsN5FTAtuXp7HF35
A+5yKsofnCyeH1ZKuWBpMIhoaaDbuzVC1HBjBw4duDsAQUR97lKsq6UikJ9DXLhz
ii8YeRiFXX15uRkn1YCajcdS3n6R8GXUfYnuhYOiYu7/WDI1sIghppQQlEYvCqmJ
pn4er4nuzd+Mlk/VJ/A3zb6Kds3fxhOBvlWWC8KUVWWm+Os2+AA1Xaihv7rTZBHd
LVzRzdoi+5TCQ4MfYXMCBKDqGLjaOwN7/3R++KNVkR6kBR5XrTDztcCoHRzy6ILs
R1T6WSzVD23bkybMHGSadZtL+5apy2cZ1X2WZo+jlFrXsLWpCNgIKSJyfxo5u1+8
1brCox7oO/VLdJCJo/TJO68yK5MAqil2aERuxul3VKGGvtWddZZD+3llf2mQRLnj
F+Ydj+2i85/GXKmPQKg/aR17GDNTvEaK3gWLUTA4Xo429OtcF60OSx9ZPgc3n0yQ
6P6iGOOsCE1YQytuolKERhNrgrbIzNGLwdvTAVrarQ73PUfspaj12dyNlwD6V2zG
Nbg5FB677iGWkLn+DYQA
=k6TH
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: t_bach.vcf
Type: text/x-vcard
Size: 4 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150802/b3f9cb5b/attachment.vcf>