Bug #82052 [Warning] Event 'MYSQL_AUDIT_CONNECTION_DISCONNECT' cannot be aborted.
Submitted: 29 Jun 2016 14:07 Modified: 16 Nov 2016 16:48
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Security: Audit Severity:S3 (Non-critical)
Version:5.7.13 OS:Any
Assigned to: CPU Architecture:Any
Tags: audit log, thread pool

[29 Jun 2016 14:07] Shane Bester
Description:
When audit log plugin and thread pool plugin are enabled, and a connection gets terminated via wait_timeout/interactive_timeout, the error log is spammed:

 14 [Warning] Event 'MYSQL_AUDIT_CONNECTION_DISCONNECT' cannot be aborted.
 15 [Warning] Event 'MYSQL_AUDIT_CONNECTION_DISCONNECT' cannot be aborted.
 16 [Warning] Event 'MYSQL_AUDIT_CONNECTION_DISCONNECT' cannot be aborted.

In was only connecting like this;

mysql> \r
Connection id:    15
Current database: mysql

mysql> \r
Connection id:    16
Current database: mysql

How to repeat:
start server with --plugin-load-add=thread_pool.so --plugin-load-add=audit_log.so --wait-timeout=1 --interactive-timeout=1 and connect to server
[29 Jun 2016 14:09] Shane Bester
To repeat it: make sure the "new style" audit log plugin is used, so install it via the audit_log_filter_linux_install.sql first.
[16 Nov 2016 16:48] Paul Dubois
Posted by developer:
 
Noted in 5.7.17, 8.0.1 changelogs.

Infinite recursion could occur if the audit_log plugin signalled an
error while handling an error.