Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Learn how Concerto can help you.
Solved
PHP Fatal error: Uncaught Exception: SQLSTATE[HY000] [2002] Cannot assign requested address in
Posted on 2016-09-29
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Active today
Check your code to make sure that you do not leave open connections.
Check variables to see what is the max connection ...... Allowed....
The information in your question provides no other insight,
Does your php code test for the existence of an existing connection before opening a new one?
Check variables to see what is the max connection ...... Allowed....
The information in your question provides no other insight,
Does your php code test for the existence of an existing connection before opening a new one?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
- Server Hardware
- IT Administration
- Disaster Recovery
- Storage Software
- Databases
- Storage Hardware, MySQL Server, Hardware, Percona, *Backups
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing.
Set up your basic HTML file. Open your form tag and set the method and action attributes.:
(CODE)
Set up your first few inputs one for the name and …
Suggested Courses
Course of the Month10 days, 14 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.