aborted_clients every 6 minutes [Case 81093]

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

Code:

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.

 

Thanks,

I increased the wait_timeout to 1200, the aborted_clients are still the same 6 minutes apart.

Code:

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)

 

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.

Code:

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?

 

From the cpanel error log there is this process which matches the timestamp of the aborted_client and query . . .

Code:

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

 

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

Support Request Id 4377179

 

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

 

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.