Bug #74970 [Fbk->NoF]: failed with 2002: Cannot assign requested address after 26 retries

From: Date: Sun, 03 Oct 2021 04:22:12 +0000
Subject: Bug #74970 [Fbk->NoF]: failed with 2002: Cannot assign requested address after 26 retries
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-236984@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=74970&edit=1

 ID:               74970
 Updated by:       php-bugs@lists.php.net
 Reported by:      spam2 at rhsoft dot net
 Summary:          failed with 2002: Cannot assign requested address
                   after 26 retries
-Status:           Feedback
+Status:           No Feedback
 Type:             Bug
 Package:          MySQLi related
 Operating System: Linux
 PHP Version:      7.0.21
 Assigned To:      cmb
 Private report:   N

 New Comment:

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.


Previous Comments:
------------------------------------------------------------------------
[2021-09-22 14:38:45] cmb@php.net

What is the actual bug that you are reporting?

------------------------------------------------------------------------
[2017-07-22 13:53:24] 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





------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=74970&edit=1

Thread (3 messages)

« previous php.bugs (#236984) next »