From: Bjorn Munch Date: February 23 2011 9:32am Subject: bzr commit into mysql-5.1-mtr branch (bjorn.munch:2982) Bug#11762407 List-Archive: http://lists.mysql.com/commits/131914 X-Bug: 11762407 Message-Id: <201102230932.p1N9WZ1G024809@khepri15.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1473163865==" --===============1473163865== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///home/bm136801/my/suppsql-51/ based on revid:bjorn.munch@stripped 2982 Bjorn Munch 2011-02-23 Bug #11762407 54999: MTR GLOBAL SUPPRESSION HIDES SQL THREAD EXECUTION UNEXPECTED ERRORS Removed the global suppression, added lots of local ones to affected tests Re-commit, now kept "Slave SQL" at start of patterns. modified: mysql-test/extra/binlog_tests/binlog.test mysql-test/extra/rpl_tests/rpl_conflicts.test mysql-test/extra/rpl_tests/rpl_extra_col_master.test mysql-test/extra/rpl_tests/rpl_extra_col_slave.test mysql-test/extra/rpl_tests/rpl_loaddata.test mysql-test/extra/rpl_tests/rpl_row_basic.test mysql-test/extra/rpl_tests/rpl_row_tabledefs.test mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test mysql-test/include/mtr_warnings.sql mysql-test/suite/binlog/r/binlog_base64_flag.result mysql-test/suite/binlog/r/binlog_row_binlog.result mysql-test/suite/binlog/r/binlog_stm_binlog.result mysql-test/suite/binlog/t/binlog_base64_flag.test mysql-test/suite/rpl/r/rpl_binlog_corruption.result mysql-test/suite/rpl/r/rpl_binlog_max_cache_size.result mysql-test/suite/rpl/r/rpl_bug33931.result mysql-test/suite/rpl/r/rpl_circular_for_4_hosts.result mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result mysql-test/suite/rpl/r/rpl_extra_col_slave_innodb.result mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result mysql-test/suite/rpl/r/rpl_filter_tables_not_exist.result mysql-test/suite/rpl/r/rpl_idempotency.result mysql-test/suite/rpl/r/rpl_ignore_table.result mysql-test/suite/rpl/r/rpl_incident.result mysql-test/suite/rpl/r/rpl_init_slave_errors.result mysql-test/suite/rpl/r/rpl_known_bugs_detection.result mysql-test/suite/rpl/r/rpl_loaddata.result mysql-test/suite/rpl/r/rpl_loaddata_concurrent.result mysql-test/suite/rpl/r/rpl_loaddata_fatal.result mysql-test/suite/rpl/r/rpl_rotate_logs.result mysql-test/suite/rpl/r/rpl_row_basic_11bugs.result mysql-test/suite/rpl/r/rpl_row_basic_2myisam.result mysql-test/suite/rpl/r/rpl_row_basic_3innodb.result mysql-test/suite/rpl/r/rpl_row_colSize.result mysql-test/suite/rpl/r/rpl_row_conflicts.result mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result mysql-test/suite/rpl/r/rpl_row_tabledefs_2myisam.result mysql-test/suite/rpl/r/rpl_row_tabledefs_3innodb.result mysql-test/suite/rpl/r/rpl_skip_error.result mysql-test/suite/rpl/r/rpl_slave_grp_exec.result mysql-test/suite/rpl/r/rpl_slave_load_remove_tmpfile.result mysql-test/suite/rpl/r/rpl_slave_load_tmpdir_not_exist.result mysql-test/suite/rpl/r/rpl_stm_EE_err2.result mysql-test/suite/rpl/r/rpl_stm_conflicts.result mysql-test/suite/rpl/r/rpl_temporary_errors.result mysql-test/suite/rpl/t/rpl_binlog_corruption.test mysql-test/suite/rpl/t/rpl_binlog_max_cache_size.test mysql-test/suite/rpl/t/rpl_bug33931.test mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test mysql-test/suite/rpl/t/rpl_filter_tables_not_exist.test mysql-test/suite/rpl/t/rpl_idempotency.test mysql-test/suite/rpl/t/rpl_ignore_table.test mysql-test/suite/rpl/t/rpl_incident.test mysql-test/suite/rpl/t/rpl_init_slave_errors.test mysql-test/suite/rpl/t/rpl_known_bugs_detection.test mysql-test/suite/rpl/t/rpl_loaddata_fatal.test mysql-test/suite/rpl/t/rpl_rotate_logs.test mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test mysql-test/suite/rpl/t/rpl_row_colSize.test mysql-test/suite/rpl/t/rpl_row_inexist_tbl.test mysql-test/suite/rpl/t/rpl_skip_error.test mysql-test/suite/rpl/t/rpl_slave_grp_exec.test mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test mysql-test/suite/rpl/t/rpl_slave_load_tmpdir_not_exist.test mysql-test/suite/rpl/t/rpl_temporary_errors.test === modified file 'mysql-test/extra/binlog_tests/binlog.test' --- a/mysql-test/extra/binlog_tests/binlog.test 2010-11-28 09:43:36 +0000 +++ b/mysql-test/extra/binlog_tests/binlog.test 2011-02-23 09:31:37 +0000 @@ -343,6 +343,7 @@ SHOW SESSION VARIABLES LIKE "%_checks"; --echo # INSERT INTO t1 VALUES(2) --echo # foreign_key_checks=1 and unique_checks=1 --echo # It should not change current session's variables, even error happens +call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.t1; Duplicate entry .2. for key .PRIMARY., Error_code: 1062"); --error 1062 BINLOG ' dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE= === modified file 'mysql-test/extra/rpl_tests/rpl_conflicts.test' --- a/mysql-test/extra/rpl_tests/rpl_conflicts.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_conflicts.test 2011-02-23 09:31:37 +0000 @@ -93,6 +93,7 @@ if (`SELECT @@global.binlog_format != 'R source include/wait_for_slave_sql_error.inc; let $err= query_get_value("SHOW SLAVE STATUS", Last_SQL_Error, 1); --echo Last_SQL_Error = $err (expected "duplicate key" error) + call mtr.add_suppression("Slave SQL.*Duplicate entry .1. for key .PRIMARY.* Error_code: 1062"); SELECT * FROM t1; --echo ---- Resolve the conflict on the slave and restart SQL thread ---- @@ -137,6 +138,7 @@ connection slave; # replication continues. if (`SELECT @@global.binlog_format = 'ROW' AND @@global.slave_exec_mode = 'STRICT'`) { --echo ---- Wait until slave stops with an error ---- + call mtr.add_suppression("Can.t find record in .t1., Error_code: 1032"); let $slave_sql_errno= 1032; # ER_KEY_NOT_FOUND source include/wait_for_slave_sql_error.inc; === modified file 'mysql-test/extra/rpl_tests/rpl_extra_col_master.test' --- a/mysql-test/extra/rpl_tests/rpl_extra_col_master.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_extra_col_master.test 2011-02-23 09:31:37 +0000 @@ -121,6 +121,12 @@ SELECT f1,f2,f3,f4,f5,f6,f7,f8,f9, hex(f10),hex(f11) FROM t1 ORDER BY f3 LIMIT 20; #connection slave; + +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); + sync_slave_with_master; --echo --echo * Select count and 20 rows from Slave * === modified file 'mysql-test/extra/rpl_tests/rpl_extra_col_slave.test' --- a/mysql-test/extra/rpl_tests/rpl_extra_col_slave.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_extra_col_slave.test 2011-02-23 09:31:37 +0000 @@ -766,6 +766,10 @@ RESET MASTER; connection slave; START SLAVE; +call mtr.add_suppression("Slave SQL.*Error .Unknown table .t6.. on query.* Error_code: 1051"); +call mtr.add_suppression("Slave SQL.*Error .Duplicate column name .c6.. on query.* Error_code: 1060"); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column . ...e mismatch.* Error_code: 1535"); + --echo *** Master Data Insert *** connection master; set @b1 = 'b1b1b1b1'; === modified file 'mysql-test/extra/rpl_tests/rpl_loaddata.test' --- a/mysql-test/extra/rpl_tests/rpl_loaddata.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_loaddata.test 2011-02-23 09:31:37 +0000 @@ -63,6 +63,8 @@ eval $lower_stmt_head infile '../../std_ save_master_pos; connection slave; # 1062 = ER_DUP_ENTRY +call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .10. for key .b.. on query.* Error_code: 1062"); +call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.*error code=1062.*Error on slave:.*Error_code: 0"); --let $slave_sql_errno= 1062 --source include/wait_for_slave_sql_error_and_skip.inc === modified file 'mysql-test/extra/rpl_tests/rpl_row_basic.test' --- a/mysql-test/extra/rpl_tests/rpl_row_basic.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_row_basic.test 2011-02-23 09:31:37 +0000 @@ -371,7 +371,9 @@ INSERT INTO t3 VALUES (1, "", 1); INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2); connection slave; -# 1535 = ER_BINLOG_ROW_WRONG_TABLE_DEF +# 1535 = ER_BINLOG_ROW_WRONG_TABLE_DEF +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535"); +call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table test.t1.* Error_code: 1032"); --let $slave_sql_errno= 1535 --let $show_slave_sql_error= 1 --source include/wait_for_slave_sql_error.inc === modified file 'mysql-test/extra/rpl_tests/rpl_row_tabledefs.test' --- a/mysql-test/extra/rpl_tests/rpl_row_tabledefs.test 2010-05-24 13:54:08 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_row_tabledefs.test 2011-02-23 09:31:37 +0000 @@ -147,6 +147,7 @@ sync_slave_with_master; connection master; INSERT INTO t4 VALUES (4); connection slave; +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column [012] type mismatch.* Error_code: 1535"); --let $slave_skip_counter= 2 --let $slave_sql_errno= 1535 --let $show_slave_sql_error= 1 === modified file 'mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test' --- a/mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test 2011-02-23 09:31:37 +0000 @@ -25,6 +25,7 @@ drop table t1; connection slave; --source include/wait_for_slave_sql_to_stop.inc +call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.* error code=1062.*Error on slave:.* Error_code: 0"); let $error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Error, 1); let $errno= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1); --echo Error: "$error" (expected different error codes on master and slave) === modified file 'mysql-test/include/mtr_warnings.sql' --- a/mysql-test/include/mtr_warnings.sql 2010-04-09 17:57:11 +0000 +++ b/mysql-test/include/mtr_warnings.sql 2011-02-23 09:31:37 +0000 @@ -107,7 +107,6 @@ INSERT INTO global_suppressions VALUES ("Slave: The incident LOST_EVENTS occured on the master"), ("Slave: Unknown error.* 1105"), ("Slave: Can't drop database.* database doesn't exist"), - ("Slave SQL:.*(Error_code: \[\[:digit:\]\]+|Query:.*)"), ("Sort aborted"), ("Time-out in NDB"), ("Warning:\s+One can only use the --user.*root"), === modified file 'mysql-test/suite/binlog/r/binlog_base64_flag.result' --- a/mysql-test/suite/binlog/r/binlog_base64_flag.result 2010-06-18 17:32:23 +0000 +++ b/mysql-test/suite/binlog/r/binlog_base64_flag.result 2011-02-23 09:31:37 +0000 @@ -91,6 +91,8 @@ iONkSBcBAAAAKwAAAMQBAAAQABAAAAAAAAEAA//4 '; ERROR HY000: master may suffer from http://bugs.mysql.com/bug.php?id=37426 so slave stops; check error log on slave for more info drop table t1, char63_utf8, char128_utf8; +call mtr.add_suppression("Slave SQL.*master suffers from this bug: http:..bugs.mysql.com.bug.php.id=37426.* Error_code: 1105"); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535"); # # Bug #54393: crash and/or valgrind errors in # mysql_client_binlog_statement === modified file 'mysql-test/suite/binlog/r/binlog_row_binlog.result' --- a/mysql-test/suite/binlog/r/binlog_row_binlog.result 2010-11-28 09:43:36 +0000 +++ b/mysql-test/suite/binlog/r/binlog_row_binlog.result 2011-02-23 09:31:37 +0000 @@ -1374,6 +1374,7 @@ unique_checks OFF # INSERT INTO t1 VALUES(2) # foreign_key_checks=1 and unique_checks=1 # It should not change current session's variables, even error happens +call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.t1; Duplicate entry .2. for key .PRIMARY., Error_code: 1062"); BINLOG ' dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE= dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA== === modified file 'mysql-test/suite/binlog/r/binlog_stm_binlog.result' --- a/mysql-test/suite/binlog/r/binlog_stm_binlog.result 2010-11-28 09:43:36 +0000 +++ b/mysql-test/suite/binlog/r/binlog_stm_binlog.result 2011-02-23 09:31:37 +0000 @@ -845,6 +845,7 @@ unique_checks OFF # INSERT INTO t1 VALUES(2) # foreign_key_checks=1 and unique_checks=1 # It should not change current session's variables, even error happens +call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.t1; Duplicate entry .2. for key .PRIMARY., Error_code: 1062"); BINLOG ' dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE= dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA== === modified file 'mysql-test/suite/binlog/t/binlog_base64_flag.test' --- a/mysql-test/suite/binlog/t/binlog_base64_flag.test 2010-06-18 17:32:23 +0000 +++ b/mysql-test/suite/binlog/t/binlog_base64_flag.test 2011-02-23 09:31:37 +0000 @@ -151,6 +151,8 @@ iONkSBcBAAAAKwAAAMQBAAAQABAAAAAAAAEAA//4 drop table t1, char63_utf8, char128_utf8; +call mtr.add_suppression("Slave SQL.*master suffers from this bug: http:..bugs.mysql.com.bug.php.id=37426.* Error_code: 1105"); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535"); --echo # --echo # Bug #54393: crash and/or valgrind errors in === modified file 'mysql-test/suite/rpl/r/rpl_binlog_corruption.result' --- a/mysql-test/suite/rpl/r/rpl_binlog_corruption.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_binlog_corruption.result 2011-02-23 09:31:37 +0000 @@ -1,6 +1,7 @@ include/master-slave.inc [connection master] call mtr.add_suppression('Found invalid event in binary log'); +call mtr.add_suppression('Slave SQL.*Relay log read failure: Could not parse relay log event entry.* 1594'); ==== Initialize ==== include/stop_slave.inc RESET SLAVE; === modified file 'mysql-test/suite/rpl/r/rpl_binlog_max_cache_size.result' --- a/mysql-test/suite/rpl/r/rpl_binlog_max_cache_size.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_binlog_max_cache_size.result 2011-02-23 09:31:37 +0000 @@ -125,6 +125,7 @@ include/stop_slave.inc include/start_slave.inc CALL mtr.add_suppression("Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage.*"); CALL mtr.add_suppression("Writing one row to the row-based binary log failed.*"); +CALL mtr.add_suppression("Slave SQL.*The incident LOST_EVENTS occured on the master. Message: error writing to the binary log"); TRUNCATE t1; SET GLOBAL max_binlog_cache_size= ORIGINAL_VALUE; SET GLOBAL binlog_cache_size= ORIGINAL_VALUE; === modified file 'mysql-test/suite/rpl/r/rpl_bug33931.result' --- a/mysql-test/suite/rpl/r/rpl_bug33931.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_bug33931.result 2011-02-23 09:31:37 +0000 @@ -1,6 +1,7 @@ include/master-slave.inc [connection master] call mtr.add_suppression("Failed during slave I/O thread initialization"); +call mtr.add_suppression("Slave SQL.*Failed during slave thread initialization.* 1593"); include/stop_slave.inc reset slave; SET GLOBAL debug="d,simulate_io_slave_error_on_init,simulate_sql_slave_error_on_init"; === modified file 'mysql-test/suite/rpl/r/rpl_circular_for_4_hosts.result' --- a/mysql-test/suite/rpl/r/rpl_circular_for_4_hosts.result 2011-02-03 16:09:33 +0000 +++ b/mysql-test/suite/rpl/r/rpl_circular_for_4_hosts.result 2011-02-23 09:31:37 +0000 @@ -46,6 +46,7 @@ SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; include/start_slave.inc INSERT INTO t1 VALUES(6,'C',2); INSERT INTO t1(b,c) VALUES('B',2); +call mtr.add_suppression("Slave SQL.*Duplicate entry .6. for key .PRIMARY.* Error_code: 1062"); include/wait_for_slave_sql_error.inc [errno=1062] INSERT INTO t1(b,c) VALUES('A',2); INSERT INTO t1(b,c) VALUES('D',2); === modified file 'mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result' --- a/mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result 2011-02-23 09:31:37 +0000 @@ -58,6 +58,10 @@ f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex( 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); * Select count and 20 rows from Slave * @@ -929,6 +933,10 @@ f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex( 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); * Select count and 20 rows from Slave * @@ -1800,6 +1808,10 @@ f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex( 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); * Select count and 20 rows from Slave * === modified file 'mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result' --- a/mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result 2011-02-23 09:31:37 +0000 @@ -58,6 +58,10 @@ f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex( 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); * Select count and 20 rows from Slave * @@ -929,6 +933,10 @@ f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex( 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); * Select count and 20 rows from Slave * @@ -1800,6 +1808,10 @@ f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex( 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456 +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 2 type mismatch.* 1535"); +call mtr.add_suppression("Slave SQL.*Error .Can.t DROP .c7.; check that column.key exists. on query.* 1091"); +call mtr.add_suppression("Slave SQL.*Error .Unknown column .c7. in .t15.. on query.* 1054"); +call mtr.add_suppression("Slave SQL.*Error .Key column .c6. doesn.t exist in table. on query.* 1072"); * Select count and 20 rows from Slave * === modified file 'mysql-test/suite/rpl/r/rpl_extra_col_slave_innodb.result' --- a/mysql-test/suite/rpl/r/rpl_extra_col_slave_innodb.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_extra_col_slave_innodb.result 2011-02-23 09:31:37 +0000 @@ -460,6 +460,9 @@ c4 BLOB, c5 CHAR(5)) ENGINE='InnoDB'; RESET MASTER; *** Start Slave *** START SLAVE; +call mtr.add_suppression("Slave SQL.*Error .Unknown table .t6.. on query.* Error_code: 1051"); +call mtr.add_suppression("Slave SQL.*Error .Duplicate column name .c6.. on query.* Error_code: 1060"); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column . ...e mismatch.* Error_code: 1535"); *** Master Data Insert *** set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); === modified file 'mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result' --- a/mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result 2011-02-23 09:31:37 +0000 @@ -460,6 +460,9 @@ c4 BLOB, c5 CHAR(5)) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** START SLAVE; +call mtr.add_suppression("Slave SQL.*Error .Unknown table .t6.. on query.* Error_code: 1051"); +call mtr.add_suppression("Slave SQL.*Error .Duplicate column name .c6.. on query.* Error_code: 1060"); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column . ...e mismatch.* Error_code: 1535"); *** Master Data Insert *** set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); === modified file 'mysql-test/suite/rpl/r/rpl_filter_tables_not_exist.result' --- a/mysql-test/suite/rpl/r/rpl_filter_tables_not_exist.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_filter_tables_not_exist.result 2011-02-23 09:31:37 +0000 @@ -42,6 +42,7 @@ UPDATE t4 LEFT JOIN (t1, t2, t5) ON (t1. UPDATE t4 LEFT JOIN (t1, t6, t7) ON (t4.id=t1.id and t4.id=t6.id and t4.id=t7.id) SET a=0, d=0, f=0, g=0 where t4.id=1; UPDATE t7 LEFT JOIN (t4, t1, t2) ON (t7.id=t4.id and t7.id=t1.id and t7.id=t2.id) SET a=0, b=0, d=0, g=0 where t7.id=1; UPDATE t7 LEFT JOIN (t8, t4, t1) ON (t7.id=t8.id and t7.id=t4.id and t7.id=t1.id) SET a=0, d=0, g=0, h=0 where t7.id=1; +call mtr.add_suppression("Slave SQL.*Error .Table .test.t[47]. doesn.t exist. on query.* Error_code: 1146"); UPDATE t1 LEFT JOIN t4 ON (t1.id=t4.id) SET a=0 where t1.id=1; include/wait_for_slave_sql_error_and_skip.inc [errno=1146] Last_SQL_Error = 'Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN t4 ON (t1.id=t4.id) SET a=0 where t1.id=1'' === modified file 'mysql-test/suite/rpl/r/rpl_idempotency.result' --- a/mysql-test/suite/rpl/r/rpl_idempotency.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_idempotency.result 2011-02-23 09:31:37 +0000 @@ -1,8 +1,9 @@ include/master-slave.inc [connection master] -call mtr.add_suppression("Slave: Can't find record in 't.' Error_code: 1032"); -call mtr.add_suppression("Slave: Cannot delete or update a parent row: a foreign key constraint fails .* Error_code: 1451"); -call mtr.add_suppression("Slave: Cannot add or update a child row: a foreign key constraint fails .* Error_code: 1452"); +call mtr.add_suppression("Can.t find record in .t[12].* Error_code: 1032"); +call mtr.add_suppression("Cannot delete or update a parent row: a foreign key constraint fails .* Error_code: 1451"); +call mtr.add_suppression("Cannot add or update a child row: a foreign key constraint fails .* Error_code: 1452"); +call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.* Duplicate entry .1. for key .PRIMARY.* Error_code: 1062"); SET @old_slave_exec_mode= @@global.slave_exec_mode; CREATE TABLE t1 (a INT PRIMARY KEY); CREATE TABLE t2 (a INT); === modified file 'mysql-test/suite/rpl/r/rpl_ignore_table.result' --- a/mysql-test/suite/rpl/r/rpl_ignore_table.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_ignore_table.result 2011-02-23 09:31:37 +0000 @@ -112,6 +112,7 @@ show grants for mysqltest4@localhost; Grants for mysqltest4@localhost GRANT USAGE ON *.* TO 'mysqltest4'@'localhost' IDENTIFIED BY PASSWORD '*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7' set global slave_exec_mode='IDEMPOTENT'; +call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table mysql.* Error_code: 1032"); drop table t1, mysqltest2.t2; drop table t4; drop database mysqltest2; === modified file 'mysql-test/suite/rpl/r/rpl_incident.result' --- a/mysql-test/suite/rpl/r/rpl_incident.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_incident.result 2011-02-23 09:31:37 +0000 @@ -15,6 +15,7 @@ a 2 3 4 +call mtr.add_suppression("Slave SQL.*The incident LOST_EVENTS occured on the master.* 1590"); include/wait_for_slave_sql_error.inc [errno=1590] Last_SQL_Error = 'The incident LOST_EVENTS occured on the master. Message: ' **** On Slave **** === modified file 'mysql-test/suite/rpl/r/rpl_init_slave_errors.result' --- a/mysql-test/suite/rpl/r/rpl_init_slave_errors.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_init_slave_errors.result 2011-02-23 09:31:37 +0000 @@ -6,7 +6,7 @@ SET GLOBAL debug= "d,simulate_io_slave_e start slave; include/wait_for_slave_sql_error.inc [errno=1593] Last_SQL_Error = 'Failed during slave thread initialization' -call mtr.add_suppression("Failed during slave I/O thread initialization"); +call mtr.add_suppression("Failed during slave.* thread initialization"); SET GLOBAL debug= ""; reset slave; SET GLOBAL init_slave= "garbage"; === modified file 'mysql-test/suite/rpl/r/rpl_known_bugs_detection.result' --- a/mysql-test/suite/rpl/r/rpl_known_bugs_detection.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_known_bugs_detection.result 2011-02-23 09:31:37 +0000 @@ -7,6 +7,7 @@ SELECT * FROM t1; a b 1 10 2 2 +call mtr.add_suppression("Slave SQL.*suffer.*http:..bugs.mysql.com.bug.php.id=24432"); include/wait_for_slave_sql_error.inc [errno=1105] Last_SQL_Error = 'Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10'' SELECT * FROM t1; === modified file 'mysql-test/suite/rpl/r/rpl_loaddata.result' --- a/mysql-test/suite/rpl/r/rpl_loaddata.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_loaddata.result 2011-02-23 09:31:37 +0000 @@ -27,6 +27,8 @@ drop table t3; create table t1(a int, b int, unique(b)); insert into t1 values(1,10); load data infile '../../std_data/rpl_loaddata.dat' into table t1; +call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .10. for key .b.. on query.* Error_code: 1062"); +call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.*error code=1062.*Error on slave:.*Error_code: 0"); include/wait_for_slave_sql_error_and_skip.inc [errno=1062] include/check_slave_no_error.inc set sql_log_bin=0; === modified file 'mysql-test/suite/rpl/r/rpl_loaddata_concurrent.result' --- a/mysql-test/suite/rpl/r/rpl_loaddata_concurrent.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_loaddata_concurrent.result 2011-02-23 09:31:37 +0000 @@ -38,6 +38,8 @@ drop table t3; create table t1(a int, b int, unique(b)); insert into t1 values(1,10); load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1; +call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .10. for key .b.. on query.* Error_code: 1062"); +call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.*error code=1062.*Error on slave:.*Error_code: 0"); include/wait_for_slave_sql_error_and_skip.inc [errno=1062] include/check_slave_no_error.inc set sql_log_bin=0; === modified file 'mysql-test/suite/rpl/r/rpl_loaddata_fatal.result' --- a/mysql-test/suite/rpl/r/rpl_loaddata_fatal.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_loaddata_fatal.result 2011-02-23 09:31:37 +0000 @@ -3,6 +3,7 @@ include/master-slave.inc CREATE TABLE t1 (a INT, b INT); INSERT INTO t1 VALUES (1,10); LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE t1; +call mtr.add_suppression("Slave SQL.*Fatal error: Not enough memory, Error_code: 1593"); include/wait_for_slave_sql_error_and_skip.inc [errno=1593] Last_SQL_Error = 'Fatal error: Not enough memory' DROP TABLE t1; === modified file 'mysql-test/suite/rpl/r/rpl_rotate_logs.result' --- a/mysql-test/suite/rpl/r/rpl_rotate_logs.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_rotate_logs.result 2011-02-23 09:31:37 +0000 @@ -36,6 +36,7 @@ drop table temp_table, t3; insert into t2 values(1234); set insert_id=1234; insert into t2 values(NULL); +call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .1234. for key .PRIMARY.. on query.* Error_code: 1062"); include/wait_for_slave_sql_error_and_skip.inc [errno=1062] purge master logs to 'master-bin.000002'; show master logs; === modified file 'mysql-test/suite/rpl/r/rpl_row_basic_11bugs.result' --- a/mysql-test/suite/rpl/r/rpl_row_basic_11bugs.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_basic_11bugs.result 2011-02-23 09:31:37 +0000 @@ -63,6 +63,7 @@ DROP TABLE t1; include/rpl_reset.inc **** On Slave **** SET GLOBAL QUERY_CACHE_SIZE=0; +call mtr.add_suppression("Slave SQL.*Could not execute Update_rows event on table test.t1.* Error_code: 1032"); **** On Master **** CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1),(2),(3); === modified file 'mysql-test/suite/rpl/r/rpl_row_basic_2myisam.result' --- a/mysql-test/suite/rpl/r/rpl_row_basic_2myisam.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_basic_2myisam.result 2011-02-23 09:31:37 +0000 @@ -478,6 +478,8 @@ include/diff_tables.inc [master:t2, slav [expecting slave to stop] INSERT INTO t3 VALUES (1, "", 1); INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535"); +call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table test.t1.* Error_code: 1032"); include/wait_for_slave_sql_error.inc [errno=1535] Last_SQL_Error = 'Table definition on master and slave does not match: Column 1 size mismatch - master has size 384, test.t3 on slave has size 49. Master's column size should be <= the slave's column size.' include/rpl_reset.inc === modified file 'mysql-test/suite/rpl/r/rpl_row_basic_3innodb.result' --- a/mysql-test/suite/rpl/r/rpl_row_basic_3innodb.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_basic_3innodb.result 2011-02-23 09:31:37 +0000 @@ -478,6 +478,8 @@ include/diff_tables.inc [master:t2, slav [expecting slave to stop] INSERT INTO t3 VALUES (1, "", 1); INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535"); +call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table test.t1.* Error_code: 1032"); include/wait_for_slave_sql_error.inc [errno=1535] Last_SQL_Error = 'Table definition on master and slave does not match: Column 1 size mismatch - master has size 384, test.t3 on slave has size 49. Master's column size should be <= the slave's column size.' include/rpl_reset.inc === modified file 'mysql-test/suite/rpl/r/rpl_row_colSize.result' --- a/mysql-test/suite/rpl/r/rpl_row_colSize.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_colSize.result 2011-02-23 09:31:37 +0000 @@ -265,6 +265,7 @@ STOP SLAVE; RESET SLAVE; RESET MASTER; START SLAVE; +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 0 ...e mismatch.* Error_code: 1535"); *** Cleanup *** DROP TABLE IF EXISTS t1; include/rpl_end.inc === modified file 'mysql-test/suite/rpl/r/rpl_row_conflicts.result' --- a/mysql-test/suite/rpl/r/rpl_row_conflicts.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_conflicts.result 2011-02-23 09:31:37 +0000 @@ -22,6 +22,7 @@ a ---- Wait until slave stops with an error ---- include/wait_for_slave_sql_error.inc [errno=1062] Last_SQL_Error = Could not execute Write_rows event on table test.t1; Duplicate entry '1' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 346 (expected "duplicate key" error) +call mtr.add_suppression("Slave SQL.*Duplicate entry .1. for key .PRIMARY.* Error_code: 1062"); SELECT * FROM t1; a 1 @@ -48,6 +49,7 @@ SELECT * FROM t1; a [on slave] ---- Wait until slave stops with an error ---- +call mtr.add_suppression("Can.t find record in .t1., Error_code: 1032"); include/wait_for_slave_sql_error.inc [errno=1032] Last_SQL_Error (expected "duplicate key" error) Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos END_LOG_POS === modified file 'mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result' --- a/mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result 2011-02-23 09:31:37 +0000 @@ -10,6 +10,7 @@ DROP TABLE t1; INSERT INTO t1 VALUES (1); ==== Verify error on slave ==== [on slave] +call mtr.add_suppression("Slave SQL.*Error .Table .test.t1. doesn.t exist. on opening tables, Error_code: 1146"); include/wait_for_slave_sql_error.inc [errno=1146] ==== Clean up ==== include/stop_slave_io.inc === modified file 'mysql-test/suite/rpl/r/rpl_row_tabledefs_2myisam.result' --- a/mysql-test/suite/rpl/r/rpl_row_tabledefs_2myisam.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_tabledefs_2myisam.result 2011-02-23 09:31:37 +0000 @@ -117,6 +117,7 @@ a include/check_slave_is_running.inc INSERT INTO t9 VALUES (4); INSERT INTO t4 VALUES (4); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column [012] type mismatch.* Error_code: 1535"); include/wait_for_slave_sql_error_and_skip.inc [errno=1535] Last_SQL_Error = 'Table definition on master and slave does not match: Column 0 type mismatch - received type 3, test.t4 has type 4' INSERT INTO t9 VALUES (5); === modified file 'mysql-test/suite/rpl/r/rpl_row_tabledefs_3innodb.result' --- a/mysql-test/suite/rpl/r/rpl_row_tabledefs_3innodb.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_row_tabledefs_3innodb.result 2011-02-23 09:31:37 +0000 @@ -117,6 +117,7 @@ a include/check_slave_is_running.inc INSERT INTO t9 VALUES (4); INSERT INTO t4 VALUES (4); +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column [012] type mismatch.* Error_code: 1535"); include/wait_for_slave_sql_error_and_skip.inc [errno=1535] Last_SQL_Error = 'Table definition on master and slave does not match: Column 0 type mismatch - received type 3, test.t4 has type 4' INSERT INTO t9 VALUES (5); === modified file 'mysql-test/suite/rpl/r/rpl_skip_error.result' --- a/mysql-test/suite/rpl/r/rpl_skip_error.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_skip_error.result 2011-02-23 09:31:37 +0000 @@ -56,6 +56,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SET SQL_LOG_BIN=1; +call mtr.add_suppression("Slave SQL.*Could not execute .*te_rows event on table test.t.; Duplicate entry.* Error_code: 1062"); CREATE TABLE t1(id INT NOT NULL PRIMARY KEY, data INT) Engine=InnoDB; SHOW CREATE TABLE t1; Table Create Table === modified file 'mysql-test/suite/rpl/r/rpl_slave_grp_exec.result' --- a/mysql-test/suite/rpl/r/rpl_slave_grp_exec.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_slave_grp_exec.result 2011-02-23 09:31:37 +0000 @@ -29,6 +29,7 @@ a b SELECT * FROM t3 ORDER BY a; a b 1 ZZ +call mtr.add_suppression("Slave SQL.*Error .Table .test.t3. doesn.t exist. on.* Error_code: 1146"); include/wait_for_slave_sql_error.inc [errno=1146] SHOW TABLES LIKE 't%'; Tables_in_test (t%) === modified file 'mysql-test/suite/rpl/r/rpl_slave_load_remove_tmpfile.result' --- a/mysql-test/suite/rpl/r/rpl_slave_load_remove_tmpfile.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_slave_load_remove_tmpfile.result 2011-02-23 09:31:37 +0000 @@ -13,4 +13,5 @@ include/stop_slave_io.inc RESET SLAVE; drop table t1; call mtr.add_suppression("Slave: Error writing file 'UNKNOWN' .Errcode: 9. Error_code: 3"); +call mtr.add_suppression("Slave SQL.*Error in Begin_load_query event: write to.* failed, Error_code: 9"); include/rpl_end.inc === modified file 'mysql-test/suite/rpl/r/rpl_slave_load_tmpdir_not_exist.result' --- a/mysql-test/suite/rpl/r/rpl_slave_load_tmpdir_not_exist.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_slave_load_tmpdir_not_exist.result 2011-02-23 09:31:37 +0000 @@ -1,6 +1,7 @@ include/master-slave.inc [connection master] START SLAVE; +call mtr.add_suppression("Slave SQL.*Unable to use slave.s temporary directory.* Error_code: 12"); include/wait_for_slave_sql_error.inc [errno=12] include/stop_slave_io.inc RESET SLAVE; === modified file 'mysql-test/suite/rpl/r/rpl_stm_EE_err2.result' --- a/mysql-test/suite/rpl/r/rpl_stm_EE_err2.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_stm_EE_err2.result 2011-02-23 09:31:37 +0000 @@ -8,6 +8,7 @@ insert into t1 values(1),(2); ERROR 23000: Duplicate entry '2' for key 'a' drop table t1; include/wait_for_slave_sql_to_stop.inc +call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.* error code=1062.*Error on slave:.* Error_code: 0"); Error: "Query caused different errors on master and slave. Error on master: message (format)='Duplicate entry '%-.192s' for key %d' error code=1062 ; Error on slave: actual message='no error', error code=0. Default database: 'test'. Query: 'insert into t1 values(1),(2)'" (expected different error codes on master and slave) Errno: "0" (expected 0) drop table t1; === modified file 'mysql-test/suite/rpl/r/rpl_stm_conflicts.result' --- a/mysql-test/suite/rpl/r/rpl_stm_conflicts.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_stm_conflicts.result 2011-02-23 09:31:37 +0000 @@ -17,6 +17,7 @@ a ---- Wait until slave stops with an error ---- include/wait_for_slave_sql_error.inc [errno=1062] Last_SQL_Error = Error 'Duplicate entry '1' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'INSERT INTO t1 VALUES (1)' (expected "duplicate key" error) +call mtr.add_suppression("Slave SQL.*Duplicate entry .1. for key .PRIMARY.* Error_code: 1062"); SELECT * FROM t1; a 1 === modified file 'mysql-test/suite/rpl/r/rpl_temporary_errors.result' --- a/mysql-test/suite/rpl/r/rpl_temporary_errors.result 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/r/rpl_temporary_errors.result 2011-02-23 09:31:37 +0000 @@ -37,6 +37,7 @@ a b 3 3 4 4 include/check_slave_is_running.inc +call mtr.add_suppression("Slave SQL.*Could not execute Update_rows event on table test.t1"); **** On Master **** DROP TABLE t1; SET SESSION BINLOG_FORMAT=MIXED; === modified file 'mysql-test/suite/rpl/t/rpl_binlog_corruption.test' --- a/mysql-test/suite/rpl/t/rpl_binlog_corruption.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_binlog_corruption.test 2011-02-23 09:31:37 +0000 @@ -22,7 +22,7 @@ source include/have_debug.inc; --connection slave call mtr.add_suppression('Found invalid event in binary log'); - +call mtr.add_suppression('Slave SQL.*Relay log read failure: Could not parse relay log event entry.* 1594'); # # BUG#40482: server/mysqlbinlog crashes when reading invalid Incident_log_event === modified file 'mysql-test/suite/rpl/t/rpl_binlog_max_cache_size.test' --- a/mysql-test/suite/rpl/t/rpl_binlog_max_cache_size.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_binlog_max_cache_size.test 2011-02-23 09:31:37 +0000 @@ -398,6 +398,7 @@ source include/stop_slave.inc; source include/start_slave.inc; CALL mtr.add_suppression("Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage.*"); CALL mtr.add_suppression("Writing one row to the row-based binary log failed.*"); +CALL mtr.add_suppression("Slave SQL.*The incident LOST_EVENTS occured on the master. Message: error writing to the binary log"); connection master; TRUNCATE t1; === modified file 'mysql-test/suite/rpl/t/rpl_bug33931.test' --- a/mysql-test/suite/rpl/t/rpl_bug33931.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_bug33931.test 2011-02-23 09:31:37 +0000 @@ -9,6 +9,7 @@ connection slave; # Add suppression for expected warnings in slaves error log call mtr.add_suppression("Failed during slave I/O thread initialization"); +call mtr.add_suppression("Slave SQL.*Failed during slave thread initialization.* 1593"); --source include/stop_slave.inc reset slave; === modified file 'mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test' --- a/mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test 2011-02-03 16:09:33 +0000 +++ b/mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test 2011-02-23 09:31:37 +0000 @@ -82,6 +82,7 @@ INSERT INTO t1(b,c) VALUES('B',2); # Wait while C will stop. --connection server_3 # 1062 = ER_DUP_ENTRY +call mtr.add_suppression("Slave SQL.*Duplicate entry .6. for key .PRIMARY.* Error_code: 1062"); --let $slave_sql_errno= 1062 --source include/wait_for_slave_sql_error.inc --connection server_1 === modified file 'mysql-test/suite/rpl/t/rpl_filter_tables_not_exist.test' --- a/mysql-test/suite/rpl/t/rpl_filter_tables_not_exist.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_filter_tables_not_exist.test 2011-02-23 09:31:37 +0000 @@ -122,6 +122,8 @@ UPDATE t7 LEFT JOIN (t8, t4, t1) ON (t7. # if any of the above statement are not ignored, it would cause error # and stop slave sql thread. sync_slave_with_master; +connection slave; +call mtr.add_suppression("Slave SQL.*Error .Table .test.t[47]. doesn.t exist. on query.* Error_code: 1146"); connection master; # Parameters for include/wait_for_slave_sql_error_and_skip.inc: === modified file 'mysql-test/suite/rpl/t/rpl_idempotency.test' --- a/mysql-test/suite/rpl/t/rpl_idempotency.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_idempotency.test 2011-02-23 09:31:37 +0000 @@ -8,9 +8,10 @@ connection slave; source include/have_innodb.inc; # Add suppression for expected warning(s) in slaves error log -call mtr.add_suppression("Slave: Can't find record in 't.' Error_code: 1032"); -call mtr.add_suppression("Slave: Cannot delete or update a parent row: a foreign key constraint fails .* Error_code: 1451"); -call mtr.add_suppression("Slave: Cannot add or update a child row: a foreign key constraint fails .* Error_code: 1452"); +call mtr.add_suppression("Can.t find record in .t[12].* Error_code: 1032"); +call mtr.add_suppression("Cannot delete or update a parent row: a foreign key constraint fails .* Error_code: 1451"); +call mtr.add_suppression("Cannot add or update a child row: a foreign key constraint fails .* Error_code: 1452"); +call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.* Duplicate entry .1. for key .PRIMARY.* Error_code: 1062"); SET @old_slave_exec_mode= @@global.slave_exec_mode; === modified file 'mysql-test/suite/rpl/t/rpl_ignore_table.test' --- a/mysql-test/suite/rpl/t/rpl_ignore_table.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_ignore_table.test 2011-02-23 09:31:37 +0000 @@ -125,6 +125,7 @@ show grants for mysqltest4@localhost; # where mysqltest1 does not exist on slave, # to succeed on slave the mode is temporarily changed set global slave_exec_mode='IDEMPOTENT'; +call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table mysql.* Error_code: 1032"); connection master; drop table t1, mysqltest2.t2; === modified file 'mysql-test/suite/rpl/t/rpl_incident.test' --- a/mysql-test/suite/rpl/t/rpl_incident.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_incident.test 2011-02-23 09:31:37 +0000 @@ -15,6 +15,7 @@ SELECT * FROM t1; connection slave; # Wait until SQL thread stops with error LOST_EVENT on master +call mtr.add_suppression("Slave SQL.*The incident LOST_EVENTS occured on the master.* 1590"); let $slave_sql_errno= 1590; let $show_slave_sql_error= 1; source include/wait_for_slave_sql_error.inc; === modified file 'mysql-test/suite/rpl/t/rpl_init_slave_errors.test' --- a/mysql-test/suite/rpl/t/rpl_init_slave_errors.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_init_slave_errors.test 2011-02-23 09:31:37 +0000 @@ -58,7 +58,7 @@ start slave; --let $show_slave_sql_error= 1 --source include/wait_for_slave_sql_error.inc -call mtr.add_suppression("Failed during slave I/O thread initialization"); +call mtr.add_suppression("Failed during slave.* thread initialization"); SET GLOBAL debug= ""; === modified file 'mysql-test/suite/rpl/t/rpl_known_bugs_detection.test' --- a/mysql-test/suite/rpl/t/rpl_known_bugs_detection.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_known_bugs_detection.test 2011-02-23 09:31:37 +0000 @@ -30,6 +30,7 @@ connection slave; #1105 = ER_UNKNOWN_ERROR --let $slave_sql_errno= 1105 --let $show_slave_sql_error= 1 +call mtr.add_suppression("Slave SQL.*suffer.*http:..bugs.mysql.com.bug.php.id=24432"); --source include/wait_for_slave_sql_error.inc # show that it was not replicated SELECT * FROM t1; === modified file 'mysql-test/suite/rpl/t/rpl_loaddata_fatal.test' --- a/mysql-test/suite/rpl/t/rpl_loaddata_fatal.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_loaddata_fatal.test 2011-02-23 09:31:37 +0000 @@ -15,6 +15,7 @@ connection master; LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE t1; connection slave; +call mtr.add_suppression("Slave SQL.*Fatal error: Not enough memory, Error_code: 1593"); let $slave_sql_errno= 1593; let $show_slave_sql_error= 1; source include/wait_for_slave_sql_error_and_skip.inc; === modified file 'mysql-test/suite/rpl/t/rpl_rotate_logs.test' --- a/mysql-test/suite/rpl/t/rpl_rotate_logs.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_rotate_logs.test 2011-02-23 09:31:37 +0000 @@ -93,6 +93,7 @@ set insert_id=1234; insert into t2 values(NULL); connection slave; # 1062 = ER_DUP_ENTRY +call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .1234. for key .PRIMARY.. on query.* Error_code: 1062"); --let $slave_sql_errno= 1062 --source include/wait_for_slave_sql_error_and_skip.inc === modified file 'mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test' --- a/mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test 2011-02-23 09:31:37 +0000 @@ -62,6 +62,7 @@ DROP TABLE t1; --echo **** On Slave **** connection slave; SET GLOBAL QUERY_CACHE_SIZE=0; +call mtr.add_suppression("Slave SQL.*Could not execute Update_rows event on table test.t1.* Error_code: 1032"); --echo **** On Master **** connection master; === modified file 'mysql-test/suite/rpl/t/rpl_row_colSize.test' --- a/mysql-test/suite/rpl/t/rpl_row_colSize.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_row_colSize.test 2011-02-23 09:31:37 +0000 @@ -160,6 +160,9 @@ let $test_table_slave = CREATE TABLE t1 let $test_insert = INSERT INTO t1 VALUES ('This is a test.'); source include/test_fieldsize.inc; +connection slave; +call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 0 ...e mismatch.* Error_code: 1535"); + --echo *** Cleanup *** connection master; DROP TABLE IF EXISTS t1; === modified file 'mysql-test/suite/rpl/t/rpl_row_inexist_tbl.test' --- a/mysql-test/suite/rpl/t/rpl_row_inexist_tbl.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_row_inexist_tbl.test 2011-02-23 09:31:37 +0000 @@ -30,6 +30,7 @@ INSERT INTO t1 VALUES (1); connection slave; # slave should have stopped because can't find table t1 # 1146 = ER_NO_SUCH_TABLE +call mtr.add_suppression("Slave SQL.*Error .Table .test.t1. doesn.t exist. on opening tables, Error_code: 1146"); --let $slave_sql_errno= 1146 --source include/wait_for_slave_sql_error.inc === modified file 'mysql-test/suite/rpl/t/rpl_skip_error.test' --- a/mysql-test/suite/rpl/t/rpl_skip_error.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_skip_error.test 2011-02-23 09:31:37 +0000 @@ -102,6 +102,8 @@ SET SQL_LOG_BIN=1; connection slave; +call mtr.add_suppression("Slave SQL.*Could not execute .*te_rows event on table test.t.; Duplicate entry.* Error_code: 1062"); + CREATE TABLE t1(id INT NOT NULL PRIMARY KEY, data INT) Engine=InnoDB; SHOW CREATE TABLE t1; === modified file 'mysql-test/suite/rpl/t/rpl_slave_grp_exec.test' --- a/mysql-test/suite/rpl/t/rpl_slave_grp_exec.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_slave_grp_exec.test 2011-02-23 09:31:37 +0000 @@ -63,6 +63,7 @@ SELECT * FROM t3 ORDER BY a; --connection slave # 1146 = ER_NO_SUCH_TABLE +call mtr.add_suppression("Slave SQL.*Error .Table .test.t3. doesn.t exist. on.* Error_code: 1146"); --let $slave_sql_errno= 1146 --source include/wait_for_slave_sql_error.inc SHOW TABLES LIKE 't%'; === modified file 'mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test' --- a/mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test 2011-02-23 09:31:37 +0000 @@ -49,5 +49,6 @@ RESET SLAVE; drop table t1; call mtr.add_suppression("Slave: Error writing file 'UNKNOWN' .Errcode: 9. Error_code: 3"); +call mtr.add_suppression("Slave SQL.*Error in Begin_load_query event: write to.* failed, Error_code: 9"); --let $rpl_only_running_threads= 1 --source include/rpl_end.inc === modified file 'mysql-test/suite/rpl/t/rpl_slave_load_tmpdir_not_exist.test' --- a/mysql-test/suite/rpl/t/rpl_slave_load_tmpdir_not_exist.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_slave_load_tmpdir_not_exist.test 2011-02-23 09:31:37 +0000 @@ -11,6 +11,7 @@ --connection slave START SLAVE; # Why 12??? +call mtr.add_suppression("Slave SQL.*Unable to use slave.s temporary directory.* Error_code: 12"); --let $slave_sql_errno= 12 source include/wait_for_slave_sql_error.inc; === modified file 'mysql-test/suite/rpl/t/rpl_temporary_errors.test' --- a/mysql-test/suite/rpl/t/rpl_temporary_errors.test 2010-12-19 17:07:28 +0000 +++ b/mysql-test/suite/rpl/t/rpl_temporary_errors.test 2011-02-23 09:31:37 +0000 @@ -28,6 +28,9 @@ SHOW STATUS LIKE 'Slave_retried_transact SELECT * FROM t1; source include/check_slave_is_running.inc; +connection slave; +call mtr.add_suppression("Slave SQL.*Could not execute Update_rows event on table test.t1"); + --echo **** On Master **** connection master; DROP TABLE t1; --===============1473163865== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/bjorn.munch@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: bjorn.munch@stripped # target_branch: file:///home/bm136801/my/suppsql-51/ # testament_sha1: 71de8639e5c05042248a641ca565328df3ac5306 # timestamp: 2011-02-23 10:32:35 +0100 # base_revision_id: bjorn.munch@stripped\ # w7breae3phkx4fbd # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWUrImRgALiHfgEAQWPf//3/v /+q////wYDdbmskexWqRfcI57z7vnwF6b2tyKABesDkADne4AB3YABbAACgNBkAC2ABtgDQA3RFG mqsBpEAFACQApIaZAgQBRQFEgURsAyqqqJFQ21YZNjE1m1RRIAKAIqZPU8U9TajaNQAAAAAyAAAa MINTCBNMUEaAAAAAAAAAAGmgEUyk9TBpJ4mZFNpHqAAAAAA0CTUghBNEyJ+pk00E9RPUD1A9RoxA PRAHqApUiBGENGiaYRqephNR5SeiaG1GmjRkGmmmgVSCAAQJoAIJkmkpofqnqNppNDIADTUDiAHQ g5uV+cckg825mp2NBucLG6yWkGrqWZaxfS82NSs4EvbbWsZyW7t/FgpBZURYFMCoRZIiQYggKCSq pAt938/j/fpx0/LmHT04V9A0eXTuqwPvTFzwMvJWERxDEsbH6NAMSj5DOqLDVJD3/9rSsHPrz0bG CkCvCikJRds2ILC9FrSlVVBCoOJo7u9miHV+5hZ5WYOzVRHeYupIm5CsbesMtvUvGIVlucGV8XwO z9PQEQASQgREex9AUb2UDEZEhUoqRBWS2pYC0in14M5JiSwhmm8IB+fEJ0nId1g0GSSyQPtL3hZV RO2rLxaS83MSzl62qFWVliIXYc4OBl7XEl3eCXyMq5UZpsKLQhxTU1Ah7mJqyKDmKDllWrDAh8Rn BHd6q9CcYHONm0kcEROCmCwGLVWmxX8KxGVhhfVBk8EA1IAKKoioiqqIooqqrGArEVVYxVRFVVVS RQBEIqJFiqxBWMBURVFiYfrmfoFxxKdvLs0cu3s29fPO7OxupkxfprdkQqSwyc9LQuIkxvsGLb7G cmpYMIZN5pxXEJqQpMyHulGAKFuogj3oQJoiPaoxJE4o2qiWaZv3BRgSsFGN/KTLAzxxfhpT0SWN W1zduAQdksGGSIWcumwMQMw6ZhURyBVKTSa53WFDTa26oDiODZlO5lOm1UzDudnLNWlZkSw6qzLu b6NapTWtaJNqqnLqNF1WDbq5ghCXOCjFS8QwRTiKYBcxEiEDG1UEgOqpgpgi82FZSisqlnGXDM4a VBEqlEU9gjEM1C6cjUTTIFBEEYyPE6iwiDbJ1w6T0Q+z6mwfBihFFgsiiwgh9/x1MPVlN9ZxEEf8 l04LIksJLmH+PiCPax8v831Drr87XM63VrttZmRMn2mbMnVLM0M6sMOt0P6tE+LgHMzlYrUyNjYg yOarcfjr2NW1sa6xb3NWkzPtoq4H6+dac4tRiayeLMnSRdzCZNN2INYcCEnbuUxtIThpDYglCoXF GNqjFbyZIC9tcgdF5etiAtUfEJELCULFoswY0Qi1mtRF2BAdIjupcf5vBcvwTDgiepNQMjzBR390 8OTvcP4ORJ8PQKuRMK0F1NPInwecA3ZfDLBaJkuWticDHn7ff5rzxU156PHo66+DGpQnmXI3Zqn0 EJQGho0koHxH03VmS1ktGE3OKe4kAZhR0iAA/AwJPOcONUjGq3270uy60l7FWabVKtX0Yq6I3YUi j7NiAHnfXt3cvTpr37zrTb0Vvvttr7YNiUUeWhFuadIGyrIFRXutrWwjKbYktSnELaVslQWONkDb TIlwGYK0hQKenkQBJopvMGijSobGGVhisrdWKztNofiiur8k/RgizKh+vPmaHOFZ8vzlflixiqPt BXq9rvX+jbp5XfxdbOyy2y3xEDdbelJD2SHR5pPVg2UJMS1/CZqoqXkz8JPhYsXKriSa1NGSSb+D +hQ/5jMsZQiCPZY+V3CVsByWvl8vSTWxeomqk3pSERHI+yFraxck+iZteWSbPOt69pEliLWLwQGz pVotYPFgbxFE0l7FERCb03Vc4tTYLU00lFGEUKsklHm3IWLWjT3jJxEZv8macUlKWFwc1vrc8K5V vrKmZ1SddcHJm0Ps9jhOoxJ8oooh1DqqdYb4TY7Tke+EkYdkLzORi6GRrb264Hi9GTvrpWlotc5z rmSduLtw5MqyRcAryyt5rMhcnBi4qETJVh+j5WRBB4n6LklUnZVemk8Wgaxt6M0R6WaGJF16b4Rb E0BTlBHmDngDhMUDhQXxtbYrnajFkLcZuDZTjGJiYamtpy55Gr7jntC0MSfInIiQWbloJBwkLQgg HCQiKCgINK2EB0M/d7YV9oSspSxZSrCEQJ1mmgQ8GcUw5ZZhdALWoJrrRhDCGWQ1QARuk7s0bJNG aDA2GFmBlArF9rFO292KRhFrFF0VvMKpw26FSKGCa7qzVYlhEWfCYTbThEGLYmzUTa5LFlQMyUIg WEy+LEycERUqYKbaf844WmwcQ11DYLiFajLCXHOQrROgEyCTUlDYstLFRAtJ5pMjRgvVWr2FrATJ IvTJwi8t1UmSZpq1fTNcZr0pMEkmTL8e1Si21NaJJpF2JyVUXTbuElrVsWGKc02JapExEmBOMCFV YiThYq4XLU2DFmwTXrZyjEWpJFU0SJKIhOLm6TIxWLlWTFjdiZpIhgwmRIrKIwiIiMVhTVmqmmxY prYnKTFQwWGKDEkWsi5VborCxmxb7ylgwYLUjEjIkYxWImYxYIFjDC4tMY1cLrHDdqzhA0KqHC9e 003btFrOSjVmm4Yr2TNI3YJMmLBRe44YKNHssauGiixcwaMFU5M3JotykvaMWzduzTaKpOzeCI/o QDU4n5Q+k5AWNXp6rR/fJ2gEs3zUkhTQ442YWARDRyUrtyM7tcvVLNEh0F+V8NhTlEbj7D0GIayb jYTjcosJKETB7IMlicJlMdtsbAeXBXNPR/x5am5pDVIQJnImjaITZUUWE1juvcl6xdFUojyShD+8 NGXBWInonB7LP+qrZ7Zi5G8sYRA0RQoqNSw5FjBQwN0452S0wNr1ifOM16UR2UtS/0zTshNjym/p GjRbG8oWEnEyqNjWERGWjURNemqWndv3uufDRk0WapLcicxrnC0YoINbJ7MKWHmGV2x2O05VfU4J G+l2SG8SuBLLsFRGq01wBqRpGs2WpMrDV00VqlVmcHi8GXAVL8AFBAJkZJVWOSicaWklIo6VEDCK RLmor05LotySmkmwYmJgjdcyIFb2hOInKeqdEoIi5YoxSSKrkYuix0fx3sOvUtL6dJvWIrubtVtY iHg3TYMTftKZUYt1rBSNMbVKP+Bhmc2dGc6MjBuudVxqqswtasF6jq0uiL20ERawi91ZoxUNF3Zi yomtiTm9xA5sFxYapeXBQowbt1Gxsmqama2vNPqlclTxot/PM0UcYxwSum7WQRGLgsLW/BskqouY XS7xcgNHgsWLlTsjAmktYtk9ng6sYjNKiSbq5N3kgKtHPrcwYt3FG2ticWGKrRRc9rHPFqhCNVyL mus2SlNmqrEQP6P8Hm5QRFhyjrhnRvS561zt8YTo3KceSWDoBQIBKZbQLaPAidBGRg5nItpEyQ8Y RFGaWMLS6DR8anGt6K4XUqwUMykgglsUUNFFG8qUUXBMAiGT0TMKO6IrDe6NljglarCR2N7KUXA2 jYYbyh0zIeTstJK2qRojyTaMGCLvCw2yc8tr525kiRhI8VHpZRox3XQRF+lFVcdGuFX5RYQ7orpY Q0akQPBY6rDhVqq6KKnnH8p2Ln74TcKbqMtqEQKIdOGjCrJa2WLuk3ZJ/e/BJLnY8Orqv1cjBwk/ LF3UM8G7kySSMVv8XEsuanZR05JqMHdg/lJelk3TMZlzzbK3M3VOk2DVJTw4URzfTWMJJYMUsUdm WXVtk1c1GC66ijwfZ5a7LLKUnJtBEWJxGjGbk5OE2zB4MVyaWUJT6sFqM7kYOaysWpTX3tHNzVe/ MmhBRo2ZtU1XHSxsyc01PNsq6KubFRs91jPPxat2CN2Dejmnm1Ws2zZRJwuXqKl7o33tZPFgzXv0 6s1WVi5yauFGT2dP8JP8N03qzcJPprHwxf0sfyd3y/q3RNg+EuST+HdxAaNo/Kr4UbteWJm3c77+ 8dXXLb13VMIJJyqkCXmR1cS0JYrSREB8EWrad+t478cNOKENuHHeFFxNA3FCFjQ000lZOV2Ze0XG DuoTfObF4OGKmWS7mmUEDTBc3cN8ZSlYjVuvJqIvXlypqtbIvNdJ3zaGQge7FGCRNJcXPvJxj9cm rocoaX5RtJEpGxyVsyo5Oa9qwN32bPBrckttwzdS1jM2KQ9kXJs3VRkxX3slil8LUyMkjhJWsros YllyTN+lIv4WS3miHdpSTEqyflh08Jlxe3UfSTNyY08o5vtRxaq3a+ai2fDZ89nZi1USZP23wyEC VWrT9PBarLHVix/KxaxeZ4Oer3ZtmTut8bFrk6NdZd5ylszMno56aXjosaN1tuDBY3WtmSOTHtol O1evcKqKMlVU2C02a6/Tde5tGbJg6GbVguml0cnNttROfJg+7VozbubRoWvVw4bLH92D8tIj8L03 u/L9v3EUft7pHs3iKLnq+nJ4vda/Kx3ju5OGS1+3k/cXur9qvB/hw9HHkdBY7B6vZ5e+7T3eQ83j cceQatttaBghJem+2MVvKrEvRbteRFwlqI3rd7NNF2aabUTIcOBqCCMpJrUzMmtJtEqt0kdk32w5 smebFLB/aRAmky4nKxbyLTZJkbFMq1qm2WtmqSxczM35fnFKsOsjRvdrWVlxM2b5KnivVXrm6TEy km1yNFq63WjNJRNFKNFUkl8STSWSQ58KHJk5Lmb1fLWIRGTdLSiacjdJo0cihwki5VqsaLMUpMFy aJKJJlzhNFDlctOEixRJe4OU03frEYrYxyojFOJEXv3Q4VLFk3ZyJKGKbCyWM1iiijkkbKJzeT+7 u4dly7CUXpCzibhObZRzm4bM25Rduv6yyauxq7JLVatF/VYyVap2EpMIgMkfdG1iWDstZLkn9PZd yS1JsY/h2e0B0ebTo6p+KxR2brXC52WLmi5Y2f0uavBmvUWsmCaSbhayZOy50fZYwlgnPNsxarW7 JZq4WFXqxavzFqajB/Z+H8qu69k7kLljN6Fq59P3w7Sdn8Nr2K1+GLZm8Xw1ixm9047+EvGfhLij z9nptculP6JVrOys6JUaQ6t1bMiTisyciwIgPGcYiH2Z6k7Om63kBBsWKway2w1ULlyPN9rHktbu HEL1VjBf/bNg1YtV082USRhmoIouzu23sWt1j6bplT60dvgQL96peGRySWJMUm7VzaXtVGSrng4b mBkrq5M+cs05rPQhcdFjdQmf3N26CtWUIUbJpM1FFq9czfu2I04j+nVmqsXuOcdJLmzZozxKMHRM kuUbpKPFVMhlAW4cOTKMEvHWCIo+GiZ2cnGDmsKLlzgWMFzyHWXHBe40bGpyucjmcBSX24LSN8l6 hhJWS9om5JsWb6LVrFYsfDoqw6pWJNW6rNc7LFcmC1Jg6rljFmo27cm6xi6Oqbo4bt1GBlliuZrG a9NsvvquWLmqj3YHDDC9ad2abm5NsFru+o/D7O72bpsIj4ei11fZ/Z90nBCbiPvZ0WQEj4Vfdw9I FDmHEFHWNw6hv4jyqOfb2K/DSd2+oIqBgO3B3hcOVli7AuqnsWita3pm8aaNnywW6WCbBaciJ4jy DzpSLIcRak4ichw/nJQ0TM33YFhKJOSxozUc1rONN5S+95iiejZmtpryrTI92BokuaL7T7F5raqk ugiSq+1JRpa/C+xm4WNGi1Jfg5LnKjU2TbqM2iuUOUzRe3VRa2YpFirXPhGLRqzW/jmyPw93EMUi u2SlZS/brltVYtbNnvGWDtdf3mxsSlZballxzi9yc1qb8tWV10obLlWNrq7JsmCnTGU9ppSbq2LG 6jmv8HdVumtURetUTbN2qfviQNIIjJ5Ph1VXOnbd+mLm5MGDkxUdk27hVcwWOjouZH0/dy1kbMEj F+HjksT3aPF9L3Jakq5OTVa1YMn8MTxcLH5eTye7ZM+zF2PohR9PmAvYLT1WvJ8QHDZssfpqtVfw cekcY5hsHpHGOgesemvXDlGcbVWFDP3QOte2UqzIW+M3F14Wtb029eIEA0LQtJdkQ8TxwYDgI8vl 8tlSayCImRi1bPNYxdU4qXS+piizkViipe4xmqcKpNlpYsaMFedm1IiWyxac1kERYkM3DJY2d2e1 V5eaKNUnTNys0WOG5atZLGKyjdyUZmTFk3WOTBYtXpNLmKjNkqlFUly+NsXJZv0sfZgrXmuclrBp lLBzVcmGi7mxUaok3cMVWT7reS9ytf0nz5tC9Xkml0aFqjVVYIHrsQLDdwkuSdn4e7wZKudrdRq8 G65osWOXtHEBewdVyxk8ngtUdX4Zuqjd+X6eacRAdzB0YuHi6ubJh4KrFibZ4M17BRyVbuObV3ez ZN1eTB1ez4i5s6PzASe6jV8ub2fTZ91z4ejyXMX8dZS6NHwo8XfxISd1VGz8uTlHm5OnZ1ntdiu9 W9eWVS++nqRviREGFWeDljLSJ21c20xnyzOL7d+msQ1gSUTAhRuJ44JRcPBJCajBiuWE1jBWPZc9 0lxbIzvvwzz/G7Fgj6TNU2Ki9fayJrWcXcXo5uT4S5sLXNqzjNwub47tCdrFRey4xcNGa5mo3TX8 mV9VyVpybJVrTRi3mtUTYOFqa1kyM9qLm1zZim4bObNsuV4qk4NVxYqsXlzRZezjkyTwb8LmnGG6 1oyXt0mKXgVZNOTBo03cLGrdmqxtl8SclTJo2YqJL2qibJRg5s1F7Rg6MlybJyZKNGqmq8k441VW LG7NskxZtVFjtiYNmDdg4VWM2ajh3TwGgFzrnczK7Y2q8FlTyM5DB3hWYQwWUVGk12vuo0tWG5iw MV6aijFukm/kqTkLmbvoqdk2akRVkkqc0XWRFyTbWbacERO1qi4lZe2ojBevVYOjOTZVVNjSSZY1 UXlEXiBckxSVL3RFyxo2ZReNWy2kYIuYKxg/cr0mvCxV6rmjk4aq4L92VlE5ysd9Wjkm5prFWG0j Bk5MFV6SxRJZJo0wTVamDFe4pu581qZowMGqzHdgqp4pKsFixsk2aJNFrFavWs3DBYtVLl6UUSyW rGii5q0TXrmSxJmqwWMWeC6rgk1Wd4hEXGwgeixED2ISb+T9FH6eyi4xnqDlDyvWkIdXXUlg8tTg lIGMOMgujOg05EMYastFBpkNWeqK15/5qgb2QFhFNZ+KB3/CQAbQ5ZJSsFGIqqDFjFUSMFgKIMFV VRUUFUVFkYeJADnYJahEQTEYYVjBMGKYqViYPd/og+HudsV9XeUNuZ/P+Pr/F/IuBOLBiYWLGBWJ GGP/P1f87OT6tbN3V2DST9oYaNez+Wgtcci1CpQn9OHx/95Nj7vkGpWtwt9/8uRwIEuMYDLJ0sM+ vVlt/nzl3fx0ca7P6cGKi1Zv/du07Swb3/2M+o0Odm4RkY01y19vAukS4zq46Zf17a29vTv6yy79 rGrPabuIlnsMvR7Kh/0wiIz9rOft3MjqjcRbS6iqFTQw0pCjYice8+t+hh8h+yPjYYx+lbOb5u49 Hj8l+pGnwL5H7Mk+q/2WS3iNLW1LBixr07F0LM1N4nwJ9gUrRPLDUjIhLgbiUT9ZOBLkosnDOWpB iS0oy3rI06FDJWlkVJEsVOJEq2CwcYXXsLQAzKL++8AvEWuQ21zoMmEGdYYU0YmUVoASWsELk2gb EyS5MMmTJia8wHh9XwzxZI8T/V5v82CT0VXv9yyeWU2ZAqo/2t1UBgq/1VaP9EnZe2TZP9q5amWL 1i9uo2YJN3+q1YtVXKNFVHDRO1JqsaMmyrE4VWORwm0f+JDNw3bvJJ/f/Ts3auShk5qsnZsyc3RN 4JquSxokwclWDVY7OOLnNV0SWvGI7QSiLGjDDNivbOnQ5tlWLJyd3NVVa5OI+6ESDukiI6PFmxUY u7Ri1XLf547qoupam5ycmhqbn71eLsfgFZ1Z6u7Bev52R8wRGa405JRwkqqwc3o4XtFrN8PJ9mdW TBybuVHyj4jwhAwUaD/7JCp+5tZt/m83d05LqeMH8J6NSpdK3uaQw2fang+DRyi1xWk/3c/evwdh 7nu9i4xDxanp87Q49LrYW1h3SYdj0d6p2125fCryeKKCFDyIaJlPA23iPRdDjxdoIQmw6tm74VjR GCi9FFj/fkyYxHz+cvPt+bLN1rziRd90vyud2zJ/xgiJVzuzpLHBgko/hRRRcudUklyq5/P8/BRV ixXP0sYNGy1qtWNH4eWKTkSZsnCZNqbMGvm7LHD9rL0r1H5bqMmjr13ZXJK1qx4StasHRkdVjkq2 c3JsvTXprnU4YpVYpJ3YMklqab/kzbHTFi/j/phCqjkwWsV7Vc1UWuax6LYDh9iHJ7Ork6tFzdVV s1Td+9zRwsYMUmEScNDV4pqtUlWS9ixYLWqVqZk6L2CjNVjBEVYsWDBzYPF8vR5vy9jzJPCRKSU4 iJpptj3vDze2/e10GEGX9Nzk+S7JR4HU+LvqEdWPoQWP5fg6IdnyUJKI+7d1Tfh9mDZRNk/p+1/2 /0gESnhp793q/B/klCUrX7d165VJR+E1KzwlV9PNWxe9XqwfhauYli5iwVXn5XrEiqTRNYyTTWsV WTRkzTZsXl6Ifb4wYvh/D1boxcOjjNEdE8GLdyZvdVhYk/uuySsXsFEmbRe7KNGSxy5eBGDJm+HR isdnyjo6fXtEIlKBDMhOH/oxdnDN6KvR+mz0fy7r7Vz7sXizSejkeix0YqKOzxYM2a5e3WLCj5sb LPI9VFMXVozZPX1vauTBuzTfL8iEiIHpuj0iJpKIeyKPy83sucKxp72VQtrm9rocn0b1DhMLYxYY sGDIXqiXv5aF6Wk6DNcIPua33fmerWpCBJzjhdEfdHidItD9Pd7vxE7Ef3UXva+DwUJzJaoJHJeU Sgii34yowbPhAej0Zvnz+77H5zTkk9pdtq4sMJsXN2bwRE7kuFFFNn4WLk176WF7VY9Hm5rGCxiu YObo/p2XtWTovSZMmzNi1ei5i5vXzgM1hq5LFrg6OG79s3oQNU2SijRascOq1Y5vBJ5kDs4aOTFc zZqNGzNpeqkyVXJpOaTA5MVFVF6ixisXNIIHBHIIiTJgzc0k02Sa2Ij+R5eUb+SJYNXNi8FViiir pBEfLU6tdnV3VerlAdDo89FIiq1Y2tF6X4cTs0sbXe7aRpdWn2vvJxjayeYa/dHV6u7wdXDs7Njd qmiceEQG0JJJx/JD9vZm9Xi9HR9N2GUBe7eT0fpcYs1mhsNj1ejrejvczyaHvbGfj8HytsZT6VFi XixZkzJlDJBnHjX4MXhlYNDS5E0RckoxxyQHvs9Pfndbe/aNz/HzpEaxEoII3JJpJSnKUSQF6A0Y vBq7MHZw4ij6fh9VwSngkynLKvTHH8tWr8MsE322brmLRuoxfZ9nn/P726w4dGbm5rYk6OpNaqiP vLCSP4k8yc2RSOKJdgbkNjcUbzccyxzOJY5iXXO7uqubsn8O6uEeKc82qTwRadVVy1qsXKsVVUkn D6YLzRVc4VTe5m5tGTBsydTaobHc8h5IPVBpnNVc+KHpjLI1MjAeCDGyQwaGMSHo51m6tkr3iyUV ZeSjw5JYokynGjV9OejBeayzUZs3g4Pyixi7pPIxMHERwZ/iMlGQekOR49rC3wsZnRo5Nnm6O7mt YQbvVdVLFezXmTdm7NP5/ZNb1ksW8dJW+NWjwVWt1jVc9X2+3Cxikk6NWjOERitfD/J/L8vN19T4 YvI/pR/TR5S0//ZsH9mL/vh/TB+1q38C5GsER3UR/L7NJpa5gMGSyZIMWdGRD2M2/i+jrZXe/NWl 8m+q4Mb/TLrxRomyK+mWfyXU/wsMlisDQ2Ou8HlE2Lpr7E0ebuaWGS6O9qlxy/xaoVriGeIySsm9 srrW/7O5znqzdZOeQ2NjS61plYOlZVvkGaX1cav61in0bHMfod8Hi7M+1j8/b9PqkI/hNl3fZRo/ yTJrmzBc8mKl2Vi5V8v2zf0yWJslya1Vc1ZPuaMnm3WLGz9JJvVoscKr3csVcR/DJO9Nyf5f5XOr s8V+rkyYsllFVhzJtXkUVVuZLXVYzVWHg0UYMndRq30KqKsmarJsuarGKbd5MiaTd7tmDyYvcfA/ hNHDZmvUNmDkq4XPRpFzv1/2O7F0XNGTo0XNn8xa8H5giNdcDFVWujFm0ZvNzWL779F2zVwviA8r E6ubo81YiUn3WapRatOrNk5P1EB5/tOEnZizaPlYsfpQYfig9yDzWDgTe6XY3vS9zYt8fP7qplER YiSPTJ+LatIPdzarE30w/l5vs7xFHN8v9jo4Sfp+BA8FCHs9aHcdJqFU0pFSacpMX0sYSQo0SUdY mrN+3gyebyUczW0RW83UvNxdp5NDvdD4c5Pp2bsVDwd4jZ3MFz78mLs8H7Yr1ryUVc1zk93kkubv j+XqzfhDu6u7N9kbOkFPWJTiObm0ersq7LX8M1UvX4T1KQh6HNwvd3vu+7xasYCF72RAarzm84j3 fTo7PdNd/EfZgwj/Mkao/Moj5NWb7sEliq56Oaqj5eDCOTdRzYRHs8Xg6x6tmR9Mm7Y1giOT/J93 3N3s/DR8vh8/pERESyXuSZ3o2f09GNHi/TZY7vs8nrF5d99XAmXq+T56Ly8Wh2SD9RheqafF1tu/ gIOhejuyejso+Xy7P28n4fgeTAQRNFiRNEmx9Qh9M3gobxFx5wgTR89T0YsCcWLy8hUg+FYlKXu0 P/z+v1p1iND7Gz8M4vvRWFghkTitTyex6OZ5Nj3PuWHU+byfNsGv5SHi3E2qsb2bi2GJiSJk0iFd 30/Cwh6vV5sXR9nyo8E2a91YtTGAq/g7ug/1ShApV3ed36wpOlKOT9P0opHDxdHWOIIjhavZs1i5 4t3ZVi6Mn6dHZ+ms1VxuwezN1f2e972cnN2ez/s7kQPBdBEeC1/DyesaNnNa82z6j05PR9noubPs xaPV7u7oyiH06RHg9bXIhcqzUWiBwue6xm/Dzb6yo+leZwd7k+D0fSQ+9eje+0VzPJJqzer4QxRi 6ui12YNlWRCT8r2byTfLByjm0Pl6LmajxREIkt7JQ9D2TRVSVEk5cz4NnZ6vtEck3w2aJRAfT5fZ x0gPa4b4NzSzsnF0xGGFkMVZTBJjCsYMYE2LW3L5VFvA6Hc5z3ud7XJreT3iG1HQ0wbHslZoMRdt QESmKkAO2JADvEloGwgcZPSJuvdVz+Hk/Z3Id43iPgkiIR+8nsl3dzkZPqEROj8xHsQVT8lHuaOR cZs0Ed1UfSA6yO3VeRCxbvFr5q1ef8NV+CVfDmrCII8EiRm9HDs+mjFzYdR93LvBH9JG0obL1JJW MSFhCdEZuF0IFjV266pd3J9Ovu9Fzdm92hD4ez0SeTNi5vVm/DfpCCUoi89XEN+sQHoURErWL3YO GDJ+UbuYRH+zq4yfsiByIXqPZ1iNn4sTeDm3PZKSWz/m0OhBpXWjzphjBYe/K7K8DsVZ2AM7Aaaw Z4FXsmVaihm74rwryhEikTeCyb7vSA1ezqwWOrxeL+WrVAcVji837mbvkNDjvdTi0OWjBQyprtqy KwRIgfT3TpBEfhc6RK+iViN1z4VisLBi7trhdbQl3mb1a3WmHxg1EcHa5mb6XRaOR4vY6D2RI8UQ UOSfYPV+nU8+W92ug8G2mgxBYxUngyvV0vCDOI+FHq92690evaEzAxUd73m/LNoterBu+X0drzle 12svBhvY8Tizdb0YXfSODb2PGDBe8o5s0Idnw2UavhoseCV7YOqR5sH5WFYhhOLCJb3MybOlVmTE TFgmFKwwI7mi0aMrtNrwZ1uufUx3ul5M5TyqwmkwmSwofCoXPIegxPNFpj5px5QiBYjCEXX/CR8R 7t2Z/wSRB4pGDBF3p8rHmgwZxS9EQ3bPlUNAaHued/bFd7Dv9HuJrN5v8ik03c3uTlWnQUPiT0c7 iyJk0G5cV5+EGH0wgwQxcnifI4QcZDsTneN3Pv8oIj3fDwYNF61+Vkfoq2eDMuYugREWE4M24dOF rr4waqKzyammFdmzLk5r8YI5ujNRiyYs0ldErz8+LN7vNktdno/u93S5k4fgxfD7JPVe2iP8LUoI jktZuD7LlURB3dXRY93ibvBYwXRc+zuseSr+z+z8IFzFo+lr6Z2+9iINYIkDSaaLLLPsiTMgMkuA SZlMbkfWPpO42LdZ7BPUeo3GIIUYcFhebC3w0VCwMSGF6vXMearZcjRYckfB8KI8XuZRMvWFhR2a w6LtwoNrDlCskrq+2yg9PRzRXw9U89NUd3++EkyFHOCI+76cnx6OzP6wCDa4eJjpO/B1c/OEIFHm BISfhJ0B9fvWKoUKVS0DAQlUsoRBREURBiKVRQooXgBRQoIijEFBEiIoiWpVWhRAQsEEKKk9v0h0 HzHQsftUZTBYTChiXFYYl83WzY9jcz0/2MnUsPm1Pg7id7wd9WubmG3JiykzEiqSoksT3HzFFpPR WfcGx4AHI0CGKh4ltE9xuCgwGQPnZLh6iqL0O4tLl29i08Xk2ivmwdzJiYomi3Jk+8TRtBEZuy70 ejpMHMw2cVlPj2wfd3M4nlhL3INdXTCuaQ/C9Z4NTDCDawvo63F73bHpilc1VrwN7JTyZOpwU8XP Lk6ng6HtJ7SAHzqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq6dpvDE8/qIQOgyEJPAucpLSFhYY YRh4MkGSx16pTWuh1jwkOs1xsrsZLk9X4tzmitJL8Zz5hWifq+70bKwRHD0eDJ92r+CHu9nV9ePj 5xFTupWDKsBnLIwe2sye/QGTDTr0jlYYAIQ7vedRcuIggk3CUUUCUUUUUXPPshCwGCxQiQFEqEPa anh2FzqOcSS+zwisaPh934aujkbunTEsLRYgJeZBxZVVrXc7mUe5LuqwwshpczNFBD0ZhMR2YtGc yqqb5UUiSgiMl5bnOtq3A+7EuSyyW6S1LDAwaEBO0SICf5cauHyQ6vJeiPdJHLbq5mGb5UaEiHOL yVJSsbPRzbxFogbsz+oD6fyuHU9OjJ5usR2PdavhA9WyXy+whwdLyOx6vR60V7lNxg2ky92Kt+MJ fPxYQNnv7+RNV0ej0ea6I9U1zR5ISiPtFHh5pcI93qkxezo3WtnR3eLwUd7XVr5TNX/rDEgtNX+N DBJD0k6ENUw2VdFjVjBWTraGb7ncudH0/M8NSLqaW0p4tE/LgUO5w9ra9Hmbn+ROeivFeDk8nS7D vNbchSPNsaOcP5SsDm+H/aaKv4fLRKNEnV9Hs0eLFYsYOjk7N1HDmmk8WL8LIiCHpFrlCIi4h94+ Wax4PdJhC6EDdyWM2jJ9L1YDhq0XuHm/Lu4dmDFRo1fZWMHg7pOHd5OSTQ8FW3v05fPnStbLOi53 eiS5w2dI7NERD9R4xHs/hmo5xFr3fR6vw9XZy5Nndi1dFrweMR6vB8r2rumFrs2YMHiQ2fCT7GAX MVjuvauppm1dXmucPJc91WfxtrSU6Wu6bNwxjJm9HQyUZxk3fMBRG7k2ViPVq3c3gboha8Xg1Wrm 7VeiI+lHoq+Vr3esVbRmyeLu2dnNvCA6JIRn4PFyejNQ93/W2uOxzt23vqzqxMUwYrHWYaNHjBnS XIl+0kXLY5tEni+zs9Grs8m77vVu1ezdHpEIjh0e6rVw2dXm3Vj1evi3bOT7LlrmLNHZ1WMklGDl VCr2OrEIauRC2I2Zua7q5Oyj5weLzdHJc93dCBN3cMGsHk3ex6MiHZJjAaOCE3lgx9DYhsm8I9U4 iIJpebo7vR4t3ZiqtfLs3fXkqjBlXn7d3u81rydnJ0dHm5qNn/+LuSKcKEglZEyMAA== --===============1473163865==--