rpl.rpl_do_grant [ fail ] Test ended at 2010-12-20 22:23:58 CURRENT_TEST: rpl.rpl_do_grant === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 6086 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 21000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 4610 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4667 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 1396 Last_Error Error 'Operation DROP USER failed for 'create_rout_db'@'localhost'' on query. Default database: ''. Query: 'DROP USER 'create_rout_db'@'localhost'' Skip_Counter 0 Exec_Master_Log_Pos 4513 Relay_Log_Space 4927 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 1396 Last_SQL_Error 101221 00:23:58 Error 'Operation DROP USER failed for 'create_rout_db'@'localhost'' on query. Default database: ''. Query: 'DROP USER 'create_rout_db'@'localhost'' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 6b027668-0c7f-11e0-845b-00093d13b608 Master_Info_File /export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 63 User root Host localhost:51526 db test Command Query Time 0 State Info SHOW PROCESSLIST ---- 2. ---- Id 64 User root Host localhost:63621 db test Command Sleep Time 2 State Info ---- 3. ---- Id 65 User system user Host db Command Connect Time 2 State Waiting for master to send event Info ---- 4. ---- Id 67 User root Host localhost:55711 db bug42217_db Command Sleep Time 0 State Info ---- 5. ---- Id 68 User root Host localhost:59428 db test Command Sleep Time 2 State Info ======================== analyze: sync_with_master mysqltest: In included file "./include/rpl_sync.inc": At line 149: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 4610, 300)' returned NULL indicating slave SQL thread failure The result from queries just before the failure was: < snip > SELECT upgrade_alter_func(); upgrade_alter_func() INSIDE upgrade_alter_func() SHOW CREATE FUNCTION upgrade_alter_func; Function sql_mode Create Function character_set_client collation_connection Database Collation upgrade_alter_func CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_alter_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_alter_func()"; END latin1 latin1_swedish_ci latin1_swedish_ci "Should no privilege record for upgrade_alter_func in mysql.procs_priv" SELECT * FROM mysql.procs_priv; Host Db User Routine_name Routine_type Grantor Proc_priv Timestamp SELECT upgrade_alter_func(); ERROR HY000: The user specified as a definer ('create_rout_db'@'localhost') does not exist USE bug42217_db; DROP FUNCTION upgrade_del_func; DROP FUNCTION upgrade_alter_func; DROP DATABASE bug42217_db; DROP USER 'create_rout_db'@'localhost'; include/rpl_reset.inc More results from queries before failure can be found in /export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/log/rpl_do_grant.log == /export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/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, @@SERVER_UUID; NOW() @@SERVER_ID @@SERVER_UUID 2010-12-21 00:23:58 1 6b027668-0c7f-11e0-845b-00093d13b608 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 4610 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 21001 Master_id 1 Slave_UUID 6bebb3d1-0c7f-11e0-845b-00093d13b608 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 65 root localhost:61616 NULL Binlog Dump 2 Master has sent all binlog to slave; waiting for binlog to be updated NULL 70 root localhost NULL Query 0 NULL SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 4610 **** 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 114 Server ver: 5.6.1-m5-debug-log, Binlog ver: 4 master-bin.000001 114 Query 1 182 BEGIN master-bin.000001 182 Query 1 300 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' master-bin.000001 300 Query 1 369 COMMIT master-bin.000001 369 Query 1 437 BEGIN master-bin.000001 437 Query 1 553 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' master-bin.000001 553 Query 1 622 COMMIT master-bin.000001 622 Query 1 701 use `test`; flush privileges master-bin.000001 701 Query 1 825 use `test`; grant select on *.* to rpl_do_grant@localhost master-bin.000001 825 Query 1 950 use `test`; grant drop on test.* to rpl_do_grant@localhost master-bin.000001 950 Query 1 1100 use `test`; SET PASSWORD FOR 'rpl_do_grant'@'localhost'='*9313F3AC73D127EF8B2C6F70435C8C113F50C412' master-bin.000001 1100 Query 1 1168 BEGIN master-bin.000001 1168 Query 1 1290 use `test`; update mysql.user set password='' where user='rpl_do_grant' master-bin.000001 1290 Query 1 1359 COMMIT master-bin.000001 1359 Query 1 1438 use `test`; flush privileges master-bin.000001 1438 Query 1 1588 use `test`; SET PASSWORD FOR 'rpl_do_grant'@'localhost'='*9313F3AC73D127EF8B2C6F70435C8C113F50C412' master-bin.000001 1588 Query 1 1656 BEGIN master-bin.000001 1656 Query 1 1774 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' master-bin.000001 1774 Query 1 1843 COMMIT master-bin.000001 1843 Query 1 1911 BEGIN master-bin.000001 1911 Query 1 2027 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' master-bin.000001 2027 Query 1 2096 COMMIT master-bin.000001 2096 Query 1 2175 use `test`; flush privileges master-bin.000001 2175 Query 1 2276 use `test`; CREATE USER 'rpl_do_grant'@'localhost' master-bin.000001 2276 Query 1 2400 use `test`; rename user rpl_do_grant@localhost to rpl_do_grant2@localhost master-bin.000001 2400 Query 1 2541 use `test`; grant DELETE,INSERT on mysqltest1.* to rpl_do_grant2@localhost master-bin.000001 2541 Query 1 2678 use `test`; revoke DELETE on mysqltest1.* from rpl_do_grant2@localhost master-bin.000001 2678 Query 1 2821 use `test`; revoke all privileges, grant option from rpl_do_grant2@localhost master-bin.000001 2821 Query 1 2917 use `test`; drop user rpl_do_grant2@localhost master-bin.000001 2917 Query 1 2984 BEGIN master-bin.000001 2984 Query 1 3242 use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Slave: Operation DROP USER failed for \'create_rout_db\'@\'localhost\' Error_code: 1396' COLLATE 'latin1_swedish_ci')) master-bin.000001 3242 Query 1 3310 COMMIT master-bin.000001 3310 Query 1 3415 DROP DATABASE IF EXISTS bug42217_db master-bin.000001 3415 Query 1 3513 CREATE DATABASE bug42217_db master-bin.000001 3513 Query 1 3718 use `test`; GRANT CREATE ROUTINE ON bug42217_db.* TO 'create_rout_db'@'localhost' IDENTIFIED BY 'create_rout_db' WITH GRANT OPTION master-bin.000001 3718 Query 1 3965 use `bug42217_db`; CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_del_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_del_func()"; END master-bin.000001 3965 Query 1 4216 use `bug42217_db`; CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_alter_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_alter_func()"; END master-bin.000001 4216 Query 1 4316 use `bug42217_db`; DROP FUNCTION upgrade_del_func master-bin.000001 4316 Query 1 4418 use `bug42217_db`; DROP FUNCTION upgrade_alter_func master-bin.000001 4418 Query 1 4513 DROP DATABASE bug42217_db master-bin.000001 4513 Query 1 4610 DROP USER 'create_rout_db'@'localhost' **** 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 == /export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/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, @@SERVER_UUID; NOW() @@SERVER_ID @@SERVER_UUID 2010-12-21 00:23:58 2 6bebb3d1-0c7f-11e0-845b-00093d13b608 **** 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 21000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 4610 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4667 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 1396 Last_Error Error 'Operation DROP USER failed for 'create_rout_db'@'localhost'' on query. Default database: ''. Query: 'DROP USER 'create_rout_db'@'localhost'' Skip_Counter 0 Exec_Master_Log_Pos 4513 Relay_Log_Space 4927 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 1396 Last_SQL_Error 101221 00:23:58 Error 'Operation DROP USER failed for 'create_rout_db'@'localhost'' on query. Default database: ''. Query: 'DROP USER 'create_rout_db'@'localhost'' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 6b027668-0c7f-11e0-845b-00093d13b608 Master_Info_File /export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 6086 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 65 system user NULL Connect 2 Waiting for master to send event NULL 69 root localhost NULL Query 0 NULL SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 6086 **** 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 114 Server ver: 5.6.1-m5-debug-log, Binlog ver: 4 slave-bin.000001 114 Query 1 182 BEGIN slave-bin.000001 182 Query 1 300 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' slave-bin.000001 300 Query 1 369 COMMIT slave-bin.000001 369 Query 1 437 BEGIN slave-bin.000001 437 Query 1 553 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' slave-bin.000001 553 Query 1 622 COMMIT slave-bin.000001 622 Query 1 701 use `test`; flush privileges slave-bin.000001 701 Query 2 769 BEGIN slave-bin.000001 769 Query 2 891 use `test`; delete from mysql.user where user=_binary'rpl_ignore_grant' slave-bin.000001 891 Query 2 960 COMMIT slave-bin.000001 960 Query 2 1028 BEGIN slave-bin.000001 1028 Query 2 1148 use `test`; delete from mysql.db where user=_binary'rpl_ignore_grant' slave-bin.000001 1148 Query 2 1217 COMMIT slave-bin.000001 1217 Query 2 1296 use `test`; flush privileges slave-bin.000001 1296 Query 1 1420 use `test`; grant select on *.* to rpl_do_grant@localhost slave-bin.000001 1420 Query 1 1545 use `test`; grant drop on test.* to rpl_do_grant@localhost slave-bin.000001 1545 Query 1 1695 use `test`; SET PASSWORD FOR 'rpl_do_grant'@'localhost'='*9313F3AC73D127EF8B2C6F70435C8C113F50C412' slave-bin.000001 1695 Query 1 1763 BEGIN slave-bin.000001 1763 Query 1 1885 use `test`; update mysql.user set password='' where user='rpl_do_grant' slave-bin.000001 1885 Query 1 1954 COMMIT slave-bin.000001 1954 Query 1 2033 use `test`; flush privileges slave-bin.000001 2033 Query 1 2183 use `test`; SET PASSWORD FOR 'rpl_do_grant'@'localhost'='*9313F3AC73D127EF8B2C6F70435C8C113F50C412' slave-bin.000001 2183 Query 1 2251 BEGIN slave-bin.000001 2251 Query 1 2369 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' slave-bin.000001 2369 Query 1 2438 COMMIT slave-bin.000001 2438 Query 1 2506 BEGIN slave-bin.000001 2506 Query 1 2622 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' slave-bin.000001 2622 Query 1 2691 COMMIT slave-bin.000001 2691 Query 1 2770 use `test`; flush privileges slave-bin.000001 2770 Query 2 2838 BEGIN slave-bin.000001 2838 Query 2 2956 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' slave-bin.000001 2956 Query 2 3025 COMMIT slave-bin.000001 3025 Query 2 3093 BEGIN slave-bin.000001 3093 Query 2 3209 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' slave-bin.000001 3209 Query 2 3278 COMMIT slave-bin.000001 3278 Query 2 3357 use `test`; flush privileges slave-bin.000001 3357 Query 1 3458 use `test`; CREATE USER 'rpl_do_grant'@'localhost' slave-bin.000001 3458 Query 1 3582 use `test`; rename user rpl_do_grant@localhost to rpl_do_grant2@localhost slave-bin.000001 3582 Query 1 3723 use `test`; grant DELETE,INSERT on mysqltest1.* to rpl_do_grant2@localhost slave-bin.000001 3723 Query 1 3860 use `test`; revoke DELETE on mysqltest1.* from rpl_do_grant2@localhost slave-bin.000001 3860 Query 1 4003 use `test`; revoke all privileges, grant option from rpl_do_grant2@localhost slave-bin.000001 4003 Query 1 4099 use `test`; drop user rpl_do_grant2@localhost slave-bin.000001 4099 Query 1 4166 BEGIN slave-bin.000001 4166 Query 1 4424 use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Slave: Operation DROP USER failed for \'create_rout_db\'@\'localhost\' Error_code: 1396' COLLATE 'latin1_swedish_ci')) slave-bin.000001 4424 Query 1 4492 COMMIT slave-bin.000001 4492 Query 1 4597 DROP DATABASE IF EXISTS bug42217_db slave-bin.000001 4597 Query 1 4695 CREATE DATABASE bug42217_db slave-bin.000001 4695 Query 1 4900 use `test`; GRANT CREATE ROUTINE ON bug42217_db.* TO 'create_rout_db'@'localhost' IDENTIFIED BY 'create_rout_db' WITH GRANT OPTION slave-bin.000001 4900 Query 1 5121 use `bug42217_db`; CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_del_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_del_func()"; END slave-bin.000001 5121 Query 2 5196 BEGIN slave-bin.000001 5196 Query 2 5294 use `bug42217_db`; DELETE FROM mysql.procs_priv slave-bin.000001 5294 Query 2 5370 COMMIT slave-bin.000001 5370 Query 2 5456 use `bug42217_db`; FLUSH PRIVILEGES slave-bin.000001 5456 Query 2 5564 use `bug42217_db`; DROP USER 'create_rout_db'@'localhost' slave-bin.000001 5564 Query 1 5789 use `bug42217_db`; CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_alter_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_alter_func()"; END slave-bin.000001 5789 Query 1 5889 use `bug42217_db`; DROP FUNCTION upgrade_del_func slave-bin.000001 5889 Query 1 5991 use `bug42217_db`; DROP FUNCTION upgrade_alter_func slave-bin.000001 5991 Query 1 6086 DROP DATABASE bug42217_db **** 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 114 Server ver: 5.6.1-m5-debug-log, Binlog ver: 4 slave-relay-bin.000002 114 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 158 Format_desc 1 114 Server ver: 5.6.1-m5-debug-log, Binlog ver: 4 slave-relay-bin.000002 268 Query 1 182 BEGIN slave-relay-bin.000002 336 Query 1 300 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' slave-relay-bin.000002 454 Query 1 369 COMMIT slave-relay-bin.000002 523 Query 1 437 BEGIN slave-relay-bin.000002 591 Query 1 553 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' slave-relay-bin.000002 707 Query 1 622 COMMIT slave-relay-bin.000002 776 Query 1 701 use `test`; flush privileges slave-relay-bin.000002 855 Query 1 825 use `test`; grant select on *.* to rpl_do_grant@localhost slave-relay-bin.000002 979 Query 1 950 use `test`; grant drop on test.* to rpl_do_grant@localhost slave-relay-bin.000002 1104 Query 1 1100 use `test`; SET PASSWORD FOR 'rpl_do_grant'@'localhost'='*9313F3AC73D127EF8B2C6F70435C8C113F50C412' slave-relay-bin.000002 1254 Query 1 1168 BEGIN slave-relay-bin.000002 1322 Query 1 1290 use `test`; update mysql.user set password='' where user='rpl_do_grant' slave-relay-bin.000002 1444 Query 1 1359 COMMIT slave-relay-bin.000002 1513 Query 1 1438 use `test`; flush privileges slave-relay-bin.000002 1592 Query 1 1588 use `test`; SET PASSWORD FOR 'rpl_do_grant'@'localhost'='*9313F3AC73D127EF8B2C6F70435C8C113F50C412' slave-relay-bin.000002 1742 Query 1 1656 BEGIN slave-relay-bin.000002 1810 Query 1 1774 use `test`; delete from mysql.user where user=_binary'rpl_do_grant' slave-relay-bin.000002 1928 Query 1 1843 COMMIT slave-relay-bin.000002 1997 Query 1 1911 BEGIN slave-relay-bin.000002 2065 Query 1 2027 use `test`; delete from mysql.db where user=_binary'rpl_do_grant' slave-relay-bin.000002 2181 Query 1 2096 COMMIT slave-relay-bin.000002 2250 Query 1 2175 use `test`; flush privileges slave-relay-bin.000002 2329 Query 1 2276 use `test`; CREATE USER 'rpl_do_grant'@'localhost' slave-relay-bin.000002 2430 Query 1 2400 use `test`; rename user rpl_do_grant@localhost to rpl_do_grant2@localhost slave-relay-bin.000002 2554 Query 1 2541 use `test`; grant DELETE,INSERT on mysqltest1.* to rpl_do_grant2@localhost slave-relay-bin.000002 2695 Query 1 2678 use `test`; revoke DELETE on mysqltest1.* from rpl_do_grant2@localhost slave-relay-bin.000002 2832 Query 1 2821 use `test`; revoke all privileges, grant option from rpl_do_grant2@localhost slave-relay-bin.000002 2975 Query 1 2917 use `test`; drop user rpl_do_grant2@localhost slave-relay-bin.000002 3071 Query 1 2984 BEGIN slave-relay-bin.000002 3138 Query 1 3242 use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Slave: Operation DROP USER failed for \'create_rout_db\'@\'localhost\' Error_code: 1396' COLLATE 'latin1_swedish_ci')) slave-relay-bin.000002 3396 Query 1 3310 COMMIT slave-relay-bin.000002 3464 Query 1 3415 DROP DATABASE IF EXISTS bug42217_db slave-relay-bin.000002 3569 Query 1 3513 CREATE DATABASE bug42217_db slave-relay-bin.000002 3667 Query 1 3718 use `test`; GRANT CREATE ROUTINE ON bug42217_db.* TO 'create_rout_db'@'localhost' IDENTIFIED BY 'create_rout_db' WITH GRANT OPTION slave-relay-bin.000002 3872 Query 1 3965 use `bug42217_db`; CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_del_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_del_func()"; END slave-relay-bin.000002 4119 Query 1 4216 use `bug42217_db`; CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_alter_func`() RETURNS char(30) CHARSET latin1 BEGIN RETURN "INSIDE upgrade_alter_func()"; END slave-relay-bin.000002 4370 Query 1 4316 use `bug42217_db`; DROP FUNCTION upgrade_del_func slave-relay-bin.000002 4470 Query 1 4418 use `bug42217_db`; DROP FUNCTION upgrade_alter_func slave-relay-bin.000002 4572 Query 1 4513 DROP DATABASE bug42217_db slave-relay-bin.000002 4667 Query 1 4610 DROP USER 'create_rout_db'@'localhost' - saving '/export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/log/rpl.rpl_do_grant/' to '/export/home/pb2/test/sb_1-2698285-1292879783.45/mysql-5.6.1-m5-freebsd7.0-i386-test/mysql-test/var-n_mix/log/rpl.rpl_do_grant/' Retrying test rpl.rpl_do_grant, attempt(2/3)... rpl.rpl_do_grant [ retry-fail ]