We help IT Professionals succeed at work.
Get Started
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
Is that my issue, connections are not closing out quickly enough?
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
Is that my issue, connections are not closing out quickly enough?
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE