mysql-test-run.pl 91.7 KB
Newer Older
unknown's avatar
unknown committed
1 2 3 4
#!/usr/bin/perl
# -*- cperl -*-

# This is a transformation of the "mysql-test-run" Bourne shell script
unknown's avatar
unknown committed
5 6
# to Perl. There are reasons this rewrite is not the prettiest Perl
# you have seen
unknown's avatar
unknown committed
7
#
unknown's avatar
unknown committed
8 9
#   - The original script is huge and for most part uncommented,
#     not even a usage description of the flags.
unknown's avatar
unknown committed
10
#
unknown's avatar
unknown committed
11 12 13 14 15 16
#   - There has been an attempt to write a replacement in C for the
#     original Bourne shell script. It was kind of working but lacked
#     lot of functionality to really be a replacement. Not to redo
#     that mistake and catch all the obscure features of the original
#     script, the rewrite in Perl is more close to the original script
#     meaning it also share some of the ugly parts as well.
unknown's avatar
unknown committed
17
#
unknown's avatar
unknown committed
18 19 20 21 22
#   - The original intention was that this script was to be a prototype
#     to be the base for a new C version with full functionality. Since
#     then it was decided that the Perl version should replace the
#     Bourne shell version, but the Perl style still reflects the wish
#     to make the Perl to C step easy.
unknown's avatar
unknown committed
23
#
unknown's avatar
unknown committed
24
# Some coding style from the original intent has been kept
unknown's avatar
unknown committed
25
#
unknown's avatar
unknown committed
26 27 28
#   - To make this Perl script easy to alter even for those that not
#     code Perl that often, the coding style is as close as possible to
#     the C/C++ MySQL coding standard.
unknown's avatar
unknown committed
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
#
#   - All lists of arguments to send to commands are Perl lists/arrays,
#     not strings we append args to. Within reason, most string
#     concatenation for arguments should be avoided.
#
#   - Functions defined in the main program are not to be prefixed,
#     functions in "library files" are to be prefixed with "mtr_" (for
#     Mysql-Test-Run). There are some exceptions, code that fits best in
#     the main program, but are put into separate files to avoid
#     clutter, may be without prefix.
#
#   - All stat/opendir/-f/ is to be kept in collect_test_cases(). It
#     will create a struct that the rest of the program can use to get
#     the information. This separates the "find information" from the
#     "do the work" and makes the program more easy to maintain.
#
#   - At the moment, there are tons of "global" variables that control
#     this script, even accessed from the files in "lib/*.pl". This
#     will change over time, for now global variables are used instead
#     of using %opt, %path and %exe hashes, because I want more
#     compile time checking, that hashes would not give me. Once this
#     script is debugged, hashes will be used and passed as parameters
#     to functions, to more closely mimic how it would be coded in C
#     using structs.
#
#   - The rule when it comes to the logic of this program is
#
#       command_line_setup() - is to handle the logic between flags
#       collect_test_cases() - is to do its best to select what tests
#                              to run, dig out options, if needs restart etc.
#       run_testcase()       - is to run a single testcase, and follow the
#                              logic set in both above. No, or rare file
#                              system operations. If a test seems complex,
#                              it should probably not be here.
#
# A nice way to trace the execution of this script while debugging
# is to use the Devel::Trace package found at
# "http://www.plover.com/~mjd/perl/Trace/" and run this script like
# "perl -d:Trace mysql-test-run.pl"
unknown's avatar
unknown committed
68 69 70 71 72
#
# FIXME Save a PID file from this code as well, to record the process
#       id we think it has. In Cygwin, a fork creates one Cygwin process,
#       and then the real Win32 process. Cygwin Perl can only kill Cygwin
#       processes. And "mysqld --bootstrap ..." doesn't save a PID file.
unknown's avatar
unknown committed
73 74 75 76 77 78 79 80 81 82 83 84

$Devel::Trace::TRACE= 0;       # Don't trace boring init stuff

#require 5.6.1;
use File::Path;
use File::Basename;
use Cwd;
use Getopt::Long;
use Sys::Hostname;
#use Carp;
use IO::Socket;
use IO::Socket::INET;
85
use Data::Dumper;
unknown's avatar
unknown committed
86 87 88
use strict;
#use diagnostics;

unknown's avatar
unknown committed
89
require "lib/mtr_cases.pl";
unknown's avatar
unknown committed
90
require "lib/mtr_process.pl";
91
require "lib/mtr_timer.pl";
unknown's avatar
unknown committed
92 93 94 95
require "lib/mtr_io.pl";
require "lib/mtr_gcov.pl";
require "lib/mtr_gprof.pl";
require "lib/mtr_report.pl";
unknown's avatar
unknown committed
96
require "lib/mtr_diff.pl";
unknown's avatar
unknown committed
97 98
require "lib/mtr_match.pl";
require "lib/mtr_misc.pl";
99
require "lib/mtr_stress.pl";
unknown's avatar
unknown committed
100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131

$Devel::Trace::TRACE= 1;

# Used by gcov
our @mysqld_src_dirs=
  (
   "strings",
   "mysys",
   "include",
   "extra",
   "regex",
   "isam",
   "merge",
   "myisam",
   "myisammrg",
   "heap",
   "sql",
  );

##############################################################################
#
#  Default settings
#
##############################################################################

# We are to use handle_options() in "mysys/my_getopt.c" for the C version
#
# In the C version we want to use structs and, in some cases, arrays of
# structs. We let each struct be a separate hash.

# Misc global variables

unknown's avatar
unknown committed
132 133 134
our $glob_win32=                  0; # OS and native Win32 executables
our $glob_win32_perl=             0; # ActiveState Win32 Perl
our $glob_cygwin_perl=            0; # Cygwin Perl
unknown's avatar
unknown committed
135
our $glob_cygwin_shell=           undef;
unknown's avatar
unknown committed
136
our $glob_mysql_test_dir=         undef;
unknown's avatar
unknown committed
137
our $glob_mysql_bench_dir=        undef;
unknown's avatar
unknown committed
138 139
our $glob_hostname=               undef;
our $glob_scriptname=             undef;
140
our $glob_timers=                 undef;
unknown's avatar
unknown committed
141 142
our $glob_use_running_server=     0;
our $glob_use_running_ndbcluster= 0;
unknown's avatar
unknown committed
143
our $glob_use_running_ndbcluster_slave= 0;
unknown's avatar
unknown committed
144
our $glob_use_embedded_server=    0;
unknown's avatar
unknown committed
145
our @glob_test_mode;
unknown's avatar
unknown committed
146

147 148 149
our $using_ndbcluster_master= 0;
our $using_ndbcluster_slave= 0;

unknown's avatar
unknown committed
150 151 152 153 154 155 156 157 158
our $glob_basedir;

# The total result

our $path_charsetsdir;
our $path_client_bindir;
our $path_language;
our $path_timefile;
our $path_manager_log;           # Used by mysqldadmin
159
our $path_mysqltest_log;
unknown's avatar
unknown committed
160 161
our $path_slave_load_tmpdir;     # What is this?!
our $path_my_basedir;
162
our $opt_vardir;                 # A path but set directly on cmd line
unknown's avatar
unknown committed
163 164
our $opt_tmpdir;                 # A path but set directly on cmd line

unknown's avatar
unknown committed
165 166 167
our $opt_usage;
our $opt_suite;

unknown's avatar
unknown committed
168 169 170 171 172 173 174 175 176 177
our $opt_netware;

our $opt_script_debug= 0;  # Script debugging, enable with --script-debug

# Options FIXME not all....

our $exe_master_mysqld;
our $exe_mysql;
our $exe_mysqladmin;
our $exe_mysqlbinlog;
unknown's avatar
unknown committed
178
our $exe_mysql_client_test;
unknown's avatar
unknown committed
179
our $exe_mysqld;
180
our $exe_mysqlcheck;             # Called from test case
unknown's avatar
unknown committed
181
our $exe_mysqldump;              # Called from test case
182
our $exe_mysqlslap;              # Called from test case
unknown's avatar
unknown committed
183
our $exe_mysqlimport;              # Called from test case
unknown's avatar
unknown committed
184
our $exe_mysqlshow;              # Called from test case
unknown's avatar
unknown committed
185
our $exe_mysql_fix_system_tables;
unknown's avatar
unknown committed
186 187
our $exe_mysqltest;
our $exe_slave_mysqld;
188
our $exe_im;
189
our $exe_my_print_defaults;
unknown's avatar
unknown committed
190 191 192 193 194

our $opt_bench= 0;
our $opt_small_bench= 0;
our $opt_big_test= 0;            # Send --big-test to mysqltest

unknown's avatar
unknown committed
195
our @opt_extra_mysqld_opt;
unknown's avatar
unknown committed
196 197

our $opt_compress;
198 199 200 201
our $opt_ssl;
our $opt_skip_ssl;
our $opt_ssl_supported;
our $opt_ps_protocol;
202 203 204
our $opt_sp_protocol;
our $opt_cursor_protocol;
our $opt_view_protocol;
205

unknown's avatar
unknown committed
206 207 208 209
our $opt_current_test;
our $opt_ddd;
our $opt_debug;
our $opt_do_test;
unknown's avatar
unknown committed
210
our @opt_cases;                  # The test cases names in argv
unknown's avatar
unknown committed
211 212 213 214
our $opt_embedded_server;
our $opt_extern;
our $opt_fast;
our $opt_force;
unknown's avatar
unknown committed
215
our $opt_reorder;
unknown's avatar
unknown committed
216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235

our $opt_gcov;
our $opt_gcov_err;
our $opt_gcov_msg;

our $opt_gdb;
our $opt_client_gdb;
our $opt_manual_gdb;

our $opt_gprof;
our $opt_gprof_dir;
our $opt_gprof_master;
our $opt_gprof_slave;

our $opt_local;
our $opt_local_master;

our $master;                    # Will be struct in C
our $slave;

236 237
our $instance_manager;

unknown's avatar
unknown committed
238 239
our $opt_ndbcluster_port;
our $opt_ndbconnectstring;
unknown's avatar
unknown committed
240 241
our $opt_ndbcluster_port_slave;
our $opt_ndbconnectstring_slave;
unknown's avatar
unknown committed
242 243

our $opt_no_manager;            # Does nothing now, we never use manager
unknown's avatar
unknown committed
244
our $opt_manager_port;          # Does nothing now, we never use manager
unknown's avatar
unknown committed
245 246 247 248 249 250 251 252 253 254

our $opt_old_master;

our $opt_record;

our $opt_result_ext;

our $opt_skip;
our $opt_skip_rpl;
our $opt_skip_test;
unknown's avatar
unknown committed
255
our $opt_skip_im;
unknown's avatar
unknown committed
256 257

our $opt_sleep;
unknown's avatar
unknown committed
258

259
our $opt_sleep_time_after_restart=  1;
unknown's avatar
unknown committed
260
our $opt_sleep_time_for_delete=    10;
unknown's avatar
unknown committed
261 262
our $opt_testcase_timeout;
our $opt_suite_timeout;
unknown's avatar
unknown committed
263
my  $default_testcase_timeout=     15; # 15 min max
unknown's avatar
unknown committed
264
my  $default_suite_timeout=       120; # 2 hours max
unknown's avatar
unknown committed
265 266 267 268 269 270

our $opt_socket;

our $opt_source_dist;

our $opt_start_and_exit;
271
our $opt_start_dirty;
unknown's avatar
unknown committed
272 273 274 275 276 277
our $opt_start_from;

our $opt_strace_client;

our $opt_timer;

unknown's avatar
unknown committed
278
our $opt_user;
unknown's avatar
unknown committed
279 280 281
our $opt_user_test;

our $opt_valgrind;
282
our $opt_valgrind_mysqld;
unknown's avatar
unknown committed
283
our $opt_valgrind_mysqltest;
unknown's avatar
unknown committed
284 285 286
our $opt_valgrind_all;
our $opt_valgrind_options;

287 288 289 290
our $opt_stress=               "";
our $opt_stress_suite=     "main";
our $opt_stress_mode=    "random";
our $opt_stress_threads=        5;
291 292 293
our $opt_stress_test_count=     0;
our $opt_stress_loop_count=     0;
our $opt_stress_test_duration=  0;
294 295 296
our $opt_stress_init_file=     "";
our $opt_stress_test_file=     "";

unknown's avatar
unknown committed
297 298 299 300 301 302 303 304
our $opt_verbose;

our $opt_wait_for_master;
our $opt_wait_for_slave;
our $opt_wait_timeout=  10;

our $opt_warnings;

unknown's avatar
unknown committed
305 306
our $opt_udiff;

unknown's avatar
unknown committed
307
our $opt_skip_ndbcluster;
unknown's avatar
unknown committed
308
our $opt_with_ndbcluster;
unknown's avatar
unknown committed
309 310 311
our $opt_skip_ndbcluster_slave;
our $opt_with_ndbcluster_slave;
our $opt_ndb_extra_test;
unknown's avatar
unknown committed
312

313 314 315 316 317
our $exe_ndb_mgm;
our $path_ndb_tools_dir;
our $path_ndb_backup_dir;
our $file_ndb_testrun_log;
our $flag_ndb_status_ok= 1;
unknown's avatar
unknown committed
318
our $flag_ndb_slave_status_ok= 1;
unknown's avatar
unknown committed
319 320 321 322 323 324 325 326 327 328 329

######################################################################
#
#  Function declarations
#
######################################################################

sub main ();
sub initial_setup ();
sub command_line_setup ();
sub executable_setup ();
unknown's avatar
unknown committed
330
sub environment_setup ();
331
sub kill_running_server ();
unknown's avatar
unknown committed
332
sub kill_and_cleanup ();
333 334
sub check_ssl_support ();
sub check_ndbcluster_support ();
unknown's avatar
unknown committed
335
sub rm_ndbcluster_tables ($);
336
sub ndbcluster_install ();
337
sub ndbcluster_start ($);
unknown's avatar
unknown committed
338
sub ndbcluster_stop ();
unknown's avatar
unknown committed
339
sub ndbcluster_install_slave ();
340
sub ndbcluster_start_slave ($);
unknown's avatar
unknown committed
341
sub ndbcluster_stop_slave ();
unknown's avatar
unknown committed
342 343 344 345 346
sub run_benchmarks ($);
sub run_tests ();
sub mysql_install_db ();
sub install_db ($$);
sub run_testcase ($);
unknown's avatar
unknown committed
347
sub report_failure_and_restart ($);
unknown's avatar
unknown committed
348 349
sub do_before_start_master ($$);
sub do_before_start_slave ($$);
350 351
sub mysqld_start ($$$$$);
sub mysqld_arguments ($$$$$$);
unknown's avatar
unknown committed
352 353 354
sub stop_masters_slaves ();
sub stop_masters ();
sub stop_slaves ();
355 356
sub im_start ($$);
sub im_stop ($);
unknown's avatar
unknown committed
357
sub run_mysqltest ($);
unknown's avatar
unknown committed
358
sub usage ($);
unknown's avatar
unknown committed
359 360 361 362 363 364 365 366 367 368 369 370 371 372

######################################################################
#
#  Main program
#
######################################################################

main();

sub main () {

  initial_setup();
  command_line_setup();
  executable_setup();
373 374 375

  check_ndbcluster_support();
  check_ssl_support();
376

unknown's avatar
unknown committed
377
  environment_setup();
unknown's avatar
unknown committed
378 379 380 381 382 383 384 385 386 387 388 389 390 391
  signal_setup();

  if ( $opt_gcov )
  {
    gcov_prepare();
  }

  if ( $opt_gprof )
  {
    gprof_prepare();
  }

  if ( ! $glob_use_running_server )
  {
392 393 394 395 396 397 398 399
    if ( $opt_start_dirty )
    {
      kill_running_server();
    }
    else
    {
      kill_and_cleanup();
      mysql_install_db();
unknown's avatar
unknown committed
400 401 402

#    mysql_loadstd();  FIXME copying from "std_data" .frm and
#                      .MGR but there are none?!
403
    }
unknown's avatar
unknown committed
404 405
  }

unknown's avatar
unknown committed
406
  if ( $opt_start_dirty )
unknown's avatar
unknown committed
407
  {
408
    if ( ndbcluster_start($opt_with_ndbcluster) )
unknown's avatar
unknown committed
409 410 411
    {
      mtr_error("Can't start ndbcluster");
    }
412
    if ( mysqld_start('master',0,[],[],$using_ndbcluster_master) )
unknown's avatar
unknown committed
413 414 415 416 417 418 419
    {
      mtr_report("Servers started, exiting");
    }
    else
    {
      mtr_error("Can't start the mysqld server");
    }
unknown's avatar
unknown committed
420
  }
unknown's avatar
unknown committed
421 422 423 424
  elsif ( $opt_bench )
  {
    run_benchmarks(shift);      # Shift what? Extra arguments?!
  }
425 426 427 428
  elsif ( $opt_stress )
  {
    run_stress_test()
  }
unknown's avatar
unknown committed
429 430
  else
  {
unknown's avatar
unknown committed
431
    run_tests();
unknown's avatar
unknown committed
432 433
  }

unknown's avatar
unknown committed
434
  mtr_exit(0);
unknown's avatar
unknown committed
435 436 437 438 439 440 441 442 443 444 445 446 447 448 449
}

##############################################################################
#
#  Initial setup independent on command line arguments
#
##############################################################################

sub initial_setup () {

  select(STDOUT);
  $| = 1;                       # Make unbuffered

  $glob_scriptname=  basename($0);

unknown's avatar
unknown committed
450 451 452
  $glob_win32_perl=  ($^O eq "MSWin32");
  $glob_cygwin_perl= ($^O eq "cygwin");
  $glob_win32=       ($glob_win32_perl or $glob_cygwin_perl);
unknown's avatar
unknown committed
453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468

  # We require that we are in the "mysql-test" directory
  # to run mysql-test-run

  if (! -f $glob_scriptname)
  {
    mtr_error("Can't find the location for the mysql-test-run script\n" .
              "Go to to the mysql-test directory and execute the script " .
              "as follows:\n./$glob_scriptname");
  }

  if ( -d "../sql" )
  {
    $opt_source_dist=  1;
  }

unknown's avatar
unknown committed
469
  $glob_hostname=  mtr_short_hostname();
unknown's avatar
unknown committed
470 471 472

  # 'basedir' is always parent of "mysql-test" directory
  $glob_mysql_test_dir=  cwd();
unknown's avatar
unknown committed
473 474 475 476
  if ( $glob_cygwin_perl )
  {
    # Windows programs like 'mysqld' needs Windows paths
    $glob_mysql_test_dir= `cygpath -m $glob_mysql_test_dir`;
unknown's avatar
unknown committed
477 478
    my $shell= $ENV{'SHELL'} || "/bin/bash";
    $glob_cygwin_shell=   `cygpath -w $shell`; # The Windows path c:\...
unknown's avatar
unknown committed
479
    chomp($glob_mysql_test_dir);
unknown's avatar
unknown committed
480
    chomp($glob_cygwin_shell);
unknown's avatar
unknown committed
481
  }
unknown's avatar
unknown committed
482
  $glob_basedir=         dirname($glob_mysql_test_dir);
unknown's avatar
unknown committed
483
  $glob_mysql_bench_dir= "$glob_basedir/mysql-bench"; # FIXME make configurable
unknown's avatar
unknown committed
484 485 486 487 488 489

  # needs to be same length to test logging (FIXME what???)
  $path_slave_load_tmpdir=  "../../var/tmp";

  $path_my_basedir=
    $opt_source_dist ? $glob_mysql_test_dir : $glob_basedir;
490 491

  $glob_timers= mtr_init_timers();
unknown's avatar
unknown committed
492 493 494 495 496 497 498 499 500 501 502 503 504 505
}



##############################################################################
#
#  Default settings
#
##############################################################################

sub command_line_setup () {

  # These are defaults for things that are set on the command line

unknown's avatar
unknown committed
506
  $opt_suite=        "main";    # Special default suite
unknown's avatar
unknown committed
507 508 509
  my $opt_master_myport= 9306;
  my $opt_slave_myport=  9308;
  $opt_ndbcluster_port=  9350;
unknown's avatar
unknown committed
510
  $opt_ndbcluster_port_slave=  9358;
511 512 513
  my $im_port=           9310;
  my $im_mysqld1_port=   9312;
  my $im_mysqld2_port=   9314;
unknown's avatar
unknown committed
514

unknown's avatar
unknown committed
515 516 517 518 519
  if ( $ENV{'MTR_BUILD_THREAD'} )
  {
    $opt_master_myport=   $ENV{'MTR_BUILD_THREAD'} * 40 + 8120;
    $opt_slave_myport=    $opt_master_myport + 16;
    $opt_ndbcluster_port= $opt_master_myport + 24;
520
    $opt_ndbcluster_port_slave= $opt_master_myport + 32;
unknown's avatar
unknown committed
521 522 523
    $im_port=             $opt_master_myport + 10;
    $im_mysqld1_port=     $opt_master_myport + 12;
    $im_mysqld2_port=     $opt_master_myport + 14;
unknown's avatar
unknown committed
524 525
  }

unknown's avatar
unknown committed
526
  # Read the command line
unknown's avatar
unknown committed
527
  # Note: Keep list, and the order, in sync with usage at end of this file
unknown's avatar
unknown committed
528

unknown's avatar
unknown committed
529
  Getopt::Long::Configure("pass_through");
unknown's avatar
unknown committed
530
  GetOptions(
unknown's avatar
unknown committed
531
             # Control what engine/variation to run
unknown's avatar
unknown committed
532
             'embedded-server'          => \$opt_embedded_server,
unknown's avatar
unknown committed
533
             'ps-protocol'              => \$opt_ps_protocol,
534 535 536
             'sp-protocol'              => \$opt_sp_protocol,
             'view-protocol'            => \$opt_view_protocol,
             'cursor-protocol'          => \$opt_cursor_protocol,
unknown's avatar
unknown committed
537
             'ssl|with-openssl'         => \$opt_ssl,
538 539
             'skip-ssl'                 => \$opt_skip_ssl,
             'compress'                 => \$opt_compress,
unknown's avatar
unknown committed
540 541
             'bench'                    => \$opt_bench,
             'small-bench'              => \$opt_small_bench,
unknown's avatar
unknown committed
542
             'no-manager'               => \$opt_no_manager, # Currently not used
unknown's avatar
unknown committed
543 544

             # Control what test suites or cases to run
unknown's avatar
unknown committed
545
             'force'                    => \$opt_force,
unknown's avatar
unknown committed
546
             'with-ndbcluster'          => \$opt_with_ndbcluster,
unknown's avatar
unknown committed
547
             'skip-ndbcluster|skip-ndb' => \$opt_skip_ndbcluster,
unknown's avatar
unknown committed
548 549 550 551
             'with-ndbcluster-slave'    => \$opt_with_ndbcluster_slave,
             'skip-ndbcluster-slave|skip-ndb-slave'
                                        => \$opt_skip_ndbcluster_slave,
             'ndb-extra-test'           => \$opt_ndb_extra_test,
unknown's avatar
unknown committed
552 553 554
             'do-test=s'                => \$opt_do_test,
             'suite=s'                  => \$opt_suite,
             'skip-rpl'                 => \$opt_skip_rpl,
unknown's avatar
unknown committed
555
             'skip-im'                  => \$opt_skip_im,
unknown's avatar
unknown committed
556 557 558 559 560 561
             'skip-test=s'              => \$opt_skip_test,

             # Specify ports
             'master_port=i'            => \$opt_master_myport,
             'slave_port=i'             => \$opt_slave_myport,
             'ndbcluster_port=i'        => \$opt_ndbcluster_port,
unknown's avatar
unknown committed
562
             'ndbcluster_port_slave=i'  => \$opt_ndbcluster_port_slave,
unknown's avatar
unknown committed
563
             'manager-port=i'           => \$opt_manager_port, # Currently not used
564 565 566
             'im-port=i'                => \$im_port, # Instance Manager port.
             'im-mysqld1-port=i'        => \$im_mysqld1_port, # Port of mysqld, controlled by IM
             'im-mysqld2-port=i'        => \$im_mysqld2_port, # Port of mysqld, controlled by IM
unknown's avatar
unknown committed
567 568 569 570 571

             # Test case authoring
             'record'                   => \$opt_record,

             # ???
unknown's avatar
unknown committed
572
             'mysqld=s'                 => \@opt_extra_mysqld_opt,
unknown's avatar
unknown committed
573 574 575 576

             # Run test on running server
             'extern'                   => \$opt_extern,
             'ndbconnectstring=s'       => \$opt_ndbconnectstring,
unknown's avatar
unknown committed
577
             'ndbconnectstring-slave=s' => \$opt_ndbconnectstring_slave,
unknown's avatar
unknown committed
578 579

             # Debugging
unknown's avatar
unknown committed
580
             'gdb'                      => \$opt_gdb,
unknown's avatar
unknown committed
581 582 583 584 585 586 587 588 589
             'manual-gdb'               => \$opt_manual_gdb,
             'client-gdb'               => \$opt_client_gdb,
             'ddd'                      => \$opt_ddd,
             'strace-client'            => \$opt_strace_client,
             'master-binary=s'          => \$exe_master_mysqld,
             'slave-binary=s'           => \$exe_slave_mysqld,

             # Coverage, profiling etc
             'gcov'                     => \$opt_gcov,
unknown's avatar
unknown committed
590
             'gprof'                    => \$opt_gprof,
unknown's avatar
unknown committed
591
             'valgrind:s'               => \$opt_valgrind,
unknown's avatar
unknown committed
592
             'valgrind-mysqltest:s'     => \$opt_valgrind_mysqltest,
unknown's avatar
unknown committed
593
             'valgrind-all:s'           => \$opt_valgrind_all,
unknown's avatar
unknown committed
594 595
             'valgrind-options=s'       => \$opt_valgrind_options,

596 597 598 599 600 601 602 603 604 605 606
             # Stress testing 
             'stress'                   => \$opt_stress,
             'stress-suite=s'           => \$opt_stress_suite,
             'stress-threads=i'         => \$opt_stress_threads,
             'stress-test-file=s'       => \$opt_stress_test_file,
             'stress-init-file=s'       => \$opt_stress_init_file,
             'stress-mode=s'            => \$opt_stress_mode,
             'stress-loop-count=i'      => \$opt_stress_loop_count,
             'stress-test-count=i'      => \$opt_stress_test_count,
             'stress-test-duration=i'   => \$opt_stress_test_duration,

unknown's avatar
unknown committed
607 608 609 610
             # Misc
             'big-test'                 => \$opt_big_test,
             'debug'                    => \$opt_debug,
             'fast'                     => \$opt_fast,
unknown's avatar
unknown committed
611 612 613 614
             'local'                    => \$opt_local,
             'local-master'             => \$opt_local_master,
             'netware'                  => \$opt_netware,
             'old-master'               => \$opt_old_master,
unknown's avatar
unknown committed
615
             'reorder'                  => \$opt_reorder,
unknown's avatar
unknown committed
616 617 618
             'script-debug'             => \$opt_script_debug,
             'sleep=i'                  => \$opt_sleep,
             'socket=s'                 => \$opt_socket,
619
             'start-dirty'              => \$opt_start_dirty,
unknown's avatar
unknown committed
620 621 622 623
             'start-and-exit'           => \$opt_start_and_exit,
             'start-from=s'             => \$opt_start_from,
             'timer'                    => \$opt_timer,
             'tmpdir=s'                 => \$opt_tmpdir,
unknown's avatar
unknown committed
624
             'unified-diff|udiff'       => \$opt_udiff,
unknown's avatar
unknown committed
625 626
             'user-test=s'              => \$opt_user_test,
             'user=s'                   => \$opt_user,
627
             'vardir=s'                 => \$opt_vardir,
unknown's avatar
unknown committed
628 629
             'verbose'                  => \$opt_verbose,
             'wait-timeout=i'           => \$opt_wait_timeout,
630 631
             'testcase-timeout=i'       => \$opt_testcase_timeout,
             'suite-timeout=i'          => \$opt_suite_timeout,
unknown's avatar
unknown committed
632
             'warnings|log-warnings'    => \$opt_warnings,
unknown's avatar
unknown committed
633 634

             'help|h'                   => \$opt_usage,
unknown's avatar
unknown committed
635 636
            ) or usage("Can't read options");

unknown's avatar
unknown committed
637 638 639 640
  if ( $opt_usage )
  {
    usage("");
  }
unknown's avatar
unknown committed
641

unknown's avatar
unknown committed
642 643 644 645 646 647 648 649 650 651 652 653 654 655 656
  foreach my $arg ( @ARGV )
  {
    if ( $arg =~ /^--skip-/ )
    {
      push(@opt_extra_mysqld_opt, $arg);
    }
    elsif ( $arg =~ /^-/ )
    {
      usage("Invalid option \"$arg\"");
    }
    else
    {
      push(@opt_cases, $arg);
    }
  }
unknown's avatar
unknown committed
657

658 659 660
  # --------------------------------------------------------------------------
  # Set the "var/" directory, as it is the base for everything else
  # --------------------------------------------------------------------------
661

662 663 664 665
  if ( ! $opt_vardir )
  {
    $opt_vardir= "$glob_mysql_test_dir/var";
  }
unknown's avatar
unknown committed
666

unknown's avatar
unknown committed
667 668 669
  # We make the path absolute, as the server will do a chdir() before usage
  unless ( $opt_vardir =~ m,^/, or
           ($glob_win32 and $opt_vardir =~ m,^[a-z]:/,i) )
670 671 672 673
  {
    # Make absolute path, relative test dir
    $opt_vardir= "$glob_mysql_test_dir/$opt_vardir";
  }
unknown's avatar
unknown committed
674

675 676 677
  # --------------------------------------------------------------------------
  # If not set, set these to defaults
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
678

679 680 681 682 683 684
  $opt_tmpdir=       "$opt_vardir/tmp" unless $opt_tmpdir;
  # FIXME maybe not needed?
  $path_manager_log= "$opt_vardir/log/manager.log"
    unless $path_manager_log;
  $opt_current_test= "$opt_vardir/log/current_test"
    unless $opt_current_test;
unknown's avatar
unknown committed
685

686
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
687
  # Do sanity checks of command line arguments
688
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
689 690 691

  if ( $opt_extern and $opt_local )
  {
unknown's avatar
unknown committed
692
    mtr_error("Can't use --extern and --local at the same time");
unknown's avatar
unknown committed
693 694 695 696 697 698 699 700 701 702 703 704
  }

  if ( ! $opt_socket )
  {     # FIXME set default before reading options?
#    $opt_socket=  '@MYSQL_UNIX_ADDR@';
    $opt_socket=  "/tmp/mysql.sock"; # FIXME
  }

  # --------------------------------------------------------------------------
  # Look at the command line options and set script flags
  # --------------------------------------------------------------------------

unknown's avatar
unknown committed
705
  if ( $opt_record and ! @opt_cases )
unknown's avatar
unknown committed
706 707 708 709 710 711 712
  {
    mtr_error("Will not run in record mode without a specific test case");
  }

  if ( $opt_embedded_server )
  {
    $glob_use_embedded_server= 1;
unknown's avatar
unknown committed
713
    push(@glob_test_mode, "embedded");
unknown's avatar
unknown committed
714
    $opt_skip_rpl= 1;              # We never run replication with embedded
715 716
    $opt_skip_ndbcluster= 1;       # Avoid auto detection
    $opt_skip_ssl= 1;
unknown's avatar
unknown committed
717 718 719

    if ( $opt_extern )
    {
unknown's avatar
unknown committed
720
      mtr_error("Can't use --extern with --embedded-server");
unknown's avatar
unknown committed
721 722 723
    }
  }

unknown's avatar
unknown committed
724 725 726 727 728
  if ( $opt_ps_protocol )
  {
    push(@glob_test_mode, "ps-protocol");
  }

unknown's avatar
unknown committed
729 730 731 732 733 734 735 736 737 738 739 740 741
  # FIXME don't understand what this is
#  if ( $opt_local_master )
#  {
#    $opt_master_myport=  3306;
#  }

  if ( $opt_small_bench )
  {
    $opt_bench=  1;
  }

  if ( $opt_sleep )
  {
unknown's avatar
unknown committed
742
    $opt_sleep_time_after_restart= $opt_sleep;
unknown's avatar
unknown committed
743 744
  }

unknown's avatar
unknown committed
745
  if ( $opt_gcov and ! $opt_source_dist )
unknown's avatar
unknown committed
746
  {
unknown's avatar
unknown committed
747 748 749
    mtr_error("Coverage test needs the source - please use source dist");
  }

unknown's avatar
unknown committed
750 751 752 753 754
  if ( $opt_gdb )
  {
    $opt_wait_timeout=  300;
    if ( $opt_extern )
    {
unknown's avatar
unknown committed
755
      mtr_error("Can't use --extern with --gdb");
unknown's avatar
unknown committed
756 757 758 759 760 761 762 763
    }
  }

  if ( $opt_manual_gdb )
  {
    $opt_gdb=  1;
    if ( $opt_extern )
    {
unknown's avatar
unknown committed
764
      mtr_error("Can't use --extern with --manual-gdb");
unknown's avatar
unknown committed
765 766 767 768 769 770 771
    }
  }

  if ( $opt_ddd )
  {
    if ( $opt_extern )
    {
unknown's avatar
unknown committed
772
      mtr_error("Can't use --extern with --ddd");
unknown's avatar
unknown committed
773 774 775
    }
  }

unknown's avatar
unknown committed
776 777 778 779 780 781
  # The ":s" in the argument spec, means we have three different cases
  #
  #   undefined    option not set
  #   ""           option set with no argument
  #   "somestring" option is name/path of valgrind executable

unknown's avatar
unknown committed
782
  # Take executable path from any of them, if any
783
  $opt_valgrind_mysqld= $opt_valgrind;
unknown's avatar
unknown committed
784 785 786 787 788
  $opt_valgrind= $opt_valgrind_mysqltest if $opt_valgrind_mysqltest;
  $opt_valgrind= $opt_valgrind_all       if $opt_valgrind_all;

  # If valgrind flag not defined, define if other valgrind flags are
  unless ( defined $opt_valgrind )
unknown's avatar
unknown committed
789
  {
unknown's avatar
unknown committed
790 791
    $opt_valgrind= ""
      if defined $opt_valgrind_mysqltest or defined $opt_valgrind_all;
unknown's avatar
unknown committed
792 793 794 795 796 797 798 799 800 801 802 803 804
  }

  if ( ! $opt_testcase_timeout )
  {
    $opt_testcase_timeout= $default_testcase_timeout;
    $opt_testcase_timeout*= 10 if defined $opt_valgrind;
  }

  if ( ! $opt_suite_timeout )
  {
    $opt_suite_timeout= $default_suite_timeout;
    $opt_suite_timeout*= 4 if defined $opt_valgrind;
  }
unknown's avatar
unknown committed
805

unknown's avatar
unknown committed
806 807 808 809
  if ( defined $opt_valgrind )
  {
    $opt_sleep_time_after_restart= 10;
    $opt_sleep_time_for_delete= 60;
unknown's avatar
unknown committed
810
    # >=2.1.2 requires the --tool option, some versions write to stdout, some to stderr
unknown's avatar
unknown committed
811 812
    #  valgrind --help 2>&1 | grep "\-\-tool" > /dev/null && VALGRIND="$VALGRIND --tool=memcheck"
  }
unknown's avatar
unknown committed
813

unknown's avatar
unknown committed
814
  if ( ! $opt_user )
unknown's avatar
unknown committed
815
  {
unknown's avatar
unknown committed
816 817 818 819 820 821 822 823
    if ( $glob_use_running_server )
    {
      $opt_user= "test";
    }
    else
    {
      $opt_user= "root"; # We want to do FLUSH xxx commands
    }
unknown's avatar
unknown committed
824 825
  }

826 827 828 829 830 831
  # On QNX, /tmp/dir/master.sock and /tmp/dir//master.sock seem to be
  # considered different, so avoid the extra slash (/) in the socket
  # paths.
  my $sockdir = $opt_tmpdir;
  $sockdir =~ s|/+$||;

832 833
  # Put this into a hash, will be a C struct

unknown's avatar
unknown committed
834 835 836 837 838 839
  $master->[0]=
  {
   path_myddir   => "$opt_vardir/master-data",
   path_myerr    => "$opt_vardir/log/master.err",
   path_mylog    => "$opt_vardir/log/master.log",
   path_mypid    => "$opt_vardir/run/master.pid",
840
   path_mysock   => "$sockdir/master.sock",
unknown's avatar
unknown committed
841 842 843 844 845 846 847 848 849 850 851 852
   path_myport   =>  $opt_master_myport,
   start_timeout =>  400, # enough time create innodb tables

   ndbcluster    =>  1, # ndbcluster not started
  };

  $master->[1]=
  {
   path_myddir   => "$opt_vardir/master1-data",
   path_myerr    => "$opt_vardir/log/master1.err",
   path_mylog    => "$opt_vardir/log/master1.log",
   path_mypid    => "$opt_vardir/run/master1.pid",
853
   path_mysock   => "$sockdir/master1.sock",
unknown's avatar
unknown committed
854 855 856 857 858 859 860 861 862 863
   path_myport   => $opt_master_myport + 1,
   start_timeout => 400, # enough time create innodb tables
  };

  $slave->[0]=
  {
   path_myddir   => "$opt_vardir/slave-data",
   path_myerr    => "$opt_vardir/log/slave.err",
   path_mylog    => "$opt_vardir/log/slave.log",
   path_mypid    => "$opt_vardir/run/slave.pid",
864
   path_mysock   => "$sockdir/slave.sock",
unknown's avatar
unknown committed
865 866
   path_myport   => $opt_slave_myport,
   start_timeout => 400,
unknown's avatar
unknown committed
867 868

   ndbcluster    =>  1, # ndbcluster not started
unknown's avatar
unknown committed
869 870 871 872 873 874 875 876
  };

  $slave->[1]=
  {
   path_myddir   => "$opt_vardir/slave1-data",
   path_myerr    => "$opt_vardir/log/slave1.err",
   path_mylog    => "$opt_vardir/log/slave1.log",
   path_mypid    => "$opt_vardir/run/slave1.pid",
877
   path_mysock   => "$sockdir/slave1.sock",
unknown's avatar
unknown committed
878 879 880 881 882 883 884 885 886 887
   path_myport   => $opt_slave_myport + 1,
   start_timeout => 300,
  };

  $slave->[2]=
  {
   path_myddir   => "$opt_vardir/slave2-data",
   path_myerr    => "$opt_vardir/log/slave2.err",
   path_mylog    => "$opt_vardir/log/slave2.log",
   path_mypid    => "$opt_vardir/run/slave2.pid",
888
   path_mysock   => "$sockdir/slave2.sock",
unknown's avatar
unknown committed
889 890 891
   path_myport   => $opt_slave_myport + 2,
   start_timeout => 300,
  };
892

unknown's avatar
Merge  
unknown committed
893 894 895 896 897
  $instance_manager=
  {
   path_err =>        "$opt_vardir/log/im.err",
   path_log =>        "$opt_vardir/log/im.log",
   path_pid =>        "$opt_vardir/run/im.pid",
898
   path_sock =>       "$sockdir/im.sock",
unknown's avatar
Merge  
unknown committed
899 900 901 902 903 904 905 906 907 908 909 910 911 912
   port =>            $im_port,
   start_timeout =>   $master->[0]->{'start_timeout'},
   admin_login =>     'im_admin',
   admin_password =>  'im_admin_secret',
   admin_sha1 =>      '*598D51AD2DFF7792045D6DF3DDF9AA1AF737B295',
   password_file =>   "$opt_vardir/im.passwd",
   defaults_file =>   "$opt_vardir/im.cnf",
  };

  $instance_manager->{'instances'}->[0]=
  {
   server_id    => 1,
   port         => $im_mysqld1_port,
   path_datadir => "$opt_vardir/im_mysqld_1.data",
913
   path_sock    => "$sockdir/mysqld_1.sock",
unknown's avatar
unknown committed
914
   path_pid     => "$opt_vardir/run/mysqld_1.pid",
915
   old_log_format => 1
unknown's avatar
Merge  
unknown committed
916 917 918 919 920 921 922
  };

  $instance_manager->{'instances'}->[1]=
  {
   server_id    => 2,
   port         => $im_mysqld2_port,
   path_datadir => "$opt_vardir/im_mysqld_2.data",
923
   path_sock    => "$sockdir/mysqld_2.sock",
unknown's avatar
unknown committed
924
   path_pid     => "$opt_vardir/run/mysqld_2.pid",
unknown's avatar
Merge  
unknown committed
925
   nonguarded   => 1,
926
   old_log_format => 1
unknown's avatar
Merge  
unknown committed
927
  };
928

929 930 931 932 933 934 935 936
  if ( $opt_extern )
  {
    $glob_use_running_server=  1;
    $opt_skip_rpl= 1;                   # We don't run rpl test cases
    $master->[0]->{'path_mysock'}=  $opt_socket;
  }

  $path_timefile=  "$opt_vardir/log/mysqltest-time";
937
  $path_mysqltest_log=  "$opt_vardir/log/mysqltest.log";
unknown's avatar
unknown committed
938 939 940 941 942 943 944 945 946 947 948 949 950
}


##############################################################################
#
#  Set paths to various executable programs
#
##############################################################################

sub executable_setup () {

  if ( $opt_source_dist )
  {
unknown's avatar
unknown committed
951
    if ( $glob_win32 )
unknown's avatar
unknown committed
952
    {
unknown's avatar
unknown committed
953 954
      $path_client_bindir= mtr_path_exists("$glob_basedir/client_release",
                                           "$glob_basedir/bin");
955 956
      $exe_mysqld=         mtr_exe_exists ("$path_client_bindir/mysqld-max",
                                           "$path_client_bindir/mysqld-nt",
unknown's avatar
unknown committed
957 958
                                           "$path_client_bindir/mysqld",
                                           "$path_client_bindir/mysqld-debug",);
unknown's avatar
unknown committed
959 960
      $path_language=      mtr_path_exists("$glob_basedir/share/english/");
      $path_charsetsdir=   mtr_path_exists("$glob_basedir/share/charsets");
unknown's avatar
unknown committed
961 962 963

      $exe_my_print_defaults=
        mtr_exe_exists("$path_client_bindir/my_print_defaults");
unknown's avatar
unknown committed
964 965 966
    }
    else
    {
unknown's avatar
unknown committed
967 968
      $path_client_bindir= mtr_path_exists("$glob_basedir/client");
      $exe_mysqld=         mtr_exe_exists ("$glob_basedir/sql/mysqld");
unknown's avatar
unknown committed
969
      $exe_mysqlslap=      mtr_exe_exists ("$path_client_bindir/mysqlslap");
unknown's avatar
unknown committed
970 971
      $path_language=      mtr_path_exists("$glob_basedir/sql/share/english/");
      $path_charsetsdir=   mtr_path_exists("$glob_basedir/sql/share/charsets");
972 973 974

      $exe_im= mtr_exe_exists(
        "$glob_basedir/server-tools/instance-manager/mysqlmanager");
unknown's avatar
unknown committed
975 976
      $exe_my_print_defaults=
        mtr_exe_exists("$glob_basedir/extra/my_print_defaults");
unknown's avatar
unknown committed
977
    }
unknown's avatar
unknown committed
978 979

    if ( $glob_use_embedded_server )
unknown's avatar
unknown committed
980
    {
unknown's avatar
unknown committed
981
      my $path_examples= "$glob_basedir/libmysqld/examples";
unknown's avatar
unknown committed
982
      $exe_mysqltest=    mtr_exe_exists("$path_examples/mysqltest_embedded");
unknown's avatar
unknown committed
983
      $exe_mysql_client_test=
unknown's avatar
unknown committed
984 985
        mtr_exe_exists("$path_examples/mysql_client_test_embedded",
		       "/usr/bin/false");
unknown's avatar
unknown committed
986 987 988
    }
    else
    {
989 990 991 992 993 994 995 996 997 998 999 1000 1001
      if ( $opt_valgrind_mysqltest )
      {
        # client/mysqltest might be a libtool .sh script, so look for real exe
        # to avoid valgrinding bash ;)
        $exe_mysqltest=
  	  mtr_exe_exists("$path_client_bindir/.libs/lt-mysqltest",
		         "$path_client_bindir/.libs/mysqltest",
		         "$path_client_bindir/mysqltest");
      }
      else
      {
        $exe_mysqltest= mtr_exe_exists("$path_client_bindir/mysqltest");
      }
unknown's avatar
unknown committed
1002
      $exe_mysql_client_test=
unknown's avatar
unknown committed
1003 1004
        mtr_exe_exists("$glob_basedir/tests/mysql_client_test",
		       "/usr/bin/false");
unknown's avatar
unknown committed
1005
    }
1006
    $exe_mysqlcheck=     mtr_exe_exists("$path_client_bindir/mysqlcheck");
unknown's avatar
unknown committed
1007
    $exe_mysqldump=      mtr_exe_exists("$path_client_bindir/mysqldump");
unknown's avatar
unknown committed
1008
    $exe_mysqlimport=    mtr_exe_exists("$path_client_bindir/mysqlimport");
unknown's avatar
unknown committed
1009 1010 1011 1012 1013 1014
    $exe_mysqlshow=      mtr_exe_exists("$path_client_bindir/mysqlshow");
    $exe_mysqlbinlog=    mtr_exe_exists("$path_client_bindir/mysqlbinlog");
    $exe_mysqladmin=     mtr_exe_exists("$path_client_bindir/mysqladmin");
    $exe_mysql=          mtr_exe_exists("$path_client_bindir/mysql");
    $exe_mysql_fix_system_tables=
      mtr_script_exists("$glob_basedir/scripts/mysql_fix_privilege_tables");
unknown's avatar
unknown committed
1015 1016
    $path_ndb_tools_dir= mtr_path_exists("$glob_basedir/storage/ndb/tools");
    $exe_ndb_mgm=        "$glob_basedir/storage/ndb/src/mgmclient/ndb_mgm";
unknown's avatar
unknown committed
1017 1018 1019
  }
  else
  {
unknown's avatar
unknown committed
1020
    $path_client_bindir= mtr_path_exists("$glob_basedir/bin");
1021
    $exe_mysqlcheck=     mtr_exe_exists("$path_client_bindir/mysqlcheck");
unknown's avatar
unknown committed
1022
    $exe_mysqldump=      mtr_exe_exists("$path_client_bindir/mysqldump");
unknown's avatar
unknown committed
1023
    $exe_mysqlimport=    mtr_exe_exists("$path_client_bindir/mysqlimport");
unknown's avatar
unknown committed
1024 1025 1026 1027 1028
    $exe_mysqlshow=      mtr_exe_exists("$path_client_bindir/mysqlshow");
    $exe_mysqlbinlog=    mtr_exe_exists("$path_client_bindir/mysqlbinlog");
    $exe_mysqladmin=     mtr_exe_exists("$path_client_bindir/mysqladmin");
    $exe_mysql=          mtr_exe_exists("$path_client_bindir/mysql");
    $exe_mysql_fix_system_tables=
unknown's avatar
unknown committed
1029 1030
      mtr_script_exists("$path_client_bindir/mysql_fix_privilege_tables",
			"$glob_basedir/scripts/mysql_fix_privilege_tables");
1031
    $exe_my_print_defaults=
unknown's avatar
unknown committed
1032
      mtr_exe_exists("$path_client_bindir/my_print_defaults");
unknown's avatar
unknown committed
1033 1034 1035 1036 1037

    $path_language=      mtr_path_exists("$glob_basedir/share/mysql/english/",
                                         "$glob_basedir/share/english/");
    $path_charsetsdir=   mtr_path_exists("$glob_basedir/share/mysql/charsets",
                                         "$glob_basedir/share/charsets");
unknown's avatar
unknown committed
1038

unknown's avatar
unknown committed
1039 1040 1041 1042 1043 1044 1045 1046 1047 1048
    if ( $glob_win32 )
    {
      $exe_mysqld=         mtr_exe_exists ("$glob_basedir/bin/mysqld-nt",
                                           "$glob_basedir/bin/mysqld",
                                           "$glob_basedir/bin/mysqld-debug",);
    }
    else
    {
      $exe_mysqld=         mtr_exe_exists ("$glob_basedir/libexec/mysqld",
                                           "$glob_basedir/bin/mysqld");
unknown's avatar
unknown committed
1049
      $exe_mysqlslap=      mtr_exe_exists("$path_client_bindir/mysqlslap");
unknown's avatar
unknown committed
1050
    }
1051 1052
    $exe_im= mtr_exe_exists("$glob_basedir/libexec/mysqlmanager",
                            "$glob_basedir/bin/mysqlmanager");
unknown's avatar
unknown committed
1053 1054
    if ( $glob_use_embedded_server )
    {
unknown's avatar
unknown committed
1055 1056 1057
      $exe_mysqltest= mtr_exe_exists("$path_client_bindir/mysqltest_embedded");
      $exe_mysql_client_test=
        mtr_exe_exists("$glob_basedir/tests/mysql_client_test_embedded",
unknown's avatar
unknown committed
1058 1059
                       "$path_client_bindir/mysql_client_test_embedded",
		       "/usr/bin/false");
unknown's avatar
unknown committed
1060 1061 1062
    }
    else
    {
unknown's avatar
unknown committed
1063 1064
      $exe_mysqltest= mtr_exe_exists("$path_client_bindir/mysqltest");
      $exe_mysql_client_test=
unknown's avatar
unknown committed
1065 1066
        mtr_exe_exists("$path_client_bindir/mysql_client_test",
		       "/usr/bin/false"); # FIXME temporary
unknown's avatar
unknown committed
1067
    }
1068 1069 1070

    $path_ndb_tools_dir=  "$glob_basedir/bin";
    $exe_ndb_mgm=         "$glob_basedir/bin/ndb_mgm";
unknown's avatar
unknown committed
1071 1072
  }

unknown's avatar
unknown committed
1073 1074
  $exe_master_mysqld= $exe_master_mysqld || $exe_mysqld;
  $exe_slave_mysqld=  $exe_slave_mysqld  || $exe_mysqld;
1075 1076

  $path_ndb_backup_dir=
1077 1078
    "$opt_vardir/ndbcluster-$opt_ndbcluster_port";
  $file_ndb_testrun_log= "$opt_vardir/log/ndb_testrun.log";
unknown's avatar
unknown committed
1079 1080 1081
}


unknown's avatar
unknown committed
1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092
##############################################################################
#
#  Set environment to be used by childs of this process
#
##############################################################################

# Note that some env is setup in spawn/run, in "mtr_process.pl"

sub environment_setup () {

  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1093 1094
  # We might not use a standard installation directory, like /usr/lib.
  # Set LD_LIBRARY_PATH to make sure we find our installed libraries.
unknown's avatar
unknown committed
1095 1096
  # --------------------------------------------------------------------------

unknown's avatar
unknown committed
1097 1098 1099 1100 1101 1102 1103 1104 1105
  unless ( $opt_source_dist )
  {
    $ENV{'LD_LIBRARY_PATH'}=
      "$glob_basedir/lib" .
        ($ENV{'LD_LIBRARY_PATH'} ? ":$ENV{'LD_LIBRARY_PATH'}" : "");
    $ENV{'DYLD_LIBRARY_PATH'}=
      "$glob_basedir/lib" .
        ($ENV{'DYLD_LIBRARY_PATH'} ? ":$ENV{'DYLD_LIBRARY_PATH'}" : "");
  }
unknown's avatar
unknown committed
1106 1107 1108 1109 1110

  # --------------------------------------------------------------------------
  # Also command lines in .opt files may contain env vars
  # --------------------------------------------------------------------------

unknown's avatar
unknown committed
1111 1112 1113 1114 1115
  $ENV{'UMASK'}=              "0660"; # The octal *string*
  $ENV{'UMASK_DIR'}=          "0770"; # The octal *string*
  $ENV{'LC_COLLATE'}=         "C";
  $ENV{'USE_RUNNING_SERVER'}= $glob_use_running_server;
  $ENV{'MYSQL_TEST_DIR'}=     $glob_mysql_test_dir;
unknown's avatar
unknown committed
1116
  $ENV{'MYSQL_TEST_WINDIR'}=  $glob_mysql_test_dir;
unknown's avatar
unknown committed
1117
  $ENV{'MASTER_MYSOCK'}=      $master->[0]->{'path_mysock'};
unknown's avatar
unknown committed
1118
  $ENV{'MASTER_WINMYSOCK'}=   $master->[0]->{'path_mysock'};
unknown's avatar
unknown committed
1119 1120 1121 1122 1123 1124
  $ENV{'MASTER_MYSOCK1'}=     $master->[1]->{'path_mysock'};
  $ENV{'MASTER_MYPORT'}=      $master->[0]->{'path_myport'};
  $ENV{'MASTER_MYPORT1'}=     $master->[1]->{'path_myport'};
  $ENV{'SLAVE_MYPORT'}=       $slave->[0]->{'path_myport'};
# $ENV{'MYSQL_TCP_PORT'}=     '@MYSQL_TCP_PORT@'; # FIXME
  $ENV{'MYSQL_TCP_PORT'}=     3306;
unknown's avatar
unknown committed
1125

1126 1127 1128
  $ENV{'NDBCLUSTER_PORT'}=    $opt_ndbcluster_port;
  $ENV{'NDBCLUSTER_PORT_SLAVE'}=$opt_ndbcluster_port_slave;

1129 1130
  $ENV{'IM_PATH_PID'}=        $instance_manager->{path_pid};

1131 1132
  $ENV{'IM_MYSQLD1_SOCK'}=    $instance_manager->{instances}->[0]->{path_sock};
  $ENV{'IM_MYSQLD1_PORT'}=    $instance_manager->{instances}->[0]->{port};
1133
  $ENV{'IM_MYSQLD1_PATH_PID'}=$instance_manager->{instances}->[0]->{path_pid};
1134 1135
  $ENV{'IM_MYSQLD2_SOCK'}=    $instance_manager->{instances}->[1]->{path_sock};
  $ENV{'IM_MYSQLD2_PORT'}=    $instance_manager->{instances}->[1]->{port};
1136
  $ENV{'IM_MYSQLD2_PATH_PID'}=$instance_manager->{instances}->[1]->{path_pid};
1137

unknown's avatar
unknown committed
1138 1139 1140 1141 1142 1143 1144 1145 1146
  if ( $glob_cygwin_perl )
  {
    foreach my $key ('MYSQL_TEST_WINDIR','MASTER_MYSOCK')
    {
      $ENV{$key}= `cygpath -w $ENV{$key}`;
      $ENV{$key} =~ s,\\,\\\\,g;
      chomp($ENV{$key});
    }
  }
unknown's avatar
unknown committed
1147 1148 1149 1150 1151 1152

  # We are nice and report a bit about our settings
  print "Using MTR_BUILD_THREAD = ",$ENV{MTR_BUILD_THREAD} || 0,"\n";
  print "Using MASTER_MYPORT    = $ENV{MASTER_MYPORT}\n";
  print "Using MASTER_MYPORT1   = $ENV{MASTER_MYPORT1}\n";
  print "Using SLAVE_MYPORT     = $ENV{SLAVE_MYPORT}\n";
1153 1154
  print "Using NDBCLUSTER_PORT  = $ENV{NDBCLUSTER_PORT}\n";
  print "Using NDBCLUSTER_PORT_SLAVE = $ENV{NDBCLUSTER_PORT_SLAVE}\n";
unknown's avatar
unknown committed
1155 1156
  print "Using IM_MYSQLD1_PORT  = $ENV{'IM_MYSQLD1_PORT'}\n";
  print "Using IM_MYSQLD2_PORT  = $ENV{'IM_MYSQLD2_PORT'}\n";
unknown's avatar
unknown committed
1157 1158 1159
}


unknown's avatar
unknown committed
1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174
##############################################################################
#
#  If we get a ^C, we try to clean up before termination
#
##############################################################################
# FIXME check restrictions what to do in a signal handler

sub signal_setup () {
  $SIG{INT}= \&handle_int_signal;
}

sub handle_int_signal () {
  $SIG{INT}= 'DEFAULT';         # If we get a ^C again, we die...
  mtr_warning("got INT signal, cleaning up.....");
  stop_masters_slaves();
unknown's avatar
unknown committed
1175
  mtr_error("We die from ^C signal from user");
unknown's avatar
unknown committed
1176 1177 1178 1179 1180 1181 1182 1183 1184
}


##############################################################################
#
#  Handle left overs from previous runs
#
##############################################################################

1185
sub kill_running_server () {
unknown's avatar
unknown committed
1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203

  if ( $opt_fast or $glob_use_embedded_server )
  {
    # FIXME is embedded server really using PID files?!
    unlink($master->[0]->{'path_mypid'});
    unlink($master->[1]->{'path_mypid'});
    unlink($slave->[0]->{'path_mypid'});
    unlink($slave->[1]->{'path_mypid'});
    unlink($slave->[2]->{'path_mypid'});
  }
  else
  {
    # Ensure that no old mysqld test servers are running
    # This is different from terminating processes we have
    # started from ths run of the script, this is terminating
    # leftovers from previous runs.

    mtr_report("Killing Possible Leftover Processes");
1204
    mkpath("$opt_vardir/log"); # Needed for mysqladmin log
unknown's avatar
unknown committed
1205 1206 1207
    mtr_kill_leftovers();

    ndbcluster_stop();
1208
    $master->[0]->{'ndbcluster'}= 1;
unknown's avatar
unknown committed
1209 1210
    ndbcluster_stop_slave();
    $slave->[0]->{'ndbcluster'}= 1;
unknown's avatar
unknown committed
1211
  }
1212 1213 1214 1215 1216
}

sub kill_and_cleanup () {

  kill_running_server ();
unknown's avatar
unknown committed
1217 1218 1219

  mtr_report("Removing Stale Files");

1220 1221 1222 1223
  rmtree("$opt_vardir/log");
  rmtree("$opt_vardir/ndbcluster-$opt_ndbcluster_port");
  rmtree("$opt_vardir/run");
  rmtree("$opt_vardir/tmp");
unknown's avatar
unknown committed
1224

1225 1226 1227
  mkpath("$opt_vardir/log");
  mkpath("$opt_vardir/run");
  mkpath("$opt_vardir/tmp");
unknown's avatar
unknown committed
1228
  mkpath($opt_tmpdir) if $opt_tmpdir ne "$opt_vardir/tmp";
unknown's avatar
unknown committed
1229

unknown's avatar
unknown committed
1230 1231 1232
  # FIXME do we really need to create these all, or are they
  # created for us when tables are created?

1233 1234 1235 1236 1237 1238 1239 1240 1241
  my @data_dir_lst = (
    $master->[0]->{'path_myddir'},
    $master->[1]->{'path_myddir'},
    $slave->[0]->{'path_myddir'},
    $slave->[1]->{'path_myddir'},
    $slave->[2]->{'path_myddir'});
  
  foreach my $instance (@{$instance_manager->{'instances'}})
  {
unknown's avatar
unknown committed
1242
    push(@data_dir_lst, $instance->{'path_datadir'});
1243
  }
unknown's avatar
unknown committed
1244

1245 1246 1247 1248 1249 1250
  foreach my $data_dir (@data_dir_lst)
  {
    rmtree("$data_dir");
    mkpath("$data_dir/mysql");
    mkpath("$data_dir/test");
  }
1251 1252 1253 1254 1255 1256 1257 1258 1259 1260

  # To make some old test cases work, we create a soft
  # link from the old "var" location to the new one

  if ( ! $glob_win32 and $opt_vardir ne "$glob_mysql_test_dir/var" )
  {
    # FIXME why bother with the above, why not always remove all of var?!
    rmtree("$glob_mysql_test_dir/var"); # Clean old var, FIXME or rename it?!
    symlink($opt_vardir, "$glob_mysql_test_dir/var");
  }
unknown's avatar
unknown committed
1261 1262 1263
}


1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286
sub check_ssl_support () {

  if ($opt_skip_ssl)
  {
    mtr_report("Skipping SSL");
    $opt_ssl_supported= 0;
    $opt_ssl= 0;
    return;
  }

  # check ssl support by testing using a switch
  # that is only available in that case
  if ( mtr_run($exe_mysqld,
	       ["--no-defaults",
	        "--ssl",
	        "--help"],
	       "", "/dev/null", "/dev/null", "") != 0 )
  {
    if ( $opt_ssl)
    {
      mtr_error("Couldn't find support for SSL");
      return;
    }
unknown's avatar
unknown committed
1287
    mtr_report("Skipping SSL, mysqld not compiled with SSL");
1288 1289 1290 1291 1292 1293 1294 1295 1296
    $opt_ssl_supported= 0;
    $opt_ssl= 0;
    return;
  }
  mtr_report("Setting mysqld to support SSL connections");
  $opt_ssl_supported= 1;
}


unknown's avatar
unknown committed
1297 1298 1299 1300 1301 1302
##############################################################################
#
#  Start the ndb cluster
#
##############################################################################

1303 1304 1305 1306 1307
sub check_ndbcluster_support () {

  if ($opt_skip_ndbcluster)
  {
    mtr_report("Skipping ndbcluster");
1308
    $opt_skip_ndbcluster_slave= 1;
1309
    $opt_with_ndbcluster= 0;
1310
    $opt_with_ndbcluster_slave= 0;
1311 1312
    return;
  }
1313 1314 1315 1316 1317 1318 1319 1320 1321

  # check ndbcluster support by testing using a switch
  # that is only available in that case
  if ( mtr_run($exe_mysqld,
	       ["--no-defaults",
	        "--ndb-use-exact-count",
	        "--help"],
	       "", "/dev/null", "/dev/null", "") != 0 )
  {
unknown's avatar
unknown committed
1322
    mtr_report("Skipping ndbcluster, mysqld not compiled with ndbcluster");
1323 1324
    $opt_skip_ndbcluster= 1;
    $opt_skip_ndbcluster_slave= 1;
1325
    $opt_with_ndbcluster= 0;
1326
    $opt_with_ndbcluster_slave= 0;
1327
    return;
1328
  }
1329

1330 1331
  mtr_report("Using ndbcluster, mysqld supports it");
  $opt_with_ndbcluster= 1;
1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357
  if ( $opt_ndbconnectstring )
  {
    $glob_use_running_ndbcluster= 1;
  }
  else
  {
    $opt_ndbconnectstring= "host=localhost:$opt_ndbcluster_port";
  }

  if ( $opt_skip_ndbcluster_slave )
  {
    $opt_with_ndbcluster_slave= 0;
  }
  else
  {
    $opt_with_ndbcluster_slave= 1;
    if ( $opt_ndbconnectstring_slave )
    {
      $glob_use_running_ndbcluster_slave= 1;
    }
    else
    {
      $opt_ndbconnectstring_slave= "host=localhost:$opt_ndbcluster_port_slave";
    }
  }

1358
  return;
1359 1360
}

unknown's avatar
unknown committed
1361 1362
# FIXME why is there a different start below?!

1363
sub ndbcluster_install () {
unknown's avatar
unknown committed
1364

1365 1366 1367 1368
  if ( ! $opt_with_ndbcluster or $glob_use_running_ndbcluster )
  {
    return 0;
  }
1369
  mtr_report("Installing ndbcluster master");
unknown's avatar
unknown committed
1370
  my $ndbcluster_opts=  $opt_bench ? "" : "--small";
1371 1372
  if (  mtr_run("$glob_mysql_test_dir/ndb/ndbcluster",
		["--port=$opt_ndbcluster_port",
1373
		 "--data-dir=$opt_vardir",
1374
		 "--verbose=2",
1375
		 $ndbcluster_opts,
1376
		 "--initial",
1377 1378
                 "--relative-config-data-dir",
	         "--core"],
1379 1380 1381 1382 1383 1384
		"", "", "", "") )
  {
    mtr_error("Error ndbcluster_install");
    return 1;
  }

1385
  $using_ndbcluster_master= 1;
1386 1387 1388 1389 1390 1391
  ndbcluster_stop();
  $master->[0]->{'ndbcluster'}= 1;

  return 0;
}

1392 1393
sub ndbcluster_start ($) {
  my $use_ndbcluster= shift;
1394

1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405
  if ( ! $use_ndbcluster )
  {
    $using_ndbcluster_master= 0;
    return 0;
  }
  if ( $glob_use_running_ndbcluster )
  {
    $using_ndbcluster_master= 1;
    return 0;
  }
  if ( $using_ndbcluster_master )
1406 1407 1408 1409
  {
    return 0;
  }
  # FIXME, we want to _append_ output to file $file_ndb_testrun_log instead of /dev/null
1410
  #mtr_report("Starting ndbcluster master");
1411 1412
  if ( mtr_run("$glob_mysql_test_dir/ndb/ndbcluster",
	       ["--port=$opt_ndbcluster_port",
1413
		"--data-dir=$opt_vardir",
1414 1415
		"--verbose=2",
	        "--core"],
1416 1417
	       "", "/dev/null", "", "") )
  {
unknown's avatar
unknown committed
1418
    mtr_error("Error ndbcluster_start");
1419
    $using_ndbcluster_master= 0;
1420 1421 1422
    return 1;
  }

1423
  $using_ndbcluster_master= 1;
1424
  return 0;
unknown's avatar
unknown committed
1425 1426
}

unknown's avatar
unknown committed
1427 1428 1429 1430 1431 1432 1433 1434 1435
sub rm_ndbcluster_tables ($) {
  my $dir=       shift;
  foreach my $bin ( glob("$dir/cluster_replication/apply_status*"),
                    glob("$dir/cluster_replication/schema*") )
  {
    unlink($bin);
  }
}

unknown's avatar
unknown committed
1436
sub ndbcluster_stop () {
1437

1438
  if ( ! $using_ndbcluster_master or $glob_use_running_ndbcluster )
1439
  {
1440
    $using_ndbcluster_master= 0;
1441 1442 1443
    return;
  }
  # FIXME, we want to _append_ output to file $file_ndb_testrun_log instead of /dev/null
1444
  #mtr_report("Stopping ndbcluster master");
unknown's avatar
unknown committed
1445
  mtr_run("$glob_mysql_test_dir/ndb/ndbcluster",
1446
          ["--port=$opt_ndbcluster_port",
1447
           "--data-dir=$opt_vardir",
1448
	   "--verbose=2",
unknown's avatar
unknown committed
1449
           "--stop"],
1450 1451
          "", "/dev/null", "", "");

unknown's avatar
unknown committed
1452 1453
  rm_ndbcluster_tables ($master->[0]->{'path_myddir'});
  rm_ndbcluster_tables ($master->[1]->{'path_myddir'});
1454
  $using_ndbcluster_master= 0;
unknown's avatar
unknown committed
1455 1456 1457 1458 1459 1460 1461 1462 1463
  return;
}

sub ndbcluster_install_slave () {

  if ( ! $opt_with_ndbcluster_slave or $glob_use_running_ndbcluster_slave )
  {
    return 0;
  }
1464
  mtr_report("Installing ndbcluster slave");
unknown's avatar
unknown committed
1465 1466 1467
  if (  mtr_run("$glob_mysql_test_dir/ndb/ndbcluster",
		["--port=$opt_ndbcluster_port_slave",
		 "--data-dir=$opt_vardir",
1468
		 "--verbose=2",
unknown's avatar
unknown committed
1469 1470
		 "--small",
		 "--ndbd-nodes=1",
1471
		 "--initial",
1472 1473
		 "--relative-config-data-dir",
		 "--core"],
unknown's avatar
unknown committed
1474 1475 1476 1477 1478 1479
		"", "", "", "") )
  {
    mtr_error("Error ndbcluster_install_slave");
    return 1;
  }

1480
  $using_ndbcluster_slave= 1;
unknown's avatar
unknown committed
1481 1482 1483 1484 1485 1486
  ndbcluster_stop_slave();
  $slave->[0]->{'ndbcluster'}= 1;

  return 0;
}

1487 1488
sub ndbcluster_start_slave ($) {
  my $use_ndbcluster= shift;
unknown's avatar
unknown committed
1489

1490
  if ( ! $use_ndbcluster )
unknown's avatar
unknown committed
1491
  {
1492
    $using_ndbcluster_slave= 0;
unknown's avatar
unknown committed
1493 1494
    return 0;
  }
1495 1496 1497 1498 1499 1500
  if ( $glob_use_running_ndbcluster_slave )
  {
    $using_ndbcluster_slave= 1;
    return 0;
  }

unknown's avatar
unknown committed
1501
  # FIXME, we want to _append_ output to file $file_ndb_testrun_log instead of /dev/null
1502
  #mtr_report("Starting ndbcluster slave");
unknown's avatar
unknown committed
1503 1504 1505
  if ( mtr_run("$glob_mysql_test_dir/ndb/ndbcluster",
	       ["--port=$opt_ndbcluster_port_slave",
		"--data-dir=$opt_vardir",
1506
		"--verbose=2",
1507 1508
		"--ndbd-nodes=1",
	        "--core"],
unknown's avatar
unknown committed
1509 1510 1511
	       "", "/dev/null", "", "") )
  {
    mtr_error("Error ndbcluster_start_slave");
1512
    $using_ndbcluster_slave= 0;
unknown's avatar
unknown committed
1513 1514 1515
    return 1;
  }

1516
  $using_ndbcluster_slave= 1;
unknown's avatar
unknown committed
1517 1518 1519 1520 1521
  return 0;
}

sub ndbcluster_stop_slave () {

1522
  if ( ! $using_ndbcluster_slave or $glob_use_running_ndbcluster_slave )
unknown's avatar
unknown committed
1523
  {
1524
    $using_ndbcluster_slave= 0;
unknown's avatar
unknown committed
1525 1526 1527
    return;
  }
  # FIXME, we want to _append_ output to file $file_ndb_testrun_log instead of /dev/null
1528
  #mtr_report("Stopping ndbcluster slave");
unknown's avatar
unknown committed
1529 1530 1531
  mtr_run("$glob_mysql_test_dir/ndb/ndbcluster",
          ["--port=$opt_ndbcluster_port_slave",
           "--data-dir=$opt_vardir",
1532
	   "--verbose=2",
unknown's avatar
unknown committed
1533 1534 1535 1536 1537
           "--stop"],
          "", "/dev/null", "", "");

  rm_ndbcluster_tables ($slave->[0]->{'path_myddir'});

1538
  $using_ndbcluster_slave= 0;
1539
  return;
unknown's avatar
unknown committed
1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555
}


##############################################################################
#
#  Run the benchmark suite
#
##############################################################################

sub run_benchmarks ($) {
  my $benchmark=  shift;

  my $args;

  if ( ! $glob_use_embedded_server and ! $opt_local_master )
  {
1556 1557
    $master->[0]->{'pid'}= mysqld_start('master',0,[],[],
					$using_ndbcluster_master);
unknown's avatar
unknown committed
1558 1559 1560 1561
    if ( ! $master->[0]->{'pid'} )
    {
      mtr_error("Can't start the mysqld server");
    }
unknown's avatar
unknown committed
1562 1563 1564 1565 1566
  }

  mtr_init_args(\$args);

  mtr_add_arg($args, "--socket=%s", $master->[0]->{'path_mysock'});
unknown's avatar
unknown committed
1567
  mtr_add_arg($args, "--user=%s", $opt_user);
unknown's avatar
unknown committed
1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587

  if ( $opt_small_bench )
  {
    mtr_add_arg($args, "--small-test");
    mtr_add_arg($args, "--small-tables");
  }

  if ( $opt_with_ndbcluster )
  {
    mtr_add_arg($args, "--create-options=TYPE=ndb");
  }

  my $benchdir=  "$glob_basedir/sql-bench";
  chdir($benchdir);             # FIXME check error

  # FIXME write shorter....

  if ( ! $benchmark )
  {
    mtr_add_arg($args, "--log");
unknown's avatar
unknown committed
1588
    mtr_run("$glob_mysql_bench_dir/run-all-tests", $args, "", "", "", "");
unknown's avatar
unknown committed
1589 1590 1591 1592
    # FIXME check result code?!
  }
  elsif ( -x $benchmark )
  {
unknown's avatar
unknown committed
1593
    mtr_run("$glob_mysql_bench_dir/$benchmark", $args, "", "", "", "");
unknown's avatar
unknown committed
1594 1595 1596 1597
    # FIXME check result code?!
  }
  else
  {
unknown's avatar
unknown committed
1598
    mtr_error("Benchmark $benchmark not found");
unknown's avatar
unknown committed
1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615
  }

  chdir($glob_mysql_test_dir);          # Go back

  if ( ! $glob_use_embedded_server )
  {
    stop_masters();
  }
}


##############################################################################
#
#  Run the test suite
#
##############################################################################

unknown's avatar
unknown committed
1616 1617
# FIXME how to specify several suites to run? Comma separated list?

unknown's avatar
unknown committed
1618
sub run_tests () {
unknown's avatar
unknown committed
1619 1620 1621 1622 1623 1624 1625
  run_suite($opt_suite);
}

sub run_suite () {
  my $suite= shift;

  mtr_print_thick_line();
unknown's avatar
unknown committed
1626

unknown's avatar
unknown committed
1627
  mtr_report("Finding  Tests in the '$suite' suite");
unknown's avatar
unknown committed
1628

1629 1630
  mtr_timer_start($glob_timers,"suite", 60 * $opt_suite_timeout);

unknown's avatar
unknown committed
1631
  my $tests= collect_test_cases($suite);
unknown's avatar
unknown committed
1632

unknown's avatar
unknown committed
1633
  mtr_report("Starting Tests in the '$suite' suite");
unknown's avatar
unknown committed
1634 1635 1636 1637 1638

  mtr_print_header();

  foreach my $tinfo ( @$tests )
  {
1639
    mtr_timer_start($glob_timers,"testcase", 60 * $opt_testcase_timeout);
unknown's avatar
unknown committed
1640
    run_testcase($tinfo);
1641
    mtr_timer_stop($glob_timers,"testcase");
unknown's avatar
unknown committed
1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661
  }

  mtr_print_line();

  if ( ! $opt_gdb and ! $glob_use_running_server and
       ! $opt_ddd and ! $glob_use_embedded_server )
  {
    stop_masters_slaves();
  }

  if ( $opt_gcov )
  {
    gcov_collect(); # collect coverage information
  }
  if ( $opt_gprof )
  {
    gprof_collect(); # collect coverage information
  }

  mtr_report_stats($tests);
1662 1663

  mtr_timer_stop($glob_timers,"suite");
unknown's avatar
unknown committed
1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674
}


##############################################################################
#
#  Initiate the test databases
#
##############################################################################

sub mysql_install_db () {

unknown's avatar
unknown committed
1675
  # FIXME not exactly true I think, needs improvements
unknown's avatar
unknown committed
1676
  install_db('master', $master->[0]->{'path_myddir'});
unknown's avatar
unknown committed
1677
  install_db('master', $master->[1]->{'path_myddir'});
unknown's avatar
unknown committed
1678
  install_db('slave',  $slave->[0]->{'path_myddir'});
unknown's avatar
unknown committed
1679 1680
  install_db('slave',  $slave->[1]->{'path_myddir'});
  install_db('slave',  $slave->[2]->{'path_myddir'});
unknown's avatar
unknown committed
1681

unknown's avatar
unknown committed
1682
  if ( ! $opt_skip_im )
1683 1684 1685 1686
  {
    im_prepare_env($instance_manager);
  }

1687 1688 1689 1690 1691 1692 1693
  if ( ndbcluster_install() )
  {
    # failed to install, disable usage but flag that its no ok
    $opt_with_ndbcluster= 0;
    $flag_ndb_status_ok= 0;
  }

unknown's avatar
unknown committed
1694 1695 1696 1697 1698 1699 1700
  if ( ndbcluster_install_slave() )
  {
    # failed to install, disable usage but flag that its no ok
    $opt_with_ndbcluster_slave= 0;
    $flag_ndb_slave_status_ok= 0;
  }

unknown's avatar
unknown committed
1701 1702 1703 1704 1705 1706 1707 1708
  return 0;
}


sub install_db ($$) {
  my $type=      shift;
  my $data_dir=  shift;

unknown's avatar
unknown committed
1709 1710
  my $init_db_sql=     "lib/init_db.sql";
  my $init_db_sql_tmp= "/tmp/init_db.sql$$";
unknown's avatar
unknown committed
1711 1712 1713 1714
  my $args;

  mtr_report("Installing \u$type Databases");

unknown's avatar
unknown committed
1715
  open(IN, $init_db_sql)
unknown's avatar
unknown committed
1716
    or mtr_error("Can't open $init_db_sql: $!");
unknown's avatar
unknown committed
1717
  open(OUT, ">", $init_db_sql_tmp)
unknown's avatar
unknown committed
1718
    or mtr_error("Can't write to $init_db_sql_tmp: $!");
unknown's avatar
unknown committed
1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732
  while (<IN>)
  {
    chomp;
    s/\@HOSTNAME\@/$glob_hostname/;
    if ( /^\s*$/ )
    {
      print OUT "\n";
    }
    elsif (/;$/)
    {
      print OUT "$_\n";
    }
    else
    {
unknown's avatar
unknown committed
1733
      print OUT "$_ ";
unknown's avatar
unknown committed
1734 1735 1736 1737 1738
    }
  }
  close OUT;
  close IN;

unknown's avatar
unknown committed
1739 1740 1741 1742
  mtr_init_args(\$args);

  mtr_add_arg($args, "--no-defaults");
  mtr_add_arg($args, "--bootstrap");
1743
  mtr_add_arg($args, "--console");
unknown's avatar
unknown committed
1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756
  mtr_add_arg($args, "--skip-grant-tables");
  mtr_add_arg($args, "--basedir=%s", $path_my_basedir);
  mtr_add_arg($args, "--datadir=%s", $data_dir);
  mtr_add_arg($args, "--skip-innodb");
  mtr_add_arg($args, "--skip-ndbcluster");
  mtr_add_arg($args, "--skip-bdb");

  if ( ! $opt_netware )
  {
    mtr_add_arg($args, "--language=%s", $path_language);
    mtr_add_arg($args, "--character-sets-dir=%s", $path_charsetsdir);
  }

unknown's avatar
unknown committed
1757
  if ( mtr_run($exe_mysqld, $args, $init_db_sql_tmp,
unknown's avatar
unknown committed
1758 1759
               $path_manager_log, $path_manager_log, "") != 0 )
  {
unknown's avatar
unknown committed
1760
    unlink($init_db_sql_tmp);
unknown's avatar
unknown committed
1761
    mtr_error("Error executing mysqld --bootstrap\n" .
unknown's avatar
unknown committed
1762 1763
              "Could not install $type test DBs");
  }
unknown's avatar
unknown committed
1764
  unlink($init_db_sql_tmp);
unknown's avatar
unknown committed
1765 1766 1767
}


1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837
sub im_prepare_env($) {
  my $instance_manager = shift;

  im_create_passwd_file($instance_manager);
  im_prepare_data_dir($instance_manager);
}


sub im_create_passwd_file($) {
  my $instance_manager = shift;

  my $pwd_file_path = $instance_manager->{'password_file'};
  
  mtr_report("Creating IM password file ($pwd_file_path)");
  
  open(OUT, ">", $pwd_file_path)
    or mtr_error("Can't write to $pwd_file_path: $!");
  
  print OUT $instance_manager->{'admin_login'}, ":",
        $instance_manager->{'admin_sha1'}, "\n";
  
  close(OUT);
}


sub im_create_defaults_file($) {
  my $instance_manager = shift;

  my $defaults_file = $instance_manager->{'defaults_file'};

  open(OUT, ">", $defaults_file)
    or mtr_error("Can't write to $defaults_file: $!");
  
  print OUT <<EOF
[mysql]

[manager]
pid-file            = $instance_manager->{path_pid}
socket              = $instance_manager->{path_sock}
port                = $instance_manager->{port}
password-file       = $instance_manager->{password_file}
default-mysqld-path = $exe_mysqld

EOF
;

  foreach my $instance (@{$instance_manager->{'instances'}})
  {
    my $server_id = $instance->{'server_id'};

    print OUT <<EOF
[mysqld$server_id]
socket              = $instance->{path_sock}
pid-file            = $instance->{path_pid}
port                = $instance->{port}
datadir             = $instance->{path_datadir}
log                 = $instance->{path_datadir}/mysqld$server_id.log
log-error           = $instance->{path_datadir}/mysqld$server_id.err.log
log-slow-queries    = $instance->{path_datadir}/mysqld$server_id.slow.log
language            = $path_language
character-sets-dir  = $path_charsetsdir
basedir             = $path_my_basedir
server_id           =$server_id
skip-stack-trace
skip-innodb
skip-bdb
skip-ndbcluster
EOF
;

unknown's avatar
unknown committed
1838
    print OUT "nonguarded\n" if $instance->{'nonguarded'};
1839
    print OUT "old-log-format\n" if $instance->{'old_log_format'};
1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858
    print OUT "\n";
  }

  close(OUT);
}


sub im_prepare_data_dir($) {
  my $instance_manager = shift;

  foreach my $instance (@{$instance_manager->{'instances'}})
  {
    install_db(
      'im_mysqld_' . $instance->{'server_id'},
      $instance->{'path_datadir'});
  }
}


unknown's avatar
unknown committed
1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879
##############################################################################
#
#  Run a single test case
#
##############################################################################

# When we get here, we have already filtered out test cases that doesn't
# apply to the current setup, for example if we use a running server, test
# cases that restart the server are dropped. So this function should mostly
# be about doing things, not a lot of logic.

# We don't start and kill the servers for each testcase. But some
# testcases needs a restart, because they specify options to start
# mysqld with. After that testcase, we need to restart again, to set
# back the normal options.

sub run_testcase ($) {
  my $tinfo=  shift;

  my $tname= $tinfo->{'name'};

1880 1881
  my $ndbcluster_opt;

unknown's avatar
unknown committed
1882 1883
  mtr_tonewfile($opt_current_test,"$tname\n"); # Always tell where we are

1884 1885 1886
  # output current test to ndbcluster log file to enable diagnostics
  mtr_tofile($file_ndb_testrun_log,"CURRENT TEST $tname\n");

unknown's avatar
unknown committed
1887 1888 1889 1890 1891 1892 1893 1894 1895
  # ----------------------------------------------------------------------
  # If marked to skip, just print out and return.
  # Note that a test case not marked as 'skip' can still be
  # skipped later, because of the test case itself in cooperation
  # with the mysqltest program tells us so.
  # ----------------------------------------------------------------------

  if ( $tinfo->{'skip'} )
  {
unknown's avatar
unknown committed
1896
    mtr_report_test_name($tinfo);
unknown's avatar
unknown committed
1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913
    mtr_report_test_skipped($tinfo);
    return;
  }

  # ----------------------------------------------------------------------
  # If not using a running servers we may need to stop and restart.
  # We restart in the case we have initiation scripts, server options
  # etc to run. But we also restart again after the test first restart
  # and test is run, to get back to normal server settings.
  #
  # To make the code a bit more clean, we actually only stop servers
  # here, and mark this to be done. Then a generic "start" part will
  # start up the needed servers again.
  # ----------------------------------------------------------------------

  if ( ! $glob_use_running_server and ! $glob_use_embedded_server )
  {
unknown's avatar
unknown committed
1914
    if ( $tinfo->{'master_restart'} or
1915 1916
         $master->[0]->{'running_master_is_special'} or
         ( $tinfo->{'ndb_test'} != $using_ndbcluster_master ) )
unknown's avatar
unknown committed
1917 1918
    {
      stop_masters();
unknown's avatar
unknown committed
1919
      $master->[0]->{'running_master_is_special'}= 0; # Forget why we stopped
unknown's avatar
unknown committed
1920 1921 1922 1923 1924 1925 1926 1927 1928
    }

    # ----------------------------------------------------------------------
    # Always terminate all slaves, if any. Else we may have useless
    # reconnection attempts and error messages in case the slave and
    # master servers restart.
    # ----------------------------------------------------------------------

    stop_slaves();
unknown's avatar
unknown committed
1929
  }    
unknown's avatar
unknown committed
1930

unknown's avatar
unknown committed
1931 1932 1933 1934 1935
  # ----------------------------------------------------------------------
  # Prepare to start masters. Even if we use embedded, we want to run
  # the preparation.
  # ----------------------------------------------------------------------

unknown's avatar
unknown committed
1936 1937
  $ENV{'TZ'}= $tinfo->{'timezone'};

unknown's avatar
unknown committed
1938 1939
  mtr_report_test_name($tinfo);

unknown's avatar
unknown committed
1940
  mtr_tofile($master->[0]->{'path_myerr'},"CURRENT_TEST: $tname\n");
unknown's avatar
unknown committed
1941 1942 1943 1944

# FIXME test cases that depend on each other, prevent this from
# being at this location.
#  do_before_start_master($tname,$tinfo->{'master_sh'});
unknown's avatar
unknown committed
1945

unknown's avatar
unknown committed
1946 1947 1948 1949 1950 1951
  # ----------------------------------------------------------------------
  # If any mysqld servers running died, we have to know
  # ----------------------------------------------------------------------

  mtr_record_dead_children();

unknown's avatar
unknown committed
1952 1953 1954
  # ----------------------------------------------------------------------
  # Start masters
  # ----------------------------------------------------------------------
unknown's avatar
unknown committed
1955

unknown's avatar
unknown committed
1956 1957
  if ( ! $glob_use_running_server and ! $glob_use_embedded_server )
  {
unknown's avatar
unknown committed
1958 1959 1960 1961 1962
    # FIXME give the args to the embedded server?!
    # FIXME what does $opt_local_master mean?!
    # FIXME split up start and check that started so that can do
    #       starts in parallel, masters and slaves at the same time.

1963
    if ( $tinfo->{'component_id'} eq 'mysqld' and ! $opt_local_master )
unknown's avatar
unknown committed
1964
    {
1965 1966
      if ( $master->[0]->{'ndbcluster'} )
      {
1967
	$master->[0]->{'ndbcluster'}= ndbcluster_start($tinfo->{'ndb_test'});
1968 1969 1970 1971 1972 1973
        if ( $master->[0]->{'ndbcluster'} )
        {
          report_failure_and_restart($tinfo);
          return;
        }
      }
unknown's avatar
unknown committed
1974 1975
      if ( ! $master->[0]->{'pid'} )
      {
unknown's avatar
unknown committed
1976 1977
        # FIXME not correct location for do_before_start_master()
        do_before_start_master($tname,$tinfo->{'master_sh'});
unknown's avatar
unknown committed
1978
        $master->[0]->{'pid'}=
1979 1980
          mysqld_start('master',0,$tinfo->{'master_opt'},[],
		       $using_ndbcluster_master);
unknown's avatar
unknown committed
1981 1982 1983 1984 1985
        if ( ! $master->[0]->{'pid'} )
        {
          report_failure_and_restart($tinfo);
          return;
        }
unknown's avatar
unknown committed
1986
      }
1987
      if ( $using_ndbcluster_master and ! $master->[1]->{'pid'} )
unknown's avatar
unknown committed
1988 1989
      {
        $master->[1]->{'pid'}=
1990 1991
          mysqld_start('master',1,$tinfo->{'master_opt'},[],
		       $using_ndbcluster_master);
unknown's avatar
unknown committed
1992 1993 1994 1995 1996
        if ( ! $master->[1]->{'pid'} )
        {
          report_failure_and_restart($tinfo);
          return;
        }
unknown's avatar
unknown committed
1997 1998
      }

unknown's avatar
unknown committed
1999
      if ( $tinfo->{'master_restart'} )
unknown's avatar
unknown committed
2000
      {
unknown's avatar
unknown committed
2001
        $master->[0]->{'running_master_is_special'}= 1;
unknown's avatar
unknown committed
2002 2003
      }
    }
unknown's avatar
unknown committed
2004
    elsif ( ! $opt_skip_im and $tinfo->{'component_id'} eq 'im' )
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
    {
      # We have to create defaults file every time, in order to ensure that it
      # will be the same for each test. The problem is that test can change the
      # file (by SET/UNSET commands), so w/o recreating the file, execution of
      # one test can affect the other.

      im_create_defaults_file($instance_manager);

      im_start($instance_manager, $tinfo->{im_opts});
    }
unknown's avatar
unknown committed
2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029

    # ----------------------------------------------------------------------
    # Start slaves - if needed
    # ----------------------------------------------------------------------

    if ( $tinfo->{'slave_num'} )
    {
      mtr_tofile($slave->[0]->{'path_myerr'},"CURRENT_TEST: $tname\n");

      do_before_start_slave($tname,$tinfo->{'slave_sh'});

      for ( my $idx= 0; $idx <  $tinfo->{'slave_num'}; $idx++ )
      {
        if ( ! $slave->[$idx]->{'pid'} )
        {
2030
	  $ndbcluster_opt= 0;
unknown's avatar
unknown committed
2031 2032 2033 2034
          if ( $idx == 0)
	  {
	    if ( $slave->[0]->{'ndbcluster'} )
	    {
2035 2036
	      $slave->[0]->{'ndbcluster'}=
		ndbcluster_start_slave($tinfo->{'ndb_test'});
unknown's avatar
unknown committed
2037 2038 2039 2040 2041 2042
	      if ( $slave->[0]->{'ndbcluster'} )
	      {
		report_failure_and_restart($tinfo);
		return;
	      }
	    }
2043
	    $ndbcluster_opt= $using_ndbcluster_slave;
unknown's avatar
unknown committed
2044
	  }
unknown's avatar
unknown committed
2045 2046
          $slave->[$idx]->{'pid'}=
            mysqld_start('slave',$idx,
2047 2048
                         $tinfo->{'slave_opt'}, $tinfo->{'slave_mi'},
			 $ndbcluster_opt);
unknown's avatar
unknown committed
2049 2050 2051 2052 2053
          if ( ! $slave->[$idx]->{'pid'} )
          {
            report_failure_and_restart($tinfo);
            return;
          }
unknown's avatar
unknown committed
2054 2055 2056 2057 2058
        }
      }
    }
  }

unknown's avatar
unknown committed
2059 2060 2061 2062 2063 2064 2065 2066 2067 2068
  # ----------------------------------------------------------------------
  # If --start-and-exit given, stop here to let user manually run tests
  # ----------------------------------------------------------------------

  if ( $opt_start_and_exit )
  {
    mtr_report("\nServers started, exiting");
    exit(0);
  }

unknown's avatar
unknown committed
2069 2070 2071 2072 2073
  # ----------------------------------------------------------------------
  # Run the test case
  # ----------------------------------------------------------------------

  {
2074 2075 2076 2077 2078 2079 2080 2081 2082
    # remove the old reject file
    if ( $opt_suite eq "main" )
    {
      unlink("r/$tname.reject");
    }
    else
    {
      unlink("suite/$opt_suite/r/$tname.reject");
    }
unknown's avatar
unknown committed
2083 2084
    unlink($path_timefile);

unknown's avatar
unknown committed
2085
    my $res= run_mysqltest($tinfo);
unknown's avatar
unknown committed
2086 2087 2088 2089 2090

    if ( $res == 0 )
    {
      mtr_report_test_passed($tinfo);
    }
unknown's avatar
unknown committed
2091
    elsif ( $res == 62 )
unknown's avatar
unknown committed
2092 2093 2094 2095
    {
      # Testcase itself tell us to skip this one
      mtr_report_test_skipped($tinfo);
    }
2096 2097 2098 2099 2100
    elsif ( $res == 63 )
    {
      $tinfo->{'timeout'}= 1;           # Mark as timeout
      report_failure_and_restart($tinfo);
    }
unknown's avatar
unknown committed
2101 2102
    else
    {
unknown's avatar
unknown committed
2103 2104
      # Test case failed, if in control mysqltest returns 1
      if ( $res != 1 )
unknown's avatar
unknown committed
2105 2106 2107 2108 2109
      {
        mtr_tofile($path_timefile,
                   "mysqltest returned unexpected code $res, " .
                   "it has probably crashed");
      }
unknown's avatar
unknown committed
2110 2111
      report_failure_and_restart($tinfo);
    }
2112 2113 2114 2115 2116
    # Save info from this testcase run to mysqltest.log
    mtr_tofile($path_mysqltest_log,"CURRENT TEST $tname\n");
    my $testcase_log= mtr_fromfile($path_timefile);
    mtr_tofile($path_mysqltest_log,
	       $testcase_log);
unknown's avatar
unknown committed
2117
  }
2118 2119 2120 2121 2122

  # ----------------------------------------------------------------------
  # Stop Instance Manager if we are processing an IM-test case.
  # ----------------------------------------------------------------------

unknown's avatar
unknown committed
2123 2124
  if ( ! $glob_use_running_server and $tinfo->{'component_id'} eq 'im' and
       $instance_manager->{'pid'} )
2125 2126 2127
  {
    im_stop($instance_manager);
  }
unknown's avatar
unknown committed
2128
}
unknown's avatar
unknown committed
2129

unknown's avatar
unknown committed
2130 2131 2132 2133 2134 2135 2136 2137 2138

sub report_failure_and_restart ($) {
  my $tinfo= shift;

  mtr_report_test_failed($tinfo);
  mtr_show_failed_diff($tinfo->{'name'});
  print "\n";
  if ( ! $opt_force )
  {
unknown's avatar
unknown committed
2139 2140 2141
    my $test_mode= join(" ", @::glob_test_mode) || "default";
    print "Aborting: $tinfo->{'name'} failed in $test_mode mode. ";
    print "To continue, re-run with '--force'.\n";
unknown's avatar
unknown committed
2142 2143 2144 2145
    if ( ! $opt_gdb and ! $glob_use_running_server and
         ! $opt_ddd and ! $glob_use_embedded_server )
    {
      stop_masters_slaves();
unknown's avatar
unknown committed
2146
    }
unknown's avatar
unknown committed
2147
    mtr_exit(1);
unknown's avatar
unknown committed
2148 2149 2150 2151 2152 2153 2154
  }

  # FIXME always terminate on failure?!
  if ( ! $opt_gdb and ! $glob_use_running_server and
       ! $opt_ddd and ! $glob_use_embedded_server )
  {
    stop_masters_slaves();
unknown's avatar
unknown committed
2155
  }
unknown's avatar
unknown committed
2156
  print "Resuming Tests\n\n";
unknown's avatar
unknown committed
2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169
}


##############################################################################
#
#  Start and stop servers
#
##############################################################################

# The embedded server needs the cleanup so we do some of the start work
# but stop before actually running mysqld or anything.

sub do_before_start_master ($$) {
unknown's avatar
unknown committed
2170 2171
  my $tname=       shift;
  my $init_script= shift;
unknown's avatar
unknown committed
2172 2173 2174 2175 2176 2177 2178 2179 2180

  # FIXME what about second master.....

  # Remove stale binary logs except for 2 tests which need them FIXME here????
  if ( $tname ne "rpl_crash_binlog_ib_1b" and
       $tname ne "rpl_crash_binlog_ib_2b" and
       $tname ne "rpl_crash_binlog_ib_3b")
  {
    # FIXME we really want separate dir for binlogs
unknown's avatar
unknown committed
2181
    foreach my $bin ( glob("$opt_vardir/log/master*-bin*") )
unknown's avatar
unknown committed
2182 2183 2184
    {
      unlink($bin);
    }
unknown's avatar
unknown committed
2185 2186
  }

unknown's avatar
unknown committed
2187
  # FIXME only remove the ones that are tied to this master
unknown's avatar
unknown committed
2188
  # Remove old master.info and relay-log.info files
unknown's avatar
unknown committed
2189 2190 2191 2192
  unlink("$master->[0]->{'path_myddir'}/master.info");
  unlink("$master->[0]->{'path_myddir'}/relay-log.info");
  unlink("$master->[1]->{'path_myddir'}/master.info");
  unlink("$master->[1]->{'path_myddir'}/relay-log.info");
unknown's avatar
unknown committed
2193

unknown's avatar
unknown committed
2194
  # Run master initialization shell script if one exists
unknown's avatar
unknown committed
2195
  if ( $init_script )
unknown's avatar
unknown committed
2196
  {
unknown's avatar
unknown committed
2197 2198 2199 2200 2201 2202
    my $ret= mtr_run("/bin/sh", [$init_script], "", "", "", "");
    if ( $ret != 0 )
    {
      # FIXME rewrite those scripts to return 0 if successful
#      mtr_warning("$init_script exited with code $ret");
    }
unknown's avatar
unknown committed
2203 2204 2205 2206 2207 2208
  }
  # for gcov  FIXME needed? If so we need more absolute paths
# chdir($glob_basedir);
}

sub do_before_start_slave ($$) {
unknown's avatar
unknown committed
2209 2210
  my $tname=       shift;
  my $init_script= shift;
unknown's avatar
unknown committed
2211 2212 2213 2214 2215 2216 2217 2218

  # Remove stale binary logs and old master.info files
  # except for too tests which need them
  if ( $tname ne "rpl_crash_binlog_ib_1b" and
       $tname ne "rpl_crash_binlog_ib_2b" and
       $tname ne "rpl_crash_binlog_ib_3b" )
  {
    # FIXME we really want separate dir for binlogs
unknown's avatar
unknown committed
2219
    foreach my $bin ( glob("$opt_vardir/log/slave*-bin*") )
unknown's avatar
unknown committed
2220 2221 2222
    {
      unlink($bin);
    }
unknown's avatar
unknown committed
2223
    # FIXME really master?!
unknown's avatar
unknown committed
2224 2225
    unlink("$slave->[0]->{'path_myddir'}/master.info");
    unlink("$slave->[0]->{'path_myddir'}/relay-log.info");
unknown's avatar
unknown committed
2226 2227
  }

unknown's avatar
unknown committed
2228
  # Run slave initialization shell script if one exists
unknown's avatar
unknown committed
2229
  if ( $init_script )
unknown's avatar
unknown committed
2230
  {
unknown's avatar
unknown committed
2231 2232 2233 2234 2235 2236
    my $ret= mtr_run("/bin/sh", [$init_script], "", "", "", "");
    if ( $ret != 0 )
    {
      # FIXME rewrite those scripts to return 0 if successful
#      mtr_warning("$init_script exited with code $ret");
    }
unknown's avatar
unknown committed
2237 2238
  }

unknown's avatar
unknown committed
2239 2240 2241 2242
  foreach my $bin ( glob("$slave->[0]->{'path_myddir'}/log.*") )
  {
    unlink($bin);
  }
unknown's avatar
unknown committed
2243 2244
}

2245
sub mysqld_arguments ($$$$$$) {
unknown's avatar
unknown committed
2246 2247 2248 2249 2250
  my $args=              shift;
  my $type=              shift;        # master/slave/bootstrap
  my $idx=               shift;
  my $extra_opt=         shift;
  my $slave_master_info= shift;
2251
  my $using_ndbcluster=  shift;
unknown's avatar
unknown committed
2252

unknown's avatar
unknown committed
2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263
  my $sidx= "";                 # Index as string, 0 is empty string
  if ( $idx > 0 )
  {
    $sidx= sprintf("%d", $idx); # sprintf not needed in Perl for this
  }

  my $prefix= "";               # If mysqltest server arg

  if ( $glob_use_embedded_server )
  {
    $prefix= "--server-arg=";
unknown's avatar
unknown committed
2264 2265 2266
  } else {
    # We can't pass embedded server --no-defaults
    mtr_add_arg($args, "%s--no-defaults", $prefix);
unknown's avatar
unknown committed
2267 2268
  }

2269
  mtr_add_arg($args, "%s--console", $prefix);
unknown's avatar
unknown committed
2270 2271 2272
  mtr_add_arg($args, "%s--basedir=%s", $prefix, $path_my_basedir);
  mtr_add_arg($args, "%s--character-sets-dir=%s", $prefix, $path_charsetsdir);
  mtr_add_arg($args, "%s--core", $prefix);
2273
  mtr_add_arg($args, "%s--log-bin-trust-function-creators", $prefix);
2274
  mtr_add_arg($args, "%s--loose-binlog-show-xid=0", $prefix);
unknown's avatar
unknown committed
2275 2276 2277 2278
  mtr_add_arg($args, "%s--default-character-set=latin1", $prefix);
  mtr_add_arg($args, "%s--language=%s", $prefix, $path_language);
  mtr_add_arg($args, "%s--tmpdir=$opt_tmpdir", $prefix);

2279
  if ( defined $opt_valgrind_mysqld )
unknown's avatar
unknown committed
2280 2281 2282 2283 2284 2285 2286 2287 2288
  {
    mtr_add_arg($args, "%s--skip-safemalloc", $prefix);
    mtr_add_arg($args, "%s--skip-bdb", $prefix);
  }

  my $pidfile;

  if ( $type eq 'master' )
  {
unknown's avatar
unknown committed
2289 2290 2291 2292
    my $id= $idx > 0 ? $idx + 101 : 1;

    mtr_add_arg($args, "%s--log-bin=%s/log/master-bin%s", $prefix,
                $opt_vardir, $sidx);
unknown's avatar
unknown committed
2293 2294 2295 2296
    mtr_add_arg($args, "%s--pid-file=%s", $prefix,
                $master->[$idx]->{'path_mypid'});
    mtr_add_arg($args, "%s--port=%d", $prefix,
                $master->[$idx]->{'path_myport'});
unknown's avatar
unknown committed
2297
    mtr_add_arg($args, "%s--server-id=%d", $prefix, $id);
unknown's avatar
unknown committed
2298 2299
    mtr_add_arg($args, "%s--socket=%s", $prefix,
                $master->[$idx]->{'path_mysock'});
unknown's avatar
unknown committed
2300
    mtr_add_arg($args, "%s--innodb_data_file_path=ibdata1:128M:autoextend", $prefix);
unknown's avatar
unknown committed
2301 2302 2303
    mtr_add_arg($args, "%s--local-infile", $prefix);
    mtr_add_arg($args, "%s--datadir=%s", $prefix,
                $master->[$idx]->{'path_myddir'});
unknown's avatar
unknown committed
2304

unknown's avatar
unknown committed
2305 2306 2307 2308 2309
    if ( $idx > 0 )
    {
      mtr_add_arg($args, "%s--skip-innodb", $prefix);
    }

unknown's avatar
unknown committed
2310 2311 2312 2313
    if ( $opt_skip_ndbcluster )
    {
      mtr_add_arg($args, "%s--skip-ndbcluster", $prefix);
    }
2314
    if ( $using_ndbcluster )
unknown's avatar
unknown committed
2315 2316 2317 2318 2319
    {
      mtr_add_arg($args, "%s--ndbcluster", $prefix);
      mtr_add_arg($args, "%s--ndb-connectstring=%s", $prefix,
                  $opt_ndbconnectstring);
    }
unknown's avatar
unknown committed
2320 2321 2322 2323 2324
  }

  if ( $type eq 'slave' )
  {
    my $slave_server_id=  2 + $idx;
unknown's avatar
unknown committed
2325
    my $slave_rpl_rank= $slave_server_id;
unknown's avatar
unknown committed
2326 2327 2328

    mtr_add_arg($args, "%s--datadir=%s", $prefix,
                $slave->[$idx]->{'path_myddir'});
unknown's avatar
unknown committed
2329
    # FIXME slave get this option twice?!
unknown's avatar
unknown committed
2330 2331
    mtr_add_arg($args, "%s--exit-info=256", $prefix);
    mtr_add_arg($args, "%s--init-rpl-role=slave", $prefix);
2332 2333
    mtr_add_arg($args, "%s--log-bin=%s/log/slave%s-bin", $prefix,
                $opt_vardir, $sidx); # FIXME use own dir for binlogs
unknown's avatar
unknown committed
2334
    mtr_add_arg($args, "%s--log-slave-updates", $prefix);
unknown's avatar
unknown committed
2335
    # FIXME option duplicated for slave
unknown's avatar
unknown committed
2336
    mtr_add_arg($args, "%s--log=%s", $prefix,
unknown's avatar
unknown committed
2337
                $slave->[$idx]->{'path_mylog'});
unknown's avatar
unknown committed
2338 2339 2340 2341 2342
    mtr_add_arg($args, "%s--master-retry-count=10", $prefix);
    mtr_add_arg($args, "%s--pid-file=%s", $prefix,
                $slave->[$idx]->{'path_mypid'});
    mtr_add_arg($args, "%s--port=%d", $prefix,
                $slave->[$idx]->{'path_myport'});
2343 2344
    mtr_add_arg($args, "%s--relay-log=%s/log/slave%s-relay-bin", $prefix,
                $opt_vardir, $sidx);
unknown's avatar
unknown committed
2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375
    mtr_add_arg($args, "%s--report-host=127.0.0.1", $prefix);
    mtr_add_arg($args, "%s--report-port=%d", $prefix,
                $slave->[$idx]->{'path_myport'});
    mtr_add_arg($args, "%s--report-user=root", $prefix);
    mtr_add_arg($args, "%s--skip-innodb", $prefix);
    mtr_add_arg($args, "%s--skip-ndbcluster", $prefix);
    mtr_add_arg($args, "%s--skip-slave-start", $prefix);
    mtr_add_arg($args, "%s--slave-load-tmpdir=%s", $prefix,
                $path_slave_load_tmpdir);
    mtr_add_arg($args, "%s--socket=%s", $prefix,
                $slave->[$idx]->{'path_mysock'});
    mtr_add_arg($args, "%s--set-variable=slave_net_timeout=10", $prefix);

    if ( @$slave_master_info )
    {
      foreach my $arg ( @$slave_master_info )
      {
        mtr_add_arg($args, "%s%s", $prefix, $arg);
      }
    }
    else
    {
      mtr_add_arg($args, "%s--master-user=root", $prefix);
      mtr_add_arg($args, "%s--master-connect-retry=1", $prefix);
      mtr_add_arg($args, "%s--master-host=127.0.0.1", $prefix);
      mtr_add_arg($args, "%s--master-password=", $prefix);
      mtr_add_arg($args, "%s--master-port=%d", $prefix,
                  $master->[0]->{'path_myport'}); # First master
      mtr_add_arg($args, "%s--server-id=%d", $prefix, $slave_server_id);
      mtr_add_arg($args, "%s--rpl-recovery-rank=%d", $prefix, $slave_rpl_rank);
    }
unknown's avatar
unknown committed
2376 2377 2378 2379 2380
    
    if ( $opt_skip_ndbcluster_slave )
    {
      mtr_add_arg($args, "%s--skip-ndbcluster", $prefix);
    }
2381
    if ( $idx == 0 and $using_ndbcluster_slave )
unknown's avatar
unknown committed
2382 2383 2384 2385 2386
    {
      mtr_add_arg($args, "%s--ndbcluster", $prefix);
      mtr_add_arg($args, "%s--ndb-connectstring=%s", $prefix,
                  $opt_ndbconnectstring_slave);
    }
unknown's avatar
unknown committed
2387 2388 2389 2390 2391 2392
  } # end slave

  if ( $opt_debug )
  {
    if ( $type eq 'master' )
    {
2393 2394
      mtr_add_arg($args, "%s--debug=d:t:i:A,%s/log/master%s.trace",
                  $prefix, $opt_vardir, $sidx);
unknown's avatar
unknown committed
2395 2396 2397
    }
    if ( $type eq 'slave' )
    {
2398 2399
      mtr_add_arg($args, "%s--debug=d:t:i:A,%s/log/slave%s.trace",
                  $prefix, $opt_vardir, $sidx);
unknown's avatar
unknown committed
2400 2401 2402 2403 2404 2405 2406
    }
  }

  # FIXME always set nowdays??? SMALL_SERVER
  mtr_add_arg($args, "%s--key_buffer_size=1M", $prefix);
  mtr_add_arg($args, "%s--sort_buffer=256K", $prefix);
  mtr_add_arg($args, "%s--max_heap_table_size=1M", $prefix);
2407
  mtr_add_arg($args, "%s--log-bin-trust-function-creators", $prefix);
2408
  mtr_add_arg($args, "%s--loose-binlog-show-xid=0", $prefix);
unknown's avatar
unknown committed
2409

2410
  if ( $opt_ssl_supported )
unknown's avatar
unknown committed
2411
  {
2412 2413 2414 2415 2416 2417
    mtr_add_arg($args, "%s--ssl-ca=%s/std_data/cacert.pem", $prefix,
                $glob_mysql_test_dir);
    mtr_add_arg($args, "%s--ssl-cert=%s/std_data/server-cert.pem", $prefix,
                $glob_mysql_test_dir);
    mtr_add_arg($args, "%s--ssl-key=%s/std_data/server-key.pem", $prefix,
                $glob_mysql_test_dir);
unknown's avatar
unknown committed
2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447
  }

  if ( $opt_warnings )
  {
    mtr_add_arg($args, "%s--log-warnings", $prefix);
  }

  if ( $opt_gdb or $opt_client_gdb or $opt_manual_gdb or $opt_ddd)
  {
    mtr_add_arg($args, "%s--gdb", $prefix);
  }

  # If we should run all tests cases, we will use a local server for that

  if ( -w "/" )
  {
    # We are running as root;  We need to add the --root argument
    mtr_add_arg($args, "%s--user=root", $prefix);
  }

  if ( $type eq 'master' )
  {

    if ( ! $opt_old_master )
    {
      mtr_add_arg($args, "%s--rpl-recovery-rank=1", $prefix);
      mtr_add_arg($args, "%s--init-rpl-role=master", $prefix);
    }

    # FIXME strange,.....
unknown's avatar
unknown committed
2448
    # FIXME MYSQL_MYPORT is not set anythere?!
unknown's avatar
unknown committed
2449 2450 2451 2452 2453 2454 2455
    if ( $opt_local_master )
    {
      mtr_add_arg($args, "%s--host=127.0.0.1", $prefix);
      mtr_add_arg($args, "%s--port=%s", $prefix, $ENV{'MYSQL_MYPORT'});
    }
  }

unknown's avatar
unknown committed
2456
  foreach my $arg ( @opt_extra_mysqld_opt, @$extra_opt )
unknown's avatar
unknown committed
2457 2458 2459 2460 2461 2462 2463 2464 2465
  {
    mtr_add_arg($args, "%s%s", $prefix, $arg);
  }

  if ( $opt_bench )
  {
    mtr_add_arg($args, "%s--rpl-recovery-rank=1", $prefix);
    mtr_add_arg($args, "%s--init-rpl-role=master", $prefix);
  }
unknown's avatar
unknown committed
2466
  elsif ( $type eq 'master' )
unknown's avatar
unknown committed
2467 2468 2469
  {
    mtr_add_arg($args, "%s--exit-info=256", $prefix);
    mtr_add_arg($args, "%s--open-files-limit=1024", $prefix);
unknown's avatar
unknown committed
2470
    mtr_add_arg($args, "%s--log=%s", $prefix, $master->[0]->{'path_mylog'});
unknown's avatar
unknown committed
2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490
  }

  return $args;
}

# FIXME
#  if ( $type eq 'master' and $glob_use_embedded_server )
#  {
#    # Add a -A to each argument to pass it to embedded server
#    my @mysqltest_opt=  map {("-A",$_)} @args;
#    $opt_extra_mysqltest_opt=  \@mysqltest_opt;
#    return;
#  }

##############################################################################
#
#  Start mysqld and return the PID
#
##############################################################################

2491
sub mysqld_start ($$$$$) {
unknown's avatar
unknown committed
2492 2493 2494 2495
  my $type=              shift;        # master/slave/bootstrap
  my $idx=               shift;
  my $extra_opt=         shift;
  my $slave_master_info= shift;
2496
  my $using_ndbcluster=  shift;
unknown's avatar
unknown committed
2497 2498 2499 2500 2501

  my $args;                             # Arg vector
  my $exe;
  my $pid;

unknown's avatar
unknown committed
2502
  if ( $type eq 'master' )
unknown's avatar
unknown committed
2503
  {
unknown's avatar
unknown committed
2504 2505 2506 2507 2508
    $exe= $exe_master_mysqld;
  }
  elsif ( $type eq 'slave' )
  {
    $exe= $exe_slave_mysqld;
unknown's avatar
unknown committed
2509 2510 2511
  }
  else
  {
unknown's avatar
unknown committed
2512
    $exe= $exe_mysqld;
unknown's avatar
unknown committed
2513 2514 2515 2516
  }

  mtr_init_args(\$args);

2517
  if ( defined $opt_valgrind_mysqld )
unknown's avatar
unknown committed
2518
  {
unknown's avatar
unknown committed
2519
    valgrind_arguments($args, \$exe);
unknown's avatar
unknown committed
2520 2521
  }

2522 2523
  mysqld_arguments($args,$type,$idx,$extra_opt,$slave_master_info,
		   $using_ndbcluster);
unknown's avatar
unknown committed
2524 2525 2526 2527 2528

  if ( $type eq 'master' )
  {
    if ( $pid= mtr_spawn($exe, $args, "",
                         $master->[$idx]->{'path_myerr'},
unknown's avatar
unknown committed
2529 2530
                         $master->[$idx]->{'path_myerr'},
                         "",
2531
                         { append_log_file => 1 }) )
unknown's avatar
unknown committed
2532
    {
unknown's avatar
unknown committed
2533 2534
      return sleep_until_file_created($master->[$idx]->{'path_mypid'},
                                      $master->[$idx]->{'start_timeout'}, $pid);
unknown's avatar
unknown committed
2535 2536 2537 2538 2539 2540 2541
    }
  }

  if ( $type eq 'slave' )
  {
    if ( $pid= mtr_spawn($exe, $args, "",
                         $slave->[$idx]->{'path_myerr'},
unknown's avatar
unknown committed
2542 2543
                         $slave->[$idx]->{'path_myerr'},
                         "",
2544
                         { append_log_file => 1 }) )
unknown's avatar
unknown committed
2545
    {
unknown's avatar
unknown committed
2546 2547
      return sleep_until_file_created($slave->[$idx]->{'path_mypid'},
                                      $master->[$idx]->{'start_timeout'}, $pid);
unknown's avatar
unknown committed
2548 2549 2550
    }
  }

unknown's avatar
unknown committed
2551
  return 0;
unknown's avatar
unknown committed
2552 2553 2554 2555 2556
}

sub stop_masters_slaves () {

  print  "Ending Tests\n";
2557

unknown's avatar
unknown committed
2558
  if ( $instance_manager->{'pid'} )
2559 2560 2561 2562 2563
  {
    print  "Shutting-down Instance Manager\n";
    im_stop($instance_manager);
  }
  
unknown's avatar
unknown committed
2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580
  print  "Shutting-down MySQL daemon\n\n";
  stop_masters();
  print "Master(s) shutdown finished\n";
  stop_slaves();
  print "Slave(s) shutdown finished\n";
}

sub stop_masters () {

  my @args;

  for ( my $idx; $idx < 2; $idx++ )
  {
    # FIXME if we hit ^C before fully started, this test will prevent
    # the mysqld process from being killed
    if ( $master->[$idx]->{'pid'} )
    {
unknown's avatar
unknown committed
2581 2582 2583 2584 2585 2586 2587
      push(@args,{
                  pid      => $master->[$idx]->{'pid'},
                  pidfile  => $master->[$idx]->{'path_mypid'},
                  sockfile => $master->[$idx]->{'path_mysock'},
                  port     => $master->[$idx]->{'path_myport'},
                 });
      $master->[$idx]->{'pid'}= 0; # Assume we are done with it
unknown's avatar
unknown committed
2588 2589 2590
    }
  }

2591 2592 2593 2594 2595 2596
  if ( ! $master->[0]->{'ndbcluster'} )
  {
    ndbcluster_stop();
    $master->[0]->{'ndbcluster'}= 1;
  }

unknown's avatar
unknown committed
2597
  mtr_stop_mysqld_servers(\@args);
unknown's avatar
unknown committed
2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608
}

sub stop_slaves () {
  my $force= shift;

  my @args;

  for ( my $idx; $idx < 3; $idx++ )
  {
    if ( $slave->[$idx]->{'pid'} )
    {
unknown's avatar
unknown committed
2609 2610 2611 2612 2613 2614 2615
      push(@args,{
                  pid      => $slave->[$idx]->{'pid'},
                  pidfile  => $slave->[$idx]->{'path_mypid'},
                  sockfile => $slave->[$idx]->{'path_mysock'},
                  port     => $slave->[$idx]->{'path_myport'},
                 });
      $slave->[$idx]->{'pid'}= 0; # Assume we are done with it
unknown's avatar
unknown committed
2616 2617 2618
    }
  }

unknown's avatar
unknown committed
2619 2620 2621 2622 2623 2624
  if ( ! $slave->[0]->{'ndbcluster'} )
  {
    ndbcluster_stop_slave();
    $slave->[0]->{'ndbcluster'}= 1;
  }

unknown's avatar
unknown committed
2625
  mtr_stop_mysqld_servers(\@args);
unknown's avatar
unknown committed
2626 2627
}

2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639
##############################################################################
#
#  Instance Manager management routines.
#
##############################################################################

sub im_start($$) {
  my $instance_manager = shift;
  my $opts = shift;

  my $args;
  mtr_init_args(\$args);
unknown's avatar
unknown committed
2640 2641
  mtr_add_arg($args, "--defaults-file=%s",
              $instance_manager->{'defaults_file'});
2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658

  foreach my $opt (@{$opts})
  {
    mtr_add_arg($args, $opt);
  }

  $instance_manager->{'pid'} = 
    mtr_spawn(
      $exe_im,                          # path to the executable
      $args,                            # cmd-line args
      '',                               # stdin
      $instance_manager->{'path_log'},  # stdout
      $instance_manager->{'path_err'},  # stderr
      '',                               # pid file path (not used)
      { append_log_file => 1 }          # append log files
      );

unknown's avatar
unknown committed
2659
  if ( ! $instance_manager->{'pid'} )
2660 2661 2662 2663 2664 2665 2666 2667 2668
  {
    mtr_report('Could not start Instance Manager');
    return;
  }
  
  # Instance Manager can be run in daemon mode. In this case, it creates
  # several processes and the parent process, created by mtr_spawn(), exits just
  # after start. So, we have to obtain Instance Manager PID from the PID file.

unknown's avatar
unknown committed
2669 2670 2671 2672 2673 2674 2675 2676
  if ( ! sleep_until_file_created(
                                  $instance_manager->{'path_pid'},
                                  $instance_manager->{'start_timeout'},
                                  -1)) # real PID is still unknown
  {
    mtr_report("Instance Manager PID file is missing");
    return;
  }
2677 2678 2679 2680 2681 2682 2683 2684

  $instance_manager->{'pid'} =
    mtr_get_pid_from_file($instance_manager->{'path_pid'});
}

sub im_stop($) {
  my $instance_manager = shift;

2685 2686 2687 2688
  # Re-read pid from the file, since during tests Instance Manager could have
  # been restarted, so its pid could have been changed.

  $instance_manager->{'pid'} =
unknown's avatar
unknown committed
2689 2690
    mtr_get_pid_from_file($instance_manager->{'path_pid'})
      if -f $instance_manager->{'path_pid'};
2691

2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704
  # Inspired from mtr_stop_mysqld_servers().

  start_reap_all();

  # Create list of pids. We should stop Instance Manager and all started
  # mysqld-instances. Some of them may be nonguarded, so IM will not stop them
  # on shutdown.

  my @pids = ( $instance_manager->{'pid'} );
  my $instances = $instance_manager->{'instances'};

  if ( -r $instances->[0]->{'path_pid'} )
  {
unknown's avatar
unknown committed
2705
    push(@pids, mtr_get_pid_from_file($instances->[0]->{'path_pid'}));
2706 2707 2708 2709
  }

  if ( -r $instances->[1]->{'path_pid'} )
  {
unknown's avatar
unknown committed
2710
    push(@pids, mtr_get_pid_from_file($instances->[1]->{'path_pid'}));
2711 2712 2713 2714 2715 2716 2717 2718 2719 2720
  }

  # Kill processes.

  mtr_kill_processes(\@pids);
  
  stop_reap_all();

  $instance_manager->{'pid'} = undef;
}
unknown's avatar
unknown committed
2721

unknown's avatar
unknown committed
2722
sub run_mysqltest ($) {
unknown's avatar
unknown committed
2723
  my $tinfo=       shift;
unknown's avatar
unknown committed
2724

2725 2726 2727 2728 2729 2730 2731 2732 2733
  my $cmdline_mysqlcheck= "$exe_mysqlcheck --no-defaults -uroot " .
                          "--port=$master->[0]->{'path_myport'} " .
                          "--socket=$master->[0]->{'path_mysock'} --password=";
  if ( $opt_debug )
  {
    $cmdline_mysqlcheck .=
      " --debug=d:t:A,$opt_vardir/log/mysqldump.trace";
  }

unknown's avatar
unknown committed
2734
  my $cmdline_mysqldump= "$exe_mysqldump --no-defaults -uroot " .
unknown's avatar
unknown committed
2735
                         "--port=$master->[0]->{'path_myport'} " .
unknown's avatar
unknown committed
2736
                         "--socket=$master->[0]->{'path_mysock'} --password=";
2737 2738 2739 2740

 my $cmdline_mysqldumpslave= "$exe_mysqldump --no-defaults -uroot " .
                         "--socket=$slave->[0]->{'path_mysock'} --password=";

unknown's avatar
unknown committed
2741 2742 2743
  if ( $opt_debug )
  {
    $cmdline_mysqldump .=
2744
      " --debug=d:t:A,$opt_vardir/log/mysqldump.trace";
unknown's avatar
unknown committed
2745
  }
unknown's avatar
unknown committed
2746 2747 2748 2749 2750 2751

  my $cmdline_mysqlslap;

  unless ( $glob_win32 )
  {
    $cmdline_mysqlslap= "$exe_mysqlslap -uroot " .
2752
                         "--port=$master->[0]->{'path_myport'} " .
2753 2754
                         "--socket=$master->[0]->{'path_mysock'} --password= " .
                         "--lock-directory=$opt_tmpdir";
unknown's avatar
unknown committed
2755 2756 2757 2758 2759
    if ( $opt_debug )
    {
      $cmdline_mysqlslap .=
        " --debug=d:t:A,$opt_vardir/log/mysqldump.trace";
    }
2760
  }
unknown's avatar
unknown committed
2761

unknown's avatar
unknown committed
2762 2763 2764 2765 2766 2767 2768 2769
  my $cmdline_mysqlimport= "$exe_mysqlimport -uroot " .
                         "--port=$master->[0]->{'path_myport'} " .
                         "--socket=$master->[0]->{'path_mysock'} --password=";
  if ( $opt_debug )
  {
    $cmdline_mysqlimport .=
      " --debug=d:t:A,$opt_vardir/log/mysqlimport.trace";
  }
unknown's avatar
unknown committed
2770

unknown's avatar
unknown committed
2771
  my $cmdline_mysqlshow= "$exe_mysqlshow -uroot " .
unknown's avatar
unknown committed
2772
                         "--port=$master->[0]->{'path_myport'} " .
unknown's avatar
unknown committed
2773 2774 2775 2776 2777 2778 2779
                         "--socket=$master->[0]->{'path_mysock'} --password=";
  if ( $opt_debug )
  {
    $cmdline_mysqlshow .=
      " --debug=d:t:A,$opt_vardir/log/mysqlshow.trace";
  }

unknown's avatar
unknown committed
2780
  my $cmdline_mysqlbinlog=
2781 2782 2783
    "$exe_mysqlbinlog" .
      " --no-defaults --local-load=$opt_tmpdir" .
      " --character-sets-dir=$path_charsetsdir";
unknown's avatar
unknown committed
2784 2785 2786 2787

  if ( $opt_debug )
  {
    $cmdline_mysqlbinlog .=
2788
      " --debug=d:t:A,$opt_vardir/log/mysqlbinlog.trace";
unknown's avatar
unknown committed
2789 2790 2791
  }

  my $cmdline_mysql=
unknown's avatar
unknown committed
2792 2793 2794 2795 2796 2797 2798 2799 2800
    "$exe_mysql --host=localhost  --user=root --password= " .
    "--port=$master->[0]->{'path_myport'} " .
    "--socket=$master->[0]->{'path_mysock'}";

  my $cmdline_mysql_client_test=
    "$exe_mysql_client_test --no-defaults --testcase --user=root --silent " .
    "--port=$master->[0]->{'path_myport'} " .
    "--socket=$master->[0]->{'path_mysock'}";

unknown's avatar
unknown committed
2801 2802 2803 2804 2805 2806 2807 2808
  if ( $glob_use_embedded_server )
  {
    $cmdline_mysql_client_test.=
      " -A --language=$path_language" .
      " -A --datadir=$slave->[0]->{'path_myddir'}" .
      " -A --character-sets-dir=$path_charsetsdir";
  }

unknown's avatar
unknown committed
2809 2810 2811 2812 2813 2814 2815
  my $cmdline_mysql_fix_system_tables=
    "$exe_mysql_fix_system_tables --no-defaults --host=localhost --user=root --password= " .
    "--basedir=$glob_basedir --bindir=$path_client_bindir --verbose " .
    "--port=$master->[0]->{'path_myport'} " .
    "--socket=$master->[0]->{'path_mysock'}";


unknown's avatar
unknown committed
2816

unknown's avatar
unknown committed
2817 2818 2819
  # FIXME really needing a PATH???
  # $ENV{'PATH'}= "/bin:/usr/bin:/usr/local/bin:/usr/bsd:/usr/X11R6/bin:/usr/openwin/bin:/usr/bin/X11:$ENV{'PATH'}";

unknown's avatar
unknown committed
2820
  $ENV{'MYSQL'}=                    $cmdline_mysql;
2821
  $ENV{'MYSQL_CHECK'}=              $cmdline_mysqlcheck;
unknown's avatar
unknown committed
2822
  $ENV{'MYSQL_DUMP'}=               $cmdline_mysqldump;
unknown's avatar
unknown committed
2823
  $ENV{'MYSQL_SLAP'}=               $cmdline_mysqlslap unless $glob_win32;
unknown's avatar
unknown committed
2824
  $ENV{'MYSQL_IMPORT'}=             $cmdline_mysqlimport;
2825
  $ENV{'MYSQL_DUMP_SLAVE'}=         $cmdline_mysqldumpslave;
unknown's avatar
unknown committed
2826
  $ENV{'MYSQL_SHOW'}=               $cmdline_mysqlshow;
unknown's avatar
unknown committed
2827 2828 2829 2830
  $ENV{'MYSQL_BINLOG'}=             $cmdline_mysqlbinlog;
  $ENV{'MYSQL_FIX_SYSTEM_TABLES'}=  $cmdline_mysql_fix_system_tables;
  $ENV{'MYSQL_CLIENT_TEST'}=        $cmdline_mysql_client_test;
  $ENV{'CHARSETSDIR'}=              $path_charsetsdir;
2831
  $ENV{'MYSQL_MY_PRINT_DEFAULTS'}=  $exe_my_print_defaults;
unknown's avatar
unknown committed
2832

2833
  $ENV{'NDB_STATUS_OK'}=            $flag_ndb_status_ok;
unknown's avatar
unknown committed
2834 2835
  $ENV{'NDB_SLAVE_STATUS_OK'}=      $flag_ndb_slave_status_ok;
  $ENV{'NDB_EXTRA_TEST'}=           $opt_ndb_extra_test;
2836 2837 2838 2839 2840 2841
  $ENV{'NDB_MGM'}=                  $exe_ndb_mgm;
  $ENV{'NDB_BACKUP_DIR'}=           $path_ndb_backup_dir;
  $ENV{'NDB_TOOLS_DIR'}=            $path_ndb_tools_dir;
  $ENV{'NDB_TOOLS_OUTPUT'}=         $file_ndb_testrun_log;
  $ENV{'NDB_CONNECTSTRING'}=        $opt_ndbconnectstring;

unknown's avatar
unknown committed
2842 2843
  my $exe= $exe_mysqltest;
  my $args;
unknown's avatar
unknown committed
2844 2845 2846

  mtr_init_args(\$args);

unknown's avatar
unknown committed
2847
  if ( defined $opt_valgrind_mysqltest )
unknown's avatar
unknown committed
2848 2849 2850 2851
  {
    valgrind_arguments($args, \$exe);
  }

unknown's avatar
unknown committed
2852 2853 2854 2855 2856
  mtr_add_arg($args, "--no-defaults");
  mtr_add_arg($args, "--silent");
  mtr_add_arg($args, "-v");
  mtr_add_arg($args, "--skip-safemalloc");
  mtr_add_arg($args, "--tmpdir=%s", $opt_tmpdir);
2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872

  if ($tinfo->{'component_id'} eq 'im')
  {
    mtr_add_arg($args, "--socket=%s", $instance_manager->{'path_sock'});
    mtr_add_arg($args, "--port=%d", $instance_manager->{'port'});
    mtr_add_arg($args, "--user=%s", $instance_manager->{'admin_login'});
    mtr_add_arg($args, "--password=%s", $instance_manager->{'admin_password'});
  }
  else # component_id == mysqld
  {
    mtr_add_arg($args, "--socket=%s", $master->[0]->{'path_mysock'});
    mtr_add_arg($args, "--port=%d", $master->[0]->{'path_myport'});
    mtr_add_arg($args, "--database=test");
    mtr_add_arg($args, "--user=%s", $opt_user);
    mtr_add_arg($args, "--password=");
  }
unknown's avatar
unknown committed
2873

unknown's avatar
unknown committed
2874 2875 2876 2877 2878
  if ( $opt_ps_protocol )
  {
    mtr_add_arg($args, "--ps-protocol");
  }

2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893
  if ( $opt_sp_protocol )
  {
    mtr_add_arg($args, "--sp-protocol");
  }

  if ( $opt_view_protocol )
  {
    mtr_add_arg($args, "--view-protocol");
  }

  if ( $opt_cursor_protocol )
  {
    mtr_add_arg($args, "--cursor-protocol");
  }

unknown's avatar
unknown committed
2894 2895 2896 2897
  if ( $opt_strace_client )
  {
    $exe=  "strace";            # FIXME there are ktrace, ....
    mtr_add_arg($args, "-o");
2898
    mtr_add_arg($args, "%s/log/mysqltest.strace", $opt_vardir);
unknown's avatar
unknown committed
2899 2900 2901
    mtr_add_arg($args, "$exe_mysqltest");
  }

unknown's avatar
unknown committed
2902 2903
  if ( $opt_timer )
  {
2904
    mtr_add_arg($args, "--timer-file=%s/log/timer", $opt_vardir);
unknown's avatar
unknown committed
2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923
  }

  if ( $opt_big_test )
  {
    mtr_add_arg($args, "--big-test");
  }

  if ( $opt_compress )
  {
    mtr_add_arg($args, "--compress");
  }

  if ( $opt_sleep )
  {
    mtr_add_arg($args, "--sleep=%d", $opt_sleep);
  }

  if ( $opt_debug )
  {
2924
    mtr_add_arg($args, "--debug=d:t:A,%s/log/mysqltest.trace", $opt_vardir);
unknown's avatar
unknown committed
2925 2926
  }

2927
  if ( $opt_ssl_supported )
unknown's avatar
unknown committed
2928
  {
2929
    mtr_add_arg($args, "--ssl-ca=%s/std_data/cacert.pem",
2930
	        $glob_mysql_test_dir);
2931
    mtr_add_arg($args, "--ssl-cert=%s/std_data/client-cert.pem",
2932
	        $glob_mysql_test_dir);
2933
    mtr_add_arg($args, "--ssl-key=%s/std_data/client-key.pem",
2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946
	        $glob_mysql_test_dir);
  }

  # Turn on SSL for all test cases
  if ( $opt_ssl )
  {
    mtr_add_arg($args, "--ssl",
		$glob_mysql_test_dir);
  }
  elsif ( $opt_ssl_supported )
  {
    mtr_add_arg($args, "--skip-ssl",
		$glob_mysql_test_dir);
unknown's avatar
unknown committed
2947 2948
  }

unknown's avatar
unknown committed
2949 2950 2951 2952
  # ----------------------------------------------------------------------
  # If embedded server, we create server args to give mysqltest to pass on
  # ----------------------------------------------------------------------

unknown's avatar
unknown committed
2953 2954
  if ( $glob_use_embedded_server )
  {
2955
    mysqld_arguments($args,'master',0,$tinfo->{'master_opt'},[],0);
unknown's avatar
unknown committed
2956 2957
  }

2958 2959 2960 2961 2962
  # ----------------------------------------------------------------------
  # export MYSQL_TEST variable containing <path>/mysqltest <args>
  # ----------------------------------------------------------------------
  $ENV{'MYSQL_TEST'}= "$exe_mysqltest " . join(" ", @$args);

2963
  # ----------------------------------------------------------------------
2964
  # Add arguments that should not go into the MYSQL_TEST env var
2965 2966 2967 2968 2969 2970 2971 2972 2973 2974
  # ----------------------------------------------------------------------

  mtr_add_arg($args, "-R");
  mtr_add_arg($args, $tinfo->{'result_file'});

  if ( $opt_record )
  {
    mtr_add_arg($args, "--record");
  }

unknown's avatar
unknown committed
2975
  return mtr_run_test($exe,$args,$tinfo->{'path'},"",$path_timefile,"");
unknown's avatar
unknown committed
2976
}
unknown's avatar
unknown committed
2977

unknown's avatar
unknown committed
2978 2979 2980 2981 2982 2983 2984 2985 2986

sub valgrind_arguments {
  my $args= shift;
  my $exe=  shift;

  mtr_add_arg($args, "--tool=memcheck"); # From >= 2.1.2 needs this option
  mtr_add_arg($args, "--alignment=8");
  mtr_add_arg($args, "--leak-check=yes");
  mtr_add_arg($args, "--num-callers=16");
unknown's avatar
unknown committed
2987 2988
  mtr_add_arg($args, "--suppressions=%s/valgrind.supp", $glob_mysql_test_dir)
    if -f "$glob_mysql_test_dir/valgrind.supp";
unknown's avatar
unknown committed
2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001

  if ( defined $opt_valgrind_all )
  {
    mtr_add_arg($args, "-v");
    mtr_add_arg($args, "--show-reachable=yes");
  }

  if ( $opt_valgrind_options )
  {
    # FIXME split earlier and put into @glob_valgrind_*
    mtr_add_arg($args, split(' ', $opt_valgrind_options));
  }

3002

unknown's avatar
unknown committed
3003 3004 3005 3006 3007 3008
  mtr_add_arg($args, $$exe);

  $$exe= $opt_valgrind || "valgrind";
}


unknown's avatar
unknown committed
3009 3010 3011 3012 3013 3014
##############################################################################
#
#  Usage
#
##############################################################################

unknown's avatar
unknown committed
3015
sub usage ($) {
unknown's avatar
unknown committed
3016 3017 3018 3019 3020 3021 3022 3023 3024 3025
  print STDERR <<HERE;

mysql-test-run [ OPTIONS ] [ TESTCASE ]

FIXME when is TESTCASE arg used or not?!

Options to control what engine/variation to run

  embedded-server       Use the embedded server, i.e. no mysqld daemons
  ps-protocol           Use the binary protocol between client and server
3026 3027 3028 3029
  cursor-protocol       Use the cursor protocol between client and server
                        (implies --ps-protocol)
  view-protocol         Create a view to execute all non updating queries
  sp-protocol           Create a stored procedure to execute all queries
3030 3031 3032
  compress              Use the compressed protocol between client and server
  ssl                   Use ssl protocol between client and server
  skip-ssl              Dont start sterver with support for ssl connections
unknown's avatar
unknown committed
3033 3034 3035 3036 3037 3038 3039
  bench                 Run the benchmark suite FIXME
  small-bench           FIXME

Options to control what test suites or cases to run

  force                 Continue to run the suite after failure
  with-ndbcluster       Use cluster, and enable test cases that requres it
unknown's avatar
unknown committed
3040
  skip-ndb[cluster]     Skip the ndb test cases, don't start cluster
unknown's avatar
unknown committed
3041 3042 3043 3044
  do-test=PREFIX        Run test cases which name are prefixed with PREFIX
  start-from=PREFIX     Run test cases starting from test prefixed with PREFIX
  suite=NAME            Run the test suite named NAME. The default is "main"
  skip-rpl              Skip the replication test cases.
unknown's avatar
unknown committed
3045
  skip-im               Don't start IM, and skip the IM test cases
unknown's avatar
unknown committed
3046 3047 3048 3049 3050 3051
  skip-test=PREFIX      Skip test cases which name are prefixed with PREFIX

Options that specify ports

  master_port=PORT      Specify the port number used by the first master
  slave_port=PORT       Specify the port number used by the first slave
unknown's avatar
unknown committed
3052
  ndbcluster_port=PORT  Specify the port number used by cluster
unknown's avatar
unknown committed
3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064

Options for test case authoring

  record TESTNAME       (Re)genereate the result file for TESTNAME

Options that pass on options

  mysqld=ARGS           Specify additional arguments to "mysqld"

Options to run test on running server

  extern                Use running server for tests FIXME DANGEROUS
3065
  ndbconnectstring=STR  Use running cluster, and connect using STR
3066
  user=USER             User for connect to server
unknown's avatar
unknown committed
3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081

Options for debugging the product

  gdb                   FIXME
  manual-gdb            FIXME
  client-gdb            FIXME
  ddd                   FIXME
  strace-client         FIXME
  master-binary=PATH    Specify the master "mysqld" to use
  slave-binary=PATH     Specify the slave "mysqld" to use

Options for coverage, profiling etc

  gcov                  FIXME
  gprof                 FIXME
3082 3083
  valgrind[=EXE]        Run the "mysqld" server using valgrind, optionally
                        specifying the executable path/name
unknown's avatar
unknown committed
3084 3085
  valgrind-mysqltest[=EXE] In addition, run the "mysqltest" executable with valgrind
  valgrind-all[=EXE]    Adds verbose flag, and --show-reachable to valgrind
unknown's avatar
unknown committed
3086 3087 3088 3089 3090 3091 3092
  valgrind-options=ARGS Extra options to give valgrind

Misc options

  verbose               Verbose output from this script
  script-debug          Debug this script itself
  timer                 Show test case execution time
unknown's avatar
unknown committed
3093 3094
  start-and-exit        Only initiate and start the "mysqld" servers, use the startup
                        settings for the specified test case if any
3095
  start-dirty           Only start the "mysqld" servers without initiation
unknown's avatar
unknown committed
3096
  fast                  Don't try to cleanup from earlier runs
unknown's avatar
unknown committed
3097
  reorder               Reorder tests to get less server restarts
unknown's avatar
unknown committed
3098
  help                  Get this help text
unknown's avatar
unknown committed
3099
  unified-diff | udiff  When presenting differences, use unified diff
unknown's avatar
unknown committed
3100

3101 3102 3103
  testcase-timeout=MINUTES Max test case run time (default 5)
  suite-timeout=MINUTES    Max test suite run time (default 120)

3104 3105 3106
Deprecated options
  with-openssl          Deprecated option for ssl

3107

unknown's avatar
unknown committed
3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124
Options not yet described, or that I want to look into more

  big-test              
  debug                 
  local                 
  local-master          
  netware               
  old-master            
  sleep=SECONDS         
  socket=PATH           
  tmpdir=DIR            
  user-test=s           
  wait-timeout=SECONDS  
  warnings              
  log-warnings          

HERE
unknown's avatar
unknown committed
3125
  mtr_exit(1);
3126

unknown's avatar
unknown committed
3127
}