View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000414 | pgpool-HA | Bug | public | 2018-07-20 20:51 | 2018-12-04 10:43 |
| Reporter | Seema | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | PGPOOL-II | OS | FreeBSD | OS Version | 11.1-RELEASE |
| Summary | 0000414: pg_dump causes Segmentation fault (core dumped) | ||||
| Description | Hi, I have configured PGPOOL-II with two DB Nodes running postgres. Versions are: OS: Freebsd 11 PGPOOL Version: pgpool-II version 3.5.3 (ekieboshi), pg_dump version: 9.5.12, 9.3.23 (checked with both versions) Pgpool and DB is working fine with our applications. Problem: When I try t export the DB using pg_dump from the pgpool server, I am getting the following error: root@host1:/ # pg_dump -h <host IP> -p 5432 -d <db name> -U pgsql > /cl/BACKUP-DB/dbname_pgp.sql Password: Segmentation fault (core dumped) root@host1:/ # I found the following error messages in pgpool.log during the same same: Jul 20 15:26:17 pgpserver pgpool[850]: [3-1] 2018-07-20 15:26:17: pid 850:ERROR: unable to read data from frontend Jul 20 15:26:17 pgpserver pgpool[850]: [3-2] 2018-07-20 15:26:17: pid 850:DETAIL: EOF encountered with frontend Jul 20 15:26:17 pgpserver pgpool[850]: [3-3] 2018-07-20 15:26:17: pid 850:LOCATION: pool_stream.c:261 Jul 20 15:26:17 pgpserver pgpool: 2018-07-20 15:26:17: pid 850:ERROR: unable to read data from frontend Jul 20 15:26:17 pgpserver pgpool: 2018-07-20 15:26:17: pid 850:DETAIL: EOF encountered with frontend Jul 20 15:26:17 pgpserver pgpool: 2018-07-20 15:26:17: pid 850:LOCATION: pool_stream.c:261 I have tried checking the firewall rules and kernel configuration, but there is no change. The following parameters are given in /boot/loader.conf.local kern.maxusers="1024" kern.ipc.semmns="2048" kern.ipc.semmni="128" kern.ipc.shmall="33554432" kern.ipc.shmseg="1024" kern.ipc.shmmax=137438953472 kern.ipc.maxsockets="256000" kern.ipc.maxsockbuf="2621440" kern.maxswzone="335544320" accfhttp_load="YES" hw.igb.enable_msix=0 aesni_load="YES" I am able to execute pg_dump directly on the DB nodes, but pg_dump gives error when executed from the pgpool server. I am also attaching the pgpool.conf and postgresql.conf for your reference. Expecting a solution asap, since our production rollout is halted due to this. Best Regards, Seema | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
This is a wrong project. Please select "pgpool-II" project and submit the issue again. Also I suggest you to share the back trace when pg_dump segfaluts. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-20 20:51 | Seema | New Issue | |
| 2018-07-20 20:51 | Seema | File Added: pgpool.conf.orig | |
| 2018-07-20 20:51 | Seema | File Added: postgresql.conf | |
| 2018-07-21 07:30 | t-ishii | Note Added: 0002112 | |
| 2018-12-04 10:43 | administrator | Status | new => closed |
