101 lines
2.3 KiB
Plaintext
101 lines
2.3 KiB
Plaintext
-- source include/have_ndb.inc
|
|
-- source include/have_debug.inc
|
|
|
|
connect (server1,127.0.0.1,root,,test,$MYSQLD1_PORT,);
|
|
connect (server2,127.0.0.1,root,,test,$MYSQLD2_PORT,);
|
|
connect (server3,127.0.0.1,root,,test,$MYSQLD3_PORT,);
|
|
connect (server4,127.0.0.1,root,,test,$MYSQLD4_PORT,);
|
|
|
|
disable_query_log;
|
|
disable_result_log;
|
|
|
|
set @save_debug= @@global.debug;
|
|
|
|
--connection server1
|
|
set global debug='+d,ndb_binlog_random_tableid';
|
|
--connection server2
|
|
set global debug='+d,ndb_binlog_random_tableid';
|
|
--connection server3
|
|
set global debug='+d,ndb_binlog_random_tableid';
|
|
--connection server4
|
|
set global debug='+d,ndb_binlog_random_tableid';
|
|
|
|
let $1=10;
|
|
while ($1)
|
|
{
|
|
--connection server1
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
--connection server2
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
--connection server3
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
--connection server4
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
|
|
--connection server1
|
|
reap;
|
|
--connection server2
|
|
reap;
|
|
--connection server3
|
|
reap;
|
|
--connection server4
|
|
reap;
|
|
|
|
dec $1;
|
|
}
|
|
|
|
--echo Bug#25557263
|
|
--echo
|
|
--echo Another variant of the 'WAITING MAX 119 SEC FOR DISTRIBUTING' timeout
|
|
--echo was sometimes provoked with this testcase. This time caused by
|
|
--echo a race condition between the schema changing client and the
|
|
--echo 'coordinator' on the same mysqld.
|
|
|
|
--connection server1
|
|
set global debug='+d,ndb_binlog_schema_object_race';
|
|
--connection server2
|
|
set global debug='+d,ndb_binlog_schema_object_race';
|
|
--connection server3
|
|
set global debug='+d,ndb_binlog_schema_object_race';
|
|
--connection server4
|
|
set global debug='+d,ndb_binlog_schema_object_race';
|
|
|
|
let $1=10;
|
|
while ($1)
|
|
{
|
|
--connection server1
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
--connection server2
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
--connection server3
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
--connection server4
|
|
send CREATE DATABASE IF NOT EXISTS tmp_db;
|
|
|
|
--connection server1
|
|
reap;
|
|
--connection server2
|
|
reap;
|
|
--connection server3
|
|
reap;
|
|
--connection server4
|
|
reap;
|
|
|
|
dec $1;
|
|
}
|
|
|
|
--connection server1
|
|
set global debug= @save_debug;
|
|
--connection server2
|
|
set global debug= @save_debug;
|
|
--connection server3
|
|
set global debug= @save_debug;
|
|
--connection server4
|
|
set global debug= @save_debug;
|
|
|
|
enable_query_log;
|
|
enable_result_log;
|
|
|
|
--connection server1
|
|
DROP DATABASE IF EXISTS tmp_db;
|