Audit Log Filtering UDF Statements May Hang Indefinately (Doc ID 2170708.1)

Last updated on AUGUST 10, 2016

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

 When attempting to create audit filters or set filters for users,  the commands hang forever, like this :

 

Changes

One possible change is that you are running the audit_log_filter_set_filter UDF on a slave,  and it previously worked on the master server.

Another cause is that you're running the UDF's while "FLUSH TABLES WITH READ LOCK" is enabled,  are the mysql.audit_log_filter and/or mysql.audit_log_user tables are locked by another session.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms