View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000693 | Pgpool-II | Bug | public | 2021-02-16 19:24 | 2021-06-15 13:55 |
| Reporter | shubham.s@helpshift.com | Assigned To | t-ishii | ||
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Platform | Debian | OS | Ubuntu | OS Version | 14.04 |
| Product Version | 3.6.1 | ||||
| Summary | 0000693: Getting segfaults errors frequently | ||||
| Description | We are using pgpool-II version 3.6.1 (subaruboshi) on Ubuntu 14.04. We have postgres master/slave setup behind pgpool, we are continuously observing that either one of our backend is going down, output below and our flow breaks and we have to manually use pcp_attach_node everytime to make it up again. -------------------------------------------- Hostname : <IP> Port : 5432 Status : 3 Weight : 0.500000 Status Name: down --------------------------------------------- While checking the logs we found that everytime our backend goes down we have segfault errors like below: ----------------------------------- [Mon Feb 15 19:34:31 2021] pgpool[19213]: segfault at 10 ip 0000000000432d43 sp 00007ffe7b7d7ad0 error 4 in pgpool[400000+13d000] [Mon Feb 15 19:34:59 2021] pgpool[19205]: segfault at 10 ip 000000000043e4aa sp 00007ffe7b7d7a00 error 4 in pgpool[400000+13d000] [Mon Feb 15 19:35:02 2021] pgpool[19211]: segfault at 10 ip 0000000000432d43 sp 00007ffe7b7d7ad0 error 4 in pgpool[400000+13d000] [Mon Feb 15 19:35:13 2021] pgpool[19208]: segfault at 10 ip 0000000000432d43 sp 00007ffe7b7d7ad0 error 4 in pgpool[400000+13d000] [Mon Feb 15 19:47:50 2021] pgpool[19141]: segfault at 10 ip 000000000043e4aa sp 00007ffe7b7d7a00 error 4 in pgpool[400000+13d000] ----------------------------------- We have enable_pool_hba = on in our /etc/pgpool2/pgpool.conf file and our pool_hba.conf file looks like below: ------------------------------------ local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # Passwored hosts # md5 hosts host all all 0.0.0.0/0 md5 -------------------------------------- Could you please help us here? We have recently migrated from AWS RDS to self hosted PG (v9.5) and from then we are facing this issues with pgpool. Please let us know if you need any other information from our side. Regards, Shubham | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Pgpool-II 3.6.1 is too old (released 4 years ago) and numbers of bugs causing segfault have been fixed since then. Please upgrade to the version of 3.6 series. |
|
|
No response for more than a month. Close issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-02-16 19:24 | shubham.s@helpshift.com | New Issue | |
| 2021-02-16 19:30 | shubham.s@helpshift.com | File Added: pgpool.conf | |
| 2021-02-16 21:13 | t-ishii | Note Added: 0003742 | |
| 2021-02-16 21:14 | t-ishii | Assigned To | => t-ishii |
| 2021-02-16 21:14 | t-ishii | Status | new => feedback |
| 2021-06-15 13:55 | administrator | Note Added: 0003876 | |
| 2021-06-15 13:55 | administrator | Status | feedback => closed |
