PHP :: Bug #74091 :: stuck in poll

Bug #74091

stuck in poll

Submitted:

2017-02-13 09:20 UTC

Modified:

2021-10-24 04:22 UTC

Votes:	1
Avg. Score:	4.0 ± 0.0
Reproduced:	0 of 0 (0.0%)

From:

miha dot vrhovnik at naviter dot com

Assigned:

cmb (profile)

Status:

No Feedback

Package:

MySQLi related

PHP Version:

7.0.16RC1

OS:

ubuntu

Private report:

CVE-ID:

None

View Developer Edit

Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.

php.net Username: php.net Password:

Quick Fix:	(description)
	Block user comment
Status:		Assign to:
Package:
Bug Type:
Summary:
From:	miha dot vrhovnik at naviter dot com
New email:
PHP Version:		OS:

New/Additional 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

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports

[2017-10-24 04:30 UTC] kalle@php.net

-Package: mysqlnd_ms +Package: MySQLi related

[2021-10-14 11:45 UTC] cmb@php.net

-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb

[2021-10-14 11:45 UTC] 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>

[2021-10-24 04:22 UTC] php-bugs at lists dot php dot net

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.

	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-2024 The PHP Group All rights reserved.	Last updated: Sat Dec 21 15:01:29 2024 UTC