CREATE TABLE t1(a int);
# restart: --log-error=LOG_FILE1 --log-error-verbosity=1 --binlog-format=statement
INSERT INTO t1 SELECT FOUND_ROWS();
Warnings:
Warning	1287	FOUND_ROWS() is deprecated and will be removed in a future release. Consider using COUNT(*) instead.
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
# restart: --log-error=LOG_FILE2 --log-error-verbosity=2 --binlog-format=statement
INSERT INTO t1 SELECT FOUND_ROWS();
Warnings:
Warning	1287	FOUND_ROWS() is deprecated and will be removed in a future release. Consider using COUNT(*) instead.
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
# restart: --log-error=LOG_FILE3 --log-error-verbosity=3 --binlog-format=statement
INSERT INTO t1 SELECT FOUND_ROWS();
Warnings:
Warning	1287	FOUND_ROWS() is deprecated and will be removed in a future release. Consider using COUNT(*) instead.
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
DROP TABLE t1;
# restart: --log-error=LOG_FILE8 --lc-messages-dir=MSG_DIR --log-error-verbosity=3
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
# restart: --log-error=LOG_FILE8B --lc-messages=invalid_arg1 --lc-time-names=invalid_arg2
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
# restart: --log-error=LOG_FILE9 --log-error-verbosity=3 --log-error-services=abcd 
SELECT @@GLOBAL.LOG_ERROR_SERVICES;
@@GLOBAL.LOG_ERROR_SERVICES
log_filter_internal; log_sink_internal
SET GLOBAL LOG_ERROR_SERVICES=@@GLOBAL.LOG_ERROR_SERVICES;
Pattern "\[Warning\].*Cannot set services "abcd" requested in --log-error-services, using defaults" found
# restart: --log-error=LOG_FILE10 --log-error-verbosity=3 --log-error-services=log_sink_json 
Pattern "\[Warning\].*Cannot set services "log_sink_json" requested in --log-error-services, using defaults" found
INSTALL COMPONENT "file://component_log_sink_json";
# restart: --no-console --log-error=LOG_FILE11 --log-error-services=log_filter_internal;log_sink_internal;log_sink_json --log-error-verbosity=3
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
SET GLOBAL log_error_services= default;
UNINSTALL COMPONENT "file://component_log_sink_json";
Pattern "\[ERROR\].*unknown variable 'dragnet.log_error_filter_rules=a'" found
INSTALL COMPONENT "file://component_log_filter_dragnet";
# restart: --no-console --log-error=LOG_FILE13 --log-error-services=log_filter_internal;log_filter_dragnet;log_sink_internal --dragnet.log-error-filter-rules=
SELECT @@log_error_services;
@@log_error_services
log_filter_internal;log_filter_dragnet;log_sink_internal
SELECT @@dragnet.log_error_filter_rules;
@@dragnet.log_error_filter_rules

SET @saved_log_error_verbosity= @@global.log_error_verbosity;
SET GLOBAL log_error_verbosity= 3;
SET GLOBAL dragnet.log_error_filter_rules="IF err_code==ER_ACCESS_DENIED_ERROR_WITH_PASSWORD THEN throttle 3/3600.";
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
connect(localhost,unknown_user,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user'@'localhost' (using password: NO)
SET GLOBAL log_error_verbosity= @saved_log_error_verbosity;
SET PERSIST dragnet.log_error_filter_rules= "IF prio>INFORMATION THEN drop.";
# restart: --no-console --log-error=LOG_FILE14 --log-error-services=log_filter_internal;log_filter_dragnet;log_sink_internal 
SELECT @@global.dragnet.log_error_filter_rules;
@@global.dragnet.log_error_filter_rules
IF prio>INFORMATION THEN drop.
RESET PERSIST `dragnet.log_error_filter_rules`;
SET GLOBAL log_error_services= default;
UNINSTALL COMPONENT "file://component_log_filter_dragnet";
INSTALL COMPONENT "file://component_log_filter_dragnet";
# restart: --no-console --log-error=LOG_FILE15 --dragnet.log_error_filter_rules=invalid
SELECT @@global.dragnet.log_error_filter_rules;
@@global.dragnet.log_error_filter_rules
IF prio>=INFORMATION THEN drop. IF EXISTS source_line THEN unset source_line.
UNINSTALL COMPONENT "file://component_log_filter_dragnet";
# restart: --no-console --log-error=LOG_FILE16 --log-error-suppression-list=ER_ACCESS_DENIED_ERROR_WITH_PASSWORD 
SELECT @@global.log_error_suppression_list;
@@global.log_error_suppression_list
ER_ACCESS_DENIED_ERROR_WITH_PASSWORD
SET @saved_log_error_verbosity= @@global.log_error_verbosity;
SET GLOBAL log_error_verbosity= 3;
connect(localhost,unknown_user_filtered,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user_filtered'@'localhost' (using password: NO)
SET @@global.log_error_suppression_list="";
SELECT @@global.log_error_suppression_list;
@@global.log_error_suppression_list

connect(localhost,unknown_user_unfiltered,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'unknown_user_unfiltered'@'localhost' (using password: NO)
SET GLOBAL log_error_verbosity= @saved_log_error_verbosity;
SET @@global.log_error_suppression_list=DEFAULT;
SET PERSIST log_error_suppression_list= "MY-10000";
# restart: --no-console --log-error=LOG_FILE17 
SELECT @@global.log_error_suppression_list;
@@global.log_error_suppression_list
MY-10000
RESET PERSIST `log_error_suppression_list`;
SET GLOBAL log_error_suppression_list= DEFAULT;
SET GLOBAL log_error_services= DEFAULT;
# restart: --no-console --log-error=LOG_FILE18 --log_error_suppression_list=invalid
SELECT @@global.log_error_suppression_list;
@@global.log_error_suppression_list

Pattern "log_error_suppression_list: Could not add suppression rule for code .invalid." found
INSTALL COMPONENT "file://component_log_sink_json";
INSTALL COMPONENT "file://component_log_filter_dragnet";
SET PERSIST dragnet.log_error_filter_rules="IF EXISTS msg THEN drop.";
# restart: --log-error-services=log_filter_dragnet;log_sink_json --log-error=LOG_FILE19
# JSON error log content - begin
# JSON error log content - end
RESET PERSIST `dragnet.log_error_filter_rules`;
SET GLOBAL log_error_services= DEFAULT;
UNINSTALL COMPONENT "file://component_log_sink_json";
UNINSTALL COMPONENT "file://component_log_filter_dragnet";

Reading error logs for validation
---------------------------------
[ PASS ] Error log does not contain WARNING's/NOTE's with --log-error-verbosity=1
[ PASS ] Error log does not contain NOTE's with --log-error-verbosity=2
[ PASS ] Error log contains NOTE's & WARNING's with --log-error-verbosity=3
[ PASS ] Error log does not contain NOTE's or WARNING's with --log-error-verbosity=-1 (adjusted to 1) during initialization
[ PASS ] Error log does not contain WARNING's/NOTE's with --log-error-verbosity=1  during initialization
[ PASS ] Error log does not contain NOTE's with --log-error-verbosity=2  during initialization
[ PASS ] Error log contains NOTE's with --log-error-verbosity=7 (adjusted to 3) during initialization.
[ PASS ] Error log contains a NOTE with compiled-in message 'Access denied' when lc_messages_dir does not contain error messages
[ PASS ] Error log successfully parsed as a json document
[ PASS ] Expected entry found in the json error log: ER_STARTING_AS
[ PASS ] Expected entry found in the json error log: Access denied for user 'unknown_user'@'localhost' (using password: NO)
[ PASS ] Error log messages throttled at three for 'Access denied' messages
[ PASS ] 'Access denied' messages filtered as per suppression list
[ PASS ] 'Access denied' messages not filtered, as per suppression list.