php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #74970 failed with 2002: Cannot assign requested address after 26 retries
Submitted: 2017-07-22 13:53 UTC Modified: -
From: spam2 at rhsoft dot net Assigned:
Status: Open Package: MySQLi related
PHP Version: 7.0.21 OS: Linux
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2017-07-22 13:53 UTC] spam2 at rhsoft dot net
Description:
------------
Hi

i start with the most likely solution: http://www.unixguide.net/network/socketfaq/4.5.shtml

yesterday i implemented read/write split into our CMS which works basically but due a benchmark pretty fast such errors starting to flood the log after around 50000-100000 requests with http keep alive (ab -c 250 -n 500000 -k http://application/) which sounds like the machine is running out of ports

[21-Jul-2017 19:11:38 Europe/Vienna] DATABASE-ERROR: corecms/show_content.php - /thelounge.net/corecms/config.inc.php line 659 (parent call: /thelounge.net/corecms/show_content.php on line 17): connection to '*****:3307:corecms' for user 'corecms' failed with 2002: Cannot assign requested address after 26 retries

the only workaround is persistent connections but besides https://bugs.php.net/bug.php?id=74967 is breaking the application sooner or later that don't scale when you have hunredts of workers shared between different users because ou end in number-of-user*worker-count connections




Patches

Add a Patch

Pull Requests

Add a Pull Request

 
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Sun Nov 19 01:31:42 2017 UTC