aborted_clients every 6 minutes [Case 81093]

jimlongo

• October 21, 2013 15:33

Hi, still trying to clean this up. The number of aborted clients is still relatively high (>10%) I've found that there is an aborted connection for 'root' every 6 minutes like so . . . 131021 16:14:00 [Warning] Aborted connection 1525 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error) 131021 16:20:09 [Warning] Aborted connection 1750 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error) 131021 16:26:20 [Warning] Aborted connection 1849 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error)
My timeout in my.cnf is set to 600 What I'm wondering if you have any idea what could be happening with such regularity? Of if there is a way I can track it down. I've tried watching mysql status, but it doesn't really give me any clue. Is there anything else I can look at? Thanks.

• 

  24x7server

  • October 22, 2013 04:16

  Hello, Can you please try to increase the wait_timeout value in you my.cnf file and check again.

  0
• 

  jimlongo

  • October 22, 2013 05:17

  Thanks, I increased the wait_timeout to 1200, the aborted_clients are still the same 6 minutes apart. 131022 0:58:53 [Warning] Aborted connection 31 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error) 131022 1:05:04 [Warning] Aborted connection 56 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error) 131022 1:11:11 [Warning] Aborted connection 80 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error) 131022 1:17:14 [Warning] Aborted connection 111 to db: 'mysql' user: 'root' host: 'localhost' (Unknown error)
  

  0
• 

  cPanelMichael

  • October 22, 2013 12:43

  Hello :) MySQL offers documentation on this specific error message. It's available at: MySQL 5.5 - Aborted Connections There are several potential causes/solutions listed on this page. Thank you.

  0
• 

  jimlongo

  • October 22, 2013 13:47

  Thanks, I enabled all the logs and if I match up by timestamp the aborted_client message from the error log with the query from the general log it gives me this query as the cause. 22 Connect root@localhost as anonymous on mysql 22 Query set sql_mode='' /* DISABLE ANSI_QUOTES and normalize */ 22 Query SELECT user FROM mysql.user WHERE user LIKE 'cpses_%'
  Can you identify what process is using that query?

  0
• 

  jimlongo

  • October 22, 2013 16:19

  From the cpanel error log there is this process which matches the timestamp of the aborted_client and query . . . [2013-10-22 12:13:06 -0400] info [cpses_tool] cleaning up orphened cpses_ users: Id: TQ:TaskQueue:3222
  I have no database user like cpses_% Is there a way to avoid this aborted_client?

  0
• 

  cPanelMichael

  • October 23, 2013 16:15

  I recommend opening a support ticket so we can take a closer look: Submit A Ticket You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  jimlongo

  • October 24, 2013 00:07

  Had to switch from MariaDB back to MySQL before support would look at this. Support Request Id 4377179

  0
• 

  jimlongo

  • October 24, 2013 22:23

  According to this support request, "This is related to a bug that's already been filed. The case number is 81093".

  0
• 

  cPanelMichael

  • October 25, 2013 14:41

  It's been determined this is a bug where cpses_tool does not properly disconnect from MySQL. For reference, the case number is 81093. You can monitor the change log for this case number to determine when a resolution is pushed out: cPanel Change Log Thank you.

  0
• 

  jimlongo

  • November 07, 2013 04:09

  This is fixed in 11.40.17 Fixed case 81093: cpses_tool is too verbose and does not properly disconnect from sql servers. Thank you.

  0

Please sign in to leave a comment.