View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000486 | Pgpool-II | Bug | public | 2019-03-27 08:35 | 2019-05-21 16:07 |
| Reporter | cadams | Assigned To | t-ishii | ||
| Priority | normal | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | open | ||
| Product Version | 3.7.8 | ||||
| Fixed in Version | 3.7.10 | ||||
| Summary | 0000486: segfaults at drop database | ||||
| Description | segfaults occur at command 'drop database' [Mon Mar 25 15:31:34 2019] show_signal_msg: 6 callbacks suppressed [Mon Mar 25 15:31:34 2019] pgpool[80777]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[84661]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[75850]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[78736]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[80449]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[80376]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[74560]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[38743]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[84716]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:34 2019] pgpool[82496]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:41 2019] show_signal_msg: 25 callbacks suppressed [Mon Mar 25 15:31:41 2019] pgpool[76782]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:41 2019] pgpool[85871]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:41 2019] pgpool[78544]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] [Mon Mar 25 15:31:41 2019] pgpool[78740]: segfault at 10 ip 000000000042d827 sp 00007ffff4d14410 error 4 in pgpool[400000+154000] Mar 25 15:31:40 dbpool-002 pgpool[79417]: [112206-1] 2019-03-25 15:31:40: pid 79417: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 162740 statement: "drop database IF EXISTS snab_sso_qsr" message: "database "snab_sso_qsr" does not exist, skipping" logs from another incident - Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4674-1] 2019-03-26 18:30:27: pid 5307: LOG: Pgpool-II parent process has received failover request Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: Pgpool-II parent process has received failover request Mar 26 18:30:27 dbpool-403 kernel: pgpool[7030]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[7243]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[7879]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[8173]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[8412]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[8629]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[68713]: segfault at 10 ip 000000000042d827 sp 00007ffe7d426270 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[67451]: segfault at 10 ip 000000000042d827 sp 00007ffe7d426270 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[11604]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 kernel: pgpool[12047]: segfault at 10 ip 000000000042d827 sp 00007ffe7d4262b0 error 4 in pgpool[400000+154000] Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4675-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 7030 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 7030 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70075 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 7243 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70076 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 7879 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70077 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 8173 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70078 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 8412 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70079 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 8629 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4676-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70075 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70080 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 11604 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70081 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: child process with pid: 7875 exits with status 256 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70082 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 12047 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4677-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 7243 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70083 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: child process with pid: 12136 exits with status 256 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70084 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 67451 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70085 Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 68713 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70086 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4678-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70076 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4679-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 7879 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4680-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70077 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4681-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 8173 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4682-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70078 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4683-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 8412 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4684-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70079 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4685-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 8629 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4686-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70080 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4687-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 11604 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4688-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70081 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4689-1] 2019-03-26 18:30:27: pid 5307: LOG: child process with pid: 7875 exits with status 256 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4690-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70082 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4691-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 12047 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4692-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70083 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4693-1] 2019-03-26 18:30:27: pid 5307: LOG: child process with pid: 12136 exits with status 256 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4694-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70084 Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4695-1] 2019-03-26 18:30:27: pid 5307: WARNING: child process with pid: 67451 was terminated by segmentation fault Mar 26 18:30:27 dbpool-403 pgpool[5307]: [4696-1] 2019-03-26 18:30:27: pid 5307: LOG: fork a new child process with pid: 70085 | ||||
| Steps To Reproduce | Connect via pgpool and give command 'DROP DATABASE {any database name, existing or not}' Happens whether load balancing is on or off. Only happens under high loads, high connection counts, and I have as yet been unsuccessful getting it to reproduce on a debugging system. | ||||
| Additional Information | inux 3.10.0-957.10.1.el7.x86_64 0000001 SMP Mon Mar 18 15:06:45 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux postgresql 9.6.12 | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
I couldn't reproduce this segfault. If you can reproduce this issue, could you provide a stack trace to help us to find the cause? |
|
|
stacktrace from pid of pgpool process where the drop database command is given. The segfaults occur in other processes (obtained from another crash instance) Program received signal SIGUSR1, User defined signal 1. 0x00007fa090fefe10 in __nanosleep_nocancel () from /lib64/libc.so.6 (gdb) thread apply all bt Thread 1 (Thread 0x7fa092fe2880 (LWP 178007)): #0 0x00007fa090fefe10 in __nanosleep_nocancel () from /lib64/libc.so.6 0000001 0x00007fa090fefcc4 in sleep () from /lib64/libc.so.6 0000002 0x0000000000435f6f in SimpleQuery (frontend=frontend@entry=0xc96568, backend=backend@entry=0x7fa092fb4418, len=30, contents=contents@entry=0xc9c588 "drop database test_test_drop;") at protocol/pool_proto_modules.c:501 0000003 0x000000000043b574 in ProcessFrontendResponse (frontend=frontend@entry=0xc96568, backend=backend@entry=0x7fa092fb4418) at protocol/pool_proto_modules.c:2389 0000004 0x000000000042dfb0 in read_packets_and_process (frontend=frontend@entry=0xc96568, backend=backend@entry=0x7fa092fb4418, reset_request=reset_request@entry=0, state=state@entry=0x7ffd9c6c89dc, num_fields=num_fields@entry=0x7ffd9c6c89da, cont=cont@entry=0x7ffd9c6c89e4 "\001") at protocol/pool_process_query.c:4784 0000005 0x000000000042eaeb in pool_process_query (frontend=0xc96568, backend=0x7fa092fb4418, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:274 0000006 0x0000000000428f39 in do_child (fds=fds@entry=0xc92810) at protocol/child.c:385 0000007 0x00000000004099e5 in fork_a_child (fds=0xc92810, id=2067) at main/pgpool_main.c:610 0000008 0x000000000040a451 in reaper () at main/pgpool_main.c:2544 0000009 0x00000000004103cf in PgpoolMain (discard_status=discard_status@entry=0 '\000', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:439 0000010 0x000000000040807b in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:318 |
|
|
[Wed Mar 27 19:39:13 2019] show_signal_msg: 2 callbacks suppressed [Wed Mar 27 19:39:13 2019] pgpool[202034]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[203946]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[206403]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[182463]: segfault at 10 ip 000000000042d827 sp 00007ffda7155100 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[187175]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[205415]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[206242]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] [Wed Mar 27 19:39:13 2019] pgpool[205380]: segfault at 10 ip 000000000042d827 sp 00007ffda71550c0 error 4 in pgpool[400000+154000] cores attached |
|
|
[New LWP 182463] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `pgpool: postgres SGDatabase 10.6.129.30(47122) id'. Program terminated with signal 11, Segmentation fault. #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda715533c, num_fields=num_fields@entry=0x7ffda715533a, cont=cont@entry=0x7ffda7155344 "\001") at protocol/pool_process_query.c:4590 4590 num_fds = Max(CONNECTION(backend, i)->fd + 1, num_fds); Missing separate debuginfos, use: debuginfo-install audit-libs-2.8.4-4.el7.x86_64 cyrus-sasl-lib-2.1.26-23.el7.x86_64 glibc-2.17-260.el7_6.3.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-37.el7_6.x86_64 libcap-ng-0.7.5-4.el7.x86_64 libcom_err-1.42.9-13.el7.x86_64 libgcc-4.8.5-36.el7.x86_64 libmemcached-1.0.16-5.el7.x86_64 libselinux-2.5-14.1.el7.x86_64 libstdc++-4.8.5-36.el7.x86_64 nspr-4.19.0-1.el7_5.x86_64 nss-3.36.0-7.1.el7_6.x86_64 nss-softokn-freebl-3.36.0-5.el7_5.x86_64 nss-util-3.36.0-1.1.el7_6.x86_64 openldap-2.4.44-21.el7_6.x86_64 openssl-libs-1.0.2k-16.el7_6.1.x86_64 pam-1.1.8-22.el7.x86_64 pcre-8.32-17.el7.x86_64 postgresql96-libs-9.6.12-1PGDG.rhel7.x86_64 zlib-1.2.7-18.el7.x86_64 (gdb) bt #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda715533c, num_fields=num_fields@entry=0x7ffda715533a, cont=cont@entry=0x7ffda7155344 "\001") at protocol/pool_process_query.c:4590 0000001 0x000000000042eaeb in pool_process_query (frontend=0x1ae8568, backend=0x7f7390885418, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:274 0000002 0x0000000000428f39 in do_child (fds=fds@entry=0x1ae4810) at protocol/child.c:385 0000003 0x00000000004099e5 in fork_a_child (fds=0x1ae4810, id=1658) at main/pgpool_main.c:610 0000004 0x000000000040fccb in PgpoolMain (discard_status=discard_status@entry=0 '\000', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:366 0000005 0x000000000040807b in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:318 [New LWP 187175] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `pgpool: postgres SGDatabase 10.6.129.29(33434) id'. Program terminated with signal 11, Segmentation fault. #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 4590 num_fds = Max(CONNECTION(backend, i)->fd + 1, num_fds); Missing separate debuginfos, use: debuginfo-install audit-libs-2.8.4-4.el7.x86_64 cyrus-sasl-lib-2.1.26-23.el7.x86_64 glibc-2.17-260.el7_6.3.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-37.el7_6.x86_64 libcap-ng-0.7.5-4.el7.x86_64 libcom_err-1.42.9-13.el7.x86_64 libgcc-4.8.5-36.el7.x86_64 libmemcached-1.0.16-5.el7.x86_64 libselinux-2.5-14.1.el7.x86_64 libstdc++-4.8.5-36.el7.x86_64 nspr-4.19.0-1.el7_5.x86_64 nss-3.36.0-7.1.el7_6.x86_64 nss-softokn-freebl-3.36.0-5.el7_5.x86_64 nss-util-3.36.0-1.1.el7_6.x86_64 openldap-2.4.44-21.el7_6.x86_64 openssl-libs-1.0.2k-16.el7_6.1.x86_64 pam-1.1.8-22.el7.x86_64 pcre-8.32-17.el7.x86_64 postgresql96-libs-9.6.12-1PGDG.rhel7.x86_64 zlib-1.2.7-18.el7.x86_64 (gdb) bt #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 0000001 0x000000000042eaeb in pool_process_query (frontend=0x1ae8568, backend=0x7f7390885418, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:274 0000002 0x0000000000428f39 in do_child (fds=fds@entry=0x1ae4810) at protocol/child.c:385 0000003 0x00000000004099e5 in fork_a_child (fds=0x1ae4810, id=487) at main/pgpool_main.c:610 0000004 0x000000000040a451 in reaper () at main/pgpool_main.c:2544 0000005 0x00000000004103cf in PgpoolMain (discard_status=discard_status@entry=0 '\000', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:439 0000006 0x000000000040807b in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:318 [New LWP 202034] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `pgpool: postgres SGDatabase 10.6.129.29(33810) id'. Program terminated with signal 11, Segmentation fault. #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 4590 num_fds = Max(CONNECTION(backend, i)->fd + 1, num_fds); Missing separate debuginfos, use: debuginfo-install audit-libs-2.8.4-4.el7.x86_64 cyrus-sasl-lib-2.1.26-23.el7.x86_64 glibc-2.17-260.el7_6.3.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-37.el7_6.x86_64 libcap-ng-0.7.5-4.el7.x86_64 libcom_err-1.42.9-13.el7.x86_64 libgcc-4.8.5-36.el7.x86_64 libmemcached-1.0.16-5.el7.x86_64 libselinux-2.5-14.1.el7.x86_64 libstdc++-4.8.5-36.el7.x86_64 nspr-4.19.0-1.el7_5.x86_64 nss-3.36.0-7.1.el7_6.x86_64 nss-softokn-freebl-3.36.0-5.el7_5.x86_64 nss-util-3.36.0-1.1.el7_6.x86_64 openldap-2.4.44-21.el7_6.x86_64 openssl-libs-1.0.2k-16.el7_6.1.x86_64 pam-1.1.8-22.el7.x86_64 pcre-8.32-17.el7.x86_64 postgresql96-libs-9.6.12-1PGDG.rhel7.x86_64 zlib-1.2.7-18.el7.x86_64 (gdb) bt #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 0000001 0x000000000042eaeb in pool_process_query (frontend=0x1ae8568, backend=0x7f7390885418, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:274 0000002 0x0000000000428f39 in do_child (fds=fds@entry=0x1ae4810) at protocol/child.c:385 0000003 0x00000000004099e5 in fork_a_child (fds=0x1ae4810, id=2703) at main/pgpool_main.c:610 0000004 0x000000000040a451 in reaper () at main/pgpool_main.c:2544 0000005 0x00000000004103cf in PgpoolMain (discard_status=discard_status@entry=0 '\000', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:439 0000006 0x000000000040807b in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:318 [New LWP 203946] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `pgpool: postgres SGDatabase 10.6.129.31(56780) id'. Program terminated with signal 11, Segmentation fault. #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 4590 num_fds = Max(CONNECTION(backend, i)->fd + 1, num_fds); Missing separate debuginfos, use: debuginfo-install audit-libs-2.8.4-4.el7.x86_64 cyrus-sasl-lib-2.1.26-23.el7.x86_64 glibc-2.17-260.el7_6.3.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-37.el7_6.x86_64 libcap-ng-0.7.5-4.el7.x86_64 libcom_err-1.42.9-13.el7.x86_64 libgcc-4.8.5-36.el7.x86_64 libmemcached-1.0.16-5.el7.x86_64 libselinux-2.5-14.1.el7.x86_64 libstdc++-4.8.5-36.el7.x86_64 nspr-4.19.0-1.el7_5.x86_64 nss-3.36.0-7.1.el7_6.x86_64 nss-softokn-freebl-3.36.0-5.el7_5.x86_64 nss-util-3.36.0-1.1.el7_6.x86_64 openldap-2.4.44-21.el7_6.x86_64 openssl-libs-1.0.2k-16.el7_6.1.x86_64 pam-1.1.8-22.el7.x86_64 pcre-8.32-17.el7.x86_64 postgresql96-libs-9.6.12-1PGDG.rhel7.x86_64 zlib-1.2.7-18.el7.x86_64 (gdb) bt #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 0000001 0x000000000042eaeb in pool_process_query (frontend=0x1ae8568, backend=0x7f7390885418, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:274 0000002 0x0000000000428f39 in do_child (fds=fds@entry=0x1ae4810) at protocol/child.c:385 0000003 0x00000000004099e5 in fork_a_child (fds=0x1ae4810, id=251) at main/pgpool_main.c:610 0000004 0x000000000040a451 in reaper () at main/pgpool_main.c:2544 0000005 0x00000000004103cf in PgpoolMain (discard_status=discard_status@entry=0 '\000', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:439 0000006 0x000000000040807b in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:318 [New LWP 205380] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `pgpool: postgres SGDatabase 10.6.129.29(59824) id'. Program terminated with signal 11, Segmentation fault. #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 4590 num_fds = Max(CONNECTION(backend, i)->fd + 1, num_fds); Missing separate debuginfos, use: debuginfo-install audit-libs-2.8.4-4.el7.x86_64 cyrus-sasl-lib-2.1.26-23.el7.x86_64 glibc-2.17-260.el7_6.3.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-37.el7_6.x86_64 libcap-ng-0.7.5-4.el7.x86_64 libcom_err-1.42.9-13.el7.x86_64 libgcc-4.8.5-36.el7.x86_64 libmemcached-1.0.16-5.el7.x86_64 libselinux-2.5-14.1.el7.x86_64 libstdc++-4.8.5-36.el7.x86_64 nspr-4.19.0-1.el7_5.x86_64 nss-3.36.0-7.1.el7_6.x86_64 nss-softokn-freebl-3.36.0-5.el7_5.x86_64 nss-util-3.36.0-1.1.el7_6.x86_64 openldap-2.4.44-21.el7_6.x86_64 openssl-libs-1.0.2k-16.el7_6.1.x86_64 pam-1.1.8-22.el7.x86_64 pcre-8.32-17.el7.x86_64 postgresql96-libs-9.6.12-1PGDG.rhel7.x86_64 zlib-1.2.7-18.el7.x86_64 (gdb) bt #0 0x000000000042d827 in read_packets_and_process (frontend=frontend@entry=0x1ae8568, backend=backend@entry=0x7f7390885418, reset_request=reset_request@entry=0, state=state@entry=0x7ffda71552fc, num_fields=num_fields@entry=0x7ffda71552fa, cont=cont@entry=0x7ffda7155304 "\001") at protocol/pool_process_query.c:4590 0000001 0x000000000042eaeb in pool_process_query (frontend=0x1ae8568, backend=0x7f7390885418, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:274 0000002 0x0000000000428f39 in do_child (fds=fds@entry=0x1ae4810) at protocol/child.c:385 0000003 0x00000000004099e5 in fork_a_child (fds=0x1ae4810, id=4207) at main/pgpool_main.c:610 0000004 0x000000000040a451 in reaper () at main/pgpool_main.c:2544 0000005 0x00000000004103cf in PgpoolMain (discard_status=discard_status@entry=0 '\000', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:439 0000006 0x000000000040807b in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:318 |
|
|
We fixed DROP DATABASE failure. Could you try the following commit? https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=717a2c87f3e6b798a75b683aaa684e65f41a4960 |
|
|
No response. I am going to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-03-27 08:35 | cadams | New Issue | |
| 2019-03-27 08:35 | cadams | File Added: pgpool.conf.clt0 | |
| 2019-03-27 09:43 | pengbo | Note Added: 0002467 | |
| 2019-03-27 09:43 | pengbo | Assigned To | => pengbo |
| 2019-03-27 09:43 | pengbo | Status | new => assigned |
| 2019-03-27 09:43 | pengbo | Description Updated | |
| 2019-03-27 09:43 | pengbo | Steps to Reproduce Updated | |
| 2019-03-27 09:43 | pengbo | Additional Information Updated | |
| 2019-03-28 09:43 | cadams | Note Added: 0002472 | |
| 2019-03-28 09:45 | cadams | File Added: core.pgpool.0.xz.tar | |
| 2019-03-28 09:45 | cadams | Note Added: 0002473 | |
| 2019-03-29 22:52 | cadams | Note Added: 0002483 | |
| 2019-04-24 15:24 | pengbo | Note Added: 0002573 | |
| 2019-05-21 16:03 | administrator | Status | assigned => closed |
| 2019-05-21 16:07 | administrator | Assigned To | pengbo => t-ishii |
| 2019-05-21 16:07 | administrator | Fixed in Version | => 3.7.10 |
| 2019-05-21 16:07 | administrator | Note Added: 0002616 |
