Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.
Course Of The Month
7 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
- Software-Other
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona, *Monitoring tool
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Suggested Courses
Course of the Month7 days, 5 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.