Bug #74970 [NEW]: failed with 2002: Cannot assign requested address after 26 retries
From: spam2 at rhsoft dot net
Operating system: Linux
PHP version: 7.0.21
Package: MySQLi related
Bug Type: Bug
Bug description:failed with 2002: Cannot assign requested address after 26 retries
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 bug report at https://bugs.php.net/bug.php?id=74970&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74970&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74970&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74970&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=74970&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=74970&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=74970&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=74970&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=74970&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=74970&r=support
Expected behavior: https://bugs.php.net/fix.php?id=74970&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=74970&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=74970&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=74970&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74970&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=74970&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=74970&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=74970&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=74970&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=74970&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=74970&r=mysqlcfg
Thread (3 messages)
- spam2 at rhsoft dot net