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)
• Status: Closed
• Category: MySQL Server: Security: Audit
• Severity: S3 (Non-critical)
• Version: 5.7.13
• OS: Any
• 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] MySQL Verification Team

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.