Aborted_Connects Increasing – Causing High Percentage Of Refused Conne

[peterlaursen]

Please tell: what is the 'wait_timeout' setting on this server (execute “SHOW GLOBAL VARIABLES LIKE 'wait_timeout';”), and what is the sample interval setting in MONyog.

MONyog uses persistent connection to MySQL but If sample interval is larger than 'wait_timeout' the server will disconnect MONyog after 'wait_timeout' idle seconds. MONyog will then reconnect automatically next time it queries the server.

'wait_timeout' has a default setting of 28800 (seconds = 8 hours) in MySQL, but this server may have set a lower value. Now say it is set to “120” (= 2 minutes) and sample interval in MONyog is 5 minutes, MONyog will be disconnected 2 minutes after it has retrieved data from the server last time. And each time the server increments aborted_connects.

[paulohm1]

Thank you for the response. However, my wait_timeout is set to the default of 28800 seconds.

The only other timeouts I have explicitly set in my.cnf are:

slave_net_timeout=60 and innodb_lock_wait_timeout=50

Could either of these cause the same issue?

[paulohm1]

Also, my collection interval in MONYog is 2 minutes.

I also have sniffing enabled which “sniffs” every 2 seconds.

[paulohm1]

I always see connections from monyog in the “processlist” page that have a “command” of “sleep” and a “DB” of “NULL”.

If monyog is using persistent connections and correctly closing those connections, why are some of these connections left open in the “sleep” state?

I have attached an image of one such entry in the processlist page of monyog.

[paulohm1]

I believe we have found that the cause of these aborted_connects is a load balancer in our environment which does a check of the tcp port (3306) on a regular basis. I will post back if I find otherwise.

[mattjulich]

Hi Paul,

I'm running into a similar issue, numerous aborted connections behind an F5 load balancer. Mine seem to actually make connections to the db, then are aborted, then remade, than aborted, then remade, all without interaction from a user. Was there any specific setting you've found on your load balancer to tweak to halt that behavior, tweaks to the tcp port healthcheck?

Thanks

[jjekabsons]

Hi all,

we have the same problem here.

Every time we use the process list we got every second a new entry in error-log:

[Warning] Aborted connection XXXX to db: 'unconnected' user: 'root' host: 'XXX.XXX.XXX.XXX' (Got an error reading communication packets)

– All timeouts are long enough.

– There are no load balancers or something else who can cause this issue.

Can someone help please.

Thanks

[Mahesh]

Make sure that MySQL server detail entered is correct, also are you getting this error only on PROCESSLIST page?

You can go through this link wherein causes of communication errors has been mentioned http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html

[jjekabsons]

The abort warning is only when I open the Processlist in MONyog, then every second I get a new warning.

And its only from MONyog, no other program or user works on that server.

I have checked all from your posted link and everything looks good.

Also the configuration for that server in MONyog is ok.

[Mike Coulten]

Hi, I am debugging similar errors on my mySQL 5.5 on RedHat linux servers

130807 22:44:32 [Warning] Aborted connection 8026 to db: 'ENERGYALERT' user: 'FLCF' host: '192.168.100.12' (Got an error reading communication packets)

We get these errors intermittently and often we get a group of connections all aborting i.e. all of our Matlab (JDBC) connections but all other connections are unaffected. We can simulate these disconnects by rebooting the server the client is on but logs show no reboots or users online at the time of the disconnects being investigated.

I dont think its MoNyog related but reading this ticket we will be turning off MoNyog monitoring on one db to test if it is

[Author]

Posts