View Issue Details

IDProjectCategoryView StatusLast Update
0000415Pgpool-IIBugpublic2019-01-30 10:02
ReporterSeemaAssigned Tot-ishii 
PriorityurgentSeveritymajorReproducibilityalways
Status assignedResolutionopen 
PlatformPGPOOL-IIOSFreeBSDOS Version11.1-RELEASE
Product Version3.5.3 
Target VersionFixed in Version 
Summary0000415: 0000414: pg_dump causes Segmentation fault (core dumped)
DescriptionHi,

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
TagsNo tags attached.

Activities

Seema

2018-07-23 14:34

reporter  

postgresql.conf (21,233 bytes)
pgpool.conf.orig (35,335 bytes)

pengbo

2018-07-23 14:44

developer   ~0002115

I could not reproduce this issue on CentOS. If possible, could you provide the core file?

Seema

2018-07-24 13:18

reporter   ~0002116

Hello,
I have uploaded the core file.

Regards,
Seema

pg_dump.core (7,155,712 bytes)

t-ishii

2018-07-25 08:21

developer   ~0002119

Thanks. Unfortunately I don't have time to set up FreeBSD for now. Can you share stack trace info ?

Seema

2018-07-25 13:48

reporter   ~0002120

Hi,

Can you give me the procedure to take the stack trace?

Regards,
Seema

t-ishii

2018-07-25 13:53

developer   ~0002121

gdb pg_dump pg_dump.core
bt full

Seema

2018-07-25 13:57

reporter   ~0002122

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)

t-ishii

2018-07-25 14:07

developer   ~0002123

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).

administrator

2018-12-04 10:47

administrator   ~0002302

If you have resovled this issue, could you close this item?

Seema

2018-12-04 13:51

reporter   ~0002304

Issue is still persisting. But I have opened another case with ID 0000418

Issue History

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