|  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: -
Avg. Score:4.0 ± 0.8
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:2 (100.0%)
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.
Block user comment
Status: Assign to:
Bug Type:
From: spam2 at rhsoft dot net
New email:
PHP Version: OS:


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

i start with the most likely solution:

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 - / line 659 (parent call: / 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 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


Add a Patch

Pull Requests

Add a Pull Request

PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sat Jul 24 04:01:23 2021 UTC