2
# mysql-test-run - originally written by Matt Wagner <matt@mysql.com>
3
# modified by Sasha Pachev <sasha@mysql.com>
4
# Slightly updated by Monty
5
# Cleaned up again by Matt
7
# List of failed cases (--force) backported from 4.1 by Joerg
10
#echo "##################################################";
11
#echo "This script is deprecated and will soon be removed";
12
#echo "Use mysql-test-run.pl instead";
13
#echo "##################################################";
24
TZ=$MY_TZ; export TZ # for UNIX_TIMESTAMP tests to work
25
LOCAL_SOCKET=@MYSQL_UNIX_ADDR@
27
if [ -z "$MYSQL_TCP_PORT" ]; then
28
MYSQL_TCP_PORT=@MYSQL_TCP_PORT@
29
if [ @MYSQL_TCP_PORT_DEFAULT@ -eq 0 ]; then
30
ESP=`getent services mysql/tcp`
32
MYSQL_TCP_PORT=`echo "$ESP"|sed -e's-^[a-z]*[ ]*\([0-9]*\)/[a-z]*$-\1-g'`
39
# For query_cache test
41
SCO_SV | UnixWare | OpenUNIX )
42
# do nothing (Causes strange behavior)
45
# do nothing (avoid error message)
58
PATH=/bin:/usr/bin:/usr/local/bin:/usr/bsd:/usr/X11R6/bin:/usr/openwin/bin:/usr/bin/X11:$PATH
59
MASTER_40_ARGS="--rpl-recovery-rank=1 --init-rpl-role=master"
65
IFS="${IFS= }"; save_ifs="$IFS"; IFS=':'
76
echo "Fatal error: Cannot find program $file in $PATH" 1>&2
84
sleep_until_file_deleted ()
88
loop=$SLEEP_TIME_FOR_DELETE
89
while (test $loop -gt 0)
100
loop=`expr $loop - 1`
104
sleep_until_file_created ()
109
while (test $loop -gt 0)
116
loop=`expr $loop - 1`
118
echo "ERROR: $file was not created in $org_time seconds; Aborting"
127
#$WAIT_PID pid $SLEEP_TIME_FOR_DELETE
130
# Check that valgrind is installed
133
FIND_VALGRIND=`which valgrind` # this will print an error if not found
134
# Give good warning to the user and stop
135
if [ -z "$FIND_VALGRIND" ] ; then
136
$ECHO "You need to have the 'valgrind' program in your PATH to run mysql-test-run with option --valgrind. Valgrind's home page is http://valgrind.kde.org ."
139
# >=2.1.2 requires the --tool option, some versions write to stdout, some to stderr
140
valgrind --help 2>&1 | grep "\-\-tool" > /dev/null && FIND_VALGRIND="$FIND_VALGRIND --tool=memcheck"
141
FIND_VALGRIND="$FIND_VALGRIND --alignment=8 --leak-check=yes --num-callers=16 --suppressions=$MYSQL_TEST_DIR/valgrind.supp"
144
# No paths below as we can't be sure where the program is!
148
BASENAME=`which basename`
149
if test $? != 0; then exit 1; fi
150
DIFF=`which diff | $SED q`
151
if test $? != 0; then exit 1; fi
156
ECHO=echo # use internal echo if possible
157
EXPR=expr # use internal if possible
160
if test $? != 0; then exit 1; fi
163
if test $? != 0; then exit 1; fi
166
if test $? != 0; then exit 1; fi
169
# Are we using a source or a binary distribution?
172
if [ -d bin/mysqld ] && [ -d mysql-test ] ; then
175
if [ -d $testdir/mysql-test ] ; then
180
if [ ! -f ./mysql-test-run ] ; then
181
$ECHO "Can't find the location for the mysql-test-run script"
183
$ECHO "Go to to the mysql-test directory and execute the script as follows:"
184
$ECHO "./mysql-test-run."
192
# BASEDIR is always above mysql-test directory ...
196
if [ -d ./sql ] ; then
201
# ... one level for tar.gz, two levels for a RPM installation
202
if [ ! -f ./bin/mysql_upgrade ] ; then
203
# Has to be RPM installation
210
MYSQL_TEST_WINDIR=$MYSQL_TEST_DIR
211
MYSQLTEST_VARDIR=$MYSQL_TEST_DIR/var
212
export MYSQL_TEST_DIR MYSQL_TEST_WINDIR MYSQLTEST_VARDIR
213
STD_DATA=$MYSQL_TEST_DIR/std_data
214
hostname=`hostname` # Installed in the mysql privilege table
216
MANAGER_QUIET_OPT="-q"
217
TESTDIR="$MYSQL_TEST_DIR/t"
228
MYSQL_TMP_DIR=$MYSQL_TEST_DIR/var/tmp
231
# Use a relative path for where the slave will find the dumps
232
# generated by "LOAD DATA" on the master. The path is relative
233
# since it must have fixed length to test logging
234
# i.e otherwise the output from "SHOW MASTER STATUS" will vary
235
# with the strlen() of MYSQL_TEST_DIR
236
SLAVE_LOAD_TMPDIR=../tmp
239
MYSQLD_SRC_DIRS="strings mysys include extra regex myisam \
241
MY_LOG_DIR="$MYSQL_TEST_DIR/var/log"
243
# Set LD_LIBRARY_PATH if we are using shared libraries
245
LD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$BASEDIR/libmysql_r/.libs:$BASEDIR/zlib/.libs:$LD_LIBRARY_PATH"
246
DYLD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$BASEDIR/libmysql_r/.libs:$BASEDIR/zlib/.libs:$DYLD_LIBRARY_PATH"
247
export LD_LIBRARY_PATH DYLD_LIBRARY_PATH
250
# Allow anyone in the group to see the generated database files
254
export UMASK UMASK_DIR
258
MASTER_MYHOST=127.0.0.1
261
SLAVE_MYHOST=127.0.0.1
262
SLAVE_MYPORT=9308 # leave room for 2 masters for cluster tests
263
MYSQL_MANAGER_LOG=$MYSQL_TEST_DIR/var/log/manager.log
265
NDBCLUSTER_PORT_SLAVE=9358
268
# To make it easier for different devs to work on the same host,
269
# an environment variable can be used to control all ports. A small
270
# number is to be used, 0 - 16 or similar.
272
# Note the MASTER_MYPORT has to be set the same in all 4.x and 5.x
273
# versions of this script, else a 4.0 test run might conflict with a
274
# 5.1 test run, even if different MTR_BUILD_THREAD is used. This means
275
# all port numbers might not be used in this version of the script.
277
if [ -n "$MTR_BUILD_THREAD" ] ; then
278
MASTER_MYPORT=`expr $MTR_BUILD_THREAD '*' 10 + 10000`
279
SLAVE_MYPORT=`expr $MASTER_MYPORT + 3`
280
NDBCLUSTER_PORT=`expr $MASTER_MYPORT + 6`
281
NDBCLUSTER_PORT_SLAVE=`expr $MASTER_MYPORT + 7`
283
echo "Using MTR_BUILD_THREAD = $MTR_BUILD_THREAD"
284
echo "Using MASTER_MYPORT = $MASTER_MYPORT"
285
echo "Using SLAVE_MYPORT = $SLAVE_MYPORT"
286
echo "Using NDBCLUSTER_PORT = $NDBCLUSTER_PORT"
287
echo "Using NDBCLUSTER_PORT_SLAVE = $NDBCLUSTER_PORT_SLAVE"
295
EXTRA_MYSQL_TEST_OPT=""
296
EXTRA_MYSQLCHECK_OPT=""
297
EXTRA_MYSQLDUMP_OPT=""
298
EXTRA_MYSQLSLAP_OPT=""
299
EXTRA_MYSQLSHOW_OPT=""
300
EXTRA_MYSQLBINLOG_OPT=""
302
USE_NDBCLUSTER=@USE_NDBCLUSTER@
303
USE_NDBCLUSTER_SLAVE=@USE_NDBCLUSTER@
305
USE_NDBCLUSTER_ONLY=0
306
USE_RUNNING_NDBCLUSTER=""
307
USE_RUNNING_NDBCLUSTER_SLAVE=""
310
NDBCLUSTER_EXTRA_OPTS=""
318
SLEEP_TIME_AFTER_RESTART=1
319
SLEEP_TIME_FOR_DELETE=10
320
SLEEP_TIME_FOR_FIRST_MASTER=400 # Enough time to create innodb tables
321
SLEEP_TIME_FOR_SECOND_MASTER=400
322
SLEEP_TIME_FOR_FIRST_SLAVE=400
323
SLEEP_TIME_FOR_SECOND_SLAVE=300
326
START_WAIT_TIMEOUT=10
328
MYSQL_TEST_SSL_OPTS=""
330
USE_EMBEDDED_SERVER=""
336
MASTER_MYSQLDBINLOG=1
345
STRESS_TEST_DURATION=""
350
$ECHO "Logging: $0 $*" # To ensure we see all arguments in the output, for the test analysis tool
352
while test $# -gt 0; do
355
USE_EMBEDDED_SERVER=1
356
USE_MANAGER=0 NO_SLAVE=1
359
USE_NDBCLUSTER_SLAVE=""
360
TEST_MODE="$TEST_MODE embedded" ;;
365
TEST_MODE="$TEST_MODE purify" ;;
366
--user=*) DBUSER=`$ECHO "$1" | $SED -e "s;--user=;;"` ;;
368
--timer) USE_TIMER=1 ;;
369
--old-master) MASTER_40_ARGS="";;
371
MASTER_MYSQLD=`$ECHO "$1" | $SED -e "s;--master-binary=;;"` ;;
373
SLAVE_MYSQLD=`$ECHO "$1" | $SED -e "s;--slave-binary=;;"` ;;
374
--local) USE_RUNNING_SERVER=0 ;;
375
--extern) USE_RUNNING_SERVER=1 ;;
377
USE_NDBCLUSTER="--ndbcluster" ;;
378
--with-ndbcluster-slave)
379
USE_NDBCLUSTER_SLAVE="--ndbcluster" ;;
380
--with-ndbcluster-all)
381
USE_NDBCLUSTER="--ndbcluster"
382
USE_NDBCLUSTER_SLAVE="--ndbcluster"
383
USE_NDBCLUSTER_ALL=1 ;;
384
--with-ndbcluster-only)
385
USE_NDBCLUSTER="--ndbcluster"
386
USE_NDBCLUSTER_SLAVE="--ndbcluster"
387
USE_NDBCLUSTER_ONLY=1 ;;
388
--ndb-connectstring=*)
389
USE_NDBCLUSTER="--ndbcluster" ;
390
USE_RUNNING_NDBCLUSTER=`$ECHO "$1" | $SED -e "s;--ndb-connectstring=;;"` ;;
391
--ndb-connectstring-slave=*)
392
USE_NDBCLUSTER_SLAVE="--ndbcluster" ;
393
USE_RUNNING_NDBCLUSTER_SLAVE=`$ECHO "$1" | $SED -e "s;--ndb-connectstring-slave=;;"` ;;
395
NDBCLUSTER_EXTRA_OPTS=" "
400
--ndb_mgm-extra-opts=*)
401
NDB_MGM_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndb_mgm-extra-opts=;;"` ;;
402
--ndb_mgmd-extra-opts=*)
403
NDB_MGMD_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndb_mgmd-extra-opts=;;"` ;;
405
NDBD_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndbd-extra-opts=;;"` ;;
406
--tmpdir=*) MYSQL_TMP_DIR=`$ECHO "$1" | $SED -e "s;--tmpdir=;;"` ;;
409
EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --host=127.0.0.1 \
410
--port=$MYSQL_MYPORT"
412
--master_port=*) MASTER_MYPORT=`$ECHO "$1" | $SED -e "s;--master_port=;;"` ;;
413
--slave_port=*) SLAVE_MYPORT=`$ECHO "$1" | $SED -e "s;--slave_port=;;"` ;;
414
--ndbcluster_port=*) NDBCLUSTER_PORT=`$ECHO "$1" | $SED -e "s;--ndbcluster_port=;;"` ;;
415
--ndbcluster-port=*) NDBCLUSTER_PORT=`$ECHO "$1" | $SED -e "s;--ndbcluster-port=;;"` ;;
416
--ndbcluster-port-slave=*) NDBCLUSTER_PORT_SLAVE=`$ECHO "$1" | $SED -e "s;--ndbcluster-port-slave=;;"` ;;
418
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
419
--ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
420
--ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem \
421
--ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem"
422
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
423
--ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
424
--ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem \
425
--ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem"
426
MYSQL_TEST_SSL_OPTS="--ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
427
--ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem \
428
--ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem" ;;
432
--socket=*) LOCAL_SOCKET=`$ECHO "$1" | $SED -e "s;--socket=;;"` ;;
433
--skip-rpl) NO_SLAVE=1 ;;
434
--skip-test=*) SKIP_TEST=`$ECHO "$1" | $SED -e "s;--skip-test=;;"`;;
435
--do-test=*) DO_TEST=`$ECHO "$1" | $SED -e "s;--do-test=;;"`;;
436
--start-from=* ) START_FROM=`$ECHO "$1" | $SED -e "s;--start-from=;;"` ;;
437
--warnings | --log-warnings)
438
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --log-warnings"
439
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --log-warnings"
442
START_WAIT_TIMEOUT=`$ECHO "$1" | $SED -e "s;--wait-timeout=;;"`
443
STOP_WAIT_TIMEOUT=$START_WAIT_TIMEOUT;;
446
EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
462
STRESS_SUITE=`$ECHO "$1" | $SED -e "s;--stress-suite=;;"`
465
STRESS_THREADS=`$ECHO "$1" | $SED -e "s;--stress-threads=;;"`
467
--stress-test-file=*)
468
STRESS_TEST_FILE=`$ECHO "$1" | $SED -e "s;--stress-test-file=;;"`
470
--stress-init-file=*)
471
STRESS_INIT_FILE=`$ECHO "$1" | $SED -e "s;--stress-init-file=;;"`
474
STRESS_MODE=`$ECHO "$1" | $SED -e "s;--stress-mode=;;"`
476
--stress-loop-count=*)
477
STRESS_LOOP_COUNT=`$ECHO "$1" | $SED -e "s;--stress-loop-count=;;"`
479
--stress-test-count=*)
480
STRESS_TEST_COUNT=`$ECHO "$1" | $SED -e "s;--stress-test-count=;;"`
482
--stress-test-duration=*)
483
STRESS_TEST_DURATION=`$ECHO "$1" | $SED -e "s;--stress-test-duration=;;"`
485
--big*) # Actually --big-test
486
EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
488
EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
490
EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1"
491
SLEEP_TIME_AFTER_RESTART=`$ECHO "$1" | $SED -e "s;--sleep=;;"`
494
TEST_MODE="$TEST_MODE ps-protocol" EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
496
USER_TEST=`$ECHO "$1" | $SED -e "s;--user-test=;;"`
499
TMP=`$ECHO "$1" | $SED -e "s;--mysqld=;;"`
500
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $TMP"
501
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $TMP"
504
if [ x$BINARY_DIST = x1 ] ; then
505
$ECHO "Cannot do coverage test without the source - please use source dist"
515
START_WAIT_TIMEOUT=300
516
STOP_WAIT_TIMEOUT=300
517
if [ x$BINARY_DIST = x1 ] ; then
518
$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --gdb option"
521
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
522
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
523
# This needs to be checked properly
528
if [ x$BINARY_DIST = x1 ] ; then
529
$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --client-gdb option"
532
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
533
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
539
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
540
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
543
if [ x$BINARY_DIST = x1 ] ; then
544
$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --ddd option"
548
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
549
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
551
--valgrind | --valgrind-all)
553
VALGRIND=$FIND_VALGRIND
554
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-safemalloc"
555
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-safemalloc"
556
SLEEP_TIME_AFTER_RESTART=10
557
SLEEP_TIME_FOR_DELETE=60
559
if test "$1" = "--valgrind-all"
561
VALGRIND="$VALGRIND -v --show-reachable=yes"
564
--valgrind-options=*)
565
TMP=`$ECHO "$1" | $SED -e "s;--valgrind-options=;;"`
566
VALGRIND="$VALGRIND $TMP"
568
--skip-ndbcluster-slave | --skip-ndb-slave)
569
USE_NDBCLUSTER_SLAVE=""
570
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-ndbcluster"
572
--valgrind-mysqltest | --valgrind-mysqltest-all)
574
VALGRIND_MYSQLTEST=$FIND_VALGRIND
575
if test "$1" = "--valgrind-mysqltest-all"
577
VALGRIND_MYSQLTEST="$VALGRIND_MYSQLTEST -v --show-reachable=yes"
580
--skip-ndbcluster | --skip-ndb)
582
USE_NDBCLUSTER_SLAVE=""
583
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-ndbcluster"
584
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-ndbcluster"
586
--skip-master-binlog) MASTER_MYSQLDBINLOG=0 ;;
587
--skip-slave-binlog) SLAVE_MYSQLDBINLOG=0 ;;
589
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $1"
590
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $1"
596
EXTRA_MASTER_MYSQLD_TRACE=" \
597
--debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/master.trace"
598
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
599
--debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/slave.trace"
600
EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT \
601
--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqltest.trace"
602
EXTRA_MYSQLCHECK_OPT="$EXTRA_MYSQLCHECK_OPT \
603
--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlcheck.trace"
604
EXTRA_MYSQLDUMP_OPT="$EXTRA_MYSQLDUMP_OPT \
605
--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqldump.trace"
606
EXTRA_MYSQLSLAP_OPT="$EXTRA_MYSQLSLAP_OPT \
607
--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlslap.trace"
608
EXTRA_MYSQLSHOW_OPT="$EXTRA_MYSQLSHOW_OPT \
609
--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlshow.trace"
610
EXTRA_MYSQLBINLOG_OPT="$EXTRA_MYSQLBINLOG_OPT \
611
--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlbinlog.trace"
612
EXTRA_MYSQL_CLIENT_TEST_OPT="--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysql_client_test.trace"
621
TMP=`$ECHO "$1" | $SED -e "s;--comment=;;"`
623
echo '############################################'
625
echo '############################################'
628
--* ) $ECHO "Unrecognized option: $1"; exit 1 ;;
634
if [ -z "$TEST_MODE" ] ; then
637
# Remove the leading space if any
638
TEST_MODE=`echo $TEST_MODE | sed 's/^ *//'`
642
# Skip tests that doesn't work with shell version
644
SKIP_TEST="$SKIP_TEST bootstrap"
647
# mysqld Environment Parameters
650
MYRUN_DIR=$MYSQL_TEST_DIR/var/run
652
MASTER_MYDDIR="$MYSQL_TEST_DIR/var/master-data"
653
MASTER_MYSOCK="$MYSQL_TMP_DIR/master.sock"
654
MASTER_MYSOCK1=$MYSQL_MYSOCK"1"
655
MASTER_MYPID="$MYRUN_DIR/master.pid"
656
MASTER_MYLOG="$MYSQL_TEST_DIR/var/log/master.log"
657
MASTER_MYERR="$MYSQL_TEST_DIR/var/log/master.err"
659
SLAVE_MYDDIR="$MYSQL_TEST_DIR/var/slave-data"
660
SLAVE_MYSOCK="$MYSQL_TMP_DIR/slave.sock"
661
SLAVE_MYPID="$MYRUN_DIR/slave.pid"
662
SLAVE_MYLOG="$MYSQL_TEST_DIR/var/log/slave.log"
663
SLAVE_MYERR="$MYSQL_TEST_DIR/var/log/slave.err"
665
CURRENT_TEST="$MYSQL_TEST_DIR/var/log/current_test"
666
SMALL_SERVER="--key_buffer_size=1M --sort_buffer=256K --max_heap_table_size=1M"
668
export MASTER_MYHOST MASTER_MYPORT SLAVE_MYHOST SLAVE_MYPORT MYSQL_TCP_PORT MASTER_MYSOCK MASTER_MYSOCK1
670
NDBCLUSTER_OPTS="--port=$NDBCLUSTER_PORT --data-dir=$MYSQL_TEST_DIR/var --ndb_mgm-extra-opts=$NDB_MGM_EXTRA_OPTS --ndb_mgmd-extra-opts=$NDB_MGMD_EXTRA_OPTS --ndbd-extra-opts=$NDBD_EXTRA_OPTS"
671
NDBCLUSTER_OPTS_SLAVE="--port=$NDBCLUSTER_PORT_SLAVE --data-dir=$MYSQL_TEST_DIR/var"
672
if [ -n "$USE_NDBCLUSTER_SLAVE" ] ; then
673
USE_NDBCLUSTER_SLAVE="$USE_NDBCLUSTER_SLAVE --ndb-connectstring=localhost:$NDBCLUSTER_PORT_SLAVE --ndb-extra-logging"
675
NDB_BACKUP_DIR=$MYSQL_TEST_DIR/var/ndbcluster-$NDBCLUSTER_PORT
676
NDB_TOOLS_OUTPUT=$MYSQL_TEST_DIR/var/log/ndb_tools.log
678
if [ x$SOURCE_DIST = x1 ] ; then
679
MY_BASEDIR=$MYSQL_TEST_DIR
684
# Create the directories
686
# This should be fixed to be not be dependent on the contence of MYSQL_TMP_DIR
688
# (mkdir -p is not portable)
689
[ -d $MYSQL_TEST_DIR/var ] || mkdir $MYSQL_TEST_DIR/var
690
[ -d $MYSQL_TEST_DIR/var/tmp ] || mkdir $MYSQL_TEST_DIR/var/tmp
691
[ -d $MYSQL_TEST_DIR/var/run ] || mkdir $MYSQL_TEST_DIR/var/run
692
[ -d $MYSQL_TEST_DIR/var/log ] || mkdir $MYSQL_TEST_DIR/var/log
694
# Use 'test', not '[' as the shell builtin might not have '-L
695
if test ! -L "$MYSQL_TEST_DIR/var/std_data_ln" ; then
696
ln -s $MYSQL_TEST_DIR/std_data/ $MYSQL_TEST_DIR/var/std_data_ln
699
if test ${COLUMNS:-0} -lt 80 ; then COLUMNS=80 ; fi
700
E=`$EXPR $COLUMNS - 8`
701
DASH72=`$ECHO '-------------------------------------------------------'|$CUT -c 1-$E`
703
# on source dist, we pick up freshly build executables
704
# on binary, use what is installed
705
if [ x$SOURCE_DIST = x1 ] ; then
706
if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
707
if [ -f "$BASEDIR/libmysqld/examples/mysqltest_embedded" ] ; then
708
MYSQL_TEST="$BASEDIR/libmysqld/examples/mysqltest_embedded"
710
echo "Fatal error: Cannot find embedded server 'mysqltest_embedded'" 1>&2
713
MYSQL_CLIENT_TEST="$BASEDIR/libmysqld/examples/mysql_client_test_embedded"
715
MYSQLD="$BASEDIR/sql/mysqld"
716
if [ -n "$VALGRIND" ] ; then
717
MYSQLD="$VALGRIND $MYSQLD"
719
if [ -f "$BASEDIR/client/.libs/lt-mysqltest" ] ; then
720
MYSQL_TEST="$BASEDIR/client/.libs/lt-mysqltest"
721
elif [ -f "$BASEDIR/client/.libs/mysqltest" ] ; then
722
MYSQL_TEST="$BASEDIR/client/.libs/mysqltest"
724
MYSQL_TEST="$BASEDIR/client/mysqltest"
726
MYSQL_CLIENT_TEST="$BASEDIR/tests/mysql_client_test"
728
if [ -f "$BASEDIR/client/.libs/mysqlcheck" ] ; then
729
MYSQL_CHECK="$BASEDIR/client/.libs/mysqlcheck"
731
MYSQL_CHECK="$BASEDIR/client/mysqlcheck"
733
if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
734
MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
736
MYSQL_DUMP="$BASEDIR/client/mysqldump"
738
if [ -f "$BASEDIR/client/.libs/mysqlslap" ] ; then
739
MYSQL_SLAP="$BASEDIR/client/.libs/mysqlslap"
741
MYSQL_SLAP="$BASEDIR/client/mysqlslap"
743
if [ -f "$BASEDIR/client/.libs/mysqlimport" ] ; then
744
MYSQL_IMPORT="$BASEDIR/client/.libs/mysqlimport"
746
MYSQL_IMPORT="$BASEDIR/client/mysqlimport"
748
if [ -f "$BASEDIR/client/.libs/mysqlshow" ] ; then
749
MYSQL_SHOW="$BASEDIR/client/.libs/mysqlshow"
751
MYSQL_SHOW="$BASEDIR/client/mysqlshow"
753
if [ -f "$BASEDIR/client/.libs/mysqlbinlog" ] ; then
754
MYSQL_BINLOG="$BASEDIR/client/.libs/mysqlbinlog"
756
MYSQL_BINLOG="$BASEDIR/client/mysqlbinlog"
758
if [ -n "$STRACE_CLIENT" ]; then
759
MYSQL_TEST="strace -o $MYSQL_TEST_DIR/var/log/mysqltest.strace $MYSQL_TEST"
762
CLIENT_BINDIR="$BASEDIR/client"
763
MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
764
WAIT_PID="$BASEDIR/extra/mysql_waitpid"
765
MYSQL_MY_PRINT_DEFAULTS="$BASEDIR/extra/my_print_defaults"
766
MYSQL="$CLIENT_BINDIR/mysql"
767
LANGUAGE="$BASEDIR/sql/share/english/"
768
CHARSETSDIR="$BASEDIR/sql/share/charsets"
769
INSTALL_DB="./install_test_db"
770
MYSQL_FIX_SYSTEM_TABLES="$BASEDIR/scripts/mysql_fix_privilege_tables"
771
NDB_TOOLS_DIR="$BASEDIR/storage/ndb/tools"
772
NDB_MGM="$BASEDIR/storage/ndb/src/mgmclient/ndb_mgm"
774
if [ -n "$USE_PURIFY" ] ; then
775
PSUP="$MYSQL_TEST_DIR/suppress.purify"
776
PURIFYOPTIONS="-windows=no -log-file=%v.purifylog -append-logfile -add-suppression-files=$PSUP"
777
if [ -f "${MYSQL_TEST}-purify" ] ; then
778
MYSQL_TEST="${MYSQL_TEST}-purify"
779
PLOG="$MYSQL_TEST.purifylog"
780
if [ -f $PLOG ]; then
785
if [ -f "${MYSQLD}-purify" ] ; then
786
MYSQLD="${MYSQLD}-purify"
787
PLOG="$MYSQLD.purifylog"
788
if [ -f $PLOG ]; then
791
PURIFY_LOGS="$PURIFY_LOGS $PLOG"
797
# We have a binary installation. Note that this can be both from
798
# unpacking a MySQL AB binary distribution (created using
799
# "scripts/make_binary_distribution", and from a "make install".
800
# Unfortunately the structure differs a bit, for a "make install"
801
# currently all binaries are in "bin", for a MySQL AB packaging
802
# some are in "tests".
804
if test -x "$BASEDIR/libexec/mysqld"
806
MYSQLD="$VALGRIND $BASEDIR/libexec/mysqld"
807
elif test -x "$BASEDIR/bin/mysqld"
809
MYSQLD="$VALGRIND $BASEDIR/bin/mysqld"
810
elif test -x "$BASEDIR/sbin/mysqld"
812
MYSQLD="$VALGRIND $BASEDIR/sbin/mysqld"
814
$ECHO "Fatal error: Cannot find program mysqld in $BASEDIR/{libexec,bin,sbin}" 1>&2
817
CLIENT_BINDIR="$BASEDIR/bin"
818
if test -d "$BASEDIR/tests"
820
TESTS_BINDIR="$BASEDIR/tests"
822
TESTS_BINDIR="$BASEDIR/bin"
824
MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
825
MYSQL_CHECK="$CLIENT_BINDIR/mysqlcheck"
826
MYSQL_SLAP="$CLIENT_BINDIR/mysqlslap"
827
MYSQL_SHOW="$CLIENT_BINDIR/mysqlshow"
828
MYSQL_IMPORT="$CLIENT_BINDIR/mysqlimport"
829
MYSQL_BINLOG="$CLIENT_BINDIR/mysqlbinlog"
830
MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
831
WAIT_PID="$CLIENT_BINDIR/mysql_waitpid"
832
MYSQL_MY_PRINT_DEFAULTS="$CLIENT_BINDIR/my_print_defaults"
833
MYSQL="$CLIENT_BINDIR/mysql"
834
INSTALL_DB="./install_test_db --bin"
835
MYSQL_FIX_SYSTEM_TABLES="$CLIENT_BINDIR/mysql_fix_privilege_tables"
836
NDB_TOOLS_DIR="$CLIENT_BINDIR"
837
NDB_MGM="$CLIENT_BINDIR/ndb_mgm"
838
if test -d "$BASEDIR/share/mysql/english"
840
LANGUAGE="$BASEDIR/share/mysql/english/"
841
CHARSETSDIR="$BASEDIR/share/mysql/charsets"
843
LANGUAGE="$BASEDIR/share/english/"
844
CHARSETSDIR="$BASEDIR/share/charsets"
846
if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
847
if [ -f "$CLIENT_BINDIR/mysqltest_embedded" ] ; then
848
MYSQL_TEST="$CLIENT_BINDIR/mysqltest_embedded"
850
echo "Fatal error: Cannot find embedded server 'mysqltest_embedded'" 1>&2
853
if [ -d "$BASEDIR/tests/mysql_client_test_embedded" ] ; then
854
MYSQL_CLIENT_TEST="$TESTS_BINDIR/mysql_client_test_embedded"
856
MYSQL_CLIENT_TEST="$CLIENT_BINDIR/mysql_client_test_embedded"
859
MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
860
MYSQL_CLIENT_TEST="$CLIENT_BINDIR/mysql_client_test"
862
if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
863
MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
864
elif [ -f "$BASEDIR/client/mysqldump" ] ; then
865
MYSQL_DUMP="$BASEDIR/client/mysqldump"
867
MYSQL_DUMP="$BASEDIR/bin/mysqldump"
871
if [ -z "$MASTER_MYSQLD" ]
873
MASTER_MYSQLD=$MYSQLD
876
if [ -z "$SLAVE_MYSQLD" ]
881
# If we should run all tests cases, we will use a local server for that
883
if [ -z "$1" -a -z "$DO_STRESS" ]
887
if [ $USE_RUNNING_SERVER -eq 1 ]
889
MASTER_MYSOCK=$LOCAL_SOCKET;
890
DBUSER=${DBUSER:-test}
892
DBUSER=${DBUSER:-root} # We want to do FLUSH xxx commands
897
# We are running as root; We need to add the --root argument
898
EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --user=root"
899
EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --user=root"
902
MYSQL_CLIENT_TEST="$MYSQL_CLIENT_TEST --no-defaults --testcase --user=root --socket=$MASTER_MYSOCK --port=$MYSQL_TCP_PORT --silent $EXTRA_MYSQL_CLIENT_TEST_OPT"
903
# Need to pass additional arguments to MYSQL_CLIENT_TEST for embedded server
904
# -A marks each argument for passing to the function which initializes the
906
if [ "x$USE_EMBEDDED_SERVER" = "x1" ]; then
907
MYSQL_CLIENT_TEST="$MYSQL_CLIENT_TEST -A --language=$LANGUAGE -A --datadir=$SLAVE_MYDDIR -A --character-sets-dir=$CHARSETSDIR"
909
# Save path and name of mysqldump
910
MYSQL_DUMP_DIR="$MYSQL_DUMP"
911
export MYSQL_DUMP_DIR
912
MYSQL_CHECK="$MYSQL_CHECK --no-defaults --debug-info -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLCHECK_OPT"
913
MYSQL_DUMP="$MYSQL_DUMP --no-defaults --debug-info -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
914
MYSQL_SLAP="$MYSQL_SLAP -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLSLAP_OPT"
915
MYSQL_DUMP_SLAVE="$MYSQL_DUMP_DIR --no-defaults -uroot --socket=$SLAVE_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
916
MYSQL_SHOW="$MYSQL_SHOW --no-defaults --debug-info -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLSHOW_OPT"
917
MYSQL_BINLOG="$MYSQL_BINLOG --no-defaults --debug-info --local-load=$MYSQL_TMP_DIR --character-sets-dir=$CHARSETSDIR $EXTRA_MYSQLBINLOG_OPT"
918
MYSQL_IMPORT="$MYSQL_IMPORT --no-defaults --debug-info -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
919
MYSQL_FIX_SYSTEM_TABLES="$MYSQL_FIX_SYSTEM_TABLES --no-defaults --host=localhost --port=$MASTER_MYPORT --socket=$MASTER_MYSOCK --user=root --password=$DBPASSWD --basedir=$BASEDIR --bindir=$CLIENT_BINDIR --verbose"
920
MYSQL="$MYSQL --no-defaults --debug-info --host=localhost --port=$MASTER_MYPORT --socket=$MASTER_MYSOCK --user=root --password=$DBPASSWD"
921
export MYSQL MYSQL_CHECK MYSQL_DUMP MYSQL_DUMP_SLAVE MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES MYSQL_IMPORT
922
export CLIENT_BINDIR MYSQL_CLIENT_TEST CHARSETSDIR MYSQL_MY_PRINT_DEFAULTS
926
export NDB_BACKUP_DIR
927
export NDB_TOOLS_OUTPUT
931
NDB_SLAVE_STATUS_OK=1
932
export NDB_SLAVE_STATUS_OK
933
export NDB_EXTRA_TEST NDBCLUSTER_PORT NDBCLUSTER_PORT_SLAVE
935
MYSQL_TEST_ARGS="--no-defaults --socket=$MASTER_MYSOCK --database=$DB \
936
--user=$DBUSER --password=$DBPASSWD --silent -v --skip-safemalloc \
937
--tmpdir=$MYSQL_TMP_DIR --port=$MASTER_MYPORT $MYSQL_TEST_SSL_OPTS"
938
if [ x$USE_TIMER = x1 ] ; then
939
MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS --timer-file=$MY_LOG_DIR/timer"
941
MYSQL_TEST_BIN=$MYSQL_TEST
942
MYSQL_TEST="$MYSQL_TEST $MYSQL_TEST_ARGS"
944
# Export MYSQL_TEST variable for use from .test files
947
GDB_CLIENT_INIT=$MYSQL_TMP_DIR/gdbinit.client
948
GDB_MASTER_INIT=$MYSQL_TMP_DIR/gdbinit.master
949
GDB_SLAVE_INIT=$MYSQL_TMP_DIR/gdbinit.slave
950
GCOV_MSG=$MYSQL_TMP_DIR/mysqld-gcov.out
951
GCOV_ERR=$MYSQL_TMP_DIR/mysqld-gcov.err
952
GPROF_DIR=$MYSQL_TMP_DIR/gprof
953
GPROF_MASTER=$GPROF_DIR/master.gprof
954
GPROF_SLAVE=$GPROF_DIR/slave.gprof
955
TIMEFILE="$MYSQL_TEST_DIR/var/log/mysqltest-time"
956
MYSQLTEST_LOG="$MYSQL_TEST_DIR/var/log/mysqltest.log"
957
if [ -n "$DO_CLIENT_GDB" -o -n "$DO_GDB" ] ; then
961
export MYSQL MYSQL_CHECK MYSQL_DUMP MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES CLIENT_BINDIR MASTER_MYSOCK
964
# Function Definitions
973
# We can't use diff -u or diff -a as these are not portable
977
reject_file=r/$1.reject
978
result_file=r/$1.result
983
result_file=$eval_file
986
if [ -x "$DIFF" ] && [ -f $reject_file ]
988
echo "Below are the diffs between actual and expected results:"
989
echo "-------------------------------------------------------"
990
$DIFF -c $result_file $reject_file
991
echo "-------------------------------------------------------"
992
echo "Please follow the instructions outlined at"
993
echo "http://forge.mysql.com/wiki/MySQL_Internals_Porting#Debugging_a_MySQL_Server"
994
echo "to find the reason to this problem and how to report this."
1001
mysql_test_args="$MYSQL_TEST_ARGS $1"
1002
$ECHO "set args $mysql_test_args < $2" > $GDB_CLIENT_INIT
1003
echo "Set breakpoints ( if needed) and type 'run' in gdb window"
1004
#this xterm should not be backgrounded
1005
$XTERM -title "Client" -e gdb -x $GDB_CLIENT_INIT $MYSQL_TEST_BIN
1014
$ECHO "Errors are (from $TIMEFILE) :"
1016
$ECHO "(the last lines may be the most important ones)"
1020
$ECHO " $1" | $SED -e 's:.*\(........\)$:\1:'
1024
TOT_PASS=`$EXPR $TOT_PASS + 1`
1028
TOT_FAIL=`$EXPR $TOT_FAIL + 1`
1032
TOT_SKIP=`$EXPR $TOT_SKIP + 1`
1036
TOT_TEST=`$EXPR $TOT_TEST + 1`
1044
pname=`$ECHO "$1 "|$CUT -c 1-24`
1047
$ECHO "$RES$RES_SPACE [ skipped ]"
1055
pname=`$ECHO "$1 "|$CUT -c 1-24`
1058
$ECHO "$RES$RES_SPACE [ disabled ] $2"
1062
report_current_test () {
1064
echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
1065
eval "master1_running=\$MASTER1_RUNNING"
1066
if [ x$master1_running = x1 ] ; then
1067
echo "CURRENT_TEST: $tname" >> $MASTER_MYERR"1"
1069
if [ -n "$PURIFY_LOGS" ] ; then
1070
for log in $PURIFY_LOGS
1072
echo "CURRENT_TEST: $tname" >> $log
1079
if [ $TOT_FAIL = 0 ]; then
1080
$ECHO "All $TOT_TEST tests were successful."
1082
xten=`$EXPR $TOT_PASS \* 10000`
1083
raw=`$EXPR $xten / $TOT_TEST`
1084
raw=`$PRINTF %.4d $raw`
1085
whole=`$PRINTF %.2s $raw`
1086
xwhole=`$EXPR $whole \* 100`
1087
deci=`$EXPR $raw - $xwhole`
1088
$ECHO "Failed ${TOT_FAIL}/${TOT_TEST} tests, ${whole}.${deci}% were successful."
1090
$ECHO "The log files in $MY_LOG_DIR may give you some hint"
1091
$ECHO "of what went wrong."
1092
$ECHO "If you want to report this error, please read first the documentation at"
1093
$ECHO "http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html"
1096
if [ $USE_RUNNING_SERVER -eq 0 ]
1099
# Report if there was any fatal warnings/errors in the log files
1101
$RM -f $MY_LOG_DIR/warnings $MY_LOG_DIR/warnings.tmp
1102
# Remove some non fatal warnings from the log files
1103
$SED -e 's!Warning: Table:.* on delete!!g' -e 's!Warning: Setting lower_case_table_names=2!!g' -e 's!Warning: One can only use the --user.*root!!g' -e 's|InnoDB: Warning: we did not need to do crash recovery||g' \
1105
| $SED -e 's!Warning: Table:.* on rename!!g' \
1106
> $MY_LOG_DIR/warnings.tmp
1109
for i in "^Warning:" "^Error:" "^==.* at 0x" "InnoDB: Warning" "missing DBUG_RETURN" "mysqld: Warning" "Attempting backtrace" "Assertion .* failed"
1111
if $GREP "$i" $MY_LOG_DIR/warnings.tmp >> $MY_LOG_DIR/warnings
1116
$RM -f $MY_LOG_DIR/warnings.tmp
1117
if [ $GOT_WARNINGS = "1" ]
1119
echo "WARNING: Got errors/warnings while running tests. Please examine"
1120
echo "$MY_LOG_DIR/warnings for details."
1123
fi # USE_RUNNING_SERVER
1125
# Check valgrind errors from mysqltest
1126
if [ ! -z "$VALGRIND_MYSQLTEST" ]
1128
if $GREP "ERROR SUMMARY" $MYSQLTEST_LOG | $GREP -v "0 errors" > /dev/null
1130
$ECHO "Valgrind detected errors!"
1131
$GREP "ERROR SUMMARY" $MYSQLTEST_LOG | $GREP -v "0 errors"
1132
$ECHO "See $MYSQLTEST_LOG"
1137
mysql_install_db () {
1138
$ECHO "Removing Stale Files"
1139
if [ -z "$USE_OLD_DATA" ]; then
1140
$RM -rf $MASTER_MYDDIR $MASTER_MYDDIR"1"
1141
$ECHO "Installing Master Databases"
1143
if [ $? != 0 ]; then
1144
error "Could not install master test DBs"
1148
if [ ! -z "$USE_NDBCLUSTER" ]
1150
$ECHO "Installing Master Databases 1"
1152
$RM -rf var/master-data1
1153
mkdir var/master-data1
1154
cp -r var/master-data/* var/master-data1
1155
if [ $? != 0 ]; then
1156
error "Could not install master test DBs 1"
1160
$ECHO "Installing Slave Databases"
1161
$RM -rf $SLAVE_MYDDIR $MY_LOG_DIR/*
1162
# $INSTALL_DB -slave
1163
mkdir var/slave-data
1164
cp -r var/master-data/* var/slave-data
1165
if [ $? != 0 ]; then
1166
error "Could not install slave test DBs"
1170
for slave_num in 1 2 ;
1172
$RM -rf var/slave$slave_num-data
1173
mkdir -p var/slave$slave_num-data/mysql
1174
mkdir -p var/slave$slave_num-data/test
1175
cp var/slave-data/mysql/* var/slave$slave_num-data/mysql
1188
if [ -f $MASTER_MYDDIR/gmon.out ]; then
1189
gprof $MASTER_MYSQLD $MASTER_MYDDIR/gmon.out > $GPROF_MASTER
1190
echo "Master execution profile has been saved in $GPROF_MASTER"
1192
if [ -f $SLAVE_MYDDIR/gmon.out ]; then
1193
gprof $SLAVE_MYSQLD $SLAVE_MYDDIR/gmon.out > $GPROF_SLAVE
1194
echo "Slave execution profile has been saved in $GPROF_SLAVE"
1199
$FIND $BASEDIR -name \*.gcov \
1200
-or -name \*.da | $XARGS $RM
1204
$ECHO "Collecting source coverage info..."
1205
[ -f $GCOV_MSG ] && $RM $GCOV_MSG
1206
[ -f $GCOV_ERR ] && $RM $GCOV_ERR
1207
for d in $MYSQLD_SRC_DIRS; do
1209
for f in *.h *.cc *.c; do
1210
$GCOV $f 2>>$GCOV_ERR >>$GCOV_MSG
1215
$ECHO "gcov info in $GCOV_MSG, errors in $GCOV_ERR"
1220
if [ ! $? = 0 ] ; then
1226
launch_in_background()
1229
echo $@ | /bin/sh >> $CUR_MYERR 2>&1 &
1238
# Shutdown time must be high as slave may be in reconnect
1239
$MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=5 --shutdown_timeout=70 shutdown >> $MYSQL_MANAGER_LOG 2>&1
1241
# Some systems require an extra connect
1242
$MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=1 ping >> $MYSQL_MANAGER_LOG 2>&1
1252
if [ ! -n "$USE_NDBCLUSTER" ] ;
1258
if [ x$USING_NDBCLUSTER = x1 -a -z "$USE_NDBCLUSTER_OPT" ]
1260
rm -f $NDB_TOOLS_OUTPUT
1261
if [ -z "$USE_RUNNING_NDBCLUSTER" ]
1263
if [ "$DO_BENCH" != 1 -a -z "$NDBCLUSTER_EXTRA_OPTS" ]
1265
NDBCLUSTER_EXTRA_OPTS="--small"
1267
OPTS="$NDBCLUSTER_OPTS $NDBCLUSTER_EXTRA_OPTS --character-sets-dir=$CHARSETSDIR --verbose=$NDB_VERBOSE --initial --relative-config-data-dir --core"
1268
if [ "x$NDB_VERBOSE" != "x0" ] ; then
1269
echo "Starting master ndbcluster " $OPTS
1271
./ndb/ndbcluster $OPTS || NDB_STATUS_OK=0
1272
if [ x$NDB_STATUS_OK != x1 ] ; then
1273
if [ x$FORCE != x1 ] ; then
1281
NDB_CONNECTSTRING="host=localhost:$NDBCLUSTER_PORT"
1283
NDB_CONNECTSTRING="$USE_RUNNING_NDBCLUSTER"
1284
echo "Using ndbcluster at $NDB_CONNECTSTRING"
1286
USE_NDBCLUSTER_OPT="$USE_NDBCLUSTER --ndb-connectstring=\"$NDB_CONNECTSTRING\" --ndb-extra-logging"
1287
export NDB_CONNECTSTRING
1291
rm_ndbcluster_tables()
1293
$RM -f $1/mysql/apply_status*
1294
$RM -f $1/mysql/schema*
1299
if [ -n "$USE_NDBCLUSTER_OPT" ]
1302
if [ -z "$USE_RUNNING_NDBCLUSTER" ]
1304
# Kill any running ndbcluster stuff
1305
$ECHO "Stopping master cluster"
1306
./ndb/ndbcluster $NDBCLUSTER_OPTS --stop
1307
# remove ndb table the hard way as not to upset later tests
1308
rm_ndbcluster_tables $MASTER_MYDDIR
1309
rm_ndbcluster_tables $MASTER_MYDDIR"1"
1314
# The embedded server needs the cleanup so we do some of the start work
1315
# but stop before actually running mysqld or anything.
1319
eval "this_master_running=\$MASTER$1_RUNNING"
1320
if [ x$this_master_running = x1 ] || [ x$LOCAL_MASTER = x1 ] ; then
1323
# Remove stale binary logs except for 2 tests which need them
1324
if [ "$tname" != "rpl_crash_binlog_ib_1b" ] && [ "$tname" != "rpl_crash_binlog_ib_2b" ] && [ "$tname" != "rpl_crash_binlog_ib_3b" ]
1326
$RM -f $MYSQL_TEST_DIR/var/log/master-bin$1.*
1329
# Remove old master.info and relay-log.info files
1330
$RM -f $MYSQL_TEST_DIR/var/master-data$1/master.info $MYSQL_TEST_DIR/var/master-data$1/relay-log.info
1332
#run master initialization shell script if one exists
1334
if [ -f "$master_init_script" ] ;
1336
/bin/sh $master_init_script
1338
cd $BASEDIR # for gcov
1339
if [ -n "$1" ] ; then
1340
id=`$EXPR $1 + 101`;
1341
this_master_myport=`$EXPR $MASTER_MYPORT + $1`
1342
NOT_FIRST_MASTER_EXTRA_OPTS="--skip-innodb"
1343
eval "MASTER_MYPORT$1=$this_master_myport"
1344
export MASTER_MYPORT$1
1347
this_master_myport=$MASTER_MYPORT
1348
NOT_FIRST_MASTER_EXTRA_OPTS=""
1350
if [ -n "$EXTRA_MASTER_MYSQLD_TRACE" ]
1352
CURR_MASTER_MYSQLD_TRACE="$EXTRA_MASTER_MYSQLD_TRACE$1"
1354
if [ x$MASTER_MYSQLDBINLOG = x1 ]
1356
MASTER_MYSQLD_BINLOG_OPT="--log-bin=$MYSQL_TEST_DIR/var/log/master-bin$1"
1358
if [ -z "$DO_BENCH" -a -z "$DO_STRESS" ]
1360
master_args="--no-defaults \
1362
--basedir=$MY_BASEDIR \
1363
--port=$this_master_myport \
1364
--port-open-timeout=380 \
1368
$USE_NDBCLUSTER_OPT \
1369
--datadir=$MASTER_MYDDIR$1 \
1370
--pid-file=$MASTER_MYPID$1 \
1371
--socket=$MASTER_MYSOCK$1 \
1372
--log=$MASTER_MYLOG$1 \
1373
--character-sets-dir=$CHARSETSDIR \
1374
--default-character-set=$CHARACTER_SET \
1375
--tmpdir=$MYSQL_TMP_DIR \
1376
--language=$LANGUAGE \
1377
--innodb_data_file_path=ibdata1:128M:autoextend \
1378
--open-files-limit=1024 \
1379
--log-bin-trust-function-creators \
1382
$MASTER_MYSQLD_BINLOG_OPT \
1383
$EXTRA_MASTER_MYSQLD_OPT $EXTRA_MASTER_OPT \
1384
$NOT_FIRST_MASTER_EXTRA_OPTS $CURR_MASTER_MYSQLD_TRACE"
1386
master_args="--no-defaults \
1387
--server-id=$id --rpl-recovery-rank=1 \
1388
--basedir=$MY_BASEDIR --init-rpl-role=master \
1389
--port=$this_master_myport \
1390
--port-open-timeout=380 \
1392
--datadir=$MASTER_MYDDIR$1 \
1393
--pid-file=$MASTER_MYPID$1 \
1394
--socket=$MASTER_MYSOCK$1 \
1395
--character-sets-dir=$CHARSETSDIR \
1396
--default-character-set=$CHARACTER_SET \
1398
$USE_NDBCLUSTER_OPT \
1399
--tmpdir=$MYSQL_TMP_DIR \
1400
--language=$LANGUAGE \
1401
--innodb_data_file_path=ibdata1:128M:autoextend \
1402
--log-bin-trust-function-creators \
1405
$MASTER_MYSQLD_BINLOG_OPT \
1406
$EXTRA_MASTER_MYSQLD_OPT $EXTRA_MASTER_OPT \
1407
$NOT_FIRST_MASTER_EXTRA_OPTS"
1410
CUR_MYERR=$MASTER_MYERR$1
1411
CUR_MYSOCK=$MASTER_MYSOCK$1
1413
# For embedded server we collect the server flags and return
1414
if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
1415
# Add a -A to each argument to pass it to embedded server
1416
EMBEDDED_SERVER_OPTS=""
1417
for opt in $master_args
1419
EMBEDDED_SERVER_OPTS="$EMBEDDED_SERVER_OPTS -A $opt"
1421
EXTRA_MYSQL_TEST_OPT="$EMBEDDED_SERVER_OPTS"
1425
if [ x$DO_DDD = x1 ]
1427
$ECHO "set args $master_args" > $GDB_MASTER_INIT$1
1428
launch_in_background master ddd -display $DISPLAY --debugger \
1429
"gdb -x $GDB_MASTER_INIT$1" $MASTER_MYSQLD
1430
elif [ x$DO_GDB = x1 ]
1432
if [ x$MANUAL_GDB = x1 ]
1434
$ECHO "set args $master_args" > $GDB_MASTER_INIT$1
1435
$ECHO "To start gdb for the master , type in another window:"
1436
$ECHO "cd $MYSQL_TEST_DIR ; gdb -x $GDB_MASTER_INIT$1 $MASTER_MYSQLD"
1437
wait_for_master=1500
1439
( $ECHO set args $master_args;
1440
if [ $USE_MANAGER = 0 ] ; then
1448
fi ) > $GDB_MASTER_INIT$1
1449
launch_in_background master $XTERM -display $DISPLAY \
1450
-title "Master" -e gdb -x $GDB_MASTER_INIT$1 $MASTER_MYSQLD
1453
launch_in_background master $MASTER_MYSQLD $master_args
1455
sleep_until_file_created $MASTER_MYPID$1 $wait_for_master
1456
wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
1457
eval "MASTER$1_RUNNING=1"
1462
[ x$SKIP_SLAVE = x1 ] && return
1463
eval "this_slave_running=\$SLAVE$1_RUNNING"
1464
[ x$this_slave_running = 1 ] && return
1466
# When testing fail-safe replication, we will have more than one slave
1467
# in this case, we start secondary slaves with an argument
1468
slave_ident="slave$1"
1471
slave_server_id=`$EXPR 2 + $1`
1472
slave_rpl_rank=$slave_server_id
1473
slave_port=`expr $SLAVE_MYPORT + $1`
1474
slave_log="$SLAVE_MYLOG.$1"
1475
slave_err="$SLAVE_MYERR.$1"
1476
slave_datadir="$SLAVE_MYDDIR/../$slave_ident-data/"
1477
slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
1478
slave_sock="$SLAVE_MYSOCK-$1"
1482
slave_port=$SLAVE_MYPORT
1483
slave_log=$SLAVE_MYLOG
1484
slave_err=$SLAVE_MYERR
1485
slave_datadir=$SLAVE_MYDDIR
1486
slave_pid=$SLAVE_MYPID
1487
slave_sock="$SLAVE_MYSOCK"
1491
if [ x$USING_NDBCLUSTER = x1 -a -n "$USE_NDBCLUSTER_SLAVE" ] ; then
1492
if [ $slave_server_id -eq 2 ] ; then
1495
if [ "$DO_BENCH" != 1 -a -z "$NDBCLUSTER_EXTRA_OPTS" ]
1497
NDBCLUSTER_EXTRA_OPTS="--small"
1500
OPTS="$NDBCLUSTER_OPTS_SLAVE --initial $NDBCLUSTER_EXTRA_OPTS --ndbd-nodes=1 --verbose=$NDB_VERBOSE --relative-config-data-dir --core"
1501
if [ "x$NDB_VERBOSE" != "x0" ] ; then
1502
echo "Starting slave ndbcluster " $OPTS
1504
./ndb/ndbcluster $OPTS \
1505
|| NDB_SLAVE_STATUS_OK=0
1506
# > /dev/null 2>&1 || NDB_SLAVE_STATUS_OK=0
1508
if [ x$NDB_SLAVE_STATUS_OK != x1 ] ; then
1509
if [ x$FORCE != x1 ] ; then
1512
USE_NDBCLUSTER_SLAVE_OPT=
1513
USE_NDBCLUSTER_SLAVE=
1515
USE_NDBCLUSTER_SLAVE_OPT=$USE_NDBCLUSTER_SLAVE
1518
USE_NDBCLUSTER_SLAVE_OPT=
1521
# Remove stale binary logs and old master.info files
1522
# except for too tests which need them
1523
if [ "$tname" != "rpl_crash_binlog_ib_1b" ] && [ "$tname" != "rpl_crash_binlog_ib_2b" ] && [ "$tname" != "rpl_crash_binlog_ib_3b" ]
1525
$RM -f $MYSQL_TEST_DIR/var/log/$slave_ident-*bin.*
1526
$RM -f $slave_datadir/master.info $slave_datadir/relay-log.info
1529
#run slave initialization shell script if one exists
1530
if [ -f "$slave_init_script" ] ;
1532
/bin/sh $slave_init_script
1535
if [ -z "$SLAVE_MASTER_INFO" ] ; then
1536
master_info="--master-user=root \
1537
--master-connect-retry=1 \
1538
--master-host=127.0.0.1 \
1539
--master-password="" \
1540
--master-port=$MASTER_MYPORT \
1541
--server-id=$slave_server_id --rpl-recovery-rank=$slave_rpl_rank"
1543
master_info=$SLAVE_MASTER_INFO
1546
if [ x$SLAVE_MYSQLDBINLOG = x1 ]
1548
SLAVE_MYSQLD_BINLOG_OPT="--log-bin=$MYSQL_TEST_DIR/var/log/$slave_ident-bin --log-slave-updates"
1551
$RM -f $slave_datadir/log.*
1552
slave_args="--no-defaults $master_info \
1554
$SLAVE_MYSQLDBINLOG_OPT \
1555
--relay-log=$MYSQL_TEST_DIR/var/log/$slave_ident-relay-bin \
1557
--basedir=$MY_BASEDIR \
1558
--datadir=$slave_datadir \
1559
--pid-file=$slave_pid \
1560
--port=$slave_port \
1561
--port-open-timeout=380 \
1562
--socket=$slave_sock \
1563
--character-sets-dir=$CHARSETSDIR \
1564
--default-character-set=$CHARACTER_SET \
1565
--core --init-rpl-role=slave \
1566
--tmpdir=$MYSQL_TMP_DIR \
1567
--language=$LANGUAGE \
1568
--skip-innodb --skip-ndbcluster --skip-slave-start \
1569
--slave-load-tmpdir=$SLAVE_LOAD_TMPDIR \
1570
--report-host=127.0.0.1 --report-user=root \
1571
--report-port=$slave_port \
1572
--master-retry-count=10 \
1573
-O slave_net_timeout=10 \
1574
--log-bin-trust-function-creators \
1576
$SLAVE_MYSQLD_BINLOG_OPT \
1577
$EXTRA_SLAVE_MYSQLD_OPT $EXTRA_SLAVE_OPT \
1578
$USE_NDBCLUSTER_SLAVE_OPT"
1579
CUR_MYERR=$slave_err
1580
CUR_MYSOCK=$slave_sock
1582
if [ x$DO_DDD = x1 ]
1584
$ECHO "set args $slave_args" > $GDB_SLAVE_INIT
1585
launch_in_background $slave_ident ddd -display $DISPLAY --debugger \
1586
"gdb -x $GDB_SLAVE_INIT" $SLAVE_MYSQLD
1587
elif [ x$DO_GDB = x1 ]
1589
if [ x$MANUAL_GDB = x1 ]
1591
$ECHO "set args $slave_args" > $GDB_SLAVE_INIT
1592
echo "To start gdb for the slave, type in another window:"
1593
echo "cd $MYSQL_TEST_DIR ; gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD"
1596
( $ECHO set args $slave_args;
1597
if [ $USE_MANAGER = 0 ] ; then
1605
fi ) > $GDB_SLAVE_INIT
1606
launch_in_background $slave_ident $XTERM -display $DISPLAY -title "Slave" -e \
1607
gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD
1610
launch_in_background $slave_ident $SLAVE_MYSQLD $slave_args
1612
eval "SLAVE$1_RUNNING=1"
1613
sleep_until_file_created $slave_pid $wait_for_slave
1614
wait_for_slave=$SLEEP_TIME_FOR_SECOND_SLAVE
1619
# We should not start the daemon here as we don't know the arguments
1620
# for the test. Better to let the test start the daemon
1622
# $ECHO "Starting MySQL daemon"
1631
eval "this_slave_running=\$SLAVE$1_RUNNING"
1632
slave_ident="slave$1"
1635
slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
1637
slave_pid=$SLAVE_MYPID
1639
if [ x$this_slave_running = x1 ]
1641
pid=`$CAT $slave_pid`
1642
shutdown_mysqld $pid $slave_ident
1643
if [ $? != 0 ] && [ -f $slave_pid ]
1645
$ECHO "slave not cooperating with mysqladmin, will try manual kill"
1647
sleep_until_file_deleted $pid $slave_pid
1648
if [ -f $slave_pid ] ; then
1649
$ECHO "slave refused to die. Sending SIGKILL"
1650
kill -9 `$CAT $slave_pid`
1653
$ECHO "slave responded to SIGTERM "
1656
sleep $SLEEP_TIME_AFTER_RESTART
1658
eval "SLAVE$1_RUNNING=0"
1659
if [ -n "$USE_NDBCLUSTER_SLAVE_OPT" ] ; then
1662
$ECHO "Stopping slave cluster"
1663
./ndb/ndbcluster $NDBCLUSTER_OPTS_SLAVE --stop
1664
rm_ndbcluster_tables $SLAVE_MYDDIR
1670
stop_slave_threads ()
1672
eval "this_slave_running=\$SLAVE$1_RUNNING"
1673
slave_ident="slave$1"
1674
if [ x$this_slave_running = x1 ]
1676
$MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$slave_ident.sock stop-slave > /dev/null 2>&1
1682
eval "this_master_running=\$MASTER$1_RUNNING"
1683
if [ x$this_master_running = x1 ]
1685
# For embedded server we don't stop anyting but mark that
1686
# MASTER_RUNNING=0 to get cleanup when calling start_master().
1687
if [ x$USE_EMBEDDED_SERVER != x1 ] ; then
1688
pid=`$CAT $MASTER_MYPID$1`
1689
shutdown_mysqld $pid master $1
1690
if [ $? != 0 ] && [ -f $MASTER_MYPID$1 ]
1692
$ECHO "master not cooperating with mysqladmin, will try manual kill"
1694
sleep_until_file_deleted $pid $MASTER_MYPID$1
1695
if [ -f $MASTER_MYPID$1 ] ; then
1696
$ECHO "master refused to die. Sending SIGKILL"
1697
kill -9 `$CAT $MASTER_MYPID$1`
1698
$RM -f $MASTER_MYPID$1
1700
$ECHO "master responded to SIGTERM "
1703
sleep $SLEEP_TIME_AFTER_RESTART
1706
eval "MASTER$1_RUNNING=0"
1712
if [ "$MASTER_RUNNING" = 1 ]
1714
$ECHO "Ending Tests"
1715
$ECHO "Shutting-down MySQL daemon"
1719
$ECHO "Master shutdown finished"
1723
$ECHO "Slave shutdown finished"
1738
# cp $STD_DATA/*.frm $STD_DATA/*.MRG $MASTER_MYDDIR/test
1745
tname=`$BASENAME $tf .test`
1746
master_opt_file=$TESTDIR/$tname-master.opt
1747
slave_opt_file=$TESTDIR/$tname-slave.opt
1748
master_init_script=$TESTDIR/$tname-master.sh
1749
slave_init_script=$TESTDIR/$tname-slave.sh
1750
slave_master_info_file=$TESTDIR/$tname.slave-mi
1751
tsrcdir=$TESTDIR/$tname-src
1752
result_file="r/$tname.result"
1753
echo $tname > $CURRENT_TEST
1754
SKIP_SLAVE=`$EXPR \( $tname : rpl \) = 0 \& \( $tname : federated \) = 0`
1755
NDBCLUSTER_TEST=`$EXPR \( $tname : '.*ndb.*' \) != 0`
1756
if [ "x$USE_NDBCLUSTER_ALL" = "x1" ] ; then
1759
if [ "x$USE_NDBCLUSTER_ONLY" = "x1" -a "x$NDBCLUSTER_TEST" != "x1" ] ; then
1763
if [ "$USE_MANAGER" = 1 ] ; then
1764
many_slaves=`$EXPR \( \( $tname : rpl_failsafe \) != 0 \) \| \( \( $tname : rpl_chain_temp_table \) != 0 \)`
1766
if $EXPR "$tname" '<' "$START_FROM" > /dev/null ; then
1771
if [ "$SKIP_TEST" ] ; then
1772
if $EXPR \( "$tname" : "$SKIP_TEST" \) > /dev/null ; then
1778
if [ "$DO_TEST" ] ; then
1779
if $EXPR \( "$tname" : "$DO_TEST" \) > /dev/null ; then
1780
: #empty command to keep some shells happy
1787
if [ x${NO_SLAVE}x$SKIP_SLAVE = x1x0 ] ; then
1792
# if [ -f "$TESTDIR/$tname.disabled" ]
1794
# comment=`$CAT $TESTDIR/$tname.disabled`;
1795
# disable_test $tname "$comment"
1798
if [ -f "$TESTDIR/disabled.def" ] ; then
1799
comment=`$GREP "^$tname *: *" $TESTDIR/disabled.def`;
1800
if [ -n "$comment" ]
1802
comment=`echo $comment | sed 's/^[^:]*: *//'`
1803
disable_test $tname "$comment"
1808
if [ "x$USE_EMBEDDED_SERVER" != "x1" ] ; then
1809
# Stop all slave threads, so that we don't have useless reconnection
1810
# attempts and error messages in case the slave and master servers restart.
1812
stop_slave_threads 1
1813
stop_slave_threads 2
1816
# FIXME temporary solution, we will get a new C version of this
1817
# script soon anyway so it is not worth it spending the time
1818
if [ "x$USE_EMBEDDED_SERVER" = "x1" -a -z "$DO_TEST" ] ; then
1823
if [ "$tname" = "$t" ] ; then
1830
if [ $USE_RUNNING_SERVER -eq 0 ] ;
1832
if [ -f $master_opt_file ] ;
1834
EXTRA_MASTER_OPT=`$CAT $master_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1835
case "$EXTRA_MASTER_OPT" in
1837
TZ=`$ECHO "$EXTRA_MASTER_OPT" | $SED -e "s;--timezone=;;"`
1839
# Note that this must be set to space, not "" for test-reset to work
1840
EXTRA_MASTER_OPT=" "
1843
result_file=`$ECHO "$EXTRA_MASTER_OPT" | $SED -e "s;--result-file=;;"`
1844
result_file="r/$result_file.result"
1845
# Note that this must be set to space, not "" for test-reset to work
1846
EXTRA_MASTER_OPT=" "
1849
# Note that this must be set to space, not "" for test-reset to work
1850
EXTRA_MASTER_OPT=" "
1856
# only stop the cluster if this test will not use cluster
1857
if [ x$NDBCLUSTER_TEST != x1 ] ;
1862
report_current_test $tname
1863
USING_NDBCLUSTER=$NDBCLUSTER_TEST
1864
# start_ndbcluster knows if cluster is already started
1867
if [ x$USING_NDBCLUSTER = x1 -a -z "$DO_BENCH" -a -z "$DO_STRESS" ] ; then
1868
echo "CURRENT_TEST: $tname" >> $MASTER_MYERR"1"
1871
TZ=$MY_TZ; export TZ
1873
# If we had extra master opts to the previous run
1874
# or there is no master running (FIXME strange.....)
1875
# or there is a master init script
1876
if [ ! -z "$EXTRA_MASTER_OPT" ] || [ x$MASTER_RUNNING != x1 ] || \
1877
[ -f $master_init_script ] || \
1878
[ -n "$USE_NDBCLUSTER" -a x$NDBCLUSTER_TEST != x$USING_NDBCLUSTER ]
1884
# only stop the cluster if this test will not use cluster
1885
if [ x$NDBCLUSTER_TEST != x1 ] ;
1890
report_current_test $tname
1891
USING_NDBCLUSTER=$NDBCLUSTER_TEST
1892
# start_ndbcluster knows if cluster is already started
1895
if [ x$USING_NDBCLUSTER = x1 -a -z "$DO_BENCH" -a -z "$DO_STRESS" ] ; then
1896
echo "CURRENT_TEST: $tname" >> $MASTER_MYERR"1"
1900
report_current_test $tname
1904
# We never start a slave if embedded server is used
1905
if [ "x$USE_EMBEDDED_SERVER" != "x1" ] ; then
1907
if [ -f $slave_opt_file ] ;
1909
EXTRA_SLAVE_OPT=`$CAT $slave_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1912
if [ ! -z "$EXTRA_SLAVE_OPT" ] || [ x$SLAVE_RUNNING != x1 ] ;
1919
if [ -f $slave_master_info_file ] ; then
1920
SLAVE_MASTER_INFO=`$CAT $slave_master_info_file`
1923
if [ ! -z "$SLAVE_MASTER_INFO" ] || [ x$SLAVE_RUNNING != x1 ] ;
1925
SLAVE_MASTER_INFO=""
1930
USING_NDBCLUSTER=$NDBCLUSTER_TEST
1931
if [ -n "$USE_NDBCLUSTER_SLAVE_OPT" ] ; then
1932
if [ x$USING_NDBCLUSTER != x1 ] ; then
1936
if [ x$USING_NDBCLUSTER = x1 ] ; then
1942
if [ x$do_slave_restart = x1 ] ; then
1944
echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
1947
echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
1949
if [ x$many_slaves = x1 ]; then
1956
if [ "x$START_AND_EXIT" = "x1" ] ; then
1957
echo "Servers started, exiting"
1963
if [ -f $tf ] ; then
1964
$RM -f r/$tname.*reject
1965
mysql_test_args="-R $result_file $EXTRA_MYSQL_TEST_OPT"
1966
if [ -z "$DO_CLIENT_GDB" ] ; then
1967
`$VALGRIND_MYSQLTEST $MYSQL_TEST $mysql_test_args < $tf 2> $TIMEFILE`;
1969
do_gdb_test "$mysql_test_args" "$tf"
1974
# Save the testcase log to mysqltest log file
1975
echo "CURRENT_TEST: $tname" >> $MYSQLTEST_LOG
1976
cat $TIMEFILE >> $MYSQLTEST_LOG
1978
pname=`$ECHO "$tname "|$CUT -c 1-24`
1981
if [ x$many_slaves = x1 ] ; then
1986
if [ $res = 0 ]; then
1990
if [ x$USE_TIMER = x1 -a -f "$MY_LOG_DIR/timer" ]; then
1991
TIMER=`cat $MY_LOG_DIR/timer`
1992
TIMER=`$PRINTF "%13s" $TIMER`
1994
$ECHO "$RES$RES_SPACE [ pass ] $TIMER"
1996
# why the following ``if'' ? That is why res==1 is special ?
1997
if [ $res = 62 ]; then
1999
$ECHO "$RES$RES_SPACE [ skipped ]"
2001
if [ $res -ne 1 ]; then
2002
$ECHO "mysqltest returned unexpected code $res, it has probably crashed" >> $TIMEFILE
2006
$ECHO "$RES$RES_SPACE [ fail ]"
2009
show_failed_diff $tname
2011
if [ x$FORCE != x1 ] ; then
2012
$ECHO "Aborting: $tname failed in $TEST_MODE mode. To continue, re-run with '--force'."
2014
if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
2015
[ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
2021
FAILED_CASES="$FAILED_CASES $tname"
2022
if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
2023
[ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
2035
STRESS_BASEDIR="$MYSQL_TEST_DIR/var/stress"
2037
#Clean-up old stress test basedir
2038
if [ -d $STRESS_BASEDIR ] ; then
2039
$RM -rf $STRESS_BASEDIR
2041
#Create stress test basedir
2042
mkdir $STRESS_BASEDIR
2044
if [ "$STRESS_SUITE" != "main" -a "$STRESS_SUITE" != "default" ] ; then
2045
STRESS_SUITE_DIR="$MYSQL_TEST_DIR/suite/$STRESS_SUITE"
2047
STRESS_SUITE_DIR="$MYSQL_TEST_DIR"
2050
if [ -d "$STRESS_SUITE_DIR" ] ; then
2051
STRESS_SUITE_T_DIR="$STRESS_SUITE_DIR/t"
2052
STRESS_SUITE_R_DIR="$STRESS_SUITE_DIR/r"
2053
#FIXME: check that dirs above are exist
2055
echo "Directory $STRESS_SUITE_DIR with test suite doesn't exists. Abort stress testing"
2059
if [ -n "$STRESS_TEST" ] ; then
2060
STRESS_TEST_FILE="$STRESS_BASEDIR/stress_tests.txt"
2061
echo $STRESS_TEST > $STRESS_TEST_FILE
2062
elif [ -n "$STRESS_TEST_FILE" ] ; then
2063
STRESS_TEST_FILE="$STRESS_SUITE_DIR/$STRESS_TEST_FILE"
2064
if [ ! -f "$STRESS_TEST_FILE" ] ; then
2065
echo "Specified file $STRESS_TEST_FILE with list of tests does not exist"
2066
echo "Please ensure that file exists and has proper permissions"
2070
STRESS_TEST_FILE="$STRESS_SUITE_DIR/stress_tests.txt"
2071
if [ ! -f "$STRESS_TEST_FILE" ] ; then
2072
echo "Default file $STRESS_TEST_FILE with list of tests does not exist."
2073
echo "Please use --stress-test-file option to specify custom one or you can"
2074
echo "just specify name of test for testing as last argument in command line"
2079
if [ -n "$STRESS_INIT_FILE" ] ; then
2080
STRESS_INIT_FILE="$STRESS_SUITE_DIR/$STRESS_INIT_FILE"
2081
if [ ! -f "$STRESS_INIT_FILE" ] ; then
2082
echo "Specified file $STRESS_INIT_FILE with list of tests doesn't exist."
2083
echo "Please ensure that file exists and has proper permissions"
2087
STRESS_INIT_FILE="$STRESS_SUITE_DIR/stress_init.txt"
2088
#Check for default init file
2089
if [ ! -f "$STRESS_INIT_FILE" ] ; then
2094
if [ "$STRESS_MODE" != "random" -a "$STRESS_MODE" != "seq" ] ; then
2095
echo "You specified wrong mode '$STRESS_MODE' for stress test."
2096
echo "Correct values are 'random' or 'seq'"
2100
STRESS_TEST_ARGS="--server-socket=$MASTER_MYSOCK \
2101
--server-user=$DBUSER \
2102
--server-database=$DB \
2103
--stress-suite-basedir=$MYSQL_TEST_DIR \
2104
--suite=$STRESS_SUITE \
2105
--stress-tests-file=$STRESS_TEST_FILE \
2106
--stress-basedir=$STRESS_BASEDIR \
2107
--server-logs-dir=$STRESS_BASEDIR \
2108
--stress-mode=$STRESS_MODE \
2109
--mysqltest=$CLIENT_BINDIR/mysqltest \
2110
--threads=$STRESS_THREADS \
2113
--log-error-details \
2116
if [ -n "$STRESS_INIT_FILE" ] ; then
2117
STRESS_TEST_ARGS="$STRESS_TEST_ARGS --stress-init-file=$STRESS_INIT_FILE"
2120
if [ -z "$STRESS_LOOP_COUNT" -a -z "$STRESS_TEST_COUNT" -a
2121
-z "$STRESS_TEST_DURATION" ] ; then
2123
#Limit stress testing with 20 loops in case when any limit parameter
2125
STRESS_TEST_COUNT=20
2128
if [ -n "$STRESS_LOOP_COUNT" ] ; then
2129
STRESS_TEST_ARGS="$STRESS_TEST_ARGS --loop-count=$STRESS_LOOP_COUNT"
2132
if [ -n "$STRESS_TEST_COUNT" ] ; then
2133
STRESS_TEST_ARGS="$STRESS_TEST_ARGS --test-count=$STRESS_TEST_COUNT"
2136
if [ -n "$STRESS_TEST_DURATION" ] ; then
2137
STRESS_TEST_ARGS="$STRESS_TEST_ARGS --test-duration=$STRESS_TEST_DURATION"
2140
echo "Stress test related variables:"
2142
echo "STRESS - $DO_STRESS"
2143
echo "STRESS_SUITE - $STRESS_SUITE"
2144
echo "STRESS_TEST_FILE - $STRESS_TEST_FILE"
2145
echo "STRESS_INIT_FILE - $STRESS_INIT_FILE"
2146
echo "STRESS_THREADS - $STRESS_THREADS"
2147
echo "STRESS_MODE - $STRESS_MODE"
2148
echo "STRESS_TEST_COUNT - $STRESS_TEST_COUNT"
2149
echo "STRESS_LOOP_COUNT - $STRESS_LOOP_COUNT"
2150
echo "STRESS_TEST_DURATION - $STRESS_TEST_DURATION"
2152
#echo "$STRESS_TEST_ARGS";
2154
$MYSQL_TEST_DIR/mysql-stress-test.pl $STRESS_TEST_ARGS
2159
######################################################################
2160
# Main script starts here
2161
######################################################################
2163
[ "$DO_GCOV" -a ! -x "$GCOV" ] && error "No gcov found"
2165
[ "$DO_GCOV" ] && gcov_prepare
2166
[ "$DO_GPROF" ] && gprof_prepare
2168
if [ $USE_RUNNING_SERVER -eq 0 ]
2170
if [ -z "$FAST_START" ]
2172
# Ensure that no old mysqld test servers are running
2173
$MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2174
$MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK1 -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2175
$MYSQLADMIN --no-defaults --socket=$SLAVE_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2176
$MYSQLADMIN --no-defaults --host=$hostname --port=$MASTER_MYPORT --protocol=tcp -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2177
$MYSQLADMIN --no-defaults --host=$hostname --protocol=tcp --port=`expr $MASTER_MYPORT + 1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2178
$MYSQLADMIN --no-defaults --host=$hostname --protocol=tcp --port=$SLAVE_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2179
$MYSQLADMIN --no-defaults --host=$hostname --protocol=tcp --port=`expr $SLAVE_MYPORT + 1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2180
sleep_until_file_deleted 0 $MASTER_MYPID
2181
sleep_until_file_deleted 0 $MASTER_MYPID"1"
2182
sleep_until_file_deleted 0 $SLAVE_MYPID
2184
rm $MASTER_MYPID $MASTER_MYPID"1" $SLAVE_MYPID
2187
# just to force stopping anything from previous runs
2188
USE_NDBCLUSTER_OPT=$USE_NDBCLUSTER
2191
# Remove files that can cause problems
2192
$RM -rf $MYSQL_TEST_DIR/var/ndbcluster
2193
$RM -rf $MYSQL_TEST_DIR/var/tmp/snapshot*
2194
$RM -rf $MYSQL_TEST_DIR/var/run/* $MYSQL_TEST_DIR/var/tmp/*
2196
# Remove old berkeley db log files that can confuse the server
2197
$RM -f $MASTER_MYDDIR/log.*
2198
$RM -f $MASTER_MYDDIR"1"/log.*
2200
# Remove old log and reject files
2201
$RM -f r/*.reject r/*.progress r/*.log r/*.warnings
2203
wait_for_master=$SLEEP_TIME_FOR_FIRST_MASTER
2204
wait_for_slave=$SLEEP_TIME_FOR_FIRST_SLAVE
2205
$ECHO "Installing Test Databases"
2208
if [ -n "$1" -a `expr "X$*" : '.*ndb'` -eq 0 ]
2215
$ECHO "Loading Standard Test Databases"
2219
$ECHO "Starting Tests"
2221
# Some test cases need USE_RUNNING_SERVER
2222
export USE_RUNNING_SERVER
2225
# This can probably be deleted
2227
if [ "$DO_BENCH" = 1 ]
2231
if [ "$DO_SMALL_BENCH" = 1 ]
2233
EXTRA_BENCH_ARGS="--small-test --small-tables"
2236
if [ x$USING_NDBCLUSTER = x1 ]
2238
EXTRA_BENCH_ARGS="--create-options=TYPE=ndb $EXTRA_BENCH_ARGS"
2241
BENCHDIR=$BASEDIR/sql-bench/
2246
./run-all-tests --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS --log
2250
./$1 --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS
2252
echo "benchmark $1 not found"
2263
if [ "$DO_STRESS" = 1 ]
2266
if [ -n "$1" ] ; then
2270
if [ $USE_RUNNING_SERVER -eq 0 ] ; then
2276
if [ $USE_RUNNING_SERVER -eq 0 ] ; then
2286
if [ x$USE_TIMER = x1 ] ; then
2287
$ECHO "TEST RESULT TIME (ms)"
2295
if [ x$RECORD = x1 ]; then
2296
$ECHO "Will not run in record mode without a specific test case."
2298
for tf in $TESTDIR/*.$TESTSUFFIX
2302
$RM -f $TIMEFILE # Remove for full test
2305
while [ ! -z "$1" ]; do
2306
tname=`$BASENAME $1 .test`
2307
tf=$TESTDIR/$tname.$TESTSUFFIX
2308
if [ -f $tf ] ; then
2311
$ECHO "Test case $tf does not exist."
2320
if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && [ -z "$DO_DDD" ]
2327
[ "$DO_GCOV" ] && gcov_collect # collect coverage information
2328
[ "$DO_GPROF" ] && gprof_collect # collect coverage information
2330
if [ $TOT_FAIL -ne 0 ]; then
2331
$ECHO "mysql-test-run in $TEST_MODE mode: *** Failing the test(s):$FAILED_CASES"
2335
if [ $GOT_WARNINGS -ne 0 ]; then