Edit report at https://bugs.php.net/bug.php?id=74091&edit=1
ID: 74091
Updated by: php-bugs@lists.php.net
Reported by: miha dot vrhovnik at naviter dot com
Summary: stuck in poll
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: MySQLi related
Operating System: ubuntu
PHP Version: 7.0.16RC1
Assigned To: cmb
Private report: N
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2021-10-14 11:45:49] cmb@php.net
Do you still experience this with any of the actively supported
PHP versions[1]?
[1] <https://www.php.net/supported-versions.php>
------------------------------------------------------------------------
[2017-02-13 09:20:51] 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
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=74091&edit=1