| 1 |
CREATE TABLE t ENGINE=memory AS SELECT 1; |
| 2 |
CHANGE MASTER TO master_host='127.0.0.1'; |
| 3 |
# restart: --read-only=TRUE --skip-slave-start |
| 4 |
SELECT * FROM t; |
| 5 |
1 |
| 6 |
FOUND 1 /\[Warning\] .+?memory table.+?TRUNCATE/ in mysqld.1.err |
| 7 |
RESET SLAVE ALL; |
| 8 |
CHANGE MASTER 'pseudo-upstream' TO master_host='127.0.0.1'; |
| 9 |
# restart: --read-only=TRUE --skip-slave-start |
| 10 |
SELECT * FROM t; |
| 11 |
1 |
| 12 |
FOUND 2 /\[Warning\] .+?memory table.+?TRUNCATE/ in mysqld.1.err |
| 13 |
SET @@GLOBAL.read_only= FALSE; |
| 14 |
RESET SLAVE 'pseudo-upstream' ALL; |
| 15 |
DROP TABLE t; |
| 16 |
CALL mtr.add_suppression("\[Warning\] .+?memory table.+?TRUNCATE"); |