55 lines
2.0 KiB
Plaintext
55 lines
2.0 KiB
Plaintext
-- source include/have_ndb.inc
|
|
-- source suite/ndb/include/backup_restore_setup.inc
|
|
|
|
# Store initial counts of both detected and synchronized objects
|
|
--let $initial_detected_count = query_get_value(SHOW STATUS LIKE 'Ndb_metadata_detected_count', Value, 1)
|
|
--let $initial_synced_count = query_get_value(SHOW STATUS LIKE 'Ndb_metadata_synced_count', Value, 1)
|
|
# Turn auto sync on with a low interval so changes are detected quickly
|
|
SET @old_ndb_metadata_check = @@global.ndb_metadata_check;
|
|
SET @old_ndb_metadata_check_interval = @@global.ndb_metadata_check_interval;
|
|
SET GLOBAL ndb_metadata_check = true;
|
|
SET GLOBAL ndb_metadata_check_interval = 0;
|
|
|
|
--exec $NDB_RESTORE -b 1 -n 1 -p 1 -m -r $NDB_SAVED_BACKUPS/51_dd >> $NDB_TOOLS_OUTPUT
|
|
--exec $NDB_RESTORE -e -b 1 -n 2 -p 1 -r $NDB_SAVED_BACKUPS/51_dd >> $NDB_TOOLS_OUTPUT
|
|
|
|
--disable_query_log
|
|
call mtr.add_suppression("NDB: Table upgrade required");
|
|
call mtr.add_suppression("NDB: Table definition contains obsolete data types");
|
|
call mtr.add_suppression("NDB: Failed to migrate table");
|
|
call mtr.add_suppression("NDB: Got error '1296: Table definition contains obsolete data types");
|
|
--enable_query_log
|
|
|
|
# Wait until the following 3 object changes are detected:
|
|
# Logfile group 'lg'
|
|
# Tablespace 'ts'
|
|
# Table 'test.t1'
|
|
--let $expected_changes = 3
|
|
--let $max_wait = 30
|
|
--source wait_metadata_changes_detected.inc
|
|
|
|
# Wait until the changes detected have been synced
|
|
--let $max_wait = 30
|
|
--source wait_metadata_synced.inc
|
|
|
|
--error ER_NO_SUCH_TABLE
|
|
SHOW CREATE TABLE t1;
|
|
SHOW WARNINGS;
|
|
|
|
--exec $NDB_DROP_TABLE --no-defaults -d test t1 >> $NDB_TOOLS_OUTPUT
|
|
|
|
# Wait until the blacklist is empty
|
|
--let $max_wait = 30
|
|
--source wait_metadata_sync_blacklist_empty.inc
|
|
|
|
# Reset metadata check values
|
|
SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
|
|
SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
|
|
|
|
ALTER TABLESPACE ts
|
|
DROP DATAFILE 'datafile.dat';
|
|
DROP TABLESPACE ts;
|
|
DROP LOGFILE GROUP lg
|
|
ENGINE NDB;
|
|
--remove_file $NDB_TOOLS_OUTPUT
|