9

In TCP servers, I understand that a Connection Refused would either be because the

  1. The process stopped listening, by calling close on the server-socket (existing connections stay open, and new connections are refused), or
  2. The process ended, or
  3. The process did not accept connections frequently enough, so the backlog became full / the backlog was too small.

What are the possible causes of ECONNREFUSED when attempting to connect to UNIX Domain Sockets.

This question is to help me narrow down a MySQL connection mystery on a Solaris 10 configuration.

Community
  • 1
  • 1
700 Software
  • 85,281
  • 83
  • 234
  • 341

1 Answers1

-3

Connection refused does NOT mean the server closed the socket (after you connected to it), it means there is no server listening on the socket. So, first, your server crashes, THEN, clients get a connection refused. (Except if the backlog becomes full, if the backlog size you pass to listen() is too small, or your server doesn't accept() connections fast enough, but i've never seen that in real life situations).

Normally, i'd blame it on some firewall, but, since, in your other post, you say it happens only intermittently, i guess what happens is: your mysql server crashes, safe_mysqld restarts it, which takes a few seconds, and during that startup phase, you get your connection refused errors because there's no server there to listen to you. Try setting up a cron job that does "ps -ef | grep mysqld" every minute, check if the process id changes from time to time, and try to match these changes to your connection refused error messages.

If mysqld does NOT restart, i.e. the process ID remains the same, try something like "truss -v listen,accept -p ". This should give you some output every time a client connects - maybe you can match "lots of things going on in truss" to "i get connection refused now". But, don't do this on a heavily loaded production system, or truss will a) drown you in output and b) slow down your server significantly.

Guntram Blohm
  • 9,667
  • 2
  • 24
  • 31
  • Please see my edit, **I clarified item 1. Item 1 is valid.** Please see my edit in my other post. `mysqld` **does not crash**, and `mysqld_safe` **does not restart** `mysqld`. This is not a question about MySQL really, it is a question about possible causes of `ECONNREFUSED`. You can't blame a firewall because this is a **UNIX Domain Socket** question. Using `truss` may be helpful, possibly. I'll see if I can schedule a task to work on that. – 700 Software Dec 06 '13 at 16:48