Skip to main content
cPanel Technical Support has been heavily impacted by hurricane Beryl and our ability to respond to tickets has been hindered as a result. We appreciate your understanding and patience as we address these delays.

aborted_clients every 6 minutes [Case 81093]

Comments

10 comments

  • 24x7server
    Hello, Can you please try to increase the wait_timeout value in you my.cnf file and check again.
    0
  • jimlongo
    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
    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
    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
    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
    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
    Had to switch from MariaDB back to MySQL before support would look at this. Support Request Id 4377179
    0
  • jimlongo
    According to this support request, "This is related to a bug that's already been filed. The case number is 81093".
    0
  • cPanelMichael
    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
    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.