php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #74970 failed with 2002: Cannot assign requested address after 26 retries
Submitted: 2017-07-22 13:53 UTC Modified: 2021-10-03 04:22 UTC
Votes:3
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: cmb (profile)
Status: No Feedback Package: MySQLi related
PHP Version: 7.0.21 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
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

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2021-09-22 14:38 UTC] cmb@php.net
-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb
 [2021-09-22 14:38 UTC] cmb@php.net 
What is the actual bug that you are reporting?
 [2021-10-03 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 Copyright © 2001-2023 The PHP Group
All rights reserved. 		Last updated: Fri Sep 22 04:01:25 2023 UTC