Bug #74091 [Opn->Fbk]: stuck in poll

Edit report at https://bugs.php.net/bug.php?id=74091&edit=1 ID: 74091 Updated by: cmb@php.net Reported by: miha dot vrhovnik at naviter dot com Summary: stuck in poll -Status: Open +Status: Feedback Type: Bug Package: MySQLi related Operating System: ubuntu PHP Version: 7.0.16RC1 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: Do you still experience this with any of the actively supported PHP versions[1]? [1] <https://www.php.net/supported-versions.php> Previous Comments: ------------------------------------------------------------------------ [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