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
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: spam2 at rhsoft dot net
New email:
PHP Version: OS:

 

 [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: Sat Nov 18 15:03:12 2017 UTC