PHP :: Bug #74091 :: stuck in poll

Bug #74091
stuck in poll
Submitted:
2017-02-13 09:20 UTC
Modified:
2017-10-24 04:30 UTC
Votes:	1
Avg. Score:	4.0 ± 0.0
Reproduced:	0 of 0 (0.0%)
From:
miha dot vrhovnik at naviter dot com
Assigned:
Status:
Open
Package:
MySQLi related
PHP Version:
7.0.16RC1
OS:
ubuntu
Private report:
CVE-ID:
None
View Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From:	miha dot vrhovnik at naviter dot com
New email:
PHP Version:		OS:
New Comment:
[2017-02-13 09:20 UTC] miha dot vrhovnik at naviter dot com
Description:
------------
We are running the php-fpm server with a few wordpress sites it happens that under high IO all the processes get stuck. I've provided the backrace of one of them. The stack trace is the same just the query is different.

This is not new to 7.0.16 as the webserver previously run 7.0.13 I just tried with the latest to confirm.

 gdb -p 21386
GNU gdb (Ubuntu 7.11.1-0ubuntu1~16.04) 7.11.1
Copyright (C) 2016 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word".
Attaching to process 21386
Reading symbols from target:/usr/sbin/php-fpm7.0...Reading symbols from /usr/lib/debug/.build-id/8d/79afed0442f91f2ecb8ac532e54acf05353f62.debug...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libz.so.1...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libresolv.so.2...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libresolv-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libbz2.so.1.0...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/librt.so.1...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//librt-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libm.so.6...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libm-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libdl.so.2...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libdl-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libapparmor.so.1...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libsystemd.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libxml2.so.2...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libssl.so.1.0.0...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libcrypto.so.1.0.0...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libc.so.6...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libc-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libpthread.so.0...Reading symbols from /usr/lib/debug/.build-id/4d/7f52f335dc9665c2dcf308ce6514a6ae86dede.debug...done.
done.
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Reading symbols from target:/lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libselinux.so.1...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/liblzma.so.5...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libgcrypt.so.20...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libicuuc.so.55...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libpcre.so.3...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libgpg-error.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libicudata.so.55...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libstdc++.so.6...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libgcc_s.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/opcache.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/mysqlnd.so...Reading symbols from /usr/lib/debug/.build-id/27/4697b234f145ad15e0f8f78592c0b92bd7994f.debug...done.
done.
Reading symbols from target:/usr/lib/php/20151012/curl.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libcurl.so.4...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libidn.so.11...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/librtmp.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/liblber-2.4.so.2...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libgnutls.so.30...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libhogweed.so.4...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libnettle.so.6...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libgmp.so.10...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libkrb5.so.3...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libk5crypto.so.3...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libcom_err.so.2...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libkrb5support.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libsasl2.so.2...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libgssapi.so.3...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libp11-kit.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libtasn1.so.6...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libkeyutils.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libheimntlm.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libkrb5.so.26...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libasn1.so.8...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libhcrypto.so.4...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libroken.so.18...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libffi.so.6...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libwind.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libheimbase.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libhx509.so.5...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libsqlite3.so.0...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libcrypt.so.1...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libcrypt-2.23.so...done.
done.
Reading symbols from target:/usr/lib/php/20151012/fileinfo.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/gd.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libgd.so.3...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libXpm.so.4...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libjpeg.so.8...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libpng12.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libfreetype.so.6...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libfontconfig.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libvpx.so.3...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libtiff.so.5...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libX11.so.6...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libexpat.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libjbig.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libxcb.so.1...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libXau.so.6...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libXdmcp.so.6...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/intl.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libicui18n.so.55...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libicuio.so.55...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/mbstring.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/mysqli.so...Reading symbols from /usr/lib/debug/.build-id/4c/6bdc15d350a4b672ebef24a9b5a3cd45b6242f.debug...done.
done.
Reading symbols from target:/usr/lib/php/20151012/pdo_mysql.so...Reading symbols from /usr/lib/debug/.build-id/27/5e021c76fd7fe1d45a6f0b8a5701f4ae4328b4.debug...done.
done.
Reading symbols from target:/usr/lib/php/20151012/phar.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/readline.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libedit.so.2...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libtinfo.so.5...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libbsd.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/soap.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/xmlrpc.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libxmlrpc-epi.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/php/20151012/xsl.so...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libexslt.so.0...(no debugging symbols found)...done.
Reading symbols from target:/usr/lib/x86_64-linux-gnu/libxslt.so.1...(no debugging symbols found)...done.
Reading symbols from target:/lib/x86_64-linux-gnu/libnss_compat.so.2...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libnss_compat-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libnsl.so.1...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libnsl-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libnss_nis.so.2...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libnss_nis-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libnss_files.so.2...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libnss_files-2.23.so...done.
done.
Reading symbols from target:/lib/x86_64-linux-gnu/libnss_dns.so.2...Reading symbols from /usr/lib/debug/lib/x86_64-linux-gnu//libnss_dns-2.23.so...done.
done.
0x00007f10a3b54b5d in poll () at ../sysdeps/unix/syscall-template.S:84
84      ../sysdeps/unix/syscall-template.S: No such file or directory.
(gdb) bt
#0  0x00007f10a3b54b5d in poll () at ../sysdeps/unix/syscall-template.S:84
#1  0x0000000000653210 in poll (__timeout=<optimized out>, __nfds=1, __fds=0x7ffc6264c7b0) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46
#2  php_pollfd_for (timeouttv=0x1ee0d18, events=25, fd=<optimized out>) at /build/php7.0-7.0.16/main/php_network.h:177
#3  php_sock_stream_wait_for_data (stream=0x1ec55d0, sock=<optimized out>) at /build/php7.0-7.0.16/main/streams/xp_socket.c:138
#4  php_sockop_read (stream=0x1ec55d0,
    buf=0x1f0c074 "..cut.out..."..., count=38678) at /build/php7.0-7.0.16/main/streams/xp_socket.c:162
#5  0x000000000064735e in _php_stream_fill_read_buffer (stream=stream@entry=0x1ec55d0, size=size@entry=4) at /build/php7.0-7.0.16/main/streams/streams.c:675
#6  0x0000000000647487 in _php_stream_read (stream=stream@entry=0x1ec55d0, buf=buf@entry=0x7ffc6264c960 "", size=size@entry=4) at /build/php7.0-7.0.16/main/streams/streams.c:722
#7  0x00007f10a000a336 in php_mysqlnd_net_network_read_ex_pub (net=<optimized out>, buffer=<optimized out>, count=4, stats=0x1e87000, error_info=<optimized out>) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd_net.c:100
#8  0x00007f10a0009c86 in php_mysqlnd_net_receive_ex_pub (net=0x1ebbc60, buffer=0x7ffc6264c960 "", count=4, conn_stats=0x1e87000, error_info=0x1ed7828) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd_net.c:719
#9  0x00007f10a0002ffc in mysqlnd_read_header (net=0x1ebbc60, conn_stats=0x1e87000, error_info=<optimized out>, header=0x7f1091230c00, header=0x7f1091230c00) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd_wireprotocol.c:284
#10 0x00007f10a000624d in php_mysqlnd_rset_header_read (_packet=0x7f1091230c00, conn=0x1ed7700) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd_wireprotocol.c:1094
#11 0x00007f10a0010e41 in mysqlnd_query_read_result_set_header (conn=0x1ed7700, s=<optimized out>) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd_result.c:422
#12 0x00007f109fff9203 in php_mysqlnd_conn_data_reap_query_pub (conn=0x1ed7700, type=<optimized out>) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd.c:1259
#13 0x00007f109fffd29f in php_mysqlnd_conn_data_query_pub (conn=0x1ed7700, query=0x7f10915d7d38 "DELETE\n        FROM wp_wprc_cached_requests", query_len=43) at /build/php7.0-7.0.16/ext/mysqlnd/mysqlnd.c:1202
#14 0x00007f10981bdc59 in zif_mysqli_query (execute_data=<optimized out>, return_value=0x7f10a0613f30) at /build/php7.0-7.0.16/ext/mysqli/mysqli_nonapi.c:593
#15 0x00000000006df79d in ZEND_DO_ICALL_SPEC_HANDLER () at /build/php7.0-7.0.16/Zend/zend_vm_execute.h:586
#16 0x00000000006d094b in execute_ex (ex=<optimized out>) at /build/php7.0-7.0.16/Zend/zend_vm_execute.h:414
#17 0x0000000000724e77 in zend_execute (op_array=0x7f10a06780e0, op_array@entry=0x7f1096468c30, return_value=return_value@entry=0x7f10a0613ec0) at /build/php7.0-7.0.16/Zend/zend_vm_execute.h:458
#18 0x00000000006904c3 in zend_execute_scripts (type=type@entry=8, retval=0x7f10a0613ec0, retval@entry=0x0, file_count=file_count@entry=3) at /build/php7.0-7.0.16/Zend/zend.c:1442
#19 0x000000000062ff60 in php_execute_script (primary_file=primary_file@entry=0x7ffc6264f150) at /build/php7.0-7.0.16/main/main.c:2492
#20 0x000000000045ae44 in main (argc=<optimized out>, argv=<optimized out>) at /build/php7.0-7.0.16/sapi/fpm/fpm/fpm_main.c:1967

Actual result:
--------------
All processes are stuck at the poll
Patches

Add a Patch
Pull Requests

Add a Pull Request
History

AllCommentsChangesGit/SVN commitsRelated reports
[2017-10-24 04:30 UTC] kalle@php.net
-Package: mysqlnd_ms +Package: MySQLi related
	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for

Copyright © 2001-2021 The PHP Group All rights reserved.	Last updated: Thu Jan 28 15:01:24 2021 UTC