Bug #72163 Rev 5774 broke rpl_plugin_load
Submitted: 30 Mar 2014 7:14 Modified: 29 Oct 2014 11:03
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.6.17 OS:Any
Assigned to: CPU Architecture:Any
Tags: example, mtr, regression

[30 Mar 2014 7:14] Laurynas Biveinis
Description:
Rev 5774 updated rpl_plugin_load.test but not rpl_plugin_load.result.

5.6$ bzr log -r 5774
------------------------------------------------------------
revno: 5774
committer: Manish Kumar<manish.4.kumar@oracle.com>
branch nick: mysql-5.6
timestamp: Mon 2014-01-27 15:27:21 +0530
message:
  WL#7205 - Make the MTR rpl suite GTID_MODE agnostic
                    
  This worklog aims at making the MTR rpl suite GTID_MODE
  agnostic, so that we can have run it daily on pushbuild with
  --gtid-mode=ON.

How to repeat:
cmake -DWITH_EXAMPLE_STORAGE_ENGINE=ON && make
./mysql-test-run rpl_plugin_load
...
rpl.rpl_plugin_load 'mix'                [ fail ]
        Test ended at 2014-03-30 10:09:20

CURRENT_TEST: rpl.rpl_plugin_load
--- /home/laurynas/percona/src/5.6/mysql-test/suite/rpl/r/rpl_plugin_load.result	2013-08-02 13:41:26.674173000 +0300
+++ /home/laurynas/percona/src/5.6/obj-debug/mysql-test/var/log/rpl_plugin_load.reject	2014-03-30 10:09:20.731918178 +0300
@@ -18,6 +18,7 @@
 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
 ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
 EXAMPLE	YES	Example storage engine	NO	NO	NO
+include/sync_slave_sql_with_master.inc
 connection slave: Verify that example engine is not installed.
 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
 ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
@@ -32,5 +33,6 @@
 Verify that example engine is not installed.
 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
 ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
+include/sync_slave_sql_with_master.inc
 include/rpl_end.inc
 End of test

Suggested fix:
=== modified file 'mysql-test/suite/rpl/r/rpl_plugin_load.result'
--- mysql-test/suite/rpl/r/rpl_plugin_load.result	2013-05-29 10:37:30 +0000
+++ mysql-test/suite/rpl/r/rpl_plugin_load.result	2014-03-30 07:13:13 +0000
@@ -18,6 +18,7 @@
 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
 ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
 EXAMPLE	YES	Example storage engine	NO	NO	NO
+include/sync_slave_sql_with_master.inc
 connection slave: Verify that example engine is not installed.
 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
 ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
@@ -32,5 +33,6 @@
 Verify that example engine is not installed.
 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
 ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
+include/sync_slave_sql_with_master.inc
 include/rpl_end.inc
 End of test
[30 Mar 2014 20:33] MySQL Verification Team
Hello Laurynas,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[29 Oct 2014 11:03] Laurynas Biveinis
5.7.5 is OK