WL#11625: MTR: Review the VALGRIND 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 created to review the Valgrind 
related warnings 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 Valgrind related 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:
 ("==[0-9]*== Memcheck,"),
 ("==[0-9]*== Copyright"),
 ("==[0-9]*== Using"),
 ("==[0-9]*== For more details"),
 /* This comes with innodb plugin tests */
 ("==[0-9]*== Warning: set address range perms: large range"),
 /* valgrind-3.5.0 dumps this */
 ("==[0-9]*== Command: "),
 /* Messages from valgrind tools */
 ("==[0-9]*== Callgrind"),
 ("==[0-9]*== For interactive control, run 'callgrind_control -h'"),
 ("==[0-9]*== Events    :"),
 ("==[0-9]*== Collected : [0-9]+"),
 ("==[0-9]*== I   refs:      [0-9]+"),
 ("==[0-9]*== Massif"),
 ("==[0-9]*== Helgrind"),
 ("==[0-9]*== Warning: invalid file descriptor -1 in syscall write()"),
 ("==[0-9]*== Warning: invalid file descriptor -1 in syscall read()"),
Following warnings were removed from mysql-test/include/mtr_warnings.sql:
("==[0-9]*== For more details")
("==[0-9]*== Warning: invalid file descriptor -1 in syscall write()")
("==[0-9]*== Warning: invalid file descriptor -1 in syscall read()")

Following warning was removed from mysql-test/include/mtr_warnings.sql and 
suppressed in main.explain and rpl_row_event_max_size.inc(used by 
rpl_gtid.rpl_gtid_row_event_max_size and rpl_nogtid.rpl_row_event_max_size.test):
("==[0-9]*== Warning: set address range perms: large range")