<div>
<div class="content wysiwyg-content">
I'm trying to figure out what this error is that I've found in my httpd error_log file. &nbsp;Sometimes the site shows as not available and tracked it down to this error in the error_log:<br />
<br />
&nbsp;PHP Fatal error: &nbsp;Uncaught Exception: SQLSTATE[HY000] [2002] Cannot assign requested address in ....<br />
<br />
I'm not sure what this means, but I see that I have about 20k open when I run this command: &nbsp;netstat -anlp | grep :3306 | grep TIME_WAIT -wc<br />
<br />
I tried shortening from 60 sec to 3 sec and no change in the connections: <br />
echo &quot;3&quot; &gt;&nbsp;/proc/sys/net/ipv4/tcp_fin<wbr />_timeout<br />
<br />
Is that my issue, connections are not closing out quickly enough?
</div>
</div>


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?

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

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.