Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Aborted_Connects Increasing – Causing High Percentage Of Refused Conne

forums forums Monyog Using Monyog Aborted_Connects Increasing – Causing High Percentage Of Refused Conne

  • This topic is empty.
Viewing 9 reply threads
  • Author
    Posts
    • #34162
      peterlaursen
      Participant

      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.

    • #34163
      paulohm1
      Member

      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?

    • #34164
      paulohm1
      Member

      Also, my collection interval in MONYog is 2 minutes.

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

    • #34165
      paulohm1
      Member

      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.

    • #34166
      paulohm1
      Member

      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.

    • #34167
      mattjulich
      Member

      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

    • #34168
      jjekabsons
      Member

      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

    • #34169
      Mahesh
      Member

      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

    • #34170
      jjekabsons
      Member

      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.

    • #34171
      Mike Coulten
      Member

      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

Viewing 9 reply threads
  • You must be logged in to reply to this topic.