Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can someone help me with this error?

[08-Apr-2013 17:44:08 Europe/Berlin] PHP Warning:  PDO::__construct(): [2002]
    Cannot assign requested address (trying to connect via tcp://****:3306) in 
[08-Apr-2013 17:44:08 Europe/Berlin] PHP Fatal error:  Uncaught exception 
    'PDOException' with message 'SQLSTATE[HY000] [2002] Cannot assign requested 
    address' in /var/www/***

I have a Server with a lot connections per second; out of about 100 Connections, a single one got this error.

I've tried this recommendation from stackoverflow however it does not solve my problem.

share|improve this question
See the following link which might help:… – Gary Apr 12 '13 at 18:06

You could also be hitting max open files (sockets) under Linux. You can change this in /etc/security/limits.conf.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.