--source connect.inc --source include/have_debug.inc --source suite/ndb/include/backup_restore_setup.inc # # This test focuses on the metadata sync related performance schema # tables: ndb_sync_pending_objects and ndb_sync_excluded_objects # # Create metadata CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'lg1_undofile.dat' INITIAL_SIZE 1M UNDO_BUFFER_SIZE = 1M ENGINE NDB; CREATE TABLESPACE ts1 ADD DATAFILE 'ts1_datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 2M ENGINE NDB; CREATE TABLE t1 ( a INT PRIMARY KEY, b INT ) ENGINE NDB TABLESPACE ts1 STORAGE DISK; CREATE TABLE t2 ( a INT PRIMARY KEY, b VARCHAR(255) ) ENGINE NDB; CREATE TABLE t3 ( a INT PRIMARY KEY, b VARCHAR(255) ) ENGINE NDB; CREATE DATABASE db1; CREATE TABLE db1.t1 ( a INT PRIMARY KEY, b VARCHAR(255) ) ENGINE NDB; --echo Backup --disable_query_log --source include/ndb_backup.inc --enable_query_log # Drop metadata DROP TABLE t1,t2,t3; DROP DATABASE db1; ALTER TABLESPACE ts1 DROP DATAFILE 'ts1_datafile.dat'; DROP TABLESPACE ts1; DROP LOGFILE GROUP lg1 ENGINE NDB; --echo Restore backup into NDB Dictionary --exec $NDB_RESTORE -b $the_backup_id -n 1 -m $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT # 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) --disable_query_log # Skip synchronization of detected objects to obtain deterministic results # in the ndb_sync_pending_objects table SET GLOBAL debug = '+d,skip_ndb_metadata_sync'; # Enable metadata check with no 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_interval = 0; SET GLOBAL ndb_metadata_check = true; --enable_query_log --echo Wait until the following 6 object changes are detected: --echo - Logfile group 'lg1' --echo - Tablespace 'ts1' --echo - Schema 'db1' --echo - Table 'test.t1' --echo - Table 'test.t2' --echo - Table 'test.t3' --let $expected_changes = 6 --let $max_wait = 60 --source wait_metadata_changes_detected.inc --disable_query_log # Reset values SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check; SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval; --enable_query_log --sorted_result SELECT * FROM performance_schema.ndb_sync_pending_objects; # Enable sync again with the injected failures resulting in the # ndb_sync_excluded_objects table being populated --disable_query_log SET GLOBAL debug = '+d,ndb_metadata_sync_fail'; SET GLOBAL debug = '-d,skip_ndb_metadata_sync'; --enable_query_log --echo Wait until the changes detected have been synced --let $max_wait = 60 --source wait_metadata_synced.inc # Verify that the objects have been excluded --sorted_result SELECT * FROM performance_schema.ndb_sync_excluded_objects; # Remove injected failure --disable_query_log ONCE SET GLOBAL debug = '-d,ndb_metadata_sync_fail'; --echo Restart MySQL server to synchronize metadata let $mysqld_name=mysqld.1.1; --source include/restart_mysqld.inc # Clean-up DROP TABLE t1,t2,t3; DROP DATABASE db1; ALTER TABLESPACE ts1 DROP DATAFILE 'ts1_datafile.dat'; DROP TABLESPACE ts1; DROP LOGFILE GROUP lg1 ENGINE NDB; --source suite/ndb/include/backup_restore_cleanup.inc --remove_file $NDB_TOOLS_OUTPUT