?
Solved

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

Posted on 2016-09-29
1
Medium Priority
?
1,541 Views
Last Modified: 2016-10-05
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?
0
Comment
Question by:Nathan Riley
1 Comment
 
LVL 81

Accepted Solution

by:
arnold earned 2000 total points
ID: 41822848
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?
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written articles previously comparing SARDU and YUMI.  I also included a couple of lines about Easy2boot (easy2boot.com).  I have now been using, and enjoying easy2boot as my sole multiboot utility for some years and realize that it deserves …
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question