mysql-test-run.pl 91.6 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 1377
		 "--initial",
                 "--relative-config-data-dir"],
1378 1379 1380 1381 1382 1383
		"", "", "", "") )
  {
    mtr_error("Error ndbcluster_install");
    return 1;
  }

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

  return 0;
}

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

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

1421
  $using_ndbcluster_master= 1;
1422
  return 0;
unknown's avatar
unknown committed
1423 1424
}

unknown's avatar
unknown committed
1425 1426 1427 1428 1429 1430 1431 1432 1433
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
1434
sub ndbcluster_stop () {
1435

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

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

sub ndbcluster_install_slave () {

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

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

  return 0;
}

1484 1485
sub ndbcluster_start_slave ($) {
  my $use_ndbcluster= shift;
unknown's avatar
unknown committed
1486

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

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

1512
  $using_ndbcluster_slave= 1;
unknown's avatar
unknown committed
1513 1514 1515 1516 1517
  return 0;
}

sub ndbcluster_stop_slave () {

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

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

1534
  $using_ndbcluster_slave= 0;
1535
  return;
unknown's avatar
unknown committed
1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551
}


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

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

  my $args;

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

  mtr_init_args(\$args);

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

  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
1584
    mtr_run("$glob_mysql_bench_dir/run-all-tests", $args, "", "", "", "");
unknown's avatar
unknown committed
1585 1586 1587 1588
    # FIXME check result code?!
  }
  elsif ( -x $benchmark )
  {
unknown's avatar
unknown committed
1589
    mtr_run("$glob_mysql_bench_dir/$benchmark", $args, "", "", "", "");
unknown's avatar
unknown committed
1590 1591 1592 1593
    # FIXME check result code?!
  }
  else
  {
unknown's avatar
unknown committed
1594
    mtr_error("Benchmark $benchmark not found");
unknown's avatar
unknown committed
1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611
  }

  chdir($glob_mysql_test_dir);          # Go back

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


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

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

unknown's avatar
unknown committed
1614
sub run_tests () {
unknown's avatar
unknown committed
1615 1616 1617 1618 1619 1620 1621
  run_suite($opt_suite);
}

sub run_suite () {
  my $suite= shift;

  mtr_print_thick_line();
unknown's avatar
unknown committed
1622

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

1625 1626
  mtr_timer_start($glob_timers,"suite", 60 * $opt_suite_timeout);

unknown's avatar
unknown committed
1627
  my $tests= collect_test_cases($suite);
unknown's avatar
unknown committed
1628

unknown's avatar
unknown committed
1629
  mtr_report("Starting Tests in the '$suite' suite");
unknown's avatar
unknown committed
1630 1631 1632 1633 1634

  mtr_print_header();

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

  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);
1658 1659

  mtr_timer_stop($glob_timers,"suite");
unknown's avatar
unknown committed
1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670
}


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

sub mysql_install_db () {

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

unknown's avatar
unknown committed
1678
  if ( ! $opt_skip_im )
1679 1680 1681 1682
  {
    im_prepare_env($instance_manager);
  }

1683 1684 1685 1686 1687 1688 1689
  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
1690 1691 1692 1693 1694 1695 1696
  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
1697 1698 1699 1700 1701 1702 1703 1704
  return 0;
}


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

unknown's avatar
unknown committed
1705 1706
  my $init_db_sql=     "lib/init_db.sql";
  my $init_db_sql_tmp= "/tmp/init_db.sql$$";
unknown's avatar
unknown committed
1707 1708 1709 1710
  my $args;

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

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

unknown's avatar
unknown committed
1735 1736 1737 1738
  mtr_init_args(\$args);

  mtr_add_arg($args, "--no-defaults");
  mtr_add_arg($args, "--bootstrap");
1739
  mtr_add_arg($args, "--console");
unknown's avatar
unknown committed
1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752
  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
1753
  if ( mtr_run($exe_mysqld, $args, $init_db_sql_tmp,
unknown's avatar
unknown committed
1754 1755
               $path_manager_log, $path_manager_log, "") != 0 )
  {
unknown's avatar
unknown committed
1756
    unlink($init_db_sql_tmp);
unknown's avatar
unknown committed
1757
    mtr_error("Error executing mysqld --bootstrap\n" .
unknown's avatar
unknown committed
1758 1759
              "Could not install $type test DBs");
  }
unknown's avatar
unknown committed
1760
  unlink($init_db_sql_tmp);
unknown's avatar
unknown committed
1761 1762 1763
}


1764 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
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
1834
    print OUT "nonguarded\n" if $instance->{'nonguarded'};
1835
    print OUT "old-log-format\n" if $instance->{'old_log_format'};
1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854
    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
1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875
##############################################################################
#
#  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'};

1876 1877
  my $ndbcluster_opt;

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

1880 1881 1882
  # 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
1883 1884 1885 1886 1887 1888 1889 1890 1891
  # ----------------------------------------------------------------------
  # 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
1892
    mtr_report_test_name($tinfo);
unknown's avatar
unknown committed
1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909
    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
1910
    if ( $tinfo->{'master_restart'} or
1911 1912
         $master->[0]->{'running_master_is_special'} or
         ( $tinfo->{'ndb_test'} != $using_ndbcluster_master ) )
unknown's avatar
unknown committed
1913 1914
    {
      stop_masters();
unknown's avatar
unknown committed
1915
      $master->[0]->{'running_master_is_special'}= 0; # Forget why we stopped
unknown's avatar
unknown committed
1916 1917 1918 1919 1920 1921 1922 1923 1924
    }

    # ----------------------------------------------------------------------
    # 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
1925
  }    
unknown's avatar
unknown committed
1926

unknown's avatar
unknown committed
1927 1928 1929 1930 1931
  # ----------------------------------------------------------------------
  # Prepare to start masters. Even if we use embedded, we want to run
  # the preparation.
  # ----------------------------------------------------------------------

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

unknown's avatar
unknown committed
1934 1935
  mtr_report_test_name($tinfo);

unknown's avatar
unknown committed
1936
  mtr_tofile($master->[0]->{'path_myerr'},"CURRENT_TEST: $tname\n");
unknown's avatar
unknown committed
1937 1938 1939 1940

# 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
1941

unknown's avatar
unknown committed
1942 1943 1944 1945 1946 1947
  # ----------------------------------------------------------------------
  # If any mysqld servers running died, we have to know
  # ----------------------------------------------------------------------

  mtr_record_dead_children();

unknown's avatar
unknown committed
1948 1949 1950
  # ----------------------------------------------------------------------
  # Start masters
  # ----------------------------------------------------------------------
unknown's avatar
unknown committed
1951

unknown's avatar
unknown committed
1952 1953
  if ( ! $glob_use_running_server and ! $glob_use_embedded_server )
  {
unknown's avatar
unknown committed
1954 1955 1956 1957 1958
    # 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.

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

unknown's avatar
unknown committed
1995
      if ( $tinfo->{'master_restart'} )
unknown's avatar
unknown committed
1996
      {
unknown's avatar
unknown committed
1997
        $master->[0]->{'running_master_is_special'}= 1;
unknown's avatar
unknown committed
1998 1999
      }
    }
unknown's avatar
unknown committed
2000
    elsif ( ! $opt_skip_im and $tinfo->{'component_id'} eq 'im' )
2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
    {
      # 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
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025

    # ----------------------------------------------------------------------
    # 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'} )
        {
2026
	  $ndbcluster_opt= 0;
unknown's avatar
unknown committed
2027 2028 2029 2030
          if ( $idx == 0)
	  {
	    if ( $slave->[0]->{'ndbcluster'} )
	    {
2031 2032
	      $slave->[0]->{'ndbcluster'}=
		ndbcluster_start_slave($tinfo->{'ndb_test'});
unknown's avatar
unknown committed
2033 2034 2035 2036 2037 2038
	      if ( $slave->[0]->{'ndbcluster'} )
	      {
		report_failure_and_restart($tinfo);
		return;
	      }
	    }
2039
	    $ndbcluster_opt= $using_ndbcluster_slave;
unknown's avatar
unknown committed
2040
	  }
unknown's avatar
unknown committed
2041 2042
          $slave->[$idx]->{'pid'}=
            mysqld_start('slave',$idx,
2043 2044
                         $tinfo->{'slave_opt'}, $tinfo->{'slave_mi'},
			 $ndbcluster_opt);
unknown's avatar
unknown committed
2045 2046 2047 2048 2049
          if ( ! $slave->[$idx]->{'pid'} )
          {
            report_failure_and_restart($tinfo);
            return;
          }
unknown's avatar
unknown committed
2050 2051 2052 2053 2054
        }
      }
    }
  }

unknown's avatar
unknown committed
2055 2056 2057 2058 2059 2060 2061 2062 2063 2064
  # ----------------------------------------------------------------------
  # 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
2065 2066 2067 2068 2069
  # ----------------------------------------------------------------------
  # Run the test case
  # ----------------------------------------------------------------------

  {
2070 2071 2072 2073 2074 2075 2076 2077 2078
    # 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
2079 2080
    unlink($path_timefile);

unknown's avatar
unknown committed
2081
    my $res= run_mysqltest($tinfo);
unknown's avatar
unknown committed
2082 2083 2084 2085 2086

    if ( $res == 0 )
    {
      mtr_report_test_passed($tinfo);
    }
unknown's avatar
unknown committed
2087
    elsif ( $res == 62 )
unknown's avatar
unknown committed
2088 2089 2090 2091
    {
      # Testcase itself tell us to skip this one
      mtr_report_test_skipped($tinfo);
    }
2092 2093 2094 2095 2096
    elsif ( $res == 63 )
    {
      $tinfo->{'timeout'}= 1;           # Mark as timeout
      report_failure_and_restart($tinfo);
    }
unknown's avatar
unknown committed
2097 2098
    else
    {
unknown's avatar
unknown committed
2099 2100
      # Test case failed, if in control mysqltest returns 1
      if ( $res != 1 )
unknown's avatar
unknown committed
2101 2102 2103 2104 2105
      {
        mtr_tofile($path_timefile,
                   "mysqltest returned unexpected code $res, " .
                   "it has probably crashed");
      }
unknown's avatar
unknown committed
2106 2107
      report_failure_and_restart($tinfo);
    }
2108 2109 2110 2111 2112
    # 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
2113
  }
2114 2115 2116 2117 2118

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

unknown's avatar
unknown committed
2119 2120
  if ( ! $glob_use_running_server and $tinfo->{'component_id'} eq 'im' and
       $instance_manager->{'pid'} )
2121 2122 2123
  {
    im_stop($instance_manager);
  }
unknown's avatar
unknown committed
2124
}
unknown's avatar
unknown committed
2125

unknown's avatar
unknown committed
2126 2127 2128 2129 2130 2131 2132 2133 2134

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
2135 2136 2137
    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
2138 2139 2140 2141
    if ( ! $opt_gdb and ! $glob_use_running_server and
         ! $opt_ddd and ! $glob_use_embedded_server )
    {
      stop_masters_slaves();
unknown's avatar
unknown committed
2142
    }
unknown's avatar
unknown committed
2143
    mtr_exit(1);
unknown's avatar
unknown committed
2144 2145 2146 2147 2148 2149 2150
  }

  # 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
2151
  }
unknown's avatar
unknown committed
2152
  print "Resuming Tests\n\n";
unknown's avatar
unknown committed
2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165
}


##############################################################################
#
#  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
2166 2167
  my $tname=       shift;
  my $init_script= shift;
unknown's avatar
unknown committed
2168 2169 2170 2171 2172 2173 2174 2175 2176

  # 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
2177
    foreach my $bin ( glob("$opt_vardir/log/master*-bin*") )
unknown's avatar
unknown committed
2178 2179 2180
    {
      unlink($bin);
    }
unknown's avatar
unknown committed
2181 2182
  }

unknown's avatar
unknown committed
2183
  # FIXME only remove the ones that are tied to this master
unknown's avatar
unknown committed
2184
  # Remove old master.info and relay-log.info files
unknown's avatar
unknown committed
2185 2186 2187 2188
  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
2189

unknown's avatar
unknown committed
2190
  # Run master initialization shell script if one exists
unknown's avatar
unknown committed
2191
  if ( $init_script )
unknown's avatar
unknown committed
2192
  {
unknown's avatar
unknown committed
2193 2194 2195 2196 2197 2198
    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
2199 2200 2201 2202 2203 2204
  }
  # for gcov  FIXME needed? If so we need more absolute paths
# chdir($glob_basedir);
}

sub do_before_start_slave ($$) {
unknown's avatar
unknown committed
2205 2206
  my $tname=       shift;
  my $init_script= shift;
unknown's avatar
unknown committed
2207 2208 2209 2210 2211 2212 2213 2214

  # 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
2215
    foreach my $bin ( glob("$opt_vardir/log/slave*-bin*") )
unknown's avatar
unknown committed
2216 2217 2218
    {
      unlink($bin);
    }
unknown's avatar
unknown committed
2219
    # FIXME really master?!
unknown's avatar
unknown committed
2220 2221
    unlink("$slave->[0]->{'path_myddir'}/master.info");
    unlink("$slave->[0]->{'path_myddir'}/relay-log.info");
unknown's avatar
unknown committed
2222 2223
  }

unknown's avatar
unknown committed
2224
  # Run slave initialization shell script if one exists
unknown's avatar
unknown committed
2225
  if ( $init_script )
unknown's avatar
unknown committed
2226
  {
unknown's avatar
unknown committed
2227 2228 2229 2230 2231 2232
    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
2233 2234
  }

unknown's avatar
unknown committed
2235 2236 2237 2238
  foreach my $bin ( glob("$slave->[0]->{'path_myddir'}/log.*") )
  {
    unlink($bin);
  }
unknown's avatar
unknown committed
2239 2240
}

2241
sub mysqld_arguments ($$$$$$) {
unknown's avatar
unknown committed
2242 2243 2244 2245 2246
  my $args=              shift;
  my $type=              shift;        # master/slave/bootstrap
  my $idx=               shift;
  my $extra_opt=         shift;
  my $slave_master_info= shift;
2247
  my $using_ndbcluster=  shift;
unknown's avatar
unknown committed
2248

unknown's avatar
unknown committed
2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259
  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
2260 2261 2262
  } else {
    # We can't pass embedded server --no-defaults
    mtr_add_arg($args, "%s--no-defaults", $prefix);
unknown's avatar
unknown committed
2263 2264
  }

2265
  mtr_add_arg($args, "%s--console", $prefix);
unknown's avatar
unknown committed
2266 2267 2268
  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);
2269
  mtr_add_arg($args, "%s--log-bin-trust-function-creators", $prefix);
2270
  mtr_add_arg($args, "%s--loose-binlog-show-xid=0", $prefix);
unknown's avatar
unknown committed
2271 2272 2273 2274
  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);

2275
  if ( defined $opt_valgrind_mysqld )
unknown's avatar
unknown committed
2276 2277 2278 2279 2280 2281 2282 2283 2284
  {
    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
2285 2286 2287 2288
    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
2289 2290 2291 2292
    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
2293
    mtr_add_arg($args, "%s--server-id=%d", $prefix, $id);
unknown's avatar
unknown committed
2294 2295
    mtr_add_arg($args, "%s--socket=%s", $prefix,
                $master->[$idx]->{'path_mysock'});
unknown's avatar
unknown committed
2296
    mtr_add_arg($args, "%s--innodb_data_file_path=ibdata1:128M:autoextend", $prefix);
unknown's avatar
unknown committed
2297 2298 2299
    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
2300

unknown's avatar
unknown committed
2301 2302 2303 2304 2305
    if ( $idx > 0 )
    {
      mtr_add_arg($args, "%s--skip-innodb", $prefix);
    }

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

  if ( $type eq 'slave' )
  {
    my $slave_server_id=  2 + $idx;
unknown's avatar
unknown committed
2321
    my $slave_rpl_rank= $slave_server_id;
unknown's avatar
unknown committed
2322 2323 2324

    mtr_add_arg($args, "%s--datadir=%s", $prefix,
                $slave->[$idx]->{'path_myddir'});
unknown's avatar
unknown committed
2325
    # FIXME slave get this option twice?!
unknown's avatar
unknown committed
2326 2327
    mtr_add_arg($args, "%s--exit-info=256", $prefix);
    mtr_add_arg($args, "%s--init-rpl-role=slave", $prefix);
2328 2329
    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
2330
    mtr_add_arg($args, "%s--log-slave-updates", $prefix);
unknown's avatar
unknown committed
2331
    # FIXME option duplicated for slave
unknown's avatar
unknown committed
2332
    mtr_add_arg($args, "%s--log=%s", $prefix,
unknown's avatar
unknown committed
2333
                $slave->[$idx]->{'path_mylog'});
unknown's avatar
unknown committed
2334 2335 2336 2337 2338
    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'});
2339 2340
    mtr_add_arg($args, "%s--relay-log=%s/log/slave%s-relay-bin", $prefix,
                $opt_vardir, $sidx);
unknown's avatar
unknown committed
2341 2342 2343 2344 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
    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
2372 2373 2374 2375 2376
    
    if ( $opt_skip_ndbcluster_slave )
    {
      mtr_add_arg($args, "%s--skip-ndbcluster", $prefix);
    }
2377
    if ( $idx == 0 and $using_ndbcluster_slave )
unknown's avatar
unknown committed
2378 2379 2380 2381 2382
    {
      mtr_add_arg($args, "%s--ndbcluster", $prefix);
      mtr_add_arg($args, "%s--ndb-connectstring=%s", $prefix,
                  $opt_ndbconnectstring_slave);
    }
unknown's avatar
unknown committed
2383 2384 2385 2386 2387 2388
  } # end slave

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

  # 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);
2403
  mtr_add_arg($args, "%s--log-bin-trust-function-creators", $prefix);
2404
  mtr_add_arg($args, "%s--loose-binlog-show-xid=0", $prefix);
unknown's avatar
unknown committed
2405

2406
  if ( $opt_ssl_supported )
unknown's avatar
unknown committed
2407
  {
2408 2409 2410 2411 2412 2413
    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
2414 2415 2416 2417 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
  }

  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
2444
    # FIXME MYSQL_MYPORT is not set anythere?!
unknown's avatar
unknown committed
2445 2446 2447 2448 2449 2450 2451
    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
2452
  foreach my $arg ( @opt_extra_mysqld_opt, @$extra_opt )
unknown's avatar
unknown committed
2453 2454 2455 2456 2457 2458 2459 2460 2461
  {
    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
2462
  elsif ( $type eq 'master' )
unknown's avatar
unknown committed
2463 2464 2465
  {
    mtr_add_arg($args, "%s--exit-info=256", $prefix);
    mtr_add_arg($args, "%s--open-files-limit=1024", $prefix);
unknown's avatar
unknown committed
2466
    mtr_add_arg($args, "%s--log=%s", $prefix, $master->[0]->{'path_mylog'});
unknown's avatar
unknown committed
2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486
  }

  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
#
##############################################################################

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

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

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

  mtr_init_args(\$args);

2513
  if ( defined $opt_valgrind_mysqld )
unknown's avatar
unknown committed
2514
  {
unknown's avatar
unknown committed
2515
    valgrind_arguments($args, \$exe);
unknown's avatar
unknown committed
2516 2517
  }

2518 2519
  mysqld_arguments($args,$type,$idx,$extra_opt,$slave_master_info,
		   $using_ndbcluster);
unknown's avatar
unknown committed
2520 2521 2522 2523 2524

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

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

unknown's avatar
unknown committed
2547
  return 0;
unknown's avatar
unknown committed
2548 2549 2550 2551 2552
}

sub stop_masters_slaves () {

  print  "Ending Tests\n";
2553

unknown's avatar
unknown committed
2554
  if ( $instance_manager->{'pid'} )
2555 2556 2557 2558 2559
  {
    print  "Shutting-down Instance Manager\n";
    im_stop($instance_manager);
  }
  
unknown's avatar
unknown committed
2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576
  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
2577 2578 2579 2580 2581 2582 2583
      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
2584 2585 2586
    }
  }

2587 2588 2589 2590 2591 2592
  if ( ! $master->[0]->{'ndbcluster'} )
  {
    ndbcluster_stop();
    $master->[0]->{'ndbcluster'}= 1;
  }

unknown's avatar
unknown committed
2593
  mtr_stop_mysqld_servers(\@args);
unknown's avatar
unknown committed
2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604
}

sub stop_slaves () {
  my $force= shift;

  my @args;

  for ( my $idx; $idx < 3; $idx++ )
  {
    if ( $slave->[$idx]->{'pid'} )
    {
unknown's avatar
unknown committed
2605 2606 2607 2608 2609 2610 2611
      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
2612 2613 2614
    }
  }

unknown's avatar
unknown committed
2615 2616 2617 2618 2619 2620
  if ( ! $slave->[0]->{'ndbcluster'} )
  {
    ndbcluster_stop_slave();
    $slave->[0]->{'ndbcluster'}= 1;
  }

unknown's avatar
unknown committed
2621
  mtr_stop_mysqld_servers(\@args);
unknown's avatar
unknown committed
2622 2623
}

2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635
##############################################################################
#
#  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
2636 2637
  mtr_add_arg($args, "--defaults-file=%s",
              $instance_manager->{'defaults_file'});
2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654

  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
2655
  if ( ! $instance_manager->{'pid'} )
2656 2657 2658 2659 2660 2661 2662 2663 2664
  {
    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
2665 2666 2667 2668 2669 2670 2671 2672
  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;
  }
2673 2674 2675 2676 2677 2678 2679 2680

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

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

2681 2682 2683 2684
  # 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
2685 2686
    mtr_get_pid_from_file($instance_manager->{'path_pid'})
      if -f $instance_manager->{'path_pid'};
2687

2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699 2700
  # 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
2701
    push(@pids, mtr_get_pid_from_file($instances->[0]->{'path_pid'}));
2702 2703 2704 2705
  }

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

  # Kill processes.

  mtr_kill_processes(\@pids);
  
  stop_reap_all();

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

unknown's avatar
unknown committed
2718
sub run_mysqltest ($) {
unknown's avatar
unknown committed
2719
  my $tinfo=       shift;
unknown's avatar
unknown committed
2720

2721 2722 2723 2724 2725 2726 2727 2728 2729
  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
2730
  my $cmdline_mysqldump= "$exe_mysqldump --no-defaults -uroot " .
unknown's avatar
unknown committed
2731
                         "--port=$master->[0]->{'path_myport'} " .
unknown's avatar
unknown committed
2732
                         "--socket=$master->[0]->{'path_mysock'} --password=";
2733 2734 2735 2736

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

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

  my $cmdline_mysqlslap;

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

unknown's avatar
unknown committed
2758 2759 2760 2761 2762 2763 2764 2765
  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
2766

unknown's avatar
unknown committed
2767
  my $cmdline_mysqlshow= "$exe_mysqlshow -uroot " .
unknown's avatar
unknown committed
2768
                         "--port=$master->[0]->{'path_myport'} " .
unknown's avatar
unknown committed
2769 2770 2771 2772 2773 2774 2775
                         "--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
2776
  my $cmdline_mysqlbinlog=
2777 2778 2779
    "$exe_mysqlbinlog" .
      " --no-defaults --local-load=$opt_tmpdir" .
      " --character-sets-dir=$path_charsetsdir";
unknown's avatar
unknown committed
2780 2781 2782 2783

  if ( $opt_debug )
  {
    $cmdline_mysqlbinlog .=
2784
      " --debug=d:t:A,$opt_vardir/log/mysqlbinlog.trace";
unknown's avatar
unknown committed
2785 2786 2787
  }

  my $cmdline_mysql=
unknown's avatar
unknown committed
2788 2789 2790 2791 2792 2793 2794 2795 2796
    "$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
2797 2798 2799 2800 2801 2802 2803 2804
  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
2805 2806 2807 2808 2809 2810 2811
  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
2812

unknown's avatar
unknown committed
2813 2814 2815
  # 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
2816
  $ENV{'MYSQL'}=                    $cmdline_mysql;
2817
  $ENV{'MYSQL_CHECK'}=              $cmdline_mysqlcheck;
unknown's avatar
unknown committed
2818
  $ENV{'MYSQL_DUMP'}=               $cmdline_mysqldump;
unknown's avatar
unknown committed
2819
  $ENV{'MYSQL_SLAP'}=               $cmdline_mysqlslap unless $glob_win32;
unknown's avatar
unknown committed
2820
  $ENV{'MYSQL_IMPORT'}=             $cmdline_mysqlimport;
2821
  $ENV{'MYSQL_DUMP_SLAVE'}=         $cmdline_mysqldumpslave;
unknown's avatar
unknown committed
2822
  $ENV{'MYSQL_SHOW'}=               $cmdline_mysqlshow;
unknown's avatar
unknown committed
2823 2824 2825 2826
  $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;
2827
  $ENV{'MYSQL_MY_PRINT_DEFAULTS'}=  $exe_my_print_defaults;
unknown's avatar
unknown committed
2828

2829
  $ENV{'NDB_STATUS_OK'}=            $flag_ndb_status_ok;
unknown's avatar
unknown committed
2830 2831
  $ENV{'NDB_SLAVE_STATUS_OK'}=      $flag_ndb_slave_status_ok;
  $ENV{'NDB_EXTRA_TEST'}=           $opt_ndb_extra_test;
2832 2833 2834 2835 2836 2837
  $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
2838 2839
  my $exe= $exe_mysqltest;
  my $args;
unknown's avatar
unknown committed
2840 2841 2842

  mtr_init_args(\$args);

unknown's avatar
unknown committed
2843
  if ( defined $opt_valgrind_mysqltest )
unknown's avatar
unknown committed
2844 2845 2846 2847
  {
    valgrind_arguments($args, \$exe);
  }

unknown's avatar
unknown committed
2848 2849 2850 2851 2852
  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);
2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868

  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
2869

unknown's avatar
unknown committed
2870 2871 2872 2873 2874
  if ( $opt_ps_protocol )
  {
    mtr_add_arg($args, "--ps-protocol");
  }

2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889
  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
2890 2891 2892 2893
  if ( $opt_strace_client )
  {
    $exe=  "strace";            # FIXME there are ktrace, ....
    mtr_add_arg($args, "-o");
2894
    mtr_add_arg($args, "%s/log/mysqltest.strace", $opt_vardir);
unknown's avatar
unknown committed
2895 2896 2897
    mtr_add_arg($args, "$exe_mysqltest");
  }

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

  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 )
  {
2920
    mtr_add_arg($args, "--debug=d:t:A,%s/log/mysqltest.trace", $opt_vardir);
unknown's avatar
unknown committed
2921 2922
  }

2923
  if ( $opt_ssl_supported )
unknown's avatar
unknown committed
2924
  {
2925
    mtr_add_arg($args, "--ssl-ca=%s/std_data/cacert.pem",
2926
	        $glob_mysql_test_dir);
2927
    mtr_add_arg($args, "--ssl-cert=%s/std_data/client-cert.pem",
2928
	        $glob_mysql_test_dir);
2929
    mtr_add_arg($args, "--ssl-key=%s/std_data/client-key.pem",
2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942
	        $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
2943 2944
  }

unknown's avatar
unknown committed
2945 2946 2947 2948
  # ----------------------------------------------------------------------
  # If embedded server, we create server args to give mysqltest to pass on
  # ----------------------------------------------------------------------

unknown's avatar
unknown committed
2949 2950
  if ( $glob_use_embedded_server )
  {
2951
    mysqld_arguments($args,'master',0,$tinfo->{'master_opt'},[],0);
unknown's avatar
unknown committed
2952 2953
  }

2954 2955 2956 2957 2958
  # ----------------------------------------------------------------------
  # export MYSQL_TEST variable containing <path>/mysqltest <args>
  # ----------------------------------------------------------------------
  $ENV{'MYSQL_TEST'}= "$exe_mysqltest " . join(" ", @$args);

2959
  # ----------------------------------------------------------------------
2960
  # Add arguments that should not go into the MYSQL_TEST env var
2961 2962 2963 2964 2965 2966 2967 2968 2969 2970
  # ----------------------------------------------------------------------

  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
2971
  return mtr_run_test($exe,$args,$tinfo->{'path'},"",$path_timefile,"");
unknown's avatar
unknown committed
2972
}
unknown's avatar
unknown committed
2973

unknown's avatar
unknown committed
2974 2975 2976 2977 2978 2979 2980 2981 2982

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
2983 2984
  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
2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997

  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));
  }

2998

unknown's avatar
unknown committed
2999 3000 3001 3002 3003 3004
  mtr_add_arg($args, $$exe);

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


unknown's avatar
unknown committed
3005 3006 3007 3008 3009 3010
##############################################################################
#
#  Usage
#
##############################################################################

unknown's avatar
unknown committed
3011
sub usage ($) {
unknown's avatar
unknown committed
3012 3013 3014 3015 3016 3017 3018 3019 3020 3021
  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
3022 3023 3024 3025
  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
3026 3027 3028
  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
3029 3030 3031 3032 3033 3034 3035
  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
3036
  skip-ndb[cluster]     Skip the ndb test cases, don't start cluster
unknown's avatar
unknown committed
3037 3038 3039 3040
  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
3041
  skip-im               Don't start IM, and skip the IM test cases
unknown's avatar
unknown committed
3042 3043 3044 3045 3046 3047
  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
3048
  ndbcluster_port=PORT  Specify the port number used by cluster
unknown's avatar
unknown committed
3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060

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
3061
  ndbconnectstring=STR  Use running cluster, and connect using STR
3062
  user=USER             User for connect to server
unknown's avatar
unknown committed
3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077

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
3078 3079
  valgrind[=EXE]        Run the "mysqld" server using valgrind, optionally
                        specifying the executable path/name
unknown's avatar
unknown committed
3080 3081
  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
3082 3083 3084 3085 3086 3087 3088
  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
3089 3090
  start-and-exit        Only initiate and start the "mysqld" servers, use the startup
                        settings for the specified test case if any
3091
  start-dirty           Only start the "mysqld" servers without initiation
unknown's avatar
unknown committed
3092
  fast                  Don't try to cleanup from earlier runs
unknown's avatar
unknown committed
3093
  reorder               Reorder tests to get less server restarts
unknown's avatar
unknown committed
3094
  help                  Get this help text
unknown's avatar
unknown committed
3095
  unified-diff | udiff  When presenting differences, use unified diff
unknown's avatar
unknown committed
3096

3097 3098 3099
  testcase-timeout=MINUTES Max test case run time (default 5)
  suite-timeout=MINUTES    Max test suite run time (default 120)

3100 3101 3102
Deprecated options
  with-openssl          Deprecated option for ssl

3103

unknown's avatar
unknown committed
3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120
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
3121
  mtr_exit(1);
3122

unknown's avatar
unknown committed
3123
}