mysql-test-run.sh 36.2 KB
Newer Older
unknown's avatar
unknown committed
1
#! /bin/sh
2 3
# mysql-test-run - originally written by Matt Wagner <matt@mysql.com>
# modified by Sasha Pachev <sasha@mysql.com>
unknown's avatar
unknown committed
4
# Sligtly updated by Monty
5
# Cleaned up again by Matt
unknown's avatar
unknown committed
6 7
# Fixed by Sergei
# :-)
unknown's avatar
unknown committed
8 9 10 11 12

#++
# Access Definitions
#--
DB=test
13
DBPASSWD=
14
VERBOSE=""
unknown's avatar
unknown committed
15
USE_MANAGER=0
unknown's avatar
unknown committed
16
TZ=GMT-3; export TZ # for UNIX_TIMESTAMP tests to work
unknown's avatar
unknown committed
17

18 19 20 21
#++
# Program Definitions
#--

22
PATH=/bin:/usr/bin:/usr/local/bin:/usr/bsd:/usr/X11R6/bin:/usr/openwin/bin:/usr/bin/X11:$PATH
23
MASTER_40_ARGS="--rpl-recovery-rank=1 --init-rpl-role=master"
24

25 26 27 28
# Standard functions

which ()
{
29
  IFS="${IFS=   }"; save_ifs="$IFS"; IFS=':'
30 31
  for file
  do
32
    for dir in $PATH
33
    do
unknown's avatar
unknown committed
34
      if test -f $dir/$file
35 36 37 38 39
      then
        echo "$dir/$file"
        continue 2
      fi
    done
40
    echo "Fatal error: Cannot find program $file in $PATH" 1>&2
41 42
    exit 1
  done
43
  IFS="$save_ifs"
44
  exit 0
45 46 47
}


unknown's avatar
unknown committed
48 49
sleep_until_file_deleted ()
{
50 51
  pid=$1;
  file=$2
unknown's avatar
unknown committed
52
  loop=$SLEEP_TIME_FOR_DELETE
unknown's avatar
unknown committed
53 54
  while (test $loop -gt 0)
  do
unknown's avatar
unknown committed
55
    if [ ! -r $file ]
unknown's avatar
unknown committed
56
    then
57 58 59 60
      if test $pid != "0"
      then
        wait_for_pid $pid
      fi
unknown's avatar
unknown committed
61 62
      return
    fi
unknown's avatar
unknown committed
63
    sleep 1
unknown's avatar
unknown committed
64 65 66 67
    loop=`expr $loop - 1`
  done
}

68
sleep_until_file_created ()
unknown's avatar
unknown committed
69 70
{
  file=$1
unknown's avatar
unknown committed
71 72
  loop=$2
  org_time=$2
unknown's avatar
unknown committed
73 74
  while (test $loop -gt 0)
  do
unknown's avatar
unknown committed
75
    if [ -r $file ]
unknown's avatar
unknown committed
76
    then
77
      return 0
unknown's avatar
unknown committed
78
    fi
unknown's avatar
unknown committed
79
    sleep 1
unknown's avatar
unknown committed
80 81
    loop=`expr $loop - 1`
  done
unknown's avatar
unknown committed
82
  echo "ERROR: $file was not created in $org_time seconds;  Aborting"
unknown's avatar
unknown committed
83 84 85
  exit 1;
}

86 87 88 89 90
# For the future

wait_for_pid()
{
  pid=$1
unknown's avatar
unknown committed
91
  #$WAIT_PID pid $SLEEP_TIME_FOR_DELETE
92 93
}

94 95
# No paths below as we can't be sure where the program is!

unknown's avatar
unknown committed
96 97
SED=sed

98 99
BASENAME=`which basename`
if test $? != 0; then exit 1; fi
unknown's avatar
unknown committed
100
DIFF=`which diff | $SED q`
101
if test $? != 0; then exit 1; fi
102 103
CAT=cat
CUT=cut
unknown's avatar
unknown committed
104
HEAD=head
105 106 107 108
TAIL=tail
ECHO=echo # use internal echo if possible
EXPR=expr # use internal if possible
FIND=find
unknown's avatar
unknown committed
109
GREP=grep
110
if test $? != 0; then exit 1; fi
111 112
PRINTF=printf
RM=rm
113 114
TIME=`which time`
if test $? != 0; then exit 1; fi
115
TR=tr
116 117
XARGS=`which xargs`
if test $? != 0; then exit 1; fi
118 119 120 121 122

# Are we using a source or a binary distribution?

testdir=@testdir@
if [ -d bin/mysqld ] && [ -d mysql-test ] ; then
123 124
 cd mysql-test
else
125 126
 if [ -d $testdir/mysql-test ] ; then
   cd $testdir
127
 fi
128 129 130 131 132 133 134
fi

if [ ! -f ./mysql-test-run ] ; then
  $ECHO "Can't find the location for the mysql-test-run script"

  $ECHO "Go to to the mysql-test directory and execute the script as follows:"
  $ECHO "./mysql-test-run."
unknown's avatar
unknown committed
135
  exit 1
136
fi
137

unknown's avatar
unknown committed
138 139 140
#++
# Misc. Definitions
#--
141

142 143 144 145 146
if [ -d ../sql ] ; then
   SOURCE_DIST=1
else
   BINARY_DIST=1
fi
147

unknown's avatar
unknown committed
148
#BASEDIR is always one above mysql-test directory
unknown's avatar
unknown committed
149 150 151 152
CWD=`pwd`
cd ..
BASEDIR=`pwd`
cd $CWD
153
MYSQL_TEST_DIR=$BASEDIR/mysql-test
154
export MYSQL_TEST_DIR
155
STD_DATA=$MYSQL_TEST_DIR/std_data
unknown's avatar
unknown committed
156
hostname=`hostname`		# Installed in the mysql privilege table
unknown's avatar
unknown committed
157

unknown's avatar
unknown committed
158
MANAGER_QUIET_OPT="-q"
159
TESTDIR="$MYSQL_TEST_DIR/t"
unknown's avatar
unknown committed
160
TESTSUFFIX=test
161
TOT_SKIP=0
unknown's avatar
unknown committed
162 163 164
TOT_PASS=0
TOT_FAIL=0
TOT_TEST=0
165 166 167
USERT=0
SYST=0
REALT=0
168
FAST_START=""
unknown's avatar
unknown committed
169
MYSQL_TMP_DIR=$MYSQL_TEST_DIR/var/tmp
unknown's avatar
unknown committed
170
SLAVE_LOAD_TMPDIR=../../var/tmp #needs to be same length to test logging
unknown's avatar
unknown committed
171
RES_SPACE="      "
unknown's avatar
unknown committed
172 173
MYSQLD_SRC_DIRS="strings mysys include extra regex isam merge myisam \
 myisammrg heap sql"
174
MY_LOG_DIR="$MYSQL_TEST_DIR/var/log" 
175 176 177
#
# Set LD_LIBRARY_PATH if we are using shared libraries
#
unknown's avatar
unknown committed
178
LD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$LD_LIBRARY_PATH"
179
export LD_LIBRARY_PATH
180

unknown's avatar
fixed  
unknown committed
181
MASTER_RUNNING=0
182
MASTER_MYPORT=9306
unknown's avatar
fixed  
unknown committed
183
SLAVE_RUNNING=0
184
SLAVE_MYPORT=9307
unknown's avatar
unknown committed
185 186 187 188
MYSQL_MANAGER_PORT=9305 # needs to be out of the way of slaves
MYSQL_MANAGER_PW_FILE=$MYSQL_TEST_DIR/var/tmp/manager.pwd
MYSQL_MANAGER_LOG=$MYSQL_TEST_DIR/var/log/manager.log
MYSQL_MANAGER_USER=root
189
NO_SLAVE=0
unknown's avatar
unknown committed
190
USER_TEST=
191

192
EXTRA_MASTER_OPT=""
193 194 195 196
EXTRA_MYSQL_TEST_OPT=""
USE_RUNNING_SERVER=1
DO_GCOV=""
DO_GDB=""
unknown's avatar
unknown committed
197
MANUAL_GDB=""
198
DO_DDD=""
199
DO_CLIENT_GDB=""
unknown's avatar
unknown committed
200
SLEEP_TIME_AFTER_RESTART=1
unknown's avatar
unknown committed
201
SLEEP_TIME_FOR_DELETE=10
unknown's avatar
unknown committed
202
SLEEP_TIME_FOR_FIRST_MASTER=400		# Enough time to create innodb tables
unknown's avatar
unknown committed
203
SLEEP_TIME_FOR_SECOND_MASTER=30
unknown's avatar
unknown committed
204
SLEEP_TIME_FOR_FIRST_SLAVE=400
unknown's avatar
unknown committed
205
SLEEP_TIME_FOR_SECOND_SLAVE=30
unknown's avatar
unknown committed
206
CHARACTER_SET=latin1
207
DBUSER=""
208 209
START_WAIT_TIMEOUT=10
STOP_WAIT_TIMEOUT=10
210 211 212

while test $# -gt 0; do
  case "$1" in
213 214
    --user=*) DBUSER=`$ECHO "$1" | $SED -e "s;--user=;;"` ;;
    --force)  FORCE=1 ;;
unknown's avatar
unknown committed
215
    --verbose-manager)  MANAGER_QUIET_OPT="" ;;
216 217 218 219 220
    --old-master) MASTER_40_ARGS="";;
    --master-binary=*)
      MASTER_MYSQLD=`$ECHO "$1" | $SED -e "s;--master-binary=;;"` ;;
    --slave-binary=*)
      SLAVE_MYSQLD=`$ECHO "$1" | $SED -e "s;--slave-binary=;;"` ;;
221
    --local)   USE_RUNNING_SERVER="" ;;
222
    --extern)   USE_RUNNING_SERVER="1" ;;
223
    --tmpdir=*) MYSQL_TMP_DIR=`$ECHO "$1" | $SED -e "s;--tmpdir=;;"` ;;
224 225 226 227 228
    --local-master)
      MASTER_MYPORT=3306;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --host=127.0.0.1 \
      --port=$MYSQL_MYPORT"
      LOCAL_MASTER=1 ;;
229 230
    --master_port=*) MASTER_MYPORT=`$ECHO "$1" | $SED -e "s;--master_port=;;"` ;;
    --slave_port=*) SLAVE_MYPORT=`$ECHO "$1" | $SED -e "s;--slave_port=;;"` ;;
unknown's avatar
unknown committed
231
    --manager-port=*) MYSQL_MANAGER_PORT=`$ECHO "$1" | $SED -e "s;--manager_port=;;"` ;;
unknown's avatar
unknown committed
232 233
    --with-openssl)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
unknown's avatar
unknown committed
234 235 236
     --ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/server-cert.pem \
     --ssl-key=$BASEDIR/SSL/server-key.pem"
unknown's avatar
unknown committed
237
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
unknown's avatar
unknown committed
238 239 240
     --ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/server-cert.pem \
     --ssl-key=$BASEDIR/SSL/server-key.pem" ;;
unknown's avatar
unknown committed
241
    --no-manager | --skip-manager) USE_MANAGER=0 ;;
242 243 244 245
    --manager)
     USE_MANAGER=1
     USE_RUNNING_SERVER=
     ;;
246 247
    --start-and-exit)
     START_AND_EXIT=1
unknown's avatar
unknown committed
248
     ;;
unknown's avatar
unknown committed
249 250 251
    --skip-innodb)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-innodb"
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-innodb" ;;
252 253 254
    --skip-bdb)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-bdb"
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-bdb" ;;
255
    --skip-rpl) NO_SLAVE=1 ;;
unknown's avatar
unknown committed
256
    --skip-test=*) SKIP_TEST=`$ECHO "$1" | $SED -e "s;--skip-test=;;"`;;
257
    --do-test=*) DO_TEST=`$ECHO "$1" | $SED -e "s;--do-test=;;"`;;
258 259 260 261
    --warnings | --log-warnings)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --log-warnings"
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --log-warnings"
     ;;
unknown's avatar
unknown committed
262 263 264
    --wait-timeout=*)
     START_WAIT_TIMEOUT=`$ECHO "$1" | $SED -e "s;--wait-timeout=;;"`
     STOP_WAIT_TIMEOUT=$START_WAIT_TIMEOUT;;
265 266 267
    --record)
      RECORD=1;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
unknown's avatar
unknown committed
268 269 270
    --bench)
      DO_BENCH=1
      NO_SLAVE=1
unknown's avatar
unknown committed
271
      ;;
272 273
    --big*)			# Actually --big-test
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
unknown's avatar
unknown committed
274 275
    --compress)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
276 277
    --sleep=*)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1"
unknown's avatar
unknown committed
278
      SLEEP_TIME_AFTER_RESTART=`$ECHO "$1" | $SED -e "s;--sleep=;;"`
279
      ;;
unknown's avatar
unknown committed
280 281 282
    --user-test=*)
      USER_TEST=`$ECHO "$1" | $SED -e "s;--user-test=;;"`
      ;;
283
    --mysqld=*)
unknown's avatar
unknown committed
284
       TMP=`$ECHO "$1" | $SED -e "s;--mysqld=;;"`
unknown's avatar
unknown committed
285
       EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $TMP"
286
       EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $TMP"
287
       ;;
288 289 290 291 292 293
    --gcov )
      if [ x$BINARY_DIST = x1 ] ; then
	$ECHO "Cannot do coverage test without the source - please use source dist"
	exit 1
      fi
      DO_GCOV=1
294
      GCOV=`which gcov`
295
      ;;
unknown's avatar
unknown committed
296 297
    --gprof )
      DO_GPROF=1
unknown's avatar
unknown committed
298
      ;;
299
    --gdb )
unknown's avatar
unknown committed
300 301
      START_WAIT_TIMEOUT=300
      STOP_WAIT_TIMEOUT=300
302
      if [ x$BINARY_DIST = x1 ] ; then
303
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --gdb option"
304 305
      fi
      DO_GDB=1
unknown's avatar
unknown committed
306 307
      # This needs to be checked properly
      # USE_MANAGER=1
308
      USE_RUNNING_SERVER=""
309
      ;;
310 311 312 313 314 315
    --client-gdb )
      if [ x$BINARY_DIST = x1 ] ; then
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --client-gdb option"
      fi
      DO_CLIENT_GDB=1
      ;;
unknown's avatar
unknown committed
316 317 318 319 320
    --manual-gdb )
      DO_GDB=1
      MANUAL_GDB=1
      USE_RUNNING_SERVER=""
      ;;
321 322
    --ddd )
      if [ x$BINARY_DIST = x1 ] ; then
323
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --ddd option"
324 325
      fi
      DO_DDD=1
326
      USE_RUNNING_SERVER=""
327
      ;;
unknown's avatar
unknown committed
328 329 330 331
    --valgrind)
      VALGRIND="valgrind --alignment=8 --leak-check=yes"
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-safemalloc"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-safemalloc"
unknown's avatar
unknown committed
332
      SLEEP_TIME_AFTER_RESTART=10
unknown's avatar
unknown committed
333
      SLEEP_TIME_FOR_DELETE=120
334
      USE_RUNNING_SERVER=""
unknown's avatar
unknown committed
335 336 337 338 339
      ;;
    --valgrind-options=*)
      TMP=`$ECHO "$1" | $SED -e "s;--valgrind-options=;;"`
      VALGRIND="$VALGRIND $TMP"
      ;;
340 341 342 343
    --skip-*)
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $1"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $1"
      ;;
unknown's avatar
unknown committed
344 345
    --strace-client )
      STRACE_CLIENT=1
unknown's avatar
unknown committed
346
      ;;
347
    --debug)
348
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
unknown's avatar
unknown committed
349
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/master.trace"
350
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
unknown's avatar
unknown committed
351
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/slave.trace"
352
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --debug"
353
      ;;
354 355 356
    --fast)
      FAST_START=1
      ;;
357 358 359 360 361 362
    -- )  shift; break ;;
    --* ) $ECHO "Unrecognized option: $1"; exit 1 ;;
    * ) break ;;
  esac
  shift
done
unknown's avatar
fixed  
unknown committed
363

unknown's avatar
unknown committed
364 365 366
#++
# mysqld Environment Parameters
#--
367

unknown's avatar
unknown committed
368
MYRUN_DIR=$MYSQL_TEST_DIR/var/run
369 370
MANAGER_PID_FILE="$MYRUN_DIR/manager.pid"

371
MASTER_MYDDIR="$MYSQL_TEST_DIR/var/master-data"
unknown's avatar
unknown committed
372
MASTER_MYSOCK="$MYSQL_TMP_DIR/master.sock"
unknown's avatar
unknown committed
373 374 375
MASTER_MYPID="$MYRUN_DIR/master.pid"
MASTER_MYLOG="$MYSQL_TEST_DIR/var/log/master.log"
MASTER_MYERR="$MYSQL_TEST_DIR/var/log/master.err"
376 377

SLAVE_MYDDIR="$MYSQL_TEST_DIR/var/slave-data"
unknown's avatar
unknown committed
378
SLAVE_MYSOCK="$MYSQL_TMP_DIR/slave.sock"
unknown's avatar
unknown committed
379 380 381
SLAVE_MYPID="$MYRUN_DIR/slave.pid"
SLAVE_MYLOG="$MYSQL_TEST_DIR/var/log/slave.log"
SLAVE_MYERR="$MYSQL_TEST_DIR/var/log/slave.err"
382

383
CURRENT_TEST="$MYSQL_TEST_DIR/var/log/current_test"
384 385
SMALL_SERVER="-O key_buffer_size=1M -O sort_buffer=256K -O max_heap_table_size=1M"

unknown's avatar
unknown committed
386 387 388
export MASTER_MYPORT
export SLAVE_MYPORT

389 390 391 392
if [ x$SOURCE_DIST = x1 ] ; then
 MY_BASEDIR=$MYSQL_TEST_DIR
else
 MY_BASEDIR=$BASEDIR
unknown's avatar
unknown committed
393
fi
unknown's avatar
unknown committed
394

unknown's avatar
unknown committed
395 396 397 398 399 400 401 402
# Create the directories

# This should be fixed to be not be dependent on the contence of MYSQL_TMP_DIR
# or MYRUN_DIR
# (mkdir -p is not portable)
[ -d $MYSQL_TEST_DIR/var ] || mkdir $MYSQL_TEST_DIR/var
[ -d $MYSQL_TEST_DIR/var/tmp ] || mkdir $MYSQL_TEST_DIR/var/tmp
[ -d $MYSQL_TEST_DIR/var/run ] || mkdir $MYSQL_TEST_DIR/var/run
403
[ -d $MYSQL_TEST_DIR/var/log ] || mkdir $MYSQL_TEST_DIR/var/log
unknown's avatar
unknown committed
404

405
if test ${COLUMNS:-0} -lt 80 ; then COLUMNS=80 ; fi
406
E=`$EXPR $COLUMNS - 8`
407
DASH72=`$ECHO '------------------------------------------------------------------------'|$CUT -c 1-$E`
408

409 410 411
# on source dist, we pick up freshly build executables
# on binary, use what is installed
if [ x$SOURCE_DIST = x1 ] ; then
unknown's avatar
unknown committed
412
 MYSQLD="$VALGRIND $BASEDIR/sql/mysqld"
413
 if [ -f "$BASEDIR/client/.libs/lt-mysqltest" ] ; then
414
   MYSQL_TEST="$BASEDIR/client/.libs/lt-mysqltest"
unknown's avatar
unknown committed
415 416
 elif [ -f "$BASEDIR/client/.libs/mysqltest" ] ; then
   MYSQL_TEST="$BASEDIR/client/.libs/mysqltest"
417 418 419
 else
   MYSQL_TEST="$BASEDIR/client/mysqltest"
 fi
unknown's avatar
unknown committed
420 421 422
 if [ -n "$STRACE_CLIENT" ]; then
  MYSQL_TEST="strace -o $MYSQL_TEST_DIR/var/log/mysqltest.strace $MYSQL_TEST"
 fi
unknown's avatar
unknown committed
423

424
 MYSQLADMIN="$BASEDIR/client/mysqladmin"
unknown's avatar
unknown committed
425
 WAIT_PID="$BASEDIR/extra/mysql_waitpid"
unknown's avatar
unknown committed
426 427 428
 MYSQL_MANAGER_CLIENT="$BASEDIR/client/mysqlmanagerc"
 MYSQL_MANAGER="$BASEDIR/tools/mysqlmanager"
 MYSQL_MANAGER_PWGEN="$BASEDIR/client/mysqlmanager-pwgen"
unknown's avatar
unknown committed
429
 MYSQL="$BASEDIR/client/mysql"
430
 LANGUAGE="$BASEDIR/sql/share/english/"
431
 CHARSETSDIR="$BASEDIR/sql/share/charsets"
432 433
 INSTALL_DB="./install_test_db"
else
434 435
 if test -x "$BASEDIR/libexec/mysqld"
 then
unknown's avatar
unknown committed
436
   MYSQLD="$VALGRIND $BASEDIR/libexec/mysqld"
437
 else
unknown's avatar
unknown committed
438
   MYSQLD="$VALGRIND $BASEDIR/bin/mysqld"
439
 fi
440 441
 MYSQL_TEST="$BASEDIR/bin/mysqltest"
 MYSQLADMIN="$BASEDIR/bin/mysqladmin"
unknown's avatar
unknown committed
442
 WAIT_PID="$BASEDIR/bin/mysql_waitpid"
unknown's avatar
unknown committed
443 444 445
 MYSQL_MANAGER="$BASEDIR/bin/mysqlmanager"
 MYSQL_MANAGER_CLIENT="$BASEDIR/bin/mysqlmanagerc"
 MYSQL_MANAGER_PWGEN="$BASEDIR/bin/mysqlmanager-pwgen"
unknown's avatar
unknown committed
446
 MYSQL="$BASEDIR/bin/mysql"
unknown's avatar
unknown committed
447
 INSTALL_DB="./install_test_db -bin"
unknown's avatar
unknown committed
448
 if test -d "$BASEDIR/share/mysql/english"
449 450
 then
   LANGUAGE="$BASEDIR/share/mysql/english/"
451
   CHARSETSDIR="$BASEDIR/share/mysql/charsets"
452 453
 else
   LANGUAGE="$BASEDIR/share/english/"
454
   CHARSETSDIR="$BASEDIR/share/charsets"
455
  fi
456 457
fi

458 459 460 461 462 463 464 465 466 467
if [ -z "$MASTER_MYSQLD" ]
then
MASTER_MYSQLD=$MYSQLD
fi

if [ -z "$SLAVE_MYSQLD" ]
then
SLAVE_MYSQLD=$MYSQLD
fi

468 469 470 471 472 473
# If we should run all tests cases, we will use a local server for that

if [ -z "$1" ]
then
   USE_RUNNING_SERVER=""
fi
474 475 476
if [ -n "$USE_RUNNING_SERVER" ]
then
   MASTER_MYSOCK="/tmp/mysql.sock"
477
   DBUSER=${DBUSER:-test}
478
else
479
   DBUSER=${DBUSER:-root}		# We want to do FLUSH xxx commands
480
fi
481 482 483 484 485 486 487 488

if [ -w / ]
then
    # We are running as root;  We need to add the --root argument
    EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --user=root"
    EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --user=root"
fi

489

490
MYSQL_TEST_ARGS="--no-defaults --socket=$MASTER_MYSOCK --database=$DB \
491
 --user=$DBUSER --password=$DBPASSWD --silent -v --skip-safemalloc \
492
 --tmpdir=$MYSQL_TMP_DIR --port=$MASTER_MYPORT"
493 494 495
MYSQL_TEST_BIN=$MYSQL_TEST
MYSQL_TEST="$MYSQL_TEST $MYSQL_TEST_ARGS"
GDB_CLIENT_INIT=$MYSQL_TMP_DIR/gdbinit.client
496 497 498
GDB_MASTER_INIT=$MYSQL_TMP_DIR/gdbinit.master
GDB_SLAVE_INIT=$MYSQL_TMP_DIR/gdbinit.slave
GCOV_MSG=$MYSQL_TMP_DIR/mysqld-gcov.out
unknown's avatar
unknown committed
499 500 501 502
GCOV_ERR=$MYSQL_TMP_DIR/mysqld-gcov.err
GPROF_DIR=$MYSQL_TMP_DIR/gprof
GPROF_MASTER=$GPROF_DIR/master.gprof
GPROF_SLAVE=$GPROF_DIR/slave.gprof
503
TIMEFILE="$MYSQL_TEST_DIR/var/log/mysqltest-time"
504 505 506
if [ -n "$DO_CLIENT_GDB" -o -n "$DO_GDB" ] ; then
  XTERM=`which xterm`
fi
507

unknown's avatar
unknown committed
508 509 510 511
#++
# Function Definitions
#--

unknown's avatar
unknown committed
512 513
prompt_user ()
{
514
 $ECHO $1
515
 read unused
unknown's avatar
unknown committed
516 517
}

unknown's avatar
unknown committed
518
# We can't use diff -u or diff -a as these are not portable
519

unknown's avatar
unknown committed
520 521 522 523
show_failed_diff ()
{
  reject_file=r/$1.reject
  result_file=r/$1.result
524
  eval_file=r/$1.eval
unknown's avatar
unknown committed
525

526 527 528 529
  if [ -f $eval_file ]
  then
    result_file=$eval_file
  fi
unknown's avatar
unknown committed
530

unknown's avatar
unknown committed
531 532 533 534
  if [ -x "$DIFF" ] && [ -f $reject_file ]
  then
    echo "Below are the diffs between actual and expected results:"
    echo "-------------------------------------------------------"
unknown's avatar
unknown committed
535
    $DIFF -c $result_file $reject_file
unknown's avatar
unknown committed
536
    echo "-------------------------------------------------------"
537 538 539
    echo "Please follow the instructions outlined at"
    echo "http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html"
    echo "to find the reason to this problem and how to report this."
unknown's avatar
unknown committed
540
  fi
unknown's avatar
unknown committed
541
}
unknown's avatar
unknown committed
542

543 544 545 546 547 548
do_gdb_test ()
{
  mysql_test_args="$MYSQL_TEST_ARGS $1"
  $ECHO "set args $mysql_test_args < $2" > $GDB_CLIENT_INIT
  echo "Set breakpoints ( if needed) and type 'run' in gdb window"
  #this xterm should not be backgrounded
unknown's avatar
unknown committed
549
  $XTERM -title "Client" -e gdb -x $GDB_CLIENT_INIT $MYSQL_TEST_BIN
550 551
}

unknown's avatar
unknown committed
552
error () {
unknown's avatar
unknown committed
553
    $ECHO  "Error:  $1"
unknown's avatar
unknown committed
554 555 556
    exit 1
}

557
error_is () {
unknown's avatar
unknown committed
558
    $CAT < $TIMEFILE | $SED -e 's/.* At line \(.*\)\: \(.*\)/   \>\> Error at line \1: \2<\</' | $HEAD -1
559 560
}

unknown's avatar
unknown committed
561
prefix_to_8() {
562
 $ECHO "        $1" | $SED -e 's:.*\(........\)$:\1:'
unknown's avatar
unknown committed
563 564
}

unknown's avatar
unknown committed
565
pass_inc () {
unknown's avatar
unknown committed
566
    TOT_PASS=`$EXPR $TOT_PASS + 1`
unknown's avatar
unknown committed
567 568 569
}

fail_inc () {
unknown's avatar
unknown committed
570
    TOT_FAIL=`$EXPR $TOT_FAIL + 1`
unknown's avatar
unknown committed
571 572
}

573 574 575 576
skip_inc () {
    TOT_SKIP=`$EXPR $TOT_SKIP + 1`
}

unknown's avatar
unknown committed
577
total_inc () {
unknown's avatar
unknown committed
578
    TOT_TEST=`$EXPR $TOT_TEST + 1`
unknown's avatar
unknown committed
579 580
}

581 582 583 584 585 586 587 588 589 590 591 592

skip_test() {
   USERT="    ...."
   SYST="    ...."
   REALT="    ...."
   timestr="$USERT $SYST $REALT"
   pname=`$ECHO "$1                        "|$CUT -c 1-24`
   RES="$pname  $timestr"
   skip_inc
   $ECHO "$RES$RES_SPACE [ skipped ]"
}

unknown's avatar
unknown committed
593
report_stats () {
594
    if [ $TOT_FAIL = 0 ]; then
unknown's avatar
unknown committed
595
	$ECHO "All $TOT_TEST tests were successful."
unknown's avatar
unknown committed
596
    else
unknown's avatar
unknown committed
597 598 599 600 601 602
	xten=`$EXPR $TOT_PASS \* 10000`
	raw=`$EXPR $xten / $TOT_TEST`
	raw=`$PRINTF %.4d $raw`
	whole=`$PRINTF %.2s $raw`
	xwhole=`$EXPR $whole \* 100`
	deci=`$EXPR $raw - $xwhole`
603
	$ECHO  "Failed ${TOT_FAIL}/${TOT_TEST} tests, ${whole}.${deci}% successful."
604
	$ECHO ""
605
        $ECHO "The log files in $MY_LOG_DIR may give you some hint"
606 607 608
	$ECHO "of what when wrong."
	$ECHO "If you want to report this error, please read first the documentation at"
        $ECHO "http://www.mysql.com/doc/M/y/MySQL_test_suite.html"
unknown's avatar
unknown committed
609
    fi
unknown's avatar
unknown committed
610

unknown's avatar
unknown committed
611 612 613
    if test -z "$USE_RUNNING_SERVER"
    then

unknown's avatar
unknown committed
614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635
    # Report if there was any fatal warnings/errors in the log files
    #
    $RM -f $MY_LOG_DIR/warnings $MY_LOG_DIR/warnings.tmp
    # Remove some non fatal warnings from the log files
    $SED -e 's!Warning:  Table:.* on delete!!g' \
         $MY_LOG_DIR/*.err > $MY_LOG_DIR/warnings.tmp

    found_error=0
    # Find errors
    for i in "^Warning:" "^Error:" "^==.* at 0x"
    do
      if `$GREP "$i" $MY_LOG_DIR/warnings.tmp >> $MY_LOG_DIR/warnings`
      then
        found_error=1
      fi
    done
    $RM -f $MY_LOG_DIR/warnings.tmp
    if [ $found_error = "1" ]
    then
      echo "WARNING: Got errors/warnings while running tests. Please examine"
      echo "$MY_LOG_DIR/warnings for details."
    fi
unknown's avatar
unknown committed
636
    fi
unknown's avatar
unknown committed
637
}
638

unknown's avatar
unknown committed
639
mysql_install_db () {
640
    $ECHO "Removing Stale Files"
641
    $RM -rf $MASTER_MYDDIR $SLAVE_MYDDIR $MY_LOG_DIR/* 
642
    $ECHO "Installing Master Databases"
643 644 645 646 647
    $INSTALL_DB
    if [ $? != 0 ]; then
	error "Could not install master test DBs"
	exit 1
    fi
648
    $ECHO "Installing Slave Databases"
649
    $INSTALL_DB -slave
650
    if [ $? != 0 ]; then
651
	error "Could not install slave test DBs"
652
	exit 1
unknown's avatar
unknown committed
653
    fi
unknown's avatar
unknown committed
654

655 656
    for slave_num in 1 2 ;
    do
657
      $RM -rf var/slave$slave_num-data
658 659 660
      mkdir -p var/slave$slave_num-data/mysql
      mkdir -p var/slave$slave_num-data/test
      cp var/slave-data/mysql/* var/slave$slave_num-data/mysql
661
    done
unknown's avatar
unknown committed
662 663 664
    return 0
}

unknown's avatar
unknown committed
665 666
gprof_prepare ()
{
unknown's avatar
unknown committed
667 668
 $RM -rf $GPROF_DIR
 mkdir -p $GPROF_DIR
unknown's avatar
unknown committed
669 670 671 672 673
}

gprof_collect ()
{
 if [ -f $MASTER_MYDDIR/gmon.out ]; then
674
   gprof $MASTER_MYSQLD $MASTER_MYDDIR/gmon.out > $GPROF_MASTER
unknown's avatar
unknown committed
675 676 677
   echo "Master execution profile has been saved in $GPROF_MASTER"
 fi
 if [ -f $SLAVE_MYDDIR/gmon.out ]; then
678
   gprof $SLAVE_MYSQLD $SLAVE_MYDDIR/gmon.out > $GPROF_SLAVE
unknown's avatar
unknown committed
679 680 681 682
   echo "Slave execution profile has been saved in $GPROF_SLAVE"
 fi
}

683
gcov_prepare () {
unknown's avatar
unknown committed
684 685
    $FIND $BASEDIR -name \*.gcov \
    -or -name \*.da | $XARGS $RM
unknown's avatar
unknown committed
686 687 688
}

gcov_collect () {
unknown's avatar
unknown committed
689
    $ECHO "Collecting source coverage info..."
unknown's avatar
unknown committed
690 691
    [ -f $GCOV_MSG ] && $RM $GCOV_MSG
    [ -f $GCOV_ERR ] && $RM $GCOV_ERR
unknown's avatar
unknown committed
692 693 694
    for d in $MYSQLD_SRC_DIRS; do
	cd $BASEDIR/$d
	for f in *.h *.cc *.c; do
unknown's avatar
unknown committed
695
	    $GCOV $f 2>>$GCOV_ERR  >>$GCOV_MSG
unknown's avatar
unknown committed
696
	done
697
	cd $MYSQL_TEST_DIR
unknown's avatar
unknown committed
698 699
    done

unknown's avatar
unknown committed
700
    $ECHO "gcov info in $GCOV_MSG, errors in $GCOV_ERR"
unknown's avatar
unknown committed
701 702
}

unknown's avatar
unknown committed
703 704 705 706 707
abort_if_failed()
{
 if [ ! $? = 0 ] ; then
  echo $1
  exit 1
unknown's avatar
unknown committed
708
 fi
unknown's avatar
unknown committed
709 710 711 712
}

start_manager()
{
unknown's avatar
unknown committed
713
 if [ $USE_MANAGER = 0 ] ; then
714 715
   echo "Manager disabled, skipping manager start."
   $RM -f $MYSQL_MANAGER_LOG
716 717
  return
 fi
unknown's avatar
unknown committed
718
 $ECHO "Starting MySQL Manager"
719 720 721 722 723 724 725 726 727
 if [ -f "$MANAGER_PID_FILE" ] ; then
    kill `cat $MANAGER_PID_FILE`
    sleep 1
    if [ -f "$MANAGER_PID_FILE" ] ; then
     kill -9 `cat $MANAGER_PID_FILE`
     sleep 1
    fi
 fi

unknown's avatar
unknown committed
728
 $RM -f $MANAGER_PID_FILE
unknown's avatar
unknown committed
729 730
 MYSQL_MANAGER_PW=`$MYSQL_MANAGER_PWGEN -u $MYSQL_MANAGER_USER \
 -o $MYSQL_MANAGER_PW_FILE`
unknown's avatar
unknown committed
731
 $MYSQL_MANAGER --log=$MYSQL_MANAGER_LOG --port=$MYSQL_MANAGER_PORT \
732
  --password-file=$MYSQL_MANAGER_PW_FILE --pid-file=$MANAGER_PID_FILE
unknown's avatar
unknown committed
733
  abort_if_failed "Could not start MySQL manager"
734 735
  mysqltest_manager_args="--manager-host=localhost \
  --manager-user=$MYSQL_MANAGER_USER \
736 737 738 739 740
  --manager-password=$MYSQL_MANAGER_PW \
  --manager-port=$MYSQL_MANAGER_PORT \
  --manager-wait-timeout=$START_WAIT_TIMEOUT"
  MYSQL_TEST="$MYSQL_TEST $mysqltest_manager_args"
  MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS $mysqltest_manager_args"
741 742 743 744
  while [ ! -f $MANAGER_PID_FILE ] ; do
   sleep 1
  done
  echo "Manager started"
unknown's avatar
unknown committed
745 746
}

unknown's avatar
unknown committed
747 748
stop_manager()
{
unknown's avatar
unknown committed
749
 if [ $USE_MANAGER = 0 ] ; then
750 751
  return
 fi
unknown's avatar
unknown committed
752 753 754 755
 $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT -u$MYSQL_MANAGER_USER \
  -p$MYSQL_MANAGER_PW -P $MYSQL_MANAGER_PORT <<EOF
shutdown
EOF
756 757
 echo "Manager terminated"

unknown's avatar
unknown committed
758 759 760
}

manager_launch()
unknown's avatar
unknown committed
761
{
unknown's avatar
unknown committed
762 763
  ident=$1
  shift
unknown's avatar
unknown committed
764
  if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
765
    $@  >> $CUR_MYERR 2>&1  &
unknown's avatar
unknown committed
766 767
    sleep 2 #hack
    return
768
  fi
unknown's avatar
unknown committed
769
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
unknown's avatar
unknown committed
770
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
unknown's avatar
unknown committed
771 772 773 774 775
def_exec $ident $@
set_exec_stdout $ident $CUR_MYERR
set_exec_stderr $ident $CUR_MYERR
set_exec_con $ident root localhost $CUR_MYSOCK
start_exec $ident $START_WAIT_TIMEOUT
unknown's avatar
unknown committed
776
EOF
unknown's avatar
unknown committed
777
  abort_if_failed "Could not execute manager command"
unknown's avatar
unknown committed
778
}
unknown's avatar
unknown committed
779

unknown's avatar
unknown committed
780 781
manager_term()
{
782 783
  pid=$1
  ident=$2
unknown's avatar
unknown committed
784
  if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
785 786
    # Shutdown time must be high as slave may be in reconnect
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock --connect_timeout=5 --shutdown_timeout=70 shutdown >> $MYSQL_MANAGER_LOG 2>&1
787 788 789 790 791 792 793 794
    res=$?
    # Some systems require an extra connect
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock --connect_timeout=1 ping >> $MYSQL_MANAGER_LOG 2>&1
    if test $res = 0
    then
      wait_for_pid $pid
    fi
    return $res
795
  fi
unknown's avatar
unknown committed
796 797
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
798
stop_exec $ident $STOP_WAIT_TIMEOUT
unknown's avatar
unknown committed
799 800 801 802 803
EOF
 abort_if_failed "Could not execute manager command"
}


unknown's avatar
unknown committed
804 805
start_master()
{
unknown's avatar
unknown committed
806 807 808 809 810 811 812
  if [ x$MASTER_RUNNING = x1 ] || [ x$LOCAL_MASTER = x1 ] ; then
    return
  fi
  # Remove old berkeley db log files that can confuse the server
  $RM -f $MASTER_MYDDIR/log.*
  # Remove stale binary logs
  $RM -f $MYSQL_TEST_DIR/var/log/master-bin.*
813 814
  # Remove old master.info and relay-log.info files
  $RM -f $MYSQL_TEST_DIR/var/master-data/master.info $MYSQL_TEST_DIR/var/master-data/relay-log.info
unknown's avatar
unknown committed
815 816 817 818 819 820 821 822 823 824 825 826

  #run master initialization shell script if one exists

  if [ -f "$master_init_script" ] ;
  then
      /bin/sh $master_init_script
  fi
  cd $BASEDIR # for gcov
  #start master
  if [ -z "$DO_BENCH" ]
  then
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin \
827 828
  	    --server-id=1  \
          --basedir=$MY_BASEDIR \
unknown's avatar
unknown committed
829
          --port=$MASTER_MYPORT \
unknown's avatar
unknown committed
830
          --local-infile \
unknown's avatar
unknown committed
831 832 833 834 835 836 837 838 839 840 841
          --exit-info=256 \
          --core \
          --datadir=$MASTER_MYDDIR \
          --pid-file=$MASTER_MYPID \
          --socket=$MASTER_MYSOCK \
          --log=$MASTER_MYLOG \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
          --innodb_data_file_path=ibdata1:50M \
842
	   $MASTER_40_ARGS \
unknown's avatar
unknown committed
843 844 845 846 847 848 849
           $SMALL_SERVER \
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT"
  else
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin \
          --server-id=1 --rpl-recovery-rank=1 \
          --basedir=$MY_BASEDIR --init-rpl-role=master \
          --port=$MASTER_MYPORT \
unknown's avatar
unknown committed
850
          --local-infile \
unknown's avatar
unknown committed
851 852 853 854 855 856 857 858 859
          --datadir=$MASTER_MYDDIR \
          --pid-file=$MASTER_MYPID \
          --socket=$MASTER_MYSOCK \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
          --innodb_data_file_path=ibdata1:50M \
860
	   $MASTER_40_ARGS \
unknown's avatar
unknown committed
861 862 863 864 865 866 867 868 869 870 871
           $SMALL_SERVER \
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT"
  fi

  CUR_MYERR=$MASTER_MYERR
  CUR_MYSOCK=$MASTER_MYSOCK

  if [ x$DO_DDD = x1 ]
  then
    $ECHO "set args $master_args" > $GDB_MASTER_INIT
    manager_launch master ddd -display $DISPLAY --debugger \
872
    "gdb -x $GDB_MASTER_INIT" $MASTER_MYSQLD
unknown's avatar
unknown committed
873 874
  elif [ x$DO_GDB = x1 ]
  then
unknown's avatar
unknown committed
875 876 877 878
    if [ x$MANUAL_GDB = x1 ]
    then
      $ECHO "set args $master_args" > $GDB_MASTER_INIT
      $ECHO "To start gdb for the master , type in another window:"
879
      $ECHO "cd $CWD ; gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD"
unknown's avatar
unknown committed
880 881 882 883
      wait_for_master=1500
    else
      ( $ECHO set args $master_args;
      if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
884
    cat <<EOF
unknown's avatar
unknown committed
885 886
b mysql_parse
commands 1
887
disa 1
unknown's avatar
unknown committed
888
end
unknown's avatar
unknown committed
889 890
r
EOF
unknown's avatar
unknown committed
891 892
      fi )  > $GDB_MASTER_INIT
      manager_launch master $XTERM -display $DISPLAY \
893
      -title "Master" -e gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD
unknown's avatar
unknown committed
894
    fi
unknown's avatar
unknown committed
895
  else
896
    manager_launch master $MASTER_MYSQLD $master_args
unknown's avatar
unknown committed
897
  fi
898
  sleep_until_file_created $MASTER_MYPID $wait_for_master
unknown's avatar
unknown committed
899
  wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
unknown's avatar
unknown committed
900 901 902 903 904
  MASTER_RUNNING=1
}

start_slave()
{
unknown's avatar
unknown committed
905 906 907
  [ x$SKIP_SLAVE = x1 ] && return
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  [ x$this_slave_running = 1 ] && return
unknown's avatar
unknown committed
908 909
  # When testing fail-safe replication, we will have more than one slave
  # in this case, we start secondary slaves with an argument
unknown's avatar
unknown committed
910 911 912 913 914 915 916 917
  slave_ident="slave$1"
  if [ -n "$1" ] ;
  then
   slave_server_id=`$EXPR 2 + $1`
   slave_rpl_rank=$slave_server_id
   slave_port=`expr $SLAVE_MYPORT + $1`
   slave_log="$SLAVE_MYLOG.$1"
   slave_err="$SLAVE_MYERR.$1"
918
   slave_datadir="$SLAVE_MYDDIR/../$slave_ident-data/"
unknown's avatar
unknown committed
919 920 921 922 923 924 925 926 927 928 929 930
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
   slave_sock="$SLAVE_MYSOCK-$1"
  else
   slave_server_id=2
   slave_rpl_rank=2
   slave_port=$SLAVE_MYPORT
   slave_log=$SLAVE_MYLOG
   slave_err=$SLAVE_MYERR
   slave_datadir=$SLAVE_MYDDIR
   slave_pid=$SLAVE_MYPID
   slave_sock="$SLAVE_MYSOCK"
 fi
unknown's avatar
unknown committed
931 932
  # Remove stale binary logs and old master.info files
  $RM -f $MYSQL_TEST_DIR/var/log/$slave_ident-*bin.*
933
  $RM -f $slave_datadir/master.info $slave_datadir/relay-log.info
unknown's avatar
unknown committed
934 935 936 937 938 939 940 941 942 943 944

  #run slave initialization shell script if one exists
  if [ -f "$slave_init_script" ] ;
  then
        /bin/sh $slave_init_script
  fi

  if [ -z "$SLAVE_MASTER_INFO" ] ; then
    master_info="--master-user=root \
          --master-connect-retry=1 \
          --master-host=127.0.0.1 \
945
          --master-password="" \
unknown's avatar
unknown committed
946 947 948 949 950 951 952 953 954 955
          --master-port=$MASTER_MYPORT \
          --server-id=$slave_server_id --rpl-recovery-rank=$slave_rpl_rank"
 else
   master_info=$SLAVE_MASTER_INFO
 fi

  $RM -f $slave_datadir/log.*
  slave_args="--no-defaults $master_info \
  	    --exit-info=256 \
          --log-bin=$MYSQL_TEST_DIR/var/log/$slave_ident-bin \
956
          --relay-log=$MYSQL_TEST_DIR/var/log/$slave_ident-relay-bin \
unknown's avatar
unknown committed
957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972
          --log-slave-updates \
          --log=$slave_log \
          --basedir=$MY_BASEDIR \
          --datadir=$slave_datadir \
          --pid-file=$slave_pid \
          --port=$slave_port \
          --socket=$slave_sock \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core --init-rpl-role=slave \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
          --skip-innodb --skip-slave-start \
          --slave-load-tmpdir=$SLAVE_LOAD_TMPDIR \
          --report-host=127.0.0.1 --report-user=root \
          --report-port=$slave_port \
973
          --master-retry-count=10 \
unknown's avatar
unknown committed
974
          -O slave_net_timeout=10 \
unknown's avatar
unknown committed
975 976 977 978 979 980 981 982 983 984 985 986
           $SMALL_SERVER \
           $EXTRA_SLAVE_OPT $EXTRA_SLAVE_MYSQLD_OPT"
  CUR_MYERR=$slave_err
  CUR_MYSOCK=$slave_sock

  if [ x$DO_DDD = x1 ]
  then
    $ECHO "set args $master_args" > $GDB_SLAVE_INIT
    manager_launch $slave_ident ddd -display $DISPLAY --debugger \
     "gdb -x $GDB_SLAVE_INIT" $SLAVE_MYSQLD
  elif [ x$DO_GDB = x1 ]
  then
unknown's avatar
unknown committed
987 988
    if [ x$MANUAL_GDB = x1 ]
    then
unknown's avatar
unknown committed
989
      $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
unknown's avatar
unknown committed
990
      echo "To start gdb for the slave, type in another window:"
991
      echo "cd $CWD ; gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD"
unknown's avatar
unknown committed
992 993
      wait_for_slave=1500
    else
unknown's avatar
unknown committed
994 995 996 997 998 999 1000 1001 1002 1003
      ( $ECHO set args $slave_args;
      if [ $USE_MANAGER = 0 ] ; then
    cat <<EOF
b mysql_parse
commands 1
disa 1
end
r
EOF
      fi )  > $GDB_SLAVE_INIT
unknown's avatar
unknown committed
1004 1005 1006
      manager_launch $slave_ident $XTERM -display $DISPLAY -title "Slave" -e \
      gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD
    fi
unknown's avatar
unknown committed
1007 1008 1009 1010
  else
    manager_launch $slave_ident $SLAVE_MYSQLD $slave_args
  fi
  eval "SLAVE$1_RUNNING=1"
1011
  sleep_until_file_created $slave_pid $wait_for_slave
unknown's avatar
unknown committed
1012
  wait_for_slave=$SLEEP_TIME_FOR_SECOND_SLAVE
unknown's avatar
unknown committed
1013 1014
}

unknown's avatar
unknown committed
1015 1016
mysql_start ()
{
unknown's avatar
unknown committed
1017 1018 1019 1020 1021 1022
# We should not start the deamon here as we don't know the argumens
# for the test.  Better to let the test start the deamon

#  $ECHO "Starting MySQL daemon"
#  start_master
#  start_slave
unknown's avatar
unknown committed
1023 1024
  cd $MYSQL_TEST_DIR
  return 1
unknown's avatar
unknown committed
1025 1026
}

unknown's avatar
unknown committed
1027 1028
stop_slave ()
{
1029 1030 1031
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  slave_ident="slave$1"
  if [ -n "$1" ] ;
unknown's avatar
unknown committed
1032
  then
1033 1034 1035
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
  else
   slave_pid=$SLAVE_MYPID
unknown's avatar
unknown committed
1036
  fi
1037 1038
  if [ x$this_slave_running = x1 ]
  then
1039 1040
    pid=`$CAT $slave_pid`
    manager_term $pid $slave_ident
1041
    if [ $? != 0 ] && [ -f $slave_pid ]
1042
    then # try harder!
1043
      $ECHO "slave not cooperating with mysqladmin, will try manual kill"
1044 1045
      kill $pid
      sleep_until_file_deleted $pid $slave_pid
1046 1047 1048 1049 1050 1051 1052 1053 1054
      if [ -f $slave_pid ] ; then
        $ECHO "slave refused to die. Sending SIGKILL"
        kill -9 `$CAT $slave_pid`
        $RM -f $slave_pid
      else
        $ECHO "slave responded to SIGTERM "
      fi
    else
      sleep $SLEEP_TIME_AFTER_RESTART
unknown's avatar
unknown committed
1055
    fi
1056
    eval "SLAVE$1_RUNNING=0"
unknown's avatar
unknown committed
1057
  fi
unknown's avatar
unknown committed
1058
}
unknown's avatar
unknown committed
1059

unknown's avatar
unknown committed
1060 1061 1062 1063
stop_master ()
{
  if [ x$MASTER_RUNNING = x1 ]
  then
1064 1065
    pid=`$CAT $MASTER_MYPID`
    manager_term $pid master
1066 1067
    if [ $? != 0 ] && [ -f $MASTER_MYPID ]
    then # try harder!
1068
      $ECHO "master not cooperating with mysqladmin, will try manual kill"
1069 1070
      kill $pid
      sleep_until_file_deleted $pid $MASTER_MYPID
1071 1072 1073 1074 1075 1076 1077 1078 1079
      if [ -f $MASTER_MYPID ] ; then
        $ECHO "master refused to die. Sending SIGKILL"
        kill -9 `$CAT $MASTER_MYPID`
        $RM -f $MASTER_MYPID
      else
        $ECHO "master responded to SIGTERM "
      fi
    else
      sleep $SLEEP_TIME_AFTER_RESTART
unknown's avatar
unknown committed
1080
    fi
unknown's avatar
unknown committed
1081 1082 1083
    MASTER_RUNNING=0
  fi
}
unknown's avatar
unknown committed
1084

unknown's avatar
unknown committed
1085 1086
mysql_stop ()
{
1087 1088
 $ECHO  "Ending Tests"
 $ECHO  "Shutting-down MySQL daemon"
1089
 $ECHO  ""
unknown's avatar
unknown committed
1090
 stop_master
unknown's avatar
unknown committed
1091
 $ECHO "Master shutdown finished"
unknown's avatar
unknown committed
1092
 stop_slave
1093 1094
 stop_slave 1
 stop_slave 2
unknown's avatar
unknown committed
1095
 $ECHO "Slave shutdown finished"
unknown's avatar
unknown committed
1096

unknown's avatar
unknown committed
1097
 return 1
unknown's avatar
unknown committed
1098 1099
}

unknown's avatar
unknown committed
1100 1101 1102 1103 1104
mysql_restart ()
{
  mysql_stop
  mysql_start
  return 1
unknown's avatar
unknown committed
1105 1106 1107
}

mysql_loadstd () {
unknown's avatar
unknown committed
1108 1109

    # cp $STD_DATA/*.frm $STD_DATA/*.MRG $MASTER_MYDDIR/test
unknown's avatar
unknown committed
1110 1111 1112
    return 1
}

unknown's avatar
unknown committed
1113 1114 1115
run_testcase ()
{
 tf=$1
unknown's avatar
unknown committed
1116
 tname=`$BASENAME $tf .test`
unknown's avatar
unknown committed
1117 1118
 master_opt_file=$TESTDIR/$tname-master.opt
 slave_opt_file=$TESTDIR/$tname-slave.opt
1119 1120
 master_init_script=$TESTDIR/$tname-master.sh
 slave_init_script=$TESTDIR/$tname-slave.sh
1121
 slave_master_info_file=$TESTDIR/$tname.slave-mi
1122
 echo $tname > $CURRENT_TEST
unknown's avatar
unknown committed
1123
 SKIP_SLAVE=`$EXPR \( $tname : rpl \) = 0`
unknown's avatar
unknown committed
1124
 if [ $USE_MANAGER = 1 ] ; then
1125
  many_slaves=`$EXPR \( $tname : rpl_failsafe \) != 0`
unknown's avatar
unknown committed
1126 1127 1128
 fi

 if [ -n "$SKIP_TEST" ] ; then
unknown's avatar
unknown committed
1129
   SKIP_THIS_TEST=`$EXPR \( $tname : "$SKIP_TEST" \) != 0`
unknown's avatar
unknown committed
1130 1131
   if [ x$SKIP_THIS_TEST = x1 ] ;
   then
1132 1133
     skip_test $tname;
     return;
unknown's avatar
unknown committed
1134 1135
   fi
  fi
1136

unknown's avatar
unknown committed
1137
 if [ -n "$DO_TEST" ] ; then
1138 1139 1140
   DO_THIS_TEST=`$EXPR \( $tname : "$DO_TEST" \) != 0`
   if [ x$DO_THIS_TEST = x0 ] ;
   then
1141 1142
     skip_test $tname;
     return;
1143 1144 1145 1146
   fi
  fi


1147 1148
 if [ x${NO_SLAVE}x$SKIP_SLAVE = x1x0 ] ;
 then
1149
   skip_test $tname;
1150 1151 1152
   return
 fi

1153
 if [ -z "$USE_RUNNING_SERVER" ] ;
unknown's avatar
unknown committed
1154
 then
1155 1156
   if [ -f $master_opt_file ] ;
   then
unknown's avatar
unknown committed
1157
     EXTRA_MASTER_OPT=`$CAT $master_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1158
     stop_master
unknown's avatar
unknown committed
1159
     echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
1160 1161 1162 1163 1164 1165
     start_master
   else
     if [ ! -z "$EXTRA_MASTER_OPT" ] || [ x$MASTER_RUNNING != x1 ] ;
     then
       EXTRA_MASTER_OPT=""
       stop_master
unknown's avatar
unknown committed
1166
       echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
1167
       start_master
unknown's avatar
unknown committed
1168 1169
     else
       echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
unknown's avatar
unknown committed
1170
     fi
1171
   fi
unknown's avatar
unknown committed
1172

unknown's avatar
unknown committed
1173
   do_slave_restart=0
1174 1175
   if [ -f $slave_opt_file ] ;
   then
unknown's avatar
unknown committed
1176
     EXTRA_SLAVE_OPT=`$CAT $slave_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1177 1178 1179 1180 1181
     do_slave_restart=1
   else
    if [ ! -z "$EXTRA_SLAVE_OPT" ] || [ x$SLAVE_RUNNING != x1 ] ;
    then
      EXTRA_SLAVE_OPT=""
unknown's avatar
unknown committed
1182 1183
      do_slave_restart=1
    fi
1184
   fi
unknown's avatar
fixed  
unknown committed
1185

1186 1187 1188 1189 1190 1191 1192
   if [ -f $slave_master_info_file ] ; then
     SLAVE_MASTER_INFO=`$CAT $slave_master_info_file`
     do_slave_restart=1
   else
     if [ ! -z "$SLAVE_MASTER_INFO" ] || [ x$SLAVE_RUNNING != x1 ] ;
     then
       SLAVE_MASTER_INFO=""
unknown's avatar
unknown committed
1193 1194
       do_slave_restart=1
     fi
1195 1196 1197 1198
   fi

   if [ x$do_slave_restart = x1 ] ; then
     stop_slave
unknown's avatar
unknown committed
1199
     echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
1200
     start_slave
unknown's avatar
unknown committed
1201 1202
   else
     echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
1203
   fi
1204 1205 1206 1207
   if [ x$many_slaves = x1 ]; then
    start_slave 1
    start_slave 2
   fi
unknown's avatar
fixed  
unknown committed
1208
 fi
1209
 cd $MYSQL_TEST_DIR
unknown's avatar
unknown committed
1210

unknown's avatar
unknown committed
1211
 if [ -f $tf ] ; then
unknown's avatar
unknown committed
1212
    $RM -f r/$tname.*reject
1213
    mysql_test_args="-R r/$tname.result $EXTRA_MYSQL_TEST_OPT"
1214 1215
    if [ -z "$DO_CLIENT_GDB" ] ; then
      mytime=`$TIME -p $MYSQL_TEST  $mysql_test_args < $tf 2> $TIMEFILE`
1216
    else
1217
      do_gdb_test "$mysql_test_args" "$tf"
1218
    fi
unknown's avatar
unknown committed
1219

unknown's avatar
unknown committed
1220 1221
    res=$?

unknown's avatar
unknown committed
1222
    if [ $res = 0 ]; then
1223
	mytime=`$CAT $TIMEFILE | $TAIL -3 | $TR '\n' ':'`
1224

1225
	USERT=`$ECHO $mytime | $CUT -d : -f 2 | $CUT -d ' ' -f 2`
unknown's avatar
unknown committed
1226
        USERT=`prefix_to_8 $USERT`
1227
	SYST=`$ECHO $mytime | $CUT -d : -f 3 | $CUT -d ' ' -f 2`
unknown's avatar
unknown committed
1228
        SYST=`prefix_to_8 $SYST`
1229
	REALT=`$ECHO $mytime | $CUT -d : -f 1 | $CUT -d ' ' -f 2`
unknown's avatar
unknown committed
1230
        REALT=`prefix_to_8 $REALT`
1231
    else
unknown's avatar
unknown committed
1232 1233 1234
	USERT="    ...."
	SYST="    ...."
	REALT="    ...."
1235 1236
    fi

1237
    timestr="$USERT $SYST $REALT"
1238 1239
    pname=`$ECHO "$tname                        "|$CUT -c 1-24`
    RES="$pname  $timestr"
unknown's avatar
unknown committed
1240

1241 1242 1243 1244
    if [ x$many_slaves = x1 ] ; then
     stop_slave 1
     stop_slave 2
    fi
unknown's avatar
unknown committed
1245

unknown's avatar
unknown committed
1246
    if [ $res = 0 ]; then
1247 1248
      total_inc
      pass_inc
1249
      $ECHO "$RES$RES_SPACE [ pass ]"
1250
    else
1251
      # why the following ``if'' ? That is why res==1 is special ?
1252 1253 1254 1255
      if [ $res = 2 ]; then
        skip_inc
	$ECHO "$RES$RES_SPACE [ skipped ]"
      else
1256
	total_inc
unknown's avatar
unknown committed
1257
        fail_inc
1258
	$ECHO "$RES$RES_SPACE [ fail ]"
1259 1260
        $ECHO
	error_is
unknown's avatar
unknown committed
1261
	show_failed_diff $tname
unknown's avatar
unknown committed
1262
	$ECHO
1263
	if [ x$FORCE != x1 ] ; then
1264 1265
	 $ECHO "Aborting. To continue, re-run with '--force'."
	 $ECHO
unknown's avatar
unknown committed
1266 1267 1268
         if [ -z "$DO_GDB" ] && [ -z "$USE_RUNNING_SERVER" ] && [ -z "$DO_DDD" ]
	 then
	   mysql_stop
unknown's avatar
unknown committed
1269
	   stop_manager
unknown's avatar
unknown committed
1270
   	 fi
1271 1272
	 exit 1
	fi
unknown's avatar
unknown committed
1273

unknown's avatar
unknown committed
1274 1275 1276 1277
        if [ -z "$DO_GDB" ] && [ -z "$USE_RUNNING_SERVER" ] && [ -z "$DO_DDD" ]
	then
	  mysql_restart
	fi
1278
	$ECHO "Resuming Tests"
1279
	$ECHO ""
1280
      fi
unknown's avatar
unknown committed
1281
    fi
1282
  fi
unknown's avatar
unknown committed
1283 1284
}

unknown's avatar
unknown committed
1285 1286 1287 1288
######################################################################
# Main script starts here
######################################################################

unknown's avatar
unknown committed
1289 1290
[ "$DO_GCOV" -a ! -x "$GCOV" ] && error "No gcov found"

unknown's avatar
unknown committed
1291 1292
[ "$DO_GCOV" ] && gcov_prepare
[ "$DO_GPROF" ] && gprof_prepare
unknown's avatar
unknown committed
1293

1294 1295
if [ -z "$USE_RUNNING_SERVER" ]
then
1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308
  if [ -z "$FAST_START" ]
  then
    # Ensure that no old mysqld test servers are running
    $MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --socket=$SLAVE_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=$MASTER_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=$SLAVE_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=`expr $SLAVE_MYPORT + 1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    sleep_until_file_deleted 0 $MASTER_MYPID
    sleep_until_file_deleted 0 $SLAVE_MYPID
  else
    rm $MASTER_MYPID $SLAVE_MYPID
  fi
unknown's avatar
unknown committed
1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324

  # Kill any running managers
  if [ -f "$MANAGER_PID_FILE" ]
  then
    kill `cat $MANAGER_PID_FILE`
    sleep 1
    if [ -f "$MANAGER_PID_FILE" ]
    then
      kill -9 `cat $MANAGER_PID_FILE`
      sleep 1
    fi
  fi

  # Remove files that can cause problems
  $RM -f $MYSQL_TEST_DIR/var/run/* $MYSQL_TEST_DIR/var/tmp/*

unknown's avatar
unknown committed
1325 1326
  wait_for_master=$SLEEP_TIME_FOR_FIRST_MASTER
  wait_for_slave=$SLEEP_TIME_FOR_FIRST_SLAVE
1327 1328
  $ECHO "Installing Test Databases"
  mysql_install_db
unknown's avatar
unknown committed
1329
  start_manager
unknown's avatar
unknown committed
1330 1331 1332

# Do not automagically start deamons if we are in gdb or running only one test
# case
1333 1334 1335 1336 1337 1338
  if [ -z "$DO_GDB" ] && [ -z "$DO_DDD" ]
  then
    mysql_start
  fi
  $ECHO  "Loading Standard Test Databases"
  mysql_loadstd
unknown's avatar
unknown committed
1339 1340
fi

1341 1342 1343 1344
if [ "x$START_AND_EXIT" = "x1" ] ; then
 echo "Servers started, exiting"
 exit
fi
unknown's avatar
unknown committed
1345

1346
$ECHO  "Starting Tests"
unknown's avatar
unknown committed
1347

unknown's avatar
unknown committed
1348 1349
if [ "$DO_BENCH" = 1 ]
then
unknown's avatar
unknown committed
1350 1351 1352 1353
  BENCHDIR=$BASEDIR/sql-bench/
  savedir=`pwd`
  cd $BENCHDIR
  if [ -z "$1" ]
unknown's avatar
unknown committed
1354
  then
unknown's avatar
unknown committed
1355
    ./run-all-tests --socket=$MASTER_MYSOCK --user=root
unknown's avatar
unknown committed
1356
  else
unknown's avatar
unknown committed
1357 1358 1359 1360 1361 1362
    if [ -x "./$1" ]
    then
       ./$1 --socket=$MASTER_MYSOCK --user=root
    else
      echo "benchmark $1 not found"
    fi
unknown's avatar
unknown committed
1363
  fi
unknown's avatar
unknown committed
1364 1365 1366 1367
  cd $savedir
  mysql_stop
  stop_manager
  exit
unknown's avatar
unknown committed
1368 1369
fi

unknown's avatar
unknown committed
1370
$ECHO
unknown's avatar
unknown committed
1371
$ECHO " TEST                         USER   SYSTEM  ELAPSED        RESULT"
unknown's avatar
unknown committed
1372 1373
$ECHO $DASH72

unknown's avatar
unknown committed
1374
if [ -z "$1" ] ;
unknown's avatar
unknown committed
1375
then
1376
 if [ x$RECORD = x1 ]; then
1377
  $ECHO "Will not run in record mode without a specific test case."
1378 1379 1380 1381 1382
 else
  for tf in $TESTDIR/*.$TESTSUFFIX
  do
    run_testcase $tf
  done
1383
  $RM -f $TIMEFILE	# Remove for full test
1384
 fi
unknown's avatar
unknown committed
1385
else
unknown's avatar
unknown committed
1386 1387 1388 1389 1390 1391 1392 1393 1394 1395
  while [ ! -z "$1" ]; do
    tname=`$BASENAME $1 .test`
    tf=$TESTDIR/$tname.$TESTSUFFIX
    if [ -f $tf ] ; then
      run_testcase $tf
    else
      $ECHO "Test case $tf does not exist."
    fi
    shift
  done
unknown's avatar
unknown committed
1396
fi
unknown's avatar
unknown committed
1397

unknown's avatar
unknown committed
1398 1399
$ECHO $DASH72
$ECHO
1400

1401
if [ -z "$DO_GDB" ] && [ -z "$USE_RUNNING_SERVER" ] && [ -z "$DO_DDD" ]
unknown's avatar
unknown committed
1402 1403 1404
then
    mysql_stop
fi
unknown's avatar
unknown committed
1405

unknown's avatar
unknown committed
1406
stop_manager
unknown's avatar
unknown committed
1407
report_stats
unknown's avatar
unknown committed
1408
$ECHO
unknown's avatar
unknown committed
1409

unknown's avatar
unknown committed
1410
[ "$DO_GCOV" ] && gcov_collect # collect coverage information
unknown's avatar
unknown committed
1411
[ "$DO_GPROF" ] && gprof_collect # collect coverage information
unknown's avatar
unknown committed
1412

unknown's avatar
unknown committed
1413
exit 0