aborted_clients every 6 minutes [Case 81093]

[jimlongo]

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]

Hello,

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

 

[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)

 

[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.

 

[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   [email protected] 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?

 

[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?

 

[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.

 

[jimlongo]

Had to switch from MariaDB back to MySQL before support would look at this.

Support Request Id 4377179

 

[jimlongo]

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

 

[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.

 

[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.