View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000635 | Pgpool-II | Bug | public | 2020-08-18 22:33 | 2020-08-20 08:57 |
| Reporter | pgdude | Assigned To | t-ishii | ||
| Priority | normal | Severity | block | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | Linux | OS | Ubuntu | OS Version | 20.04 |
| Product Version | 4.1.2 | ||||
| Summary | 0000635: Cannot startup standby in watchdog mode | ||||
| Description | Error message in log file is: Aug 18 08:18:24 michaelv4 pgpool[8972]: 2020-08-18 08:18:24 pid: 8972 db: [No Connection] usr: [No Connection] FATAL: invalid watchdog configuration. other pgpools setting is not defined This happens when I try to startup my standby in watchdog mode after I successfully started up my watchdog on the primary. I see this branch in the source code. So how is num of watchdogs coming out as zero? if (pool_config->wd_nodes.num_wd == 0) ereport(ERROR, (errmsg("invalid watchdog configuration. other pgpools setting is not defined"))); | ||||
| Steps To Reproduce | On the standby as root user: systemctl start pgpool2 Then view pgpool.log file for the errors. | ||||
| Tags | No tags attached. | ||||
|
|
I'm wondering if pgpool fails to startup the VIP if that could cause this problem? I haven't tested the VIP logic manually on the hosts. I just defined an ip that shows up in "ip addr" command. So I wonder if the IP up and down commands are the problem, since Ubuntu 20.04 uses netplan package not the old ifupdown package. If that is the problem, you may want to make note of that in the default VIP pgpool settings for bringing the VIP up and down. |
|
|
It is possible that there are problems in pgpool.conf. Can you share both of pgpool.conf? |
|
|
Attached are the pgpool.conf files for the primary, michaelv3 and the standby, michaelv4. |
|
|
Actually I cannot start up either watchdog. And the error message occurs in two places in src/watchdog/watchdog.c: wd_check_config(void) { if (pool_config->wd_nodes.num_wd == 0) ereport(ERROR, (errmsg("invalid watchdog configuration. other pgpools setting is not defined"))); wd_cluster_initialize(): ... ... /* initialize remote nodes */ g_cluster.remoteNodeCount = pool_config->wd_nodes.num_wd - 1; if (g_cluster.remoteNodeCount == 0) ereport(ERROR, (errmsg("invalid watchdog configuration. other pgpools setting is not defined"))); |
|
|
While waiting for a response, I decided to download the source code and compile it with debug statements that I added. It became apparent that one of the "other_" parameters was not uncommented even though the other ones were: other_pgpool_hostname0 = 'michaelv4' other_pgpool_port0 = 5432 #other_wd_port0 = 9000 That last one, "other_wd_port0" was the culprit. Once I un-commented it, I was able to get it started. |
|
|
Yes, you need "other_wd_port0" to be defined. So, > That last one, "other_wd_port0" was the culprit. Once I un-commented it, I was able to get it started. is a correct solution. |
|
|
Please close this issue now since it was not a pgpool2 bug, but rather a configuration error on this user's part. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-08-18 22:33 | pgdude | New Issue | |
| 2020-08-18 22:39 | pgdude | Note Added: 0003478 | |
| 2020-08-18 23:09 | t-ishii | Note Added: 0003480 | |
| 2020-08-18 23:09 | t-ishii | Assigned To | => t-ishii |
| 2020-08-18 23:09 | t-ishii | Status | new => feedback |
| 2020-08-18 23:18 | pgdude | File Added: pgpool.conf.michaelv3 | |
| 2020-08-18 23:18 | pgdude | File Added: pgpool.conf.michaelv4 | |
| 2020-08-18 23:18 | pgdude | Note Added: 0003481 | |
| 2020-08-18 23:18 | pgdude | Status | feedback => assigned |
| 2020-08-19 21:23 | pgdude | Note Added: 0003485 | |
| 2020-08-19 23:49 | pgdude | Note Added: 0003486 | |
| 2020-08-20 08:37 | t-ishii | Note Added: 0003488 | |
| 2020-08-20 08:37 | t-ishii | Status | assigned => feedback |
| 2020-08-20 08:56 | pgdude | Note Added: 0003490 | |
| 2020-08-20 08:56 | pgdude | Status | feedback => assigned |
| 2020-08-20 08:57 | t-ishii | Status | assigned => closed |
