• Luis Soares's avatar
    BUG#48048: Deprecated constructs need removal in Betony · 10a54062
    Luis Soares authored
    NOTE: Backport of:
    
    bzr log -r revid:sp1r-serg@sergbook.mysql.com-20070505200319-38337
    ------------------------------------------------------------
    revno: 2469.263.4
    committer: serg@sergbook.mysql.com
    timestamp: Sat 2007-05-05 13:03:19 -0700
    message:
      Removing deprecated features:
      --master-XXX command-line options
      log_bin_trust_routine_creators
      table_type
      BACKUP TABLE ...
      RESTORE TABLE ...
      SHOW PLUGIN
      LOAD TABLE ... FROM MASTER
      LOAD DATA FROM MASTER
      SHOW INNODB STATUS
      SHOW MUTEX STATUS
      SHOW TABLE TYPES
      ... TIMESTAMP(N)
      ... TYPE=engine
      
      RESET SLAVE don't reset connection parameters anymore
      LOAD DATA: check opt_secure_file_priv before access(filename)
      improved WARN_DEPRECATED macro
    
    10a54062
rpl_reset_slave.test 3.03 KB
# TBF - difference in row level logging
# Temp tables are not replicated in rbr, but it is still good to hit rbr with everthing

# See SHOW SLAVE STATUS displays well after RESET SLAVE (it should display the
# --master-* options from mysqld, as this is what is going to be used next time
# slave threads will be started). In bug 985, it displayed old values (of before
# RESET SLAVE).
# See if slave crashes when doing a CREATE TEMPORARY TABLE twice, separated by
# RESET SLAVE.

-- source include/master-slave.inc
connection master;
save_master_pos;
connection slave;
sync_with_master;
source include/show_slave_status2.inc;

stop slave;
change master to master_user='test';
source include/show_slave_status2.inc;

reset slave;
source include/show_slave_status2.inc;

change master to master_user='root';
start slave;
sync_with_master;
source include/show_slave_status2.inc;

# test of crash with temp tables & RESET SLAVE
# (test to see if RESET SLAVE clears temp tables in memory and disk)
stop slave;
reset slave;
start slave;
connection master;
create temporary table t1 (a int);
save_master_pos;
connection slave;
sync_with_master;
stop slave;
reset slave;
start slave;
sync_with_master;
show status like 'slave_open_temp_tables';

#
#Bug#34654  	RESET SLAVE does not clear LAST_IO_Err* 
#

# clearing the status
stop slave;
reset slave;
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
echo *** errno must be zero: $last_io_errno ***;

#
# verifying start slave resets Last_IO_Error and Last_IO_Errno.
#

change master to master_user='impossible_user_name';
start slave;
source include/wait_for_slave_io_error.inc;
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
--disable_query_log
eval SELECT $last_io_errno > 0 as ONE;
--enable_query_log

source include/stop_slave.inc;
change master to master_user='root';
source include/start_slave.inc;
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
let $last_io_error= query_get_value(SHOW SLAVE STATUS, Last_IO_Error, 1);
--echo *** last errno must be  zero: $last_io_errno ***
--echo *** last error must be blank: $last_io_error ***

#
# verifying reset slave resets Last_{IO,SQL}_Err{or,no}
#

source include/stop_slave.inc;
change master to master_user='impossible_user_name';
start slave;
source include/wait_for_slave_io_error.inc;
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
--disable_query_log
eval SELECT $last_io_errno > 0 as ONE;
--enable_query_log

source include/stop_slave.inc;
reset slave;
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
let $last_io_error= query_get_value(SHOW SLAVE STATUS, Last_IO_Error, 1);
let $last_sql_errno= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1);
let $last_sql_error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Error, 1);
--echo *** io  last errno must be  zero: $last_io_errno  ***
--echo *** io  last error must be blank: $last_io_error  ***
--echo *** sql last errno must be  zero: $last_sql_errno ***
--echo *** sql last error must be blank: $last_sql_error ***