set @save_debug= @@global.debug; # Test that the schema dist client waits properly # for the coordinator to complete the distribution # and release all references to the schema object # Delay release of ndb_schema_object after coordinator has completed set global debug='+d,ndb_delay_schema_obj_release_after_coord_complete'; # Run DDLs on the same schema objects and verify that they succeed. CREATE DATABASE IF NOT EXISTS tmp_db; CREATE DATABASE IF NOT EXISTS tmp_db; Warnings: Note 1007 Can't create database 'tmp_db'; database exists # Cleanup set global debug= @save_debug; DROP DATABASE IF EXISTS tmp_db; # # Test to check if the Client thread is hung, when the coordinator # did not receive the schema operation. # CREATE TABLE t1 (a INT) ENGINE NDB; # Now, make the coordinator ignore the schema operation set global debug="+d,ndb_schema_op_start_timeout"; call mtr.add_suppression("Schema dist client detected timeout"); call mtr.add_suppression("Failed to distribute"); # Execute any DDL on table t1 ALTER TABLE t1 ADD b INT; Warnings: Warning 1296 Node 49: 'Client detected timeout' Warning 1296 Schema distribution failed # Reset coordinator to handle all schema operations set global debug="-d,ndb_schema_op_start_timeout"; include/assert_grep.inc [Verify if ndb_schema_dist_timeout triggered by schema distribution client.] # # Test to simulate the case when client thread # detects timeout, but before freeing the schema object # Coordinator receives the schema event # set global debug="+d,ndb_stale_event_with_schema_obj"; call mtr.add_suppression("Schema dist client detected timeout"); call mtr.add_suppression("Distribution of '.*' - client timeout"); call mtr.add_suppression("Failed to distribute"); # Execute any DDL on table t1 ALTER TABLE t1 ADD i INT; Warnings: Warning 1296 Node 49: 'Client detected timeout' Warning 1296 Schema distribution failed set global debug="-d,ndb_stale_event_with_schema_obj"; include/assert_grep.inc [Verify that schema distribution client detected timeout] include/assert_grep.inc [Verify that coordinator received event after client timeout] DROP TABLE t1;