Avatar of Nathan Riley
Nathan Riley
Flag for United States of America

asked on 

PHP Fatal error: Uncaught Exception: SQLSTATE[HY000] [2002] Cannot assign requested address in

I'm trying to figure out what this error is that I've found in my httpd error_log file.  Sometimes the site shows as not available and tracked it down to this error in the error_log:

 PHP Fatal error:  Uncaught Exception: SQLSTATE[HY000] [2002] Cannot assign requested address in ....

I'm not sure what this means, but I see that I have about 20k open when I run this command:  netstat -anlp | grep :3306 | grep TIME_WAIT -wc

I tried shortening from 60 sec to 3 sec and no change in the connections:
echo "3" > /proc/sys/net/ipv4/tcp_fin_timeout

Is that my issue, connections are not closing out quickly enough?
PHPMySQL ServerAWSLinux

Avatar of undefined
Last Comment
arnold

8/22/2022 - Mon