Solved

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

Posted on 2016-09-29
1
563 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:N R
1 Comment
 
LVL 78

Accepted Solution

by:
arnold earned 500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article discusses four methods for overlaying images in a container on a web page
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to dynamically set the form action using jQuery.
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.

685 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