Bug #72372 [NEW]: Eventual connectivity error
| From: | gohanman at gmail dot com | Date: | Thu, 09 Jun 2016 19:38:29 +0000 |
| Subject: | Bug #72372 [NEW]: Eventual connectivity error | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-201506@lists.php.net to get a copy of this message | ||
From: gohanman at gmail dot com
Operating system: Windows 10
PHP version: 7.0.7
Package: MySQLi related
Bug Type: Bug
Bug description:Eventual connectivity error
Description:
------------
I don't have any kind of simple repro for this, unfortunately. I'm
trying to upgrade an app from 5.6 to 7.0. The app works fine in 7.0 for
some period of time and then every single mysqli connection attempt
starts failing with this error:
Warning: mysqli::mysqli(): (HY000/2002): An operation on a socket could
not be performed because the system lacked sufficient buffer space or
because a queue was full.
As far as I can tell this is the result of the OS itself running out of
memory for TCP buffers
(https://blogs.msdn.microsoft.com/sql_protocols/2009/03/09/understanding-the-error-an-operation-on-a-socket-could-not-be-performed-because-the-system-lacked-sufficient-buffer-space-or-because-a-queue-was-full/).
I'm not using either of the ini switches mention in the Microsoft
article. This problem does not occur using 5.6 with the same app on the
same system.
I'm seeing this issue with exactly one client browser executing PHP
scripts via HTTP requests. Closing the client browser and waiting for
several minutes does not seem to release any resources. Once the error
occurs it continues to occur on every connection attempt until Apache is
restarted.
I'm using the 32bit, thread-safe 7.0.7 build from windows.php.net with
32-bit apache 2.4.20 binaries from Apache Lounge.
Besides mysqli, I'm enabling php_opcache as well as these extensions:
curl, gettext, intl, mbstring, openssl, sockets, xsl.
--
Edit bug report at https://bugs.php.net/bug.php?id=72372&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=72372&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=72372&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=72372&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=72372&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=72372&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=72372&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=72372&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=72372&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=72372&r=support
Expected behavior: https://bugs.php.net/fix.php?id=72372&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=72372&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=72372&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=72372&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=72372&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=72372&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=72372&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=72372&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=72372&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=72372&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=72372&r=mysqlcfg