WL#11627: MTR: Review the general warning patterns in mtr_warnings.sql file

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

When a test run is completed, MTR checks the error log for any additional 
warnings generated by the test. If it finds any, the test run will be reported as 
failure.

There are few warnings which are expected without signifying a real problem or 
many tests are written to generate such warnings.

In order to avoid failure of such tests, MTR has a list of global suppression 
warning patterns. These patterns are listed in "mysql-
test/include/mtr_warnings.sql" file. Any warning generated by a test matches one 
of these patterns will be ignored by MTR.

However, it's not recommended add a new pattern directly to this file, since 
this pattern will be ignored for all the tests. If there is a test specific 
warning which needs to be suppressed, then it is recommended to add the pattern 
using mtr.add_suppression("pattern") procedure within the test file.

This worklog is to review some warnings present in "mysql-
test/include/mtr_warnings.sql" and may be cleanup/remove the patterns if they 
are needed by very less number of tests and move them to the corresponding MTR 
tests.
FR1) Cleanup/remove patterns from "mysql-
test/include/mtr_warnings.sql" file if they are needed by very less number of 
tests and move them to the corresponding MTR tests.

FR2) Remove obsolete warnings/patterns from "mysql-test/include/mtr_warnings.sql" 
file.
This worklog results in no user-visible changes.
This worklog is to review the following warnings in "mysql-
test/include/mtr_warnings.sql" and cleanup/remove the patterns if they 
are needed by very less number of tests and move them to the corresponding MTR 
tests:

Warnings:
(".SELECT UNIX_TIMESTAMP... failed on master"),
 ("Aborted connection"),
 
 ("Could not find first log file name in binary log"),
 ("Enabling keys got errno"),
 
 ("Error reading packet"),
 ("Event Scheduler"),
 ("Failed to open log"),
 ("Failed to open the existing master info file"),
 ("Forcing shutdown of [0-9]* plugins"),
 ("Forcing close of thread"),
 ("innodb-page-size has been changed"),

("Got error [0-9]* when reading table"),
 ("Incorrect definition of table"),
 ("Incorrect information in file"),
 ("InnoDB: Warning: we did not need to do crash recovery"),
 ("Invalid \\(old\\?\\) table or database name"),
 ("Lock wait timeout exceeded"),

("unknown option '--loose-"),
 ("unknown variable 'loose-"),
 ("You have forced lower_case_table_names to 0 through a command-line option"),
 ("Setting lower_case_table_names=2"),
 ("NDB Binlog:"),
 ("NDB: failed to setup table"),
 ("NDB: only row based binary logging"),
 ("Query partially completed"),
 
 ("Sort aborted"),
 ("Warning:\s+One can only use the --user.*root"),
 ("Warning:\s+Table:.* on (delete|rename)"),

("InnoDB: Error: in ALTER TABLE `test`.`t[123]`"),
 ("InnoDB: Error: in RENAME TABLE table `test`.`t1`"),
 ("InnoDB: Error: table `test`.`t[123]` does not exist in the InnoDB internal"),
("InnoDB: Option innodb_dedicated_server is ignored"),

 ("setrlimit could not change the size of core files to 'infinity'"),

("No existing UUID has been found, so we assume that this is the first time that
this server has been started.*"),
("TIMESTAMP with implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation for more
details)*"),
 ("'NO_AUTO_CREATE_USER' sql mode was not set."),

("Although a path was specified for the --general-log-file option, log tables
are used"),
 ("Although a path was specified for the --slow-query-log-file option, log
tables are used"),
 ("Backup: Operation aborted"),
 ("Restore: Operation aborted"),
 ("Restore: The grant .* was skipped because the user does not exist"),
 ("The path specified for the variable .* is not a directory or cannot be
written:"),

("Changed limits: max_open_files: *"),
 ("Changed limits: max_connections: *"),
 ("Changed limits: table_open_cache: *"),
 ("Could not increase number of max_open_files to more than *"),

("CA certificate .* is self signed"),

("Insecure configuration for --secure-file-priv:*"),

 ("Insecure configuration for --pid-file:*"),
 ("Few location(s) are inaccessible while checking PID filepath"),

 ("Plugin mysqlx reported: 'Unable to use user mysql.session account when 
connecting the server for internal plugin requests.'"),
 ("Plugin mysqlx reported: 'Failed at SSL configuration: \"SSL_CTX_new 
failed\""),
 ("Plugin mysqlx reported: 'Could not open"),
 ("Plugin mysqlx reported: 'All I/O interfaces are disabled"),
 ("Plugin mysqlx reported: 'Failed at SSL configuration: \"SSL context is not 
usable without certificate and private key\"'"),
Following warnings were removed from mysql-test/include/mtr_warnings.sql:
(".SELECT UNIX_TIMESTAMP... failed on master"),
("Aborted connection"), 
("Could not find first log file name in binary log"),
("Enabling keys got errno"),
("Failed to open log"),
("Failed to open the existing master info file"),
("Forcing shutdown of [0-9]* plugins"),
("Incorrect definition of table"),
("Incorrect information in file"),
("InnoDB: Warning: we did not need to do crash recovery"),
("Invalid \\(old\\?\\) table or database name"),
("You have forced lower_case_table_names to 0 through a command-line option"), 
("NDB: failed to setup table"),
("NDB: only row based binary logging"),
("Sort aborted"),
("Warning:\s+One can only use the --user.*root"),
("Warning:\s+Table:.* on (delete|rename)"),
("InnoDB: Error: in ALTER TABLE `test`.`t[123]`"),
("InnoDB: Error: in RENAME TABLE table `test`.`t1`"),
("InnoDB: Error: table `test`.`t[123]` does not exist in the InnoDB internal"),
("setrlimit could not change the size of core files to 'infinity'"),
("Although a path was specified for the --general-log-file option, log tables are 
used"),
("Although a path was specified for the --slow-query-log-file option, log tables 
are used"),
("Backup: Operation aborted"),
("Restore: Operation aborted"),
("Restore: The grant .* was skipped because the user does not exist"),
("The path specified for the variable .* is not a directory or cannot be
written:")
("Changed limits: max_open_files: *")
("Changed limits: max_connections: *")
("Changed limits: table_open_cache: *"),
("Could not increase number of max_open_files to more than *"),