| Bug #47617 | mtr doesn't handle well suppressions on windows | ||
|---|---|---|---|
| Submitted: | 24 Sep 2009 14:46 | Modified: | 1 Oct 2009 10:27 |
| Reporter: | Georgi Kodinov | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Tools: MTR / mysql-test-run | Severity: | S7 (Test Cases) |
| Version: | OS: | Any (Windows and Linux and Solaris) | |
| Assigned to: | Bjørn Munch | CPU Architecture: | Any |
[24 Sep 2009 14:51]
Georgi Kodinov
Looks like mtr2 is not handling suppressions in mysql-test/include/mtr_warnings.sql as well.
I have :
rpl.rpl_timezone [ fail ] Found warnings/errors in server log file!
Test ended at 2009-09-23 22:24:13
file_name line
G:/pb2/test/sb_1-763829-1253735280.22/mysql-5.1.40-win-x86_64-test/mysql-test/var-n_mix/log/mysqld.2.err 090924 4:24:13 [Warning] Slave: Unknown table 't1' Error_code: 1051
^ Found warnings!!
ok
mysqltest: Logging to ''.
Despite the fact that there's the following suppression in the file :
157 /*
158 rpl_extrColmaster_*.test, the slave thread produces warnings
159 when it get updates to a table that has more columns on the
160 master
161 */
162 ("Slave: Unknown column 'c7' in 't15' Error_code: 1054"),
163 ("Slave: Can't DROP 'c7'.* 1091"),
164 ("Slave: Key column 'c6'.* 1072"),
165 ("Slave I/O: The slave I/O thread stops because a fatal error is encountered when it try to get the value of SERVER_ID variable from master."),
166 (".SELECT UNIX_TIMESTAMP... failed on master, do not trust column Seconds_Behind_Master of SHOW SLAVE STATUS"),
[24 Sep 2009 14:54]
Georgi Kodinov
doesn't seem to be windows specific : same problems on some pb2 linux and solaris hosts.
[30 Sep 2009 7:17]
Bjørn Munch
I suspect this is a duplicate of Bug #46996
[1 Oct 2009 10:27]
Bjørn Munch
Duplicate of Bug #46996.
Description: mtr.add_suppression() is not working for MS windows in some cases. In 5.1-bugteam in mysql-test/suite/rpl/t/rpl_log_pos.test I have : 11 # Passes with rbr no problem, removed statement include [jbm] 12 13 source include/master-slave.inc; 14 call mtr.add_suppression ("Slave I/O: Got fatal error 1236 from master when reading data from binary"); 15 source include/show_master_status.inc; But I'm still getting the warning under MS windows pb2 (in a repeatable way) : rpl.rpl_log_pos [ fail ] Found warnings/errors in server log file! Test ended at 2009-09-23 22:47:54 file_name line G:/pb2/test/sb_1-763829-1253735280.22/mysql-5.1.40-win-x86_64-test/mysql-test/var-n_mix/log/mysqld.2.err 090923 23:47:54 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event', Error_code: 1236 ^ Found warnings!! ok mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:10141 (socket G:/pb2/test/sb_1-763829-1253735280.22/mysql-5.1.40-win-x86_64-test/mysql-test/var-n_mix/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from '.\include\check-warnings.test' ... mysqltest: ... Done processing test commands. mysqltest: Test has succeeded! - saving 'G:/pb2/test/sb_1-763829-1253735280.22/mysql-5.1.40-win-x86_64-test/mysql-test/var-n_mix/log/rpl.rpl_log_pos/' to 'G:/pb2/test/sb_1-763829-1253735280.22/mysql-5.1.40-win-x86_64-test/mysql-test/var-n_mix/log/rpl.rpl_log_pos/' How to repeat: Run the test under MS windows with : mysql-test-run.pl --timer --force --parallel=auto --comment=n_mix --vardir=var-n_mix --mysqld=--binlog-format=mixed --experimental=collections/default.experimental Suggested fix: Make sure suppressions work in windows