php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: miha dot vrhovnik at naviter dot com
New email:
PHP Version: OS:

 

 [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 Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Tue Jun 25 07:01:26 2019 UTC