View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000774 | Pgpool-II | Bug | public | 2022-11-24 10:59 | 2022-12-13 00:14 |
| Reporter | jaewan | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Product Version | 4.3.3 | ||||
| Summary | 0000774: node info Status "waiting" that never ends | ||||
| Description | During several tests, the standby node fell into infinite waiting. Status : 1 Weight : 0.000000 Status Name : waiting Backend Status Name : up Role : standby Backend Role : standby Replication Delay : 0 Replication State : streaming Replication Sync State : async Last Status Change : 2022-11-24 09:56:13 If you try pcp_recovery_node, ERROR: failed to process PCP request at the moment DETAIL: failback is in progress It comes out like this. Restarting the pgpool or postgresql service does not resolve the problem, and physically restarting the server does not resolve the problem. What are the measures in this situation? | ||||
| Tags | No tags attached. | ||||
|
|
> During several tests, the standby node fell into infinite waiting. "waiting" status means "Node is up. No connections yet". https://www.pgpool.net/docs/latest/en/html/pcp-node-info.html If no connection to PostgreSQL has been created, the status will not be changed to "up". If "show pool_nodes" shows "up", it is the correct behavior. |
|
|
What does "unconnected" mean? Is it the case that there is no communication? Ping test between two servers works well. |
|
|
"unconnected"가 아니고 "No connections yet" 이군요. "No connections yet"의 의미를 좀 더 알수있을까요? |
|
|
It's not "unconnected," it's "No connections yet." Can I know more about the meaning of "No connection sheet"? |
|
|
> It's not "unconnected," it's "No connections yet." > Can I know more about the meaning of "No connection sheet"? "waiting" can be considered "up". We will consider improving the status "waiting". |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-11-24 10:59 | jaewan | New Issue | |
| 2022-11-24 15:01 | pengbo | Note Added: 0004149 | |
| 2022-11-24 15:01 | pengbo | Status | new => feedback |
| 2022-11-28 09:01 | jaewan | Note Added: 0004150 | |
| 2022-11-28 09:01 | jaewan | Status | feedback => new |
| 2022-11-28 09:03 | jaewan | Note Added: 0004151 | |
| 2022-11-28 09:04 | jaewan | Note Added: 0004152 | |
| 2022-12-13 00:13 | pengbo | Note Added: 0004169 | |
| 2022-12-13 00:13 | pengbo | Status | new => feedback |
| 2022-12-13 00:14 | pengbo | Assigned To | => pengbo |
| 2022-12-13 00:14 | pengbo | Status | feedback => assigned |
