// [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.46/mysql-test: cat t/rpl_bug77932.test --source include/master-slave.inc --echo [On Master with root] --connection master grant usage,select,create routine,execute on test.* to 'miguel'@'%' with grant option; set global log_bin_trust_function_creators=ON; connect(miguel,127.0.0.1,miguel,,test,$MASTER_MYPORT,); --echo [master - as Miguel ] --connection miguel --disable_warnings CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); --enable_warnings --error 1410 GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%'; --echo [On Master with root] --connection master sync_slave_with_master; --echo [On Slave] --connection slave query_vertical SHOW SLAVE STATUS; --echo "Cleanup" --disconnect miguel [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.46/mysql-test: ./mtr rpl_bug77932 defined(@array) is deprecated at lib/mtr_cases.pm line 339. (Maybe you should just omit the defined()?) defined(@array) is deprecated at ./mtr line 493. (Maybe you should just omit the defined()?) Logging: ./mtr rpl_bug77932 150804 15:28:21 [Note] /export/umesh/server/binaries/mysql-5.5.46/bin/mysqld (mysqld 5.5.46) starting as process 6042 ... 150804 15:28:21 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.46 Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.5.46/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc [connection master] [On Master with root] grant usage,select,create routine,execute on test.* to 'miguel'@'%' with grant option; set global log_bin_trust_function_creators=ON; [master - as Miguel ] CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%'; ERROR 42000: You are not allowed to create a user with GRANT [On Master with root] main.rpl_bug77932 [ fail ] Test ended at 2015-08-04 15:28:24 CURRENT_TEST: main.rpl_bug77932 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 588 Binlog_Do_DB Binlog_Ignore_DB ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 598 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 628 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Query caused different errors on master and slave. Error on master: message (format)='You are not allowed to create a user with GRANT' error code=1410 ; Error on slave: actual message='no error', error code=0. Default database: 'test'. Query: 'GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%'' Skip_Counter 0 Exec_Master_Log_Pos 481 Relay_Log_Space 901 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error Query caused different errors on master and slave. Error on master: message (format)='You are not allowed to create a user with GRANT' error code=1410 ; Error on slave: actual message='no error', error code=0. Default database: 'test'. Query: 'GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%'' Replicate_Ignore_Server_Ids Master_Server_Id 1 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:32944 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:32945 db test Command Sleep Time 0 State Info ---- 3. ---- Id 4 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 6 User root Host localhost:32951 db test Command Query Time 0 State Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:32952 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 24: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 598, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-5.5.46/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID; NOW() @@SERVER_ID 2015-08-04 16:28:24 2 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 598 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 628 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Query caused different errors on master and slave. Error on master: message (format)='You are not allowed to create a user with GRANT' error code=1410 ; Error on slave: actual message='no error', error code=0. Default database: 'test'. Query: 'GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%'' Skip_Counter 0 Exec_Master_Log_Pos 481 Relay_Log_Space 901 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master NULL Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error Query caused different errors on master and slave. Error on master: message (format)='You are not allowed to create a user with GRANT' error code=1410 ; Error on slave: actual message='no error', error code=0. Default database: 'test'. Query: 'GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%'' Replicate_Ignore_Server_Ids Master_Server_Id 1 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 588 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 4 system user NULL Connect 0 Waiting for master to send event NULL 8 root localhost NULL Query 0 NULL SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 588 **** SHOW BINLOG EVENTS on default **** binlog_name = 'slave-bin.000001' SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 107 Server ver: 5.5.46-log, Binlog ver: 4 slave-bin.000001 107 Query 1 271 use `test`; grant usage,select,create routine,execute on test.* to 'miguel'@'%' with grant option slave-bin.000001 271 Query 1 471 use `test`; CREATE DEFINER=`miguel`@`%` FUNCTION `hello`(s CHAR(20)) RETURNS char(50) CHARSET latin1 DETERMINISTIC RETURN CONCAT('Hello, ',s,'!') slave-bin.000001 471 Query 1 588 use `test`; GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%' **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'slave-relay-bin.000002' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000002 4 Format_desc 2 107 Server ver: 5.5.46-log, Binlog ver: 4 slave-relay-bin.000002 107 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 151 Format_desc 1 107 Server ver: 5.5.46-log, Binlog ver: 4 slave-relay-bin.000002 254 Query 1 271 use `test`; grant usage,select,create routine,execute on test.* to 'miguel'@'%' with grant option slave-relay-bin.000002 418 Query 1 481 use `test`; CREATE DEFINER=`miguel`@`%` FUNCTION `hello`(s CHAR(20)) RETURNS char(50) CHARSET latin1 DETERMINISTIC RETURN CONCAT('Hello, ',s,'!') slave-relay-bin.000002 628 Query 1 598 use `test`; GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%' == /export/umesh/server/binaries/mysql-5.5.46/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID; NOW() @@SERVER_ID 2015-08-04 16:28:24 1 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 598 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:35227 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 9 root localhost NULL Query 0 NULL SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 598 **** SHOW BINLOG EVENTS on default **** binlog_name = 'master-bin.000001' SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.46-log, Binlog ver: 4 master-bin.000001 107 Query 1 271 use `test`; grant usage,select,create routine,execute on test.* to 'miguel'@'%' with grant option master-bin.000001 271 Query 1 481 use `test`; CREATE DEFINER=`miguel`@`%` FUNCTION `hello`(s CHAR(20)) RETURNS char(50) CHARSET latin1 DETERMINISTIC RETURN CONCAT('Hello, ',s,'!') master-bin.000001 481 Query 1 598 use `test`; GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%' **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info - saving '/export/umesh/server/binaries/mysql-5.5.46/mysql-test/var/log/main.rpl_bug77932/' to '/export/umesh/server/binaries/mysql-5.5.46/mysql-test/var/log/main.rpl_bug77932/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 4 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug77932 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.46/mysql-test: