View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000415 | Pgpool-II | Bug | public | 2018-07-23 14:34 | 2019-01-30 10:02 |
| Reporter | Seema | Assigned To | t-ishii | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Platform | PGPOOL-II | OS | FreeBSD | OS Version | 11.1-RELEASE |
| Product Version | 3.5.3 | ||||
| Summary | 0000415: 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. | ||||
|
|
|
|
|
I could not reproduce this issue on CentOS. If possible, could you provide the core file? |
|
|
Hello, I have uploaded the core file. Regards, Seema |
|
|
Thanks. Unfortunately I don't have time to set up FreeBSD for now. Can you share stack trace info ? |
|
|
Hi, Can you give me the procedure to take the stack trace? Regards, Seema |
|
|
gdb pg_dump pg_dump.core bt full |
|
|
below is the stack trace. Please note: While taking the stack trace pgpool service was down... root@pgp41:~ # gdb pg_dump pg_dump.core GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "amd64-marcel-freebsd"...(no debugging symbols found)... Core was generated by `pg_dump -h 159.65.145.179 -p 5432 -d demo13_do -U pgsql'. Program terminated with signal 10, Bus error. Reading symbols from /usr/local/lib/libpq.so.5...(no debugging symbols found)...done. Loaded symbols for /usr/local/lib/libpq.so.5 Reading symbols from /lib/libthr.so.3...(no debugging symbols found)...done. Loaded symbols for /lib/libthr.so.3 Reading symbols from /usr/local/lib/libintl.so.8...(no debugging symbols found)...done. Loaded symbols for /usr/local/lib/libintl.so.8 Reading symbols from /lib/libz.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/libz.so.6 Reading symbols from /lib/libc.so.7...(no debugging symbols found)...done. Loaded symbols for /lib/libc.so.7 Reading symbols from /usr/lib/libssl.so.8...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libssl.so.8 Reading symbols from /lib/libcrypto.so.8...(no debugging symbols found)...done. Loaded symbols for /lib/libcrypto.so.8 Reading symbols from /libexec/ld-elf.so.1...(no debugging symbols found)...done. Loaded symbols for /libexec/ld-elf.so.1 #0 0x000000000042e27c in ?? () (gdb) (gdb) (gdb) (gdb) (gdb) bt full #0 0x000000000042e27c in ?? () No symbol table info available. 0000001 0x000000000041826a in ?? () No symbol table info available. 0000002 0x00000000004060e3 in ?? () No symbol table info available. 0000003 0x00000000004041cf in ?? () No symbol table info available. 0000004 0x0000000800679000 in ?? () No symbol table info available. 0000005 0x0000000000000000 in ?? () No symbol table info available. (gdb) |
|
|
Unfortunately it seems the symbol tables are lacking in your installation. So the information is not helpful. Have installed PostgreSQL using FreeBSD package? If so, please install the symbol tables (sorry, I don't know how to do it because I am not familiar with FreeBSD packaging system). |
|
|
If you have resovled this issue, could you close this item? |
|
|
Issue is still persisting. But I have opened another case with ID 0000418 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-23 14:34 | Seema | New Issue | |
| 2018-07-23 14:34 | Seema | File Added: pgpool.conf.orig | |
| 2018-07-23 14:34 | Seema | File Added: postgresql.conf | |
| 2018-07-23 14:44 | pengbo | Note Added: 0002115 | |
| 2018-07-24 13:18 | Seema | File Added: pg_dump.core | |
| 2018-07-24 13:18 | Seema | Note Added: 0002116 | |
| 2018-07-25 08:21 | t-ishii | Note Added: 0002119 | |
| 2018-07-25 08:21 | t-ishii | Status | new => feedback |
| 2018-07-25 13:48 | Seema | Note Added: 0002120 | |
| 2018-07-25 13:48 | Seema | Status | feedback => new |
| 2018-07-25 13:53 | t-ishii | Note Added: 0002121 | |
| 2018-07-25 13:57 | Seema | Note Added: 0002122 | |
| 2018-07-25 14:07 | t-ishii | Note Added: 0002123 | |
| 2018-12-04 10:47 | administrator | Note Added: 0002302 | |
| 2018-12-04 13:51 | Seema | Note Added: 0002304 | |
| 2019-01-30 10:02 | pengbo | Assigned To | => t-ishii |
| 2019-01-30 10:02 | pengbo | Status | new => assigned |
