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

#
5 6 7
##############################################################################
#
#  mysql-test-run.pl
unknown's avatar
unknown committed
8
#
unknown's avatar
unknown committed
9
#  Tool used for executing a suite of .test files
unknown's avatar
unknown committed
10
#
11 12
#  See the "MySQL Test framework manual" for more information
#  http://dev.mysql.com/doc/mysqltest/en/index.html
unknown's avatar
unknown committed
13 14
#
#
15
##############################################################################
unknown's avatar
unknown committed
16

unknown's avatar
unknown committed
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
use strict;
use warnings;

BEGIN {
  # Check that mysql-test-run.pl is started from mysql-test/
  unless ( -f "mysql-test-run.pl" )
  {
    print "**** ERROR **** ",
      "You must start mysql-test-run from the mysql-test/ directory\n";
    exit(1);
  }
  # Check that lib exist
  unless ( -d "lib/" )
  {
    print "**** ERROR **** ",
      "Could not find the lib/ directory \n";
    exit(1);
  }
}
36

37 38 39 40 41 42 43 44 45 46 47
BEGIN {
  # Check backward compatibility support
  # By setting the environment variable MTR_VERSION
  # it's possible to use a previous version of
  # mysql-test-run.pl
  my $version= $ENV{MTR_VERSION} || 2;
  if ( $version == 1 )
  {
    print "=======================================================\n";
    print "  WARNING: Using mysql-test-run.pl version 1!  \n";
    print "=======================================================\n";
48 49
    # Should use exec() here on *nix but this appears not to work on Windows
    exit(system($^X, "lib/v1/mysql-test-run.pl", @ARGV) >> 8);
50 51 52 53 54 55 56 57 58 59 60 61
  }
  elsif ( $version == 2 )
  {
    # This is the current version, just continue
    ;
  }
  else
  {
    print "ERROR: Version $version of mysql-test-run does not exist!\n";
    exit(1);
  }
}
unknown's avatar
unknown committed
62

unknown's avatar
unknown committed
63
use lib "lib";
64

unknown's avatar
unknown committed
65 66
use Cwd;
use Getopt::Long;
unknown's avatar
unknown committed
67 68 69
use My::File::Path; # Patched version of File::Path
use File::Basename;
use File::Copy;
70
use File::Find;
unknown's avatar
unknown committed
71
use File::Temp qw / tempdir /;
72
use File::Spec::Functions qw / splitdir /;
unknown's avatar
unknown committed
73
use My::Platform;
unknown's avatar
unknown committed
74 75
use My::SafeProcess;
use My::ConfigFactory;
76
use My::Options;
unknown's avatar
unknown committed
77
use My::Find;
78
use My::SysInfo;
79
use My::CoreDump;
unknown's avatar
unknown committed
80
use mtr_cases;
81
use mtr_report;
82
use mtr_match;
83
use mtr_unique;
84 85
use IO::Socket::INET;
use IO::Select;
86

unknown's avatar
unknown committed
87 88 89 90 91
require "lib/mtr_process.pl";
require "lib/mtr_io.pl";
require "lib/mtr_gcov.pl";
require "lib/mtr_misc.pl";

unknown's avatar
unknown committed
92
$SIG{INT}= sub { mtr_error("Got ^C signal"); };
unknown's avatar
unknown committed
93

unknown's avatar
unknown committed
94
our $mysql_version_id;
unknown's avatar
unknown committed
95 96
our $glob_mysql_test_dir;
our $basedir;
unknown's avatar
unknown committed
97 98 99

our $path_charsetsdir;
our $path_client_bindir;
unknown's avatar
unknown committed
100
our $path_client_libdir;
unknown's avatar
unknown committed
101
our $path_language;
102 103 104

our $path_current_testlog;
our $path_testlog;
unknown's avatar
unknown committed
105

unknown's avatar
unknown committed
106 107 108 109
our $default_vardir;
our $opt_vardir;                # Path to use for var/ dir
my $path_vardir_trace;          # unix formatted opt_vardir for trace files
my $opt_tmpdir;                 # Path to use for tmp/ dir
110 111 112
my $opt_tmpdir_pid;

END {
113 114
  if ( defined $opt_tmpdir_pid and $opt_tmpdir_pid == $$ )
  {
115 116 117 118 119 120
    # Remove the tempdir this process has created
    mtr_verbose("Removing tmpdir '$opt_tmpdir");
    rmtree($opt_tmpdir);
  }
}

unknown's avatar
unknown committed
121
my $path_config_file;           # The generated config file, var/my.cnf
unknown's avatar
unknown committed
122

123 124 125 126 127 128
# Visual Studio produces executables in different sub-directories based on the
# configuration used to build them.  To make life easier, an environment
# variable or command-line option may be specified to control which set of
# executables will be used by the test suite.
our $opt_vs_config = $ENV{'MTR_VS_CONFIG'};

129
my $DEFAULT_SUITES= "main,binlog,federated,rpl,rpl_ndb,ndb,innodb";
130
my $opt_suites;
unknown's avatar
unknown committed
131

132
our $opt_verbose= 0;  # Verbose output, enable with --verbose
unknown's avatar
unknown committed
133 134 135
our $exe_mysql;
our $exe_mysqladmin;
our $exe_mysqltest;
136
our $exe_libtool;
unknown's avatar
unknown committed
137

138
our $opt_big_test= 0;
unknown's avatar
unknown committed
139

140
our @opt_combinations;
141

unknown's avatar
unknown committed
142
our @opt_extra_mysqld_opt;
unknown's avatar
unknown committed
143

Magnus Svensson's avatar
Magnus Svensson committed
144 145
my $opt_compress;
my $opt_ssl;
146
my $opt_skip_ssl;
Magnus Svensson's avatar
Magnus Svensson committed
147 148 149 150 151
my $opt_ssl_supported;
my $opt_ps_protocol;
my $opt_sp_protocol;
my $opt_cursor_protocol;
my $opt_view_protocol;
152

unknown's avatar
unknown committed
153
our $opt_debug;
unknown's avatar
unknown committed
154
our @opt_cases;                  # The test cases names in argv
155
our $opt_embedded_server;
156

unknown's avatar
unknown committed
157 158 159
# Options used when connecting to an already running server
my %opts_extern;
sub using_extern { return (keys %opts_extern > 0);};
160

unknown's avatar
unknown committed
161
our $opt_fast= 0;
unknown's avatar
unknown committed
162
our $opt_force;
163
our $opt_mem= $ENV{'MTR_MEM'};
unknown's avatar
unknown committed
164 165

our $opt_gcov;
166 167 168
our $opt_gcov_exe= "gcov";
our $opt_gcov_err= "mysql-test-gcov.msg";
our $opt_gcov_msg= "mysql-test-gcov.err";
unknown's avatar
unknown committed
169

unknown's avatar
unknown committed
170
our $glob_debugger= 0;
unknown's avatar
unknown committed
171 172
our $opt_gdb;
our $opt_client_gdb;
unknown's avatar
unknown committed
173 174
our $opt_ddd;
our $opt_client_ddd;
unknown's avatar
unknown committed
175
our $opt_manual_gdb;
unknown's avatar
unknown committed
176 177
our $opt_manual_ddd;
our $opt_manual_debug;
178 179
our $opt_debugger;
our $opt_client_debugger;
unknown's avatar
unknown committed
180

unknown's avatar
unknown committed
181 182
my $config; # The currently running config
my $current_config_name; # The currently running config file template
unknown's avatar
unknown committed
183

184
our $opt_experimental;
Daniel Fischer's avatar
Daniel Fischer committed
185
our $experimental_test_cases;
186

187
my $baseport;
188
my $opt_build_thread= $ENV{'MTR_BUILD_THREAD'} || "auto";
189
my $build_thread= 0;
190

unknown's avatar
unknown committed
191
my $opt_record;
192
my $opt_report_features;
unknown's avatar
unknown committed
193

194 195
my $opt_skip_core;

196
our $opt_check_testcases= 1;
unknown's avatar
unknown committed
197
my $opt_mark_progress;
unknown's avatar
unknown committed
198

unknown's avatar
unknown committed
199
my $opt_sleep;
unknown's avatar
unknown committed
200

201
my $opt_testcase_timeout=    15; # minutes
Sven Sandberg's avatar
Sven Sandberg committed
202
my $opt_suite_timeout   =   300; # minutes
203
my $opt_shutdown_timeout=    10; # seconds
Magnus Svensson's avatar
Magnus Svensson committed
204
my $opt_start_timeout   =   180; # seconds
unknown's avatar
unknown committed
205

206 207 208 209
sub testcase_timeout { return $opt_testcase_timeout * 60; };
sub suite_timeout { return $opt_suite_timeout * 60; };
sub check_timeout { return $opt_testcase_timeout * 6; };

unknown's avatar
unknown committed
210 211
my $opt_start;
my $opt_start_dirty;
212
my $start_only;
213
my $opt_wait_all;
unknown's avatar
unknown committed
214
my $opt_repeat= 1;
unknown's avatar
unknown committed
215
my $opt_retry= 3;
unknown's avatar
unknown committed
216
my $opt_retry_failure= 2;
unknown's avatar
unknown committed
217

unknown's avatar
unknown committed
218
my $opt_strace_client;
unknown's avatar
unknown committed
219

220
our $opt_user = "root";
unknown's avatar
unknown committed
221

unknown's avatar
unknown committed
222 223 224 225 226 227 228 229 230
my $opt_valgrind= 0;
my $opt_valgrind_mysqld= 0;
my $opt_valgrind_mysqltest= 0;
my @default_valgrind_args= ("--show-reachable=yes");
my @valgrind_args;
my $opt_valgrind_path;
my $opt_callgrind;

our $opt_warnings= 1;
unknown's avatar
unknown committed
231

232
our $opt_skip_ndbcluster= 0;
unknown's avatar
unknown committed
233

unknown's avatar
unknown committed
234 235 236
my $exe_ndbd;
my $exe_ndb_mgmd;
my $exe_ndb_waiter;
unknown's avatar
unknown committed
237

unknown's avatar
unknown committed
238
our $debug_compiled_binaries;
239

240 241
our %mysqld_variables;

242 243
my $source_dist= 0;

244 245
my $opt_max_save_core= $ENV{MTR_MAX_SAVE_CORE} || 5;
my $opt_max_save_datadir= $ENV{MTR_MAX_SAVE_DATADIR} || 20;
246
my $opt_max_test_fail= $ENV{MTR_MAX_TEST_FAIL} || 10;
247

248
my $opt_parallel= $ENV{MTR_PARALLEL} || 1;
249

unknown's avatar
unknown committed
250 251
select(STDOUT);
$| = 1; # Automatically flush STDOUT
unknown's avatar
unknown committed
252 253 254

main();

255

unknown's avatar
unknown committed
256
sub main {
Magnus Svensson's avatar
Magnus Svensson committed
257
  # Default, verbosity on
258
  report_option('verbose', 0);
unknown's avatar
unknown committed
259

260 261 262 263
  # This is needed for test log evaluation in "gen-build-status-page"
  # in all cases where the calling tool does not log the commands
  # directly before it executes them, like "make test-force-pl" in RPM builds.
  mtr_report("Logging: $0 ", join(" ", @ARGV));
264

Magnus Svensson's avatar
Magnus Svensson committed
265
  command_line_setup();
unknown's avatar
unknown committed
266

267
  if ( $opt_gcov ) {
Magnus Svensson's avatar
Magnus Svensson committed
268
    gcov_prepare($basedir);
unknown's avatar
unknown committed
269 270
  }

271
  if (!$opt_suites) {
272 273 274 275 276 277 278 279 280 281 282 283 284
    $opt_suites= $DEFAULT_SUITES;

    # Check for any extra suites to enable based on the path name
    my %extra_suites=
      (
       "mysql-5.1-new-ndb"              => "ndb_team",
       "mysql-5.1-new-ndb-merge"        => "ndb_team",
       "mysql-5.1-telco-6.2"            => "ndb_team",
       "mysql-5.1-telco-6.2-merge"      => "ndb_team",
       "mysql-5.1-telco-6.3"            => "ndb_team",
       "mysql-6.0-ndb"                  => "ndb_team",
      );

285
    foreach my $dir ( reverse splitdir($basedir) ) {
286
      my $extra_suite= $extra_suites{$dir};
287
      if (defined $extra_suite) {
288 289 290 291 292 293 294
	mtr_report("Found extra suite: $extra_suite");
	$opt_suites= "$extra_suite,$opt_suites";
	last;
      }
    }
  }

unknown's avatar
unknown committed
295
  mtr_report("Collecting tests...");
296
  my $tests= collect_test_cases($opt_suites, \@opt_cases);
unknown's avatar
unknown committed
297

unknown's avatar
unknown committed
298 299
  if ( $opt_report_features ) {
    # Put "report features" as the first test to run
300 301 302
    my $tinfo = My::Test->new
      (
       name           => 'report_features',
303
       # No result_file => Prints result
Magnus Svensson's avatar
Magnus Svensson committed
304
       path           => 'include/report-features.test',
305
       template_path  => "include/default_my.cnf",
306 307 308
       master_opt     => [],
       slave_opt      => [],
      );
unknown's avatar
unknown committed
309
    unshift(@$tests, $tinfo);
unknown's avatar
unknown committed
310
  }
311

Magnus Svensson's avatar
Magnus Svensson committed
312
  print "vardir: $opt_vardir\n";
313 314
  initialize_servers();

Magnus Svensson's avatar
Magnus Svensson committed
315 316
  #######################################################################
  my $num_tests= @$tests;
317
  if ( $opt_parallel eq "auto" ) {
Magnus Svensson's avatar
Magnus Svensson committed
318 319 320 321 322 323 324
    # Try to find a suitable value for number of workers
    my $sys_info= My::SysInfo->new();

    $opt_parallel= $sys_info->num_cpus();
    for my $limit (2000, 1500, 1000, 500){
      $opt_parallel-- if ($sys_info->min_bogomips() < $limit);
    }
325 326
    my $max_par= $ENV{MTR_MAX_PARALLEL} || 8;
    $opt_parallel= $max_par if ($opt_parallel > $max_par);
Magnus Svensson's avatar
Magnus Svensson committed
327
    $opt_parallel= $num_tests if ($opt_parallel > $num_tests);
328
    $opt_parallel= 1 if (IS_WINDOWS and $sys_info->isvm());
Magnus Svensson's avatar
Magnus Svensson committed
329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365
    $opt_parallel= 1 if ($opt_parallel < 1);
    mtr_report("Using parallel: $opt_parallel");
  }

  # Create server socket on any free port
  my $server = new IO::Socket::INET
    (
     LocalAddr => 'localhost',
     Proto => 'tcp',
     Listen => $opt_parallel,
    );
  mtr_error("Could not create testcase server port: $!") unless $server;
  my $server_port = $server->sockport();
  mtr_report("Using server port $server_port");

  # Create child processes
  my %children;
  for my $child_num (1..$opt_parallel){
    my $child_pid= My::SafeProcess::Base::_safe_fork();
    if ($child_pid == 0){
      $server= undef; # Close the server port in child
      $tests= {}; # Don't need the tests list in child

      # Use subdir of var and tmp unless only one worker
      if ($opt_parallel > 1) {
	set_vardir("$opt_vardir/$child_num");
	$opt_tmpdir= "$opt_tmpdir/$child_num";
      }

      run_worker($server_port, $child_num);
      exit(1);
    }

    $children{$child_pid}= 1;
  }
  #######################################################################

366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386
  mtr_report();
  mtr_print_thick_line();
  mtr_print_header();

  my $completed= run_test_server($server, $tests, $opt_parallel);

  # Send Ctrl-C to any children still running
  kill("INT", keys(%children));

  # Wait for childs to exit
  foreach my $pid (keys %children)
  {
    my $ret_pid= waitpid($pid, 0);
    if ($ret_pid != $pid){
      mtr_report("Unknown process $ret_pid exited");
    }
    else {
      delete $children{$ret_pid};
    }
  }

unknown's avatar
unknown committed
387 388 389 390
  if ( not defined @$completed ) {
    mtr_error("Test suite aborted");
  }

391
  if ( @$completed != $num_tests){
392

393 394
    if ($opt_force){
      # All test should have been run, print any that are still in $tests
395 396 397
      #foreach my $test ( @$tests ){
      #  $test->print_test();
      #}
398
    }
399

400
    # Not all tests completed, failure
401
    mtr_report();
402 403
    mtr_report("Only ", int(@$completed), " of $num_tests completed.");
    mtr_error("Not all tests completed");
404 405
  }

406 407
  mtr_print_line();

Magnus Svensson's avatar
Magnus Svensson committed
408
  if ( $opt_gcov ) {
409
    gcov_collect($basedir, $opt_gcov_exe,
Magnus Svensson's avatar
Magnus Svensson committed
410 411 412
		 $opt_gcov_msg, $opt_gcov_err);
  }

413 414 415 416 417 418
  mtr_report_stats($completed);

  exit(0);
}


Magnus Svensson's avatar
Magnus Svensson committed
419
sub run_test_server ($$$) {
420 421
  my ($server, $tests, $childs) = @_;

422 423
  my $num_saved_cores= 0;  # Number of core files saved in vardir/log/ so far.
  my $num_saved_datadir= 0;  # Number of datadirs saved in vardir/log/ so far.
424
  my $num_failed_test= 0; # Number of tests failed so far
425

426
  # Scheduler variables
Magnus Svensson's avatar
Magnus Svensson committed
427
  my $max_ndb= $childs / 2;
428 429 430 431 432 433 434
  $max_ndb = 4 if $max_ndb > 4;
  $max_ndb = 1 if $max_ndb < 1;
  my $num_ndb_tests= 0;

  my $completed= [];
  my %running;
  my $result;
435
  my $exe_mysqld= find_mysqld($basedir) || ""; # Used as hint to CoreDump
436

437
  my $suite_timeout_proc= My::SafeProcess->timer(suite_timeout());
unknown's avatar
unknown committed
438

439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457
  my $s= IO::Select->new();
  $s->add($server);
  while (1) {
    my @ready = $s->can_read(1); # Wake up once every second
    foreach my $sock (@ready) {
      if ($sock == $server) {
	# New client connected
	my $child= $sock->accept();
	mtr_verbose("Client connected");
	$s->add($child);
	print $child "HELLO\n";
      }
      else {
	my $line= <$sock>;
	if (!defined $line) {
	  # Client disconnected
	  mtr_verbose("Child closed socket");
	  $s->remove($sock);
	  if (--$childs == 0){
unknown's avatar
unknown committed
458
	    $suite_timeout_proc->kill();
459 460 461 462 463 464 465 466 467 468 469 470 471
	    return $completed;
	  }
	  next;
	}
	chomp($line);

	if ($line eq 'TESTRESULT'){
	  $result= My::Test::read_test($sock);
	  # $result->print_test();

	  # Report test status
	  mtr_report_test($result);

472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487
	  if ( $result->is_failed() ) {

	    # Save the workers "savedir" in var/log
	    my $worker_savedir= $result->{savedir};
	    my $worker_savename= basename($worker_savedir);
	    my $savedir= "$opt_vardir/log/$worker_savename";

	    if ($opt_max_save_datadir > 0 &&
		$num_saved_datadir >= $opt_max_save_datadir)
	    {
	      mtr_report(" - skipping '$worker_savedir/'");
	      rmtree($worker_savedir);
	    }
	    else {
	      mtr_report(" - saving '$worker_savedir/' to '$savedir/'");
	      rename($worker_savedir, $savedir);
488
	      # Move any core files from e.g. mysqltest
Magnus Svensson's avatar
Magnus Svensson committed
489
	      foreach my $coref (glob("core*"), glob("*.dmp"))
490
	      {
Magnus Svensson's avatar
Magnus Svensson committed
491
		mtr_report(" - found '$coref', moving it to '$savedir'");
492 493
                move($coref, $savedir);
              }
494 495 496 497 498 499
	      if ($opt_max_save_core > 0) {
		# Limit number of core files saved
		find({ no_chdir => 1,
		       wanted => sub {
			 my $core_file= $File::Find::name;
			 my $core_name= basename($core_file);
500

Magnus Svensson's avatar
Magnus Svensson committed
501 502 503
			 if ($core_name =~ /^core/ or  # Starting with core
			     (IS_WINDOWS and $core_name =~ /\.dmp$/)){
                                                       # Ending with .dmp
504
			   mtr_report(" - found '$core_name'",
505
				      "($num_saved_cores/$opt_max_save_core)");
506

507
			   My::CoreDump->show($core_file, $exe_mysqld);
508 509 510 511

			   if ($num_saved_cores >= $opt_max_save_core) {
			     mtr_report(" - deleting it, already saved",
					"$opt_max_save_core");
512 513 514
			     unlink("$core_file");
			   }
			   ++$num_saved_cores;
515 516
			 }
		       }
517 518 519
		     },
		     $savedir);
	      }
520
	    }
521
	    $num_saved_datadir++;
522
	    $num_failed_test++ unless $result->{retries};
523 524 525

	    if ( !$opt_force ) {
	      # Test has failed, force is off
unknown's avatar
unknown committed
526
	      $suite_timeout_proc->kill();
527 528 529
	      push(@$completed, $result);
	      return $completed;
	    }
530
	    elsif ($opt_max_test_fail > 0 and
531 532
		   $num_failed_test >= $opt_max_test_fail) {
	      $suite_timeout_proc->kill();
533 534
	      push(@$completed, $result);
	      mtr_report_stats($completed, 1);
535 536 537 538
	      mtr_report("Too many tests($num_failed_test) failed!",
			 "Terminating...");
	      return undef;
	    }
539 540 541
	  }

	  # Retry test run after test failure
unknown's avatar
unknown committed
542
	  my $retries= $result->{retries} || 2;
543
	  my $test_has_failed= $result->{failures} || 0;
unknown's avatar
unknown committed
544
	  if ($test_has_failed and $retries <= $opt_retry){
545 546 547 548
	    # Test should be run one more time unless it has failed
	    # too many times already
	    my $failures= $result->{failures};
	    if ($opt_retry > 1 and $failures >= $opt_retry_failure){
unknown's avatar
unknown committed
549
	      mtr_report("\nTest has failed $failures times,",
550 551 552 553
			 "no more retries!\n");
	    }
	    else {
	      mtr_report("\nRetrying test, attempt($retries/$opt_retry)...\n");
554
	      delete($result->{result});
555 556 557 558 559 560 561 562
	      $result->{retries}= $retries+1;
	      $result->write_test($sock, 'TESTCASE');
	      next;
	    }
	  }

	  # Repeat test $opt_repeat number of times
	  my $repeat= $result->{repeat} || 1;
563 564
	  # Don't repeat if test was skipped
	  if ($repeat < $opt_repeat && $result->{'result'} ne 'MTR_RES_SKIPPED')
565 566
	  {
	    $result->{retries}= 0;
567
	    $result->{rep_failures}++ if $result->{failures};
568
	    $result->{failures}= 0;
569
	    delete($result->{result});
570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598
	    $result->{repeat}= $repeat+1;
	    $result->write_test($sock, 'TESTCASE');
	    next;
	  }

	  # Remove from list of running
	  mtr_error("'", $result->{name},"' is not known to be running")
	    unless delete $running{$result->key()};

	  # Update scheduler variables
	  $num_ndb_tests-- if ($result->{ndb_test});

	  # Save result in completed list
	  push(@$completed, $result);

	}
	elsif ($line eq 'START'){
	  ; # Send first test
	}
	else {
	  mtr_error("Unknown response: '$line' from client");
	}

	# Find next test to schedule
	# - Try to use same configuration as worker used last time
	# - Limit number of parallel ndb tests

	my $next;
	my $second_best;
599
	for(my $i= 0; $i <= @$tests; $i++)
600 601 602
	{
	  my $t= $tests->[$i];

603 604
	  last unless defined $t;

605 606 607 608
	  if (run_testcase_check_skip_test($t)){
	    # Move the test to completed list
	    #mtr_report("skip - Moving test $i to completed");
	    push(@$completed, splice(@$tests, $i, 1));
609 610 611 612

	    # Since the test at pos $i was taken away, next
	    # test will also be at $i -> redo
	    redo;
613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641
	  }

	  # Limit number of parallell NDB tests
	  if ($t->{ndb_test} and $num_ndb_tests >= $max_ndb){
	    #mtr_report("Skipping, num ndb is already at max, $num_ndb_tests");
	    next;
	  }

	  # Prefer same configuration
	  if (defined $result and
	      $result->{template_path} eq $t->{template_path})
	  {
	    #mtr_report("Test uses same config => good match");
	    # Test uses same config => good match
	    $next= splice(@$tests, $i, 1);
	    last;
	  }

	  # Second best choice is the first that does not fulfill
	  # any of the above conditions
	  if (!defined $second_best){
	    #mtr_report("Setting second_best to $i");
	    $second_best= $i;
	  }
	}

	# Use second best choice if no other test has been found
	if (!$next and defined $second_best){
	  #mtr_report("Take second best choice $second_best");
642
	  mtr_error("Internal error, second best too large($second_best)")
643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659
	    if $second_best >  $#$tests;
	  $next= splice(@$tests, $second_best, 1);
	}

	if ($next) {
	  #$next->print_test();
	  $next->write_test($sock, 'TESTCASE');
	  $running{$next->key()}= $next;
	  $num_ndb_tests++ if ($next->{ndb_test});
	}
	else {
	  # No more test, tell child to exit
	  #mtr_report("Saying BYE to child");
	  print $sock "BYE\n";
	}
      }
    }
unknown's avatar
unknown committed
660 661 662 663 664 665

    # ----------------------------------------------------
    # Check if test suite timer expired
    # ----------------------------------------------------
    if ( ! $suite_timeout_proc->wait_one(0) )
    {
666
      mtr_report_stats($completed, 1);
unknown's avatar
unknown committed
667 668 669
      mtr_report("Test suite timeout! Terminating...");
      return undef;
    }
670 671 672 673 674 675 676 677 678
  }
}


sub run_worker ($) {
  my ($server_port, $thread_num)= @_;

  $SIG{INT}= sub { exit(1); };

679 680 681 682 683 684 685 686 687 688
  # Connect to server
  my $server = new IO::Socket::INET
    (
     PeerAddr => 'localhost',
     PeerPort => $server_port,
     Proto    => 'tcp'
    );
  mtr_error("Could not connect to server at port $server_port: $!")
    unless $server;

Magnus Svensson's avatar
Magnus Svensson committed
689 690 691
  # --------------------------------------------------------------------------
  # Set worker name
  # --------------------------------------------------------------------------
692 693
  report_option('name',"worker[$thread_num]");

Magnus Svensson's avatar
Magnus Svensson committed
694
  # --------------------------------------------------------------------------
695
  # Set different ports per thread
Magnus Svensson's avatar
Magnus Svensson committed
696
  # --------------------------------------------------------------------------
697
  set_build_thread_ports($thread_num);
Magnus Svensson's avatar
Magnus Svensson committed
698 699 700 701 702 703 704 705

  # --------------------------------------------------------------------------
  # Turn off verbosity in workers, unless explicitly specified
  # --------------------------------------------------------------------------
  report_option('verbose', undef) if ($opt_verbose == 0);

  environment_setup();

706 707 708 709 710
  # Read hello from server which it will send when shared
  # resources have been setup
  my $hello= <$server>;

  setup_vardir();
711
  check_running_as_root();
712

unknown's avatar
unknown committed
713 714 715
  if ( using_extern() ) {
    create_config_file_for_extern(%opts_extern);
  }
unknown's avatar
unknown committed
716

717 718
  # Ask server for first test
  print $server "START\n";
unknown's avatar
unknown committed
719

720 721 722 723 724
  while(my $line= <$server>){
    chomp($line);
    if ($line eq 'TESTCASE'){
      my $test= My::Test::read_test($server);
      #$test->print_test();
Magnus Svensson's avatar
Magnus Svensson committed
725 726 727 728 729 730

      # Clear comment and logfile, to avoid
      # reusing them from previous test
      delete($test->{'comment'});
      delete($test->{'logfile'});

731 732
      $test->{worker} = $thread_num if $opt_parallel > 1;

733 734 735 736 737 738 739 740
      run_testcase($test);
      #$test->{result}= 'MTR_RES_PASSED';
      # Send it back, now with results set
      #$test->print_test();
      $test->write_test($server, 'TESTRESULT');
    }
    elsif ($line eq 'BYE'){
      mtr_report("Server said BYE");
741
      stop_all_servers($opt_shutdown_timeout);
742 743 744 745 746 747 748 749 750 751
      exit(0);
    }
    else {
      mtr_error("Could not understand server, '$line'");
    }
  }

  stop_all_servers();

  exit(1);
unknown's avatar
unknown committed
752
}
unknown's avatar
unknown committed
753 754


unknown's avatar
unknown committed
755 756
sub ignore_option {
  my ($opt, $value)= @_;
757
  mtr_report("Ignoring option '$opt'");
unknown's avatar
unknown committed
758 759
}

760

Magnus Svensson's avatar
Magnus Svensson committed
761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779

# Setup any paths that are $opt_vardir related
sub set_vardir {
  my ($vardir)= @_;

  $opt_vardir= $vardir;

  $path_vardir_trace= $opt_vardir;
  # Chop off any "c:", DBUG likes a unix path ex: c:/src/... => /src/...
  $path_vardir_trace=~ s/^\w://;

  # Location of my.cnf that all clients use
  $path_config_file= "$opt_vardir/my.cnf";

  $path_testlog=         "$opt_vardir/log/mysqltest.log";
  $path_current_testlog= "$opt_vardir/log/current_test";

}

780

Magnus Svensson's avatar
Magnus Svensson committed
781
sub command_line_setup {
unknown's avatar
unknown committed
782
  my $opt_comment;
unknown's avatar
unknown committed
783
  my $opt_usage;
unknown's avatar
unknown committed
784

unknown's avatar
unknown committed
785
  # Read the command line options
unknown's avatar
unknown committed
786
  # Note: Keep list, and the order, in sync with usage at end of this file
unknown's avatar
unknown committed
787
  Getopt::Long::Configure("pass_through");
unknown's avatar
unknown committed
788
  GetOptions(
unknown's avatar
unknown committed
789
             # Control what engine/variation to run
unknown's avatar
unknown committed
790
             'embedded-server'          => \$opt_embedded_server,
unknown's avatar
unknown committed
791
             'ps-protocol'              => \$opt_ps_protocol,
792 793 794
             'sp-protocol'              => \$opt_sp_protocol,
             'view-protocol'            => \$opt_view_protocol,
             'cursor-protocol'          => \$opt_cursor_protocol,
unknown's avatar
unknown committed
795
             'ssl|with-openssl'         => \$opt_ssl,
796 797
             'skip-ssl'                 => \$opt_skip_ssl,
             'compress'                 => \$opt_compress,
unknown's avatar
unknown committed
798 799
             'vs-config'                => \$opt_vs_config,

800
	     # Max number of parallel threads to use
801
	     'parallel=s'               => \$opt_parallel,
802

unknown's avatar
unknown committed
803 804 805 806
             # Config file to use as template for all tests
	     'defaults-file=s'          => \&collect_option,
	     # Extra config file to append to all generated configs
	     'defaults-extra-file=s'    => \&collect_option,
unknown's avatar
unknown committed
807 808

             # Control what test suites or cases to run
unknown's avatar
unknown committed
809
             'force'                    => \$opt_force,
unknown's avatar
unknown committed
810
             'with-ndbcluster-only'     => \&collect_option,
unknown's avatar
unknown committed
811
             'skip-ndbcluster|skip-ndb' => \$opt_skip_ndbcluster,
812
             'suite|suites=s'           => \$opt_suites,
unknown's avatar
unknown committed
813 814 815 816
             'skip-rpl'                 => \&collect_option,
             'skip-test=s'              => \&collect_option,
             'do-test=s'                => \&collect_option,
             'start-from=s'             => \&collect_option,
817
             'big-test'                 => \$opt_big_test,
unknown's avatar
unknown committed
818
	     'combination=s'            => \@opt_combinations,
unknown's avatar
unknown committed
819
             'skip-combinations'        => \&collect_option,
820
             'experimental=s'           => \$opt_experimental,
unknown's avatar
unknown committed
821 822
	     'skip-im'                  => \&ignore_option,

unknown's avatar
unknown committed
823
             # Specify ports
824
	     'build-thread|mtr-build-thread=i' => \$opt_build_thread,
unknown's avatar
unknown committed
825 826 827

             # Test case authoring
             'record'                   => \$opt_record,
828
             'check-testcases!'         => \$opt_check_testcases,
829
             'mark-progress'            => \$opt_mark_progress,
unknown's avatar
unknown committed
830

831
             # Extra options used when starting mysqld
unknown's avatar
unknown committed
832
             'mysqld=s'                 => \@opt_extra_mysqld_opt,
unknown's avatar
unknown committed
833 834

             # Run test on running server
unknown's avatar
unknown committed
835
             'extern=s'                  => \%opts_extern, # Append to hash
unknown's avatar
unknown committed
836 837

             # Debugging
unknown's avatar
unknown committed
838
             'debug'                    => \$opt_debug,
unknown's avatar
unknown committed
839
             'gdb'                      => \$opt_gdb,
unknown's avatar
unknown committed
840
             'client-gdb'               => \$opt_client_gdb,
unknown's avatar
unknown committed
841 842
             'manual-gdb'               => \$opt_manual_gdb,
             'manual-debug'             => \$opt_manual_debug,
unknown's avatar
unknown committed
843
             'ddd'                      => \$opt_ddd,
unknown's avatar
unknown committed
844
             'client-ddd'               => \$opt_client_ddd,
unknown's avatar
unknown committed
845
             'manual-ddd'               => \$opt_manual_ddd,
846 847
	     'debugger=s'               => \$opt_debugger,
	     'client-debugger=s'        => \$opt_client_debugger,
unknown's avatar
unknown committed
848
             'strace-client:s'          => \$opt_strace_client,
849
             'max-save-core=i'          => \$opt_max_save_core,
850
             'max-save-datadir=i'       => \$opt_max_save_datadir,
851
             'max-test-fail=i'          => \$opt_max_test_fail,
unknown's avatar
unknown committed
852 853 854

             # Coverage, profiling etc
             'gcov'                     => \$opt_gcov,
855
             'valgrind|valgrind-all'    => \$opt_valgrind,
unknown's avatar
unknown committed
856 857
             'valgrind-mysqltest'       => \$opt_valgrind_mysqltest,
             'valgrind-mysqld'          => \$opt_valgrind_mysqld,
unknown's avatar
unknown committed
858 859 860 861 862 863 864 865 866 867 868 869
             'valgrind-options=s'       => sub {
	       my ($opt, $value)= @_;
	       # Deprecated option unless it's what we know pushbuild uses
	       if ($value eq "--gen-suppressions=all --show-reachable=yes") {
		 push(@valgrind_args, $_) for (split(' ', $value));
		 return;
	       }
	       die("--valgrind-options=s is deprecated. Use ",
		   "--valgrind-option=s, to be specified several",
		   " times if necessary");
	     },
             'valgrind-option=s'        => \@valgrind_args,
unknown's avatar
unknown committed
870
             'valgrind-path=s'          => \$opt_valgrind_path,
871
	     'callgrind'                => \$opt_callgrind,
unknown's avatar
unknown committed
872

873 874 875
	     # Directories
             'tmpdir=s'                 => \$opt_tmpdir,
             'vardir=s'                 => \$opt_vardir,
876
             'mem'                      => \$opt_mem,
unknown's avatar
unknown committed
877 878
             'client-bindir=s'          => \$path_client_bindir,
             'client-libdir=s'          => \$path_client_libdir,
879

unknown's avatar
unknown committed
880
             # Misc
881
             'report-features'          => \$opt_report_features,
unknown's avatar
unknown committed
882
             'comment=s'                => \$opt_comment,
unknown's avatar
unknown committed
883
             'fast'                     => \$opt_fast,
884
             'reorder!'                 => \&collect_option,
unknown's avatar
unknown committed
885 886
             'enable-disabled'          => \&collect_option,
             'verbose+'                 => \$opt_verbose,
887
             'verbose-restart'          => \&report_option,
unknown's avatar
unknown committed
888
             'sleep=i'                  => \$opt_sleep,
889
             'start-dirty'              => \$opt_start_dirty,
unknown's avatar
unknown committed
890
             'start'                    => \$opt_start,
891
             'wait-all'                 => \$opt_wait_all,
unknown's avatar
unknown committed
892
	     'print-testcases'          => \&collect_option,
unknown's avatar
unknown committed
893 894 895
	     'repeat=i'                 => \$opt_repeat,
	     'retry=i'                  => \$opt_retry,
	     'retry-failure=i'          => \$opt_retry_failure,
unknown's avatar
unknown committed
896
             'timer!'                   => \&report_option,
unknown's avatar
unknown committed
897
             'user=s'                   => \$opt_user,
898 899
             'testcase-timeout=i'       => \$opt_testcase_timeout,
             'suite-timeout=i'          => \$opt_suite_timeout,
unknown's avatar
unknown committed
900 901
             'shutdown-timeout=i'       => \$opt_shutdown_timeout,
             'warnings!'                => \$opt_warnings,
902
	     'timestamp'                => \&report_option,
unknown's avatar
unknown committed
903
	     'timediff'                 => \&report_option,
unknown's avatar
unknown committed
904 905

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

Magnus Svensson's avatar
Magnus Svensson committed
908
  usage("") if $opt_usage;
unknown's avatar
unknown committed
909

unknown's avatar
unknown committed
910
  # --------------------------------------------------------------------------
911
  # Setup verbosity
unknown's avatar
unknown committed
912
  # --------------------------------------------------------------------------
913 914
  if ($opt_verbose != 0){
    report_option('verbose', $opt_verbose);
915 916
  }

917 918
  if ( -d "../sql" )
  {
919
    $source_dist=  1;
920 921
  }

922
  # Find the absolute path to the test directory
unknown's avatar
unknown committed
923 924
  $glob_mysql_test_dir= cwd();
  if (IS_CYGWIN)
unknown's avatar
unknown committed
925
  {
unknown's avatar
unknown committed
926 927
    # Use mixed path format i.e c:/path/to/
    $glob_mysql_test_dir= mixed_path($glob_mysql_test_dir);
unknown's avatar
unknown committed
928
  }
929 930 931 932

  # In most cases, the base directory we find everything relative to,
  # is the parent directory of the "mysql-test" directory. For source
  # distributions, TAR binary distributions and some other packages.
unknown's avatar
unknown committed
933
  $basedir= dirname($glob_mysql_test_dir);
934 935 936 937 938 939

  # In the RPM case, binaries and libraries are installed in the
  # default system locations, instead of having our own private base
  # directory. And we install "/usr/share/mysql-test". Moving up one
  # more directory relative to "mysql-test" gives us a usable base
  # directory for RPM installs.
unknown's avatar
unknown committed
940
  if ( ! $source_dist and ! -d "$basedir/bin" )
941
  {
unknown's avatar
unknown committed
942
    $basedir= dirname($basedir);
943 944
  }

945
  # Look for the client binaries directory
unknown's avatar
unknown committed
946 947 948 949 950 951 952 953 954 955 956 957 958
  if ($path_client_bindir)
  {
    # --client-bindir=path set on command line, check that the path exists
    $path_client_bindir= mtr_path_exists($path_client_bindir);
  }
  else
  {
    $path_client_bindir= mtr_path_exists("$basedir/client_release",
					 "$basedir/client_debug",
					 vs_config_dirs('client', ''),
					 "$basedir/client",
					 "$basedir/bin");
  }
959

unknown's avatar
unknown committed
960
  # Look for language files and charsetsdir, use same share
961 962 963
  $path_language=   mtr_path_exists("$basedir/share/mysql/english",
                                    "$basedir/sql/share/english",
                                    "$basedir/share/english");
unknown's avatar
unknown committed
964

965 966

  my $path_share= dirname($path_language);
unknown's avatar
unknown committed
967 968
  $path_charsetsdir=   mtr_path_exists("$path_share/charsets");

969 970 971 972 973 974 975 976 977 978
  if (using_extern())
  {
    # Connect to the running mysqld and find out what it supports
    collect_mysqld_features_from_running_server();
  }
  else
  {
    # Run the mysqld to find out what features are available
    collect_mysqld_features();
  }
unknown's avatar
unknown committed
979

unknown's avatar
unknown committed
980
  if ( $opt_comment )
unknown's avatar
unknown committed
981
  {
unknown's avatar
unknown committed
982 983 984 985
    mtr_report();
    mtr_print_thick_line('#');
    mtr_report("# $opt_comment");
    mtr_print_thick_line('#');
unknown's avatar
unknown committed
986
  }
unknown's avatar
unknown committed
987

988 989
  if ( $opt_experimental )
  {
990 991 992
    # $^O on Windows considered not generic enough
    my $plat= (IS_WINDOWS) ? 'windows' : $^O;

Daniel Fischer's avatar
Daniel Fischer committed
993 994 995 996 997 998 999 1000 1001 1002
    # read the list of experimental test cases from the file specified on
    # the command line
    open(FILE, "<", $opt_experimental) or mtr_error("Can't read experimental file: $opt_experimental");
    mtr_report("Using experimental file: $opt_experimental");
    $experimental_test_cases = [];
    while(<FILE>) {
      chomp;
      # remove comments (# foo) at the beginning of the line, or after a 
      # blank at the end of the line
      s/( +|^)#.*$//;
1003 1004 1005 1006 1007 1008 1009 1010 1011
      # If @ platform specifier given, use this entry only if it contains
      # @<platform> or @!<xxx> where xxx != platform
      if (/\@.*/)
      {
	next if (/\@!$plat/);
	next unless (/\@$plat/ or /\@!/);
	# Then remove @ and everything after it
	s/\@.*$//;
      }
Daniel Fischer's avatar
Daniel Fischer committed
1012 1013 1014 1015 1016 1017
      # remove whitespace
      s/^ +//;              
      s/ +$//;
      # if nothing left, don't need to remember this line
      if ( $_ eq "" ) {
        next;
1018
      }
Daniel Fischer's avatar
Daniel Fischer committed
1019 1020 1021 1022
      # remember what is left as the name of another test case that should be
      # treated as experimental
      print " - $_\n";
      push @$experimental_test_cases, $_;
1023
    }
Daniel Fischer's avatar
Daniel Fischer committed
1024
    close FILE;
1025 1026
  }

unknown's avatar
unknown committed
1027 1028 1029 1030 1031 1032
  foreach my $arg ( @ARGV )
  {
    if ( $arg =~ /^--skip-/ )
    {
      push(@opt_extra_mysqld_opt, $arg);
    }
1033 1034 1035 1036 1037 1038
    elsif ( $arg =~ /^--$/ )
    {
      # It is an effect of setting 'pass_through' in option processing
      # that the lone '--' separating options from arguments survives,
      # simply ignore it.
    }
unknown's avatar
unknown committed
1039 1040
    elsif ( $arg =~ /^-/ )
    {
Magnus Svensson's avatar
Magnus Svensson committed
1041
      usage("Invalid option \"$arg\"");
unknown's avatar
unknown committed
1042 1043 1044 1045 1046 1047
    }
    else
    {
      push(@opt_cases, $arg);
    }
  }
unknown's avatar
unknown committed
1048

1049 1050 1051
  # --------------------------------------------------------------------------
  # Find out type of logging that are being used
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1052
  foreach my $arg ( @opt_extra_mysqld_opt )
1053
  {
unknown's avatar
unknown committed
1054
    if ( $arg =~ /binlog[-_]format=(\S+)/ )
1055
    {
unknown's avatar
unknown committed
1056 1057 1058
      # Save this for collect phase
      collect_option('binlog-format', $1);
      mtr_report("Using binlog format '$1'");
1059
    }
1060 1061
  }

1062 1063 1064 1065 1066 1067 1068 1069

  # --------------------------------------------------------------------------
  # Find out default storage engine being used(if any)
  # --------------------------------------------------------------------------
  foreach my $arg ( @opt_extra_mysqld_opt )
  {
    if ( $arg =~ /default-storage-engine=(\S+)/ )
    {
unknown's avatar
unknown committed
1070 1071 1072
      # Save this for collect phase
      collect_option('default-storage-engine', $1);
      mtr_report("Using default engine '$1'")
1073 1074 1075
    }
  }

1076
  # --------------------------------------------------------------------------
1077
  # Check if we should speed up tests by trying to run on tmpfs
1078
  # --------------------------------------------------------------------------
Magnus Svensson's avatar
Magnus Svensson committed
1079
  if ( defined $opt_mem)
1080 1081 1082 1083 1084 1085
  {
    mtr_error("Can't use --mem and --vardir at the same time ")
      if $opt_vardir;
    mtr_error("Can't use --mem and --tmpdir at the same time ")
      if $opt_tmpdir;

1086
    # Search through list of locations that are known
1087
    # to be "fast disks" to find a suitable location
1088 1089 1090
    # Use --mem=<dir> as first location to look.
    my @tmpfs_locations= ($opt_mem, "/dev/shm", "/tmp");

1091 1092 1093 1094
    foreach my $fs (@tmpfs_locations)
    {
      if ( -d $fs )
      {
1095
	my $template= "var_${opt_build_thread}_XXXX";
1096
	$opt_mem= tempdir( $template, DIR => $fs, CLEANUP => 0);
1097 1098 1099 1100
	last;
      }
    }
  }
1101

1102
  # --------------------------------------------------------------------------
Magnus Svensson's avatar
Magnus Svensson committed
1103
  # Set the "var/" directory, the base for everything else
1104
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1105
  $default_vardir= "$glob_mysql_test_dir/var";
1106 1107
  if ( ! $opt_vardir )
  {
1108
    $opt_vardir= $default_vardir;
1109
  }
unknown's avatar
unknown committed
1110

unknown's avatar
unknown committed
1111 1112
  # We make the path absolute, as the server will do a chdir() before usage
  unless ( $opt_vardir =~ m,^/, or
unknown's avatar
unknown committed
1113
           (IS_WINDOWS and $opt_vardir =~ m,^[a-z]:/,i) )
1114 1115 1116 1117
  {
    # Make absolute path, relative test dir
    $opt_vardir= "$glob_mysql_test_dir/$opt_vardir";
  }
unknown's avatar
unknown committed
1118

Magnus Svensson's avatar
Magnus Svensson committed
1119
  set_vardir($opt_vardir);
unknown's avatar
unknown committed
1120

1121
  # --------------------------------------------------------------------------
Magnus Svensson's avatar
Magnus Svensson committed
1122
  # Set the "tmp" directory
1123
  # --------------------------------------------------------------------------
1124 1125 1126 1127
  if ( ! $opt_tmpdir )
  {
    $opt_tmpdir=       "$opt_vardir/tmp" unless $opt_tmpdir;

1128
    if (check_socket_path_length("$opt_tmpdir/mysql_testsocket.sock"))
1129 1130 1131 1132 1133
    {
      mtr_report("Too long tmpdir path '$opt_tmpdir'",
		 " creating a shorter one...");

      # Create temporary directory in standard location for temporary files
1134
      $opt_tmpdir= tempdir( TMPDIR => 1, CLEANUP => 0 );
1135
      mtr_report(" - using tmpdir: '$opt_tmpdir'\n");
1136 1137 1138

      # Remember pid that created dir so it's removed by correct process
      $opt_tmpdir_pid= $$;
1139 1140
    }
  }
unknown's avatar
unknown committed
1141
  $opt_tmpdir =~ s,/+$,,;       # Remove ending slash if any
unknown's avatar
unknown committed
1142 1143

  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1144
  # fast option
unknown's avatar
unknown committed
1145
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1146 1147
  if ($opt_fast){
    $opt_shutdown_timeout= 0; # Kill processes instead of nice shutdown
unknown's avatar
unknown committed
1148 1149
  }

1150 1151 1152
  # --------------------------------------------------------------------------
  # Check parallel value
  # --------------------------------------------------------------------------
1153
  if ($opt_parallel ne "auto" && $opt_parallel < 1)
1154
  {
1155
    mtr_error("0 or negative parallel value makes no sense, use 'auto' or positive number");
1156 1157
  }

unknown's avatar
unknown committed
1158
  # --------------------------------------------------------------------------
1159
  # Record flag
unknown's avatar
unknown committed
1160
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1161
  if ( $opt_record and ! @opt_cases )
unknown's avatar
unknown committed
1162 1163 1164 1165
  {
    mtr_error("Will not run in record mode without a specific test case");
  }

1166 1167 1168 1169 1170
  if ( $opt_record ) {
    # Use only one worker with --record
    $opt_parallel= 1;
  }

1171
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1172
  # Embedded server flag
1173
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1174
  if ( $opt_embedded_server )
unknown's avatar
unknown committed
1175
  {
unknown's avatar
unknown committed
1176
    if ( IS_WINDOWS )
unknown's avatar
unknown committed
1177 1178 1179 1180 1181
    {
      # Add the location for libmysqld.dll to the path.
      my $separator= ";";
      my $lib_mysqld=
        mtr_path_exists(vs_config_dirs('libmysqld',''));
unknown's avatar
unknown committed
1182
      if ( IS_CYGWIN )
unknown's avatar
unknown committed
1183
      {
unknown's avatar
unknown committed
1184
	$lib_mysqld= posix_path($lib_mysqld);
unknown's avatar
unknown committed
1185 1186 1187 1188 1189 1190
	$separator= ":";
      }
      $ENV{'PATH'}= "$ENV{'PATH'}".$separator.$lib_mysqld;
    }
    $opt_skip_ndbcluster= 1;       # Turn off use of NDB cluster
    $opt_skip_ssl= 1;              # Turn off use of SSL
unknown's avatar
unknown committed
1191

unknown's avatar
unknown committed
1192 1193 1194 1195 1196 1197 1198
    # Turn off use of bin log
    push(@opt_extra_mysqld_opt, "--skip-log-bin");

    if ( using_extern() )
    {
      mtr_error("Can't use --extern with --embedded-server");
    }
1199

1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221

    if ($opt_gdb)
    {
      mtr_warning("Silently converting --gdb to --client-gdb in embedded mode");
      $opt_client_gdb= $opt_gdb;
      $opt_gdb= undef;
    }

    if ($opt_ddd)
    {
      mtr_warning("Silently converting --ddd to --client-ddd in embedded mode");
      $opt_client_ddd= $opt_ddd;
      $opt_ddd= undef;
    }

    if ($opt_debugger)
    {
      mtr_warning("Silently converting --debugger to --client-debugger in embedded mode");
      $opt_client_debugger= $opt_debugger;
      $opt_debugger= undef;
    }

1222 1223 1224 1225 1226 1227
    if ( $opt_gdb || $opt_ddd || $opt_manual_gdb || $opt_manual_ddd ||
	 $opt_manual_debug || $opt_debugger )
    {
      mtr_error("You need to use the client debug options for the",
		"embedded server. Ex: --client-gdb");
    }
unknown's avatar
unknown committed
1228 1229
  }

1230
  # --------------------------------------------------------------------------
1231
  # Big test flags
1232
  # --------------------------------------------------------------------------
1233 1234 1235 1236
   if ( $opt_big_test )
   {
     $ENV{'BIG_TEST'}= 1;
   }
unknown's avatar
unknown committed
1237

1238 1239 1240
  # --------------------------------------------------------------------------
  # Gcov flag
  # --------------------------------------------------------------------------
1241
  if ( $opt_gcov and ! $source_dist )
unknown's avatar
unknown committed
1242
  {
unknown's avatar
unknown committed
1243 1244 1245
    mtr_error("Coverage test needs the source - please use source dist");
  }

1246
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1247
  # Check debug related options
1248
  # --------------------------------------------------------------------------
1249
  if ( $opt_gdb || $opt_client_gdb || $opt_ddd || $opt_client_ddd ||
1250 1251
       $opt_manual_gdb || $opt_manual_ddd || $opt_manual_debug ||
       $opt_debugger || $opt_client_debugger )
unknown's avatar
unknown committed
1252
  {
1253
    # Indicate that we are using debugger
unknown's avatar
unknown committed
1254
    $glob_debugger= 1;
unknown's avatar
unknown committed
1255
    if ( using_extern() )
unknown's avatar
unknown committed
1256
    {
unknown's avatar
unknown committed
1257
      mtr_error("Can't use --extern when using debugger");
unknown's avatar
unknown committed
1258
    }
1259 1260 1261 1262 1263 1264 1265
    # Set one week timeout (check-testcase timeout will be 1/10th)
    $opt_testcase_timeout= 7 * 24 * 60;
    $opt_suite_timeout= 7 * 24 * 60;
    # One day to shutdown
    $opt_shutdown_timeout= 24 * 60;
    # One day for PID file creation (this is given in seconds not minutes)
    $opt_start_timeout= 24 * 60 * 60;
unknown's avatar
unknown committed
1266 1267
  }

1268 1269 1270 1271 1272 1273 1274 1275
  # --------------------------------------------------------------------------
  # Modified behavior with --start options
  # --------------------------------------------------------------------------
  if ($opt_start or $opt_start_dirty) {
    collect_option ('quick-collect', 1);
    $start_only= 1;
  }

1276 1277 1278 1279
  # --------------------------------------------------------------------------
  # Check use of wait-all
  # --------------------------------------------------------------------------

1280
  if ($opt_wait_all && ! $start_only)
1281 1282 1283 1284
  {
    mtr_error("--wait-all can only be used with --start or --start-dirty");
  }

1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296
  # --------------------------------------------------------------------------
  # Check timeout arguments
  # --------------------------------------------------------------------------

  mtr_error("Invalid value '$opt_testcase_timeout' supplied ".
	    "for option --testcase-timeout")
    if ($opt_testcase_timeout <= 0);
  mtr_error("Invalid value '$opt_suite_timeout' supplied ".
	    "for option --testsuite-timeout")
    if ($opt_suite_timeout <= 0);

  # --------------------------------------------------------------------------
1297
  # Check valgrind arguments
1298
  # --------------------------------------------------------------------------
unknown's avatar
unknown committed
1299
  if ( $opt_valgrind or $opt_valgrind_path or @valgrind_args)
unknown's avatar
unknown committed
1300
  {
unknown's avatar
unknown committed
1301 1302 1303 1304
    mtr_report("Turning on valgrind for all executables");
    $opt_valgrind= 1;
    $opt_valgrind_mysqld= 1;
    $opt_valgrind_mysqltest= 1;
unknown's avatar
unknown committed
1305 1306 1307 1308 1309 1310

    # Increase the timeouts when running with valgrind
    $opt_testcase_timeout*= 10;
    $opt_suite_timeout*= 6;
    $opt_start_timeout*= 10;

unknown's avatar
unknown committed
1311
  }
1312
  elsif ( $opt_valgrind_mysqld )
unknown's avatar
unknown committed
1313
  {
1314
    mtr_report("Turning on valgrind for mysqld(s) only");
unknown's avatar
unknown committed
1315
    $opt_valgrind= 1;
1316 1317 1318
  }
  elsif ( $opt_valgrind_mysqltest )
  {
1319
    mtr_report("Turning on valgrind for mysqltest and mysql_client_test only");
unknown's avatar
unknown committed
1320
    $opt_valgrind= 1;
1321 1322
  }

1323 1324 1325 1326 1327 1328 1329
  if ( $opt_callgrind )
  {
    mtr_report("Turning on valgrind with callgrind for mysqld(s)");
    $opt_valgrind= 1;
    $opt_valgrind_mysqld= 1;

    # Set special valgrind options unless options passed on command line
unknown's avatar
unknown committed
1330 1331
    push(@valgrind_args, "--trace-children=yes")
      unless @valgrind_args;
1332 1333
  }

1334 1335 1336
  if ( $opt_valgrind )
  {
    # Set valgrind_options to default unless already defined
unknown's avatar
unknown committed
1337 1338
    push(@valgrind_args, @default_valgrind_args)
      unless @valgrind_args;
unknown's avatar
unknown committed
1339

1340 1341 1342
    # Make valgrind run in quiet mode so it only print errors
    push(@valgrind_args, "--quiet" );

unknown's avatar
unknown committed
1343 1344
    mtr_report("Running valgrind with options \"",
	       join(" ", @valgrind_args), "\"");
unknown's avatar
unknown committed
1345
  }
unknown's avatar
unknown committed
1346

1347 1348 1349 1350 1351 1352 1353 1354
  mtr_report("Checking supported features...");

  check_ndbcluster_support(\%mysqld_variables);
  check_ssl_support(\%mysqld_variables);
  check_debug_support(\%mysqld_variables);

  executable_setup();

1355 1356
}

unknown's avatar
unknown committed
1357

1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372
#
# To make it easier for different devs to work on the same host,
# an environment variable can be used to control all ports. A small
# number is to be used, 0 - 16 or similar.
#
# Note the MASTER_MYPORT has to be set the same in all 4.x and 5.x
# versions of this script, else a 4.0 test run might conflict with a
# 5.1 test run, even if different MTR_BUILD_THREAD is used. This means
# all port numbers might not be used in this version of the script.
#
# Also note the limitation of ports we are allowed to hand out. This
# differs between operating systems and configuration, see
# http://www.ncftp.com/ncftpd/doc/misc/ephemeral_ports.html
# But a fairly safe range seems to be 5001 - 32767
#
1373
sub set_build_thread_ports($) {
1374
  my $thread= shift || 0;
1375

1376 1377
  if ( lc($opt_build_thread) eq 'auto' ) {
    my $found_free = 0;
1378
    $build_thread = 300;	# Start attempts from here
1379 1380
    while (! $found_free)
    {
1381
      $build_thread= mtr_get_unique_id($build_thread, 349);
1382
      if ( !defined $build_thread ) {
1383
        mtr_error("Could not get a unique build thread id");
1384 1385 1386
      }
      $found_free= check_ports_free($build_thread);
      # If not free, release and try from next number
1387 1388 1389 1390
      if (! $found_free) {
        mtr_release_unique_id();
        $build_thread++;
      }
1391
    }
1392 1393 1394 1395
  }
  else
  {
    $build_thread = $opt_build_thread + $thread - 1;
1396 1397 1398 1399
    if (! check_ports_free($build_thread)) {
      # Some port was not free(which one has already been printed)
      mtr_error("Some port(s) was not free")
    }
unknown's avatar
unknown committed
1400
  }
1401
  $ENV{MTR_BUILD_THREAD}= $build_thread;
1402

unknown's avatar
unknown committed
1403
  # Calculate baseport
1404 1405
  $baseport= $build_thread * 10 + 10000;
  if ( $baseport < 5001 or $baseport + 9 >= 32767 )
1406 1407 1408
  {
    mtr_error("MTR_BUILD_THREAD number results in a port",
              "outside 5001 - 32767",
1409
              "($baseport - $baseport + 9)");
1410
  }
1411

1412
  mtr_report("Using MTR_BUILD_THREAD $build_thread,",
1413
	     "with reserved ports $baseport..".($baseport+9));
1414

unknown's avatar
unknown committed
1415 1416 1417
}


unknown's avatar
unknown committed
1418
sub collect_mysqld_features {
unknown's avatar
unknown committed
1419
  my $found_variable_list_start= 0;
1420 1421 1422 1423 1424 1425 1426
  my $use_tmpdir;
  if ( defined $opt_tmpdir and -d $opt_tmpdir){
    # Create the tempdir in $opt_tmpdir
    $use_tmpdir= $opt_tmpdir;
  }
  my $tmpdir= tempdir(CLEANUP => 0, # Directory removed by this function
		      DIR => $use_tmpdir);
1427

1428
  #
unknown's avatar
unknown committed
1429
  # Execute "mysqld --no-defaults --help --verbose" to get a
unknown's avatar
unknown committed
1430
  # list of all features and settings
1431
  #
1432 1433 1434
  # --no-defaults and --skip-grant-tables are to avoid loading
  # system-wide configs and plugins
  #
1435
  # --datadir must exist, mysqld will chdir into it
unknown's avatar
unknown committed
1436
  #
unknown's avatar
unknown committed
1437 1438 1439 1440 1441 1442 1443 1444 1445
  my $args;
  mtr_init_args(\$args);
  mtr_add_arg($args, "--no-defaults");
  mtr_add_arg($args, "--datadir=%s", mixed_path($tmpdir));
  mtr_add_arg($args, "--language=%s", $path_language);
  mtr_add_arg($args, "--skip-grant-tables");
  mtr_add_arg($args, "--verbose");
  mtr_add_arg($args, "--help");

1446
  my $exe_mysqld= find_mysqld($basedir);
unknown's avatar
unknown committed
1447 1448
  my $cmd= join(" ", $exe_mysqld, @$args);
  my $list= `$cmd`;
unknown's avatar
unknown committed
1449

1450
  foreach my $line (split('\n', $list))
unknown's avatar
unknown committed
1451
  {
unknown's avatar
unknown committed
1452 1453
    # First look for version
    if ( !$mysql_version_id )
unknown's avatar
unknown committed
1454
    {
unknown's avatar
unknown committed
1455
      # Look for version
1456 1457 1458
      my $exe_name= basename($exe_mysqld);
      mtr_verbose("exe_name: $exe_name");
      if ( $line =~ /^\S*$exe_name\s\sVer\s([0-9]*)\.([0-9]*)\.([0-9]*)/ )
unknown's avatar
unknown committed
1459
      {
1460
	#print "Major: $1 Minor: $2 Build: $3\n";
unknown's avatar
unknown committed
1461
	$mysql_version_id= $1*10000 + $2*100 + $3;
1462 1463
	#print "mysql_version_id: $mysql_version_id\n";
	mtr_report("MySQL Version $1.$2.$3");
unknown's avatar
unknown committed
1464
      }
unknown's avatar
unknown committed
1465 1466 1467
    }
    else
    {
unknown's avatar
unknown committed
1468
      if (!$found_variable_list_start)
unknown's avatar
unknown committed
1469
      {
unknown's avatar
unknown committed
1470
	# Look for start of variables list
1471
	if ( $line =~ /[\-]+\s[\-]+/ )
unknown's avatar
unknown committed
1472 1473 1474
	{
	  $found_variable_list_start= 1;
	}
1475 1476 1477
      }
      else
      {
unknown's avatar
unknown committed
1478
	# Put variables into hash
1479
	if ( $line =~ /^([\S]+)[ \t]+(.*?)\r?$/ )
unknown's avatar
unknown committed
1480
	{
1481
	  # print "$1=\"$2\"\n";
unknown's avatar
unknown committed
1482 1483
	  $mysqld_variables{$1}= $2;
	}
1484 1485
	else
	{
1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498
	  # The variable list is ended with a blank line
	  if ( $line =~ /^[\s]*$/ )
	  {
	    last;
	  }
	  else
	  {
	    # Send out a warning, we should fix the variables that has no
	    # space between variable name and it's value
	    # or should it be fixed width column parsing? It does not
	    # look like that in function my_print_variables in my_getopt.c
	    mtr_warning("Could not parse variable list line : $line");
	  }
1499
	}
unknown's avatar
unknown committed
1500
      }
unknown's avatar
unknown committed
1501
    }
unknown's avatar
unknown committed
1502
  }
1503
  rmtree($tmpdir);
unknown's avatar
unknown committed
1504
  mtr_error("Could not find version of MySQL") unless $mysql_version_id;
1505
  mtr_error("Could not find variabes list") unless $found_variable_list_start;
unknown's avatar
unknown committed
1506 1507 1508 1509

}


1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541

sub collect_mysqld_features_from_running_server ()
{
  my $mysql= mtr_exe_exists("$path_client_bindir/mysql");

  my $args;
  mtr_init_args(\$args);

  mtr_add_arg($args, "--no-defaults");
  mtr_add_arg($args, "--user=%s", $opt_user);

  while (my ($option, $value)= each( %opts_extern )) {
    mtr_add_arg($args, "--$option=$value");
  }

  mtr_add_arg($args, "--silent"); # Tab separated output
  mtr_add_arg($args, "-e '%s'", "use mysql; SHOW VARIABLES");
  my $cmd= "$mysql " . join(' ', @$args);
  mtr_verbose("cmd: $cmd");

  my $list = `$cmd` or
    mtr_error("Could not connect to extern server using command: '$cmd'");
  foreach my $line (split('\n', $list ))
  {
    # Put variables into hash
    if ( $line =~ /^([\S]+)[ \t]+(.*?)\r?$/ )
    {
      # print "$1=\"$2\"\n";
      $mysqld_variables{$1}= $2;
    }
  }

1542 1543 1544 1545
  # "Convert" innodb flag
  $mysqld_variables{'innodb'}= "ON"
    if ($mysqld_variables{'have_innodb'} eq "YES");

1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557
  # Parse version
  my $version_str= $mysqld_variables{'version'};
  if ( $version_str =~ /^([0-9]*)\.([0-9]*)\.([0-9]*)/ )
  {
    #print "Major: $1 Minor: $2 Build: $3\n";
    $mysql_version_id= $1*10000 + $2*100 + $3;
    #print "mysql_version_id: $mysql_version_id\n";
    mtr_report("MySQL Version $1.$2.$3");
  }
  mtr_error("Could not find version of MySQL") unless $mysql_version_id;
}

1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570
sub find_mysqld {
  my ($mysqld_basedir)= @_;

  my @mysqld_names= ("mysqld", "mysqld-max-nt", "mysqld-max",
		     "mysqld-nt");

  if ( $opt_debug ){
    # Put mysqld-debug first in the list of binaries to look for
    mtr_verbose("Adding mysqld-debug first in list of binaries to look for");
    unshift(@mysqld_names, "mysqld-debug");
  }

  return my_find_bin($mysqld_basedir,
1571
		     ["sql", "libexec", "sbin", "bin"],
1572 1573 1574 1575
		     [@mysqld_names]);
}


unknown's avatar
unknown committed
1576 1577
sub executable_setup () {

1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592
  #
  # Check if libtool is available in this distribution/clone
  # we need it when valgrinding or debugging non installed binary
  # Otherwise valgrind will valgrind the libtool wrapper or bash
  # and gdb will not find the real executable to debug
  #
  if ( -x "../libtool")
  {
    $exe_libtool= "../libtool";
    if ($opt_valgrind or $glob_debugger)
    {
      mtr_report("Using \"$exe_libtool\" when running valgrind or debugger");
    }
  }

unknown's avatar
unknown committed
1593 1594 1595
  # Look for the client binaries
  $exe_mysqladmin=     mtr_exe_exists("$path_client_bindir/mysqladmin");
  $exe_mysql=          mtr_exe_exists("$path_client_bindir/mysql");
unknown's avatar
unknown committed
1596

unknown's avatar
unknown committed
1597 1598 1599 1600
  if ( ! $opt_skip_ndbcluster )
  {
    $exe_ndbd=
      my_find_bin($basedir,
Luis Soares's avatar
Luis Soares committed
1601
		  ["storage/ndb/src/kernel", "libexec", "sbin", "bin"],
unknown's avatar
unknown committed
1602 1603 1604 1605
		  "ndbd");

    $exe_ndb_mgmd=
      my_find_bin($basedir,
Luis Soares's avatar
Luis Soares committed
1606
		  ["storage/ndb/src/mgmsrv", "libexec", "sbin", "bin"],
unknown's avatar
unknown committed
1607 1608 1609 1610 1611 1612
		  "ndb_mgmd");

    $exe_ndb_waiter=
      my_find_bin($basedir,
		  ["storage/ndb/tools/", "bin"],
		  "ndb_waiter");
1613

unknown's avatar
unknown committed
1614
  }
1615

unknown's avatar
unknown committed
1616
  # Look for mysqltest executable
unknown's avatar
unknown committed
1617
  if ( $opt_embedded_server )
unknown's avatar
unknown committed
1618
  {
unknown's avatar
unknown committed
1619
    $exe_mysqltest=
1620
      mtr_exe_exists(vs_config_dirs('libmysqld/examples','mysqltest_embedded'),
unknown's avatar
unknown committed
1621
                     "$basedir/libmysqld/examples/mysqltest_embedded",
1622
                     "$path_client_bindir/mysqltest_embedded");
unknown's avatar
unknown committed
1623
  }
unknown's avatar
unknown committed
1624 1625
  else
  {
1626
    $exe_mysqltest= mtr_exe_exists("$path_client_bindir/mysqltest");
unknown's avatar
unknown committed
1627
  }
1628

unknown's avatar
unknown committed
1629 1630 1631
}


unknown's avatar
unknown committed
1632 1633 1634 1635 1636 1637 1638 1639
sub client_debug_arg($$) {
  my ($args, $client_name)= @_;

  if ( $opt_debug ) {
    mtr_add_arg($args,
		"--debug=d:t:A,%s/log/%s.trace",
		$path_vardir_trace, $client_name)
  }
1640 1641 1642
}


unknown's avatar
unknown committed
1643
sub mysql_fix_arguments () {
unknown's avatar
unknown committed
1644

unknown's avatar
unknown committed
1645
  return "" if ( IS_WINDOWS );
1646

unknown's avatar
unknown committed
1647 1648 1649
  my $exe=
    mtr_script_exists("$basedir/scripts/mysql_fix_privilege_tables",
		      "$path_client_bindir/mysql_fix_privilege_tables");
1650 1651
  my $args;
  mtr_init_args(\$args);
unknown's avatar
unknown committed
1652
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
1653

1654 1655
  mtr_add_arg($args, "--basedir=%s", $basedir);
  mtr_add_arg($args, "--bindir=%s", $path_client_bindir);
unknown's avatar
unknown committed
1656 1657 1658
  mtr_add_arg($args, "--verbose");
  return mtr_args2str($exe, @$args);
}
1659 1660


1661
sub client_arguments ($;$) {
unknown's avatar
unknown committed
1662
  my $client_name= shift;
1663
  my $group_suffix= shift;
unknown's avatar
unknown committed
1664
  my $client_exe= mtr_exe_exists("$path_client_bindir/$client_name");
1665

unknown's avatar
unknown committed
1666 1667 1668
  my $args;
  mtr_init_args(\$args);
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
1669 1670 1671 1672 1673
  if (defined($group_suffix)) {
    mtr_add_arg($args, "--defaults-group-suffix=%s", $group_suffix);
    client_debug_arg($args, "$client_name-$group_suffix");
  }
  else
1674
  {
1675
    client_debug_arg($args, $client_name);
1676
  }
unknown's avatar
unknown committed
1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689
  return mtr_args2str($client_exe, @$args);
}


sub mysqlslap_arguments () {
  my $exe= mtr_exe_maybe_exists("$path_client_bindir/mysqlslap");
  if ( $exe eq "" ) {
    # mysqlap was not found

    if (defined $mysql_version_id and $mysql_version_id >= 50100 ) {
      mtr_error("Could not find the mysqlslap binary");
    }
    return ""; # Don't care about mysqlslap
1690 1691
  }

unknown's avatar
unknown committed
1692 1693 1694 1695 1696
  my $args;
  mtr_init_args(\$args);
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  client_debug_arg($args, "mysqlslap");
  return mtr_args2str($exe, @$args);
1697 1698
}

unknown's avatar
unknown committed
1699 1700 1701 1702

sub mysqldump_arguments ($) {
  my($group_suffix) = @_;
  my $exe= mtr_exe_exists("$path_client_bindir/mysqldump");
1703 1704 1705

  my $args;
  mtr_init_args(\$args);
unknown's avatar
unknown committed
1706
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
1707
  mtr_add_arg($args, "--defaults-group-suffix=%s", $group_suffix);
unknown's avatar
unknown committed
1708 1709 1710
  client_debug_arg($args, "mysqldump-$group_suffix");
  return mtr_args2str($exe, @$args);
}
1711 1712


unknown's avatar
unknown committed
1713 1714 1715 1716 1717
sub mysql_client_test_arguments(){
  my $exe;
  # mysql_client_test executable may _not_ exist
  if ( $opt_embedded_server ) {
    $exe= mtr_exe_maybe_exists(
1718 1719 1720
            vs_config_dirs('libmysqld/examples','mysql_client_test_embedded'),
	      "$basedir/libmysqld/examples/mysql_client_test_embedded",
		"$basedir/bin/mysql_client_test_embedded");
unknown's avatar
unknown committed
1721 1722 1723 1724 1725 1726 1727 1728 1729 1730
  } else {
    $exe= mtr_exe_maybe_exists(vs_config_dirs('tests', 'mysql_client_test'),
			       "$basedir/tests/mysql_client_test",
			       "$basedir/bin/mysql_client_test");
  }

  my $args;
  mtr_init_args(\$args);
  if ( $opt_valgrind_mysqltest ) {
    valgrind_arguments($args, \$exe);
1731
  }
unknown's avatar
unknown committed
1732 1733 1734 1735
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--testcase");
  mtr_add_arg($args, "--vardir=$opt_vardir");
  client_debug_arg($args,"mysql_client_test");
1736

unknown's avatar
unknown committed
1737
  return mtr_args2str($exe, @$args);
1738 1739
}

unknown's avatar
unknown committed
1740

unknown's avatar
unknown committed
1741 1742 1743 1744 1745
#
# Set environment to be used by childs of this process for
# things that are constant during the whole lifetime of mysql-test-run
#
sub environment_setup {
unknown's avatar
unknown committed
1746

unknown's avatar
unknown committed
1747 1748
  umask(022);

1749
  my @ld_library_paths;
1750

unknown's avatar
unknown committed
1751
  if ($path_client_libdir)
unknown's avatar
unknown committed
1752
  {
unknown's avatar
unknown committed
1753 1754
    # Use the --client-libdir passed on commandline
    push(@ld_library_paths, "$path_client_libdir");
1755 1756
  }
  else
unknown's avatar
unknown committed
1757
  {
unknown's avatar
unknown committed
1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769
    # Setup LD_LIBRARY_PATH so the libraries from this distro/clone
    # are used in favor of the system installed ones
    if ( $source_dist )
    {
      push(@ld_library_paths, "$basedir/libmysql/.libs/",
	   "$basedir/libmysql_r/.libs/",
	   "$basedir/zlib.libs/");
    }
    else
    {
      push(@ld_library_paths, "$basedir/lib");
    }
1770 1771
  }

unknown's avatar
unknown committed
1772
  # --------------------------------------------------------------------------
1773 1774
  # Add the path where libndbclient can be found
  # --------------------------------------------------------------------------
1775
  if ( !$opt_skip_ndbcluster )
1776
  {
unknown's avatar
unknown committed
1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793
    push(@ld_library_paths,  "$basedir/storage/ndb/src/.libs");
  }

  # --------------------------------------------------------------------------
  # Add the path where mysqld will find udf_example.so
  # --------------------------------------------------------------------------
  my $lib_udf_example=
    mtr_file_exists(vs_config_dirs('sql', 'udf_example.dll'),
		    "$basedir/sql/.libs/udf_example.so",);

  if ( $lib_udf_example )
  {
    push(@ld_library_paths, dirname($lib_udf_example));
  }

  $ENV{'UDF_EXAMPLE_LIB'}=
    ($lib_udf_example ? basename($lib_udf_example) : "");
1794 1795
  $ENV{'UDF_EXAMPLE_LIB_OPT'}= "--plugin-dir=".
    ($lib_udf_example ? dirname($lib_udf_example) : "");
unknown's avatar
unknown committed
1796 1797 1798 1799

  # --------------------------------------------------------------------------
  # Add the path where mysqld will find ha_example.so
  # --------------------------------------------------------------------------
1800
  if ($mysql_version_id >= 50100) {
1801 1802 1803
    my $plugin_filename;
    if (IS_WINDOWS)
    {
Bjorn Munch's avatar
Bjorn Munch committed
1804
       $plugin_filename = "ha_example.dll";
1805 1806 1807 1808 1809
    }
    else 
    {
       $plugin_filename = "ha_example.so";
    }
unknown's avatar
unknown committed
1810
    my $lib_example_plugin=
1811
      mtr_file_exists(vs_config_dirs('storage/example',$plugin_filename),
Bjorn Munch's avatar
Bjorn Munch committed
1812 1813
		      "$basedir/storage/example/.libs/".$plugin_filename,
                      "$basedir/lib/mysql/plugin/".$plugin_filename);
unknown's avatar
unknown committed
1814 1815
    $ENV{'EXAMPLE_PLUGIN'}=
      ($lib_example_plugin ? basename($lib_example_plugin) : "");
1816 1817 1818
    $ENV{'EXAMPLE_PLUGIN_OPT'}= "--plugin-dir=".
      ($lib_example_plugin ? dirname($lib_example_plugin) : "");

1819 1820
    $ENV{'HA_EXAMPLE_SO'}="'".$plugin_filename."'";
    $ENV{'EXAMPLE_PLUGIN_LOAD'}="--plugin_load=;EXAMPLE=".$plugin_filename.";";
unknown's avatar
unknown committed
1821
  }
unknown's avatar
unknown committed
1822

Luis Soares's avatar
Luis Soares committed
1823 1824 1825 1826 1827 1828 1829 1830 1831
  # ----------------------------------------------------
  # Add the path where mysqld will find mypluglib.so
  # ----------------------------------------------------
  my $lib_simple_parser=
    mtr_file_exists(vs_config_dirs('plugin/fulltext', 'mypluglib.dll'),
		    "$basedir/plugin/fulltext/.libs/mypluglib.so",);

  $ENV{'SIMPLE_PARSER'}=
    ($lib_simple_parser ? basename($lib_simple_parser) : "");
1832 1833
  $ENV{'SIMPLE_PARSER_OPT'}= "--plugin-dir=".
    ($lib_simple_parser ? dirname($lib_simple_parser) : "");
Luis Soares's avatar
Luis Soares committed
1834

1835
  # --------------------------------------------------------------------------
1836
  # Valgrind need to be run with debug libraries otherwise it's almost
1837 1838 1839
  # impossible to add correct supressions, that means if "/usr/lib/debug"
  # is available, it should be added to
  # LD_LIBRARY_PATH
1840 1841 1842 1843
  #
  # But pthread is broken in libc6-dbg on Debian <= 3.1 (see Debian
  # bug 399035, http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=399035),
  # so don't change LD_LIBRARY_PATH on that platform.
1844
  # --------------------------------------------------------------------------
1845
  my $debug_libraries_path= "/usr/lib/debug";
1846 1847 1848
  my $deb_version;
  if (  $opt_valgrind and -d $debug_libraries_path and
        (! -e '/etc/debian_version' or
unknown's avatar
unknown committed
1849 1850
	 ($deb_version=
	    mtr_grab_file('/etc/debian_version')) !~ /^[0-9]+\.[0-9]$/ or
1851
         $deb_version > 3.1 ) )
1852
  {
1853
    push(@ld_library_paths, $debug_libraries_path);
1854
  }
1855

1856
  $ENV{'LD_LIBRARY_PATH'}= join(":", @ld_library_paths,
unknown's avatar
unknown committed
1857
				$ENV{'LD_LIBRARY_PATH'} ?
1858
				split(':', $ENV{'LD_LIBRARY_PATH'}) : ());
1859 1860 1861
  mtr_debug("LD_LIBRARY_PATH: $ENV{'LD_LIBRARY_PATH'}");

  $ENV{'DYLD_LIBRARY_PATH'}= join(":", @ld_library_paths,
1862 1863
				  $ENV{'DYLD_LIBRARY_PATH'} ?
				  split(':', $ENV{'DYLD_LIBRARY_PATH'}) : ());
1864
  mtr_debug("DYLD_LIBRARY_PATH: $ENV{'DYLD_LIBRARY_PATH'}");
1865

1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876
  # The environment variable used for shared libs on AIX
  $ENV{'SHLIB_PATH'}= join(":", @ld_library_paths,
                           $ENV{'SHLIB_PATH'} ?
                           split(':', $ENV{'SHLIB_PATH'}) : ());
  mtr_debug("SHLIB_PATH: $ENV{'SHLIB_PATH'}");

  # The environment variable used for shared libs on hp-ux
  $ENV{'LIBPATH'}= join(":", @ld_library_paths,
                        $ENV{'LIBPATH'} ?
                        split(':', $ENV{'LIBPATH'}) : ());
  mtr_debug("LIBPATH: $ENV{'LIBPATH'}");
1877

1878
  $ENV{'CHARSETSDIR'}=              $path_charsetsdir;
unknown's avatar
unknown committed
1879 1880
  $ENV{'UMASK'}=              "0660"; # The octal *string*
  $ENV{'UMASK_DIR'}=          "0770"; # The octal *string*
unknown's avatar
unknown committed
1881

1882 1883 1884 1885 1886 1887 1888 1889 1890 1891
  #
  # MySQL tests can produce output in various character sets
  # (especially, ctype_xxx.test). To avoid confusing Perl
  # with output which is incompatible with the current locale
  # settings, we reset the current values of LC_ALL and LC_CTYPE to "C".
  # For details, please see
  # Bug#27636 tests fails if LC_* variables set to *_*.UTF-8
  #
  $ENV{'LC_ALL'}=             "C";
  $ENV{'LC_CTYPE'}=           "C";
unknown's avatar
unknown committed
1892

unknown's avatar
unknown committed
1893
  $ENV{'LC_COLLATE'}=         "C";
unknown's avatar
unknown committed
1894
  $ENV{'USE_RUNNING_SERVER'}= using_extern();
unknown's avatar
unknown committed
1895
  $ENV{'MYSQL_TEST_DIR'}=     $glob_mysql_test_dir;
unknown's avatar
unknown committed
1896
  $ENV{'DEFAULT_MASTER_PORT'}= $mysqld_variables{'master-port'} || 3306;
1897
  $ENV{'MYSQL_TMP_DIR'}=      $opt_tmpdir;
Magnus Svensson's avatar
Magnus Svensson committed
1898
  $ENV{'MYSQLTEST_VARDIR'}=   $opt_vardir;
1899

1900 1901 1902
  # ----------------------------------------------------
  # Setup env for NDB
  # ----------------------------------------------------
unknown's avatar
unknown committed
1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926
  if ( ! $opt_skip_ndbcluster )
  {
    $ENV{'NDB_MGM'}=
      my_find_bin($basedir,
		  ["storage/ndb/src/mgmclient", "bin"],
		  "ndb_mgm");

    $ENV{'NDB_TOOLS_DIR'}=
      my_find_dir($basedir,
		  ["storage/ndb/tools", "bin"]);

    $ENV{'NDB_EXAMPLES_DIR'}=
      my_find_dir($basedir,
		  ["storage/ndb/ndbapi-examples", "bin"]);

    $ENV{'NDB_EXAMPLES_BINARY'}=
      my_find_bin($basedir,
		  ["storage/ndb/ndbapi-examples/ndbapi_simple", "bin"],
		  "ndbapi_simple", NOT_REQUIRED);

    my $path_ndb_testrun_log= "$opt_vardir/log/ndb_testrun.log";
    $ENV{'NDB_TOOLS_OUTPUT'}=         $path_ndb_testrun_log;
    $ENV{'NDB_EXAMPLES_OUTPUT'}=      $path_ndb_testrun_log;
  }
1927

1928
  # ----------------------------------------------------
unknown's avatar
unknown committed
1929
  # mysql clients
1930
  # ----------------------------------------------------
unknown's avatar
unknown committed
1931 1932 1933 1934 1935 1936 1937 1938
  $ENV{'MYSQL_CHECK'}=              client_arguments("mysqlcheck");
  $ENV{'MYSQL_DUMP'}=               mysqldump_arguments(".1");
  $ENV{'MYSQL_DUMP_SLAVE'}=         mysqldump_arguments(".2");
  $ENV{'MYSQL_SLAP'}=               mysqlslap_arguments();
  $ENV{'MYSQL_IMPORT'}=             client_arguments("mysqlimport");
  $ENV{'MYSQL_SHOW'}=               client_arguments("mysqlshow");
  $ENV{'MYSQL_BINLOG'}=             client_arguments("mysqlbinlog");
  $ENV{'MYSQL'}=                    client_arguments("mysql");
1939
  $ENV{'MYSQL_SLAVE'}=              client_arguments("mysql", ".2");
unknown's avatar
unknown committed
1940
  $ENV{'MYSQL_UPGRADE'}=            client_arguments("mysql_upgrade");
unknown's avatar
unknown committed
1941
  $ENV{'MYSQLADMIN'}=               native_path($exe_mysqladmin);
unknown's avatar
unknown committed
1942 1943 1944
  $ENV{'MYSQL_CLIENT_TEST'}=        mysql_client_test_arguments();
  $ENV{'MYSQL_FIX_SYSTEM_TABLES'}=  mysql_fix_arguments();
  $ENV{'EXE_MYSQL'}=                $exe_mysql;
1945

unknown's avatar
unknown committed
1946
  # ----------------------------------------------------
unknown's avatar
unknown committed
1947 1948
  # bug25714 executable may _not_ exist in
  # some versions, test using it should be skipped
1949
  # ----------------------------------------------------
unknown's avatar
unknown committed
1950 1951 1952
  my $exe_bug25714=
      mtr_exe_maybe_exists(vs_config_dirs('tests', 'bug25714'),
                           "$basedir/tests/bug25714");
unknown's avatar
unknown committed
1953
  $ENV{'MYSQL_BUG25714'}=  native_path($exe_bug25714);
1954

1955
  # ----------------------------------------------------
unknown's avatar
unknown committed
1956
  # mysql_fix_privilege_tables.sql
1957
  # ----------------------------------------------------
unknown's avatar
unknown committed
1958 1959
  my $file_mysql_fix_privilege_tables=
    mtr_file_exists("$basedir/scripts/mysql_fix_privilege_tables.sql",
Sven Sandberg's avatar
Sven Sandberg committed
1960 1961
		    "$basedir/share/mysql_fix_privilege_tables.sql",
		    "$basedir/share/mysql/mysql_fix_privilege_tables.sql");
1962
  $ENV{'MYSQL_FIX_PRIVILEGE_TABLES'}=  $file_mysql_fix_privilege_tables;
1963 1964

  # ----------------------------------------------------
unknown's avatar
unknown committed
1965
  # my_print_defaults
1966
  # ----------------------------------------------------
unknown's avatar
unknown committed
1967 1968 1969 1970
  my $exe_my_print_defaults=
    mtr_exe_exists(vs_config_dirs('extra', 'my_print_defaults'),
		   "$path_client_bindir/my_print_defaults",
		   "$basedir/extra/my_print_defaults");
unknown's avatar
unknown committed
1971
  $ENV{'MYSQL_MY_PRINT_DEFAULTS'}= native_path($exe_my_print_defaults);
1972

1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988
  # ----------------------------------------------------
  # Setup env so childs can execute myisampack and myisamchk
  # ----------------------------------------------------
  $ENV{'MYISAMCHK'}= native_path(mtr_exe_exists(
                       vs_config_dirs('storage/myisam', 'myisamchk'),
                       vs_config_dirs('myisam', 'myisamchk'),
                       "$path_client_bindir/myisamchk",
                       "$basedir/storage/myisam/myisamchk",
                       "$basedir/myisam/myisamchk"));
  $ENV{'MYISAMPACK'}= native_path(mtr_exe_exists(
                        vs_config_dirs('storage/myisam', 'myisampack'),
                        vs_config_dirs('myisam', 'myisampack'),
                        "$path_client_bindir/myisampack",
                        "$basedir/storage/myisam/myisampack",
                        "$basedir/myisam/myisampack"));

1989
  # ----------------------------------------------------
unknown's avatar
unknown committed
1990
  # perror
1991
  # ----------------------------------------------------
unknown's avatar
unknown committed
1992 1993 1994
  my $exe_perror= mtr_exe_exists(vs_config_dirs('extra', 'perror'),
				 "$basedir/extra/perror",
				 "$path_client_bindir/perror");
unknown's avatar
unknown committed
1995
  $ENV{'MY_PERROR'}= native_path($exe_perror);
1996

1997 1998 1999 2000
  # Create an environment variable to make it possible
  # to detect that valgrind is being used from test cases
  $ENV{'VALGRIND_TEST'}= $opt_valgrind;

unknown's avatar
unknown committed
2001 2002 2003
}


2004

2005 2006 2007 2008 2009
#
# Remove var and any directories in var/ created by previous
# tests
#
sub remove_stale_vardir () {
2010

unknown's avatar
unknown committed
2011
  mtr_report("Removing old var directory...");
unknown's avatar
unknown committed
2012

2013 2014
  # Safety!
  mtr_error("No, don't remove the vardir when running with --extern")
unknown's avatar
unknown committed
2015
    if using_extern();
2016 2017

  mtr_verbose("opt_vardir: $opt_vardir");
2018
  if ( $opt_vardir eq $default_vardir )
2019 2020 2021 2022
  {
    #
    # Running with "var" in mysql-test dir
    #
2023
    if ( -l $opt_vardir)
2024
    {
2025
      # var is a symlink
2026

2027
      if ( $opt_mem )
2028 2029
      {
	# Remove the directory which the link points at
2030
	mtr_verbose("Removing " . readlink($opt_vardir));
unknown's avatar
unknown committed
2031
	rmtree(readlink($opt_vardir));
2032

2033
	# Remove the "var" symlink
2034
	mtr_verbose("unlink($opt_vardir)");
2035
	unlink($opt_vardir);
2036 2037 2038 2039
      }
      else
      {
	# Some users creates a soft link in mysql-test/var to another area
2040 2041
	# - allow it, but remove all files in it

unknown's avatar
unknown committed
2042
	mtr_report(" - WARNING: Using the 'mysql-test/var' symlink");
2043

2044 2045 2046 2047
	# Make sure the directory where it points exist
	mtr_error("The destination for symlink $opt_vardir does not exist")
	  if ! -d readlink($opt_vardir);

2048 2049 2050
	foreach my $bin ( glob("$opt_vardir/*") )
	{
	  mtr_verbose("Removing bin $bin");
unknown's avatar
unknown committed
2051
	  rmtree($bin);
2052
	}
2053
      }
2054 2055 2056 2057
    }
    else
    {
      # Remove the entire "var" dir
2058
      mtr_verbose("Removing $opt_vardir/");
unknown's avatar
unknown committed
2059
      rmtree("$opt_vardir/");
2060
    }
2061 2062 2063 2064 2065 2066 2067

    if ( $opt_mem )
    {
      # A symlink from var/ to $opt_mem will be set up
      # remove the $opt_mem dir to assure the symlink
      # won't point at an old directory
      mtr_verbose("Removing $opt_mem");
unknown's avatar
unknown committed
2068
      rmtree($opt_mem);
2069 2070
    }

2071 2072 2073 2074 2075 2076 2077 2078 2079
  }
  else
  {
    #
    # Running with "var" in some other place
    #

    # Remove the var/ dir in mysql-test dir if any
    # this could be an old symlink that shouldn't be there
2080
    mtr_verbose("Removing $default_vardir");
unknown's avatar
unknown committed
2081
    rmtree($default_vardir);
2082 2083

    # Remove the "var" dir
2084
    mtr_verbose("Removing $opt_vardir/");
unknown's avatar
unknown committed
2085
    rmtree("$opt_vardir/");
2086
  }
2087 2088
  # Remove the "tmp" dir
  mtr_verbose("Removing $opt_tmpdir/");
Luis Soares's avatar
Luis Soares committed
2089
  rmtree("$opt_tmpdir/");
2090 2091
}

unknown's avatar
unknown committed
2092 2093


2094 2095 2096 2097
#
# Create var and the directories needed in var
#
sub setup_vardir() {
2098
  mtr_report("Creating var directory '$opt_vardir'...");
unknown's avatar
unknown committed
2099

2100
  if ( $opt_vardir eq $default_vardir )
2101
  {
2102 2103 2104 2105 2106 2107
    #
    # Running with "var" in mysql-test dir
    #
    if ( -l $opt_vardir )
    {
      #  it's a symlink
2108

2109 2110 2111 2112 2113 2114 2115 2116 2117
      # Make sure the directory where it points exist
      mtr_error("The destination for symlink $opt_vardir does not exist")
	if ! -d readlink($opt_vardir);
    }
    elsif ( $opt_mem )
    {
      # Runinng with "var" as a link to some "memory" location, normally tmpfs
      mtr_verbose("Creating $opt_mem");
      mkpath($opt_mem);
2118

unknown's avatar
unknown committed
2119
      mtr_report(" - symlinking 'var' to '$opt_mem'");
2120 2121
      symlink($opt_mem, $opt_vardir);
    }
2122 2123
  }

2124 2125 2126 2127 2128
  if ( ! -d $opt_vardir )
  {
    mtr_verbose("Creating $opt_vardir");
    mkpath($opt_vardir);
  }
unknown's avatar
unknown committed
2129

2130 2131
  # Ensure a proper error message if vardir couldn't be created
  unless ( -d $opt_vardir and -w $opt_vardir )
2132
  {
2133 2134
    mtr_error("Writable 'var' directory is needed, use the " .
	      "'--vardir=<path>' option");
2135 2136
  }

2137 2138
  mkpath("$opt_vardir/log");
  mkpath("$opt_vardir/run");
2139

2140 2141 2142
  # Create var/tmp and tmp - they might be different
  mkpath("$opt_vardir/tmp");
  mkpath($opt_tmpdir) if ($opt_tmpdir ne "$opt_vardir/tmp");
unknown's avatar
unknown committed
2143

2144 2145 2146 2147 2148 2149 2150 2151 2152
  # On some operating systems, there is a limit to the length of a
  # UNIX domain socket's path far below PATH_MAX.
  # Don't allow that to happen
  if (check_socket_path_length("$opt_tmpdir/testsocket.sock")){
    mtr_error("Socket path '$opt_tmpdir' too long, it would be ",
	      "truncated and thus not possible to use for connection to ",
	      "MySQL Server. Set a shorter with --tmpdir=<path> option");
  }

unknown's avatar
unknown committed
2153
  # copy all files from std_data into var/std_data
2154 2155
  # and make them world readable
  copytree("$glob_mysql_test_dir/std_data", "$opt_vardir/std_data", "0022");
unknown's avatar
unknown committed
2156 2157

  # Remove old log files
unknown's avatar
unknown committed
2158
  foreach my $name (glob("r/*.progress r/*.log r/*.warnings"))
unknown's avatar
unknown committed
2159 2160 2161
  {
    unlink($name);
  }
unknown's avatar
unknown committed
2162 2163 2164
}


unknown's avatar
unknown committed
2165 2166 2167 2168
#
# Check if running as root
# i.e a file can be read regardless what mode we set it to
#
2169
sub  check_running_as_root () {
2170
  my $test_file= "$opt_vardir/test_running_as_root.txt";
2171 2172 2173 2174 2175 2176 2177 2178 2179 2180
  mtr_tofile($test_file, "MySQL");
  chmod(oct("0000"), $test_file);

  my $result="";
  if (open(FILE,"<",$test_file))
  {
    $result= join('', <FILE>);
    close FILE;
  }

2181 2182 2183 2184
  # Some filesystems( for example CIFS) allows reading a file
  # although mode was set to 0000, but in that case a stat on
  # the file will not return 0000
  my $file_mode= (stat($test_file))[2] & 07777;
2185

2186 2187
  mtr_verbose("result: $result, file_mode: $file_mode");
  if ($result eq "MySQL" && $file_mode == 0)
2188 2189 2190 2191 2192
  {
    mtr_warning("running this script as _root_ will cause some " .
                "tests to be skipped");
    $ENV{'MYSQL_TEST_ROOT'}= "YES";
  }
2193 2194 2195

  chmod(oct("0755"), $test_file);
  unlink($test_file);
2196 2197 2198
}


unknown's avatar
unknown committed
2199 2200
sub check_ssl_support ($) {
  my $mysqld_variables= shift;
2201

unknown's avatar
unknown committed
2202
  if ($opt_skip_ssl)
2203
  {
unknown's avatar
unknown committed
2204
    mtr_report(" - skipping SSL");
2205 2206 2207 2208 2209
    $opt_ssl_supported= 0;
    $opt_ssl= 0;
    return;
  }

2210
  if ( ! $mysqld_variables->{'ssl'} )
2211 2212 2213 2214 2215 2216
  {
    if ( $opt_ssl)
    {
      mtr_error("Couldn't find support for SSL");
      return;
    }
unknown's avatar
unknown committed
2217
    mtr_report(" - skipping SSL, mysqld not compiled with SSL");
2218 2219 2220 2221
    $opt_ssl_supported= 0;
    $opt_ssl= 0;
    return;
  }
unknown's avatar
unknown committed
2222
  mtr_report(" - SSL connections supported");
2223 2224 2225 2226
  $opt_ssl_supported= 1;
}


unknown's avatar
unknown committed
2227 2228
sub check_debug_support ($) {
  my $mysqld_variables= shift;
unknown's avatar
unknown committed
2229

2230
  if ( ! $mysqld_variables->{'debug'} )
unknown's avatar
unknown committed
2231
  {
unknown's avatar
unknown committed
2232
    #mtr_report(" - binaries are not debug compiled");
unknown's avatar
unknown committed
2233
    $debug_compiled_binaries= 0;
2234 2235 2236 2237 2238

    if ( $opt_debug )
    {
      mtr_error("Can't use --debug, binaries does not support it");
    }
unknown's avatar
unknown committed
2239 2240
    return;
  }
unknown's avatar
unknown committed
2241
  mtr_report(" - binaries are debug compiled");
unknown's avatar
unknown committed
2242 2243 2244
  $debug_compiled_binaries= 1;
}

unknown's avatar
unknown committed
2245

2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258
#
# Helper function to handle configuration-based subdirectories which Visual
# Studio uses for storing binaries.  If opt_vs_config is set, this returns
# a path based on that setting; if not, it returns paths for the default
# /release/ and /debug/ subdirectories.
#
# $exe can be undefined, if the directory itself will be used
#
sub vs_config_dirs ($$) {
  my ($path_part, $exe) = @_;

  $exe = "" if not defined $exe;

unknown's avatar
unknown committed
2259
  # Don't look in these dirs when not on windows
unknown's avatar
unknown committed
2260
  return () unless IS_WINDOWS;
unknown's avatar
unknown committed
2261

2262 2263
  if ($opt_vs_config)
  {
unknown's avatar
unknown committed
2264
    return ("$basedir/$path_part/$opt_vs_config/$exe");
2265 2266
  }

unknown's avatar
unknown committed
2267 2268 2269
  return ("$basedir/$path_part/release/$exe",
          "$basedir/$path_part/relwithdebinfo/$exe",
          "$basedir/$path_part/debug/$exe");
2270 2271
}

unknown's avatar
unknown committed
2272

unknown's avatar
unknown committed
2273 2274
sub check_ndbcluster_support ($) {
  my $mysqld_variables= shift;
2275

unknown's avatar
unknown committed
2276
  if ($opt_skip_ndbcluster)
2277
  {
unknown's avatar
unknown committed
2278
    mtr_report(" - skipping ndbcluster");
2279 2280
    return;
  }
2281

unknown's avatar
unknown committed
2282
  if ( ! $mysqld_variables{'ndb-connectstring'} )
2283
  {
unknown's avatar
unknown committed
2284
    mtr_report(" - skipping ndbcluster, mysqld not compiled with ndbcluster");
2285
    $opt_skip_ndbcluster= 2;
2286
    return;
2287
  }
unknown's avatar
unknown committed
2288 2289

  mtr_report(" - using ndbcluster when necessary, mysqld supports it");
2290

unknown's avatar
unknown committed
2291
  return;
unknown's avatar
unknown committed
2292 2293
}

unknown's avatar
unknown committed
2294

2295
sub ndbcluster_wait_started($$){
unknown's avatar
unknown committed
2296
  my $cluster= shift;
2297
  my $ndb_waiter_extra_opt= shift;
unknown's avatar
unknown committed
2298
  my $path_waitlog= join('/', $opt_vardir, $cluster->name(), "ndb_waiter.log");
2299

unknown's avatar
unknown committed
2300
  my $args;
2301
  mtr_init_args(\$args);
unknown's avatar
unknown committed
2302 2303
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $cluster->suffix());
2304
  mtr_add_arg($args, "--timeout=%d", $opt_start_timeout);
2305 2306 2307 2308 2309

  if ($ndb_waiter_extra_opt)
  {
    mtr_add_arg($args, "$ndb_waiter_extra_opt");
  }
unknown's avatar
unknown committed
2310 2311 2312 2313

  # Start the ndb_waiter which will connect to the ndb_mgmd
  # and poll it for state of the ndbd's, will return when
  # all nodes in the cluster is started
unknown's avatar
unknown committed
2314

unknown's avatar
unknown committed
2315 2316 2317 2318 2319 2320 2321 2322 2323
  my $res= My::SafeProcess->run
    (
     name          => "ndb_waiter ".$cluster->name(),
     path          => $exe_ndb_waiter,
     args          => \$args,
     output        => $path_waitlog,
     error         => $path_waitlog,
     append        => 1,
    );
2324

unknown's avatar
unknown committed
2325 2326 2327 2328 2329 2330 2331 2332 2333 2334
  # Check that ndb_mgmd(s) are still alive
  foreach my $ndb_mgmd ( in_cluster($cluster, ndb_mgmds()) )
  {
    my $proc= $ndb_mgmd->{proc};
    if ( ! $proc->wait_one(0) )
    {
      mtr_warning("$proc died");
      return 2;
    }
  }
2335

unknown's avatar
unknown committed
2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346
  # Check that all started ndbd(s) are still alive
  foreach my $ndbd ( in_cluster($cluster, ndbds()) )
  {
    my $proc= $ndbd->{proc};
    next unless defined $proc;
    if ( ! $proc->wait_one(0) )
    {
      mtr_warning("$proc died");
      return 3;
    }
  }
2347

unknown's avatar
unknown committed
2348
  if ($res)
2349
  {
unknown's avatar
unknown committed
2350
    mtr_verbose("ndbcluster_wait_started failed");
2351 2352 2353
    return 1;
  }
  return 0;
unknown's avatar
unknown committed
2354 2355 2356
}


2357 2358 2359 2360
sub ndb_mgmd_wait_started($) {
  my ($cluster)= @_;

  my $retries= 100;
unknown's avatar
unknown committed
2361
  while ($retries)
2362
  {
unknown's avatar
unknown committed
2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374
    my $result= ndbcluster_wait_started($cluster, "--no-contact");
    if ($result == 0)
    {
      # ndb_mgmd is started
      mtr_verbose("ndb_mgmd is started");
      return 0;
    }
    elsif ($result > 1)
    {
      mtr_warning("Cluster process failed while waiting for start");
      return $result;
    }
2375

unknown's avatar
unknown committed
2376
    mtr_milli_sleep(100);
2377 2378 2379
    $retries--;
  }

unknown's avatar
unknown committed
2380
  return 1;
2381 2382
}

unknown's avatar
unknown committed
2383

unknown's avatar
unknown committed
2384 2385
sub ndb_mgmd_start ($$) {
  my ($cluster, $ndb_mgmd)= @_;
unknown's avatar
unknown committed
2386

unknown's avatar
unknown committed
2387 2388 2389 2390 2391 2392
  mtr_verbose("ndb_mgmd_start");

  my $dir= $ndb_mgmd->value("DataDir");
  mkpath($dir) unless -d $dir;

  my $args;
unknown's avatar
unknown committed
2393
  mtr_init_args(\$args);
unknown's avatar
unknown committed
2394 2395 2396
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $cluster->suffix());
  mtr_add_arg($args, "--mycnf");
2397
  mtr_add_arg($args, "--nodaemon");
unknown's avatar
unknown committed
2398

unknown's avatar
unknown committed
2399
  my $path_ndb_mgmd_log= "$dir/ndb_mgmd.log";
unknown's avatar
unknown committed
2400

unknown's avatar
unknown committed
2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411
  $ndb_mgmd->{'proc'}= My::SafeProcess->new
    (
     name          => $ndb_mgmd->after('cluster_config.'),
     path          => $exe_ndb_mgmd,
     args          => \$args,
     output        => $path_ndb_mgmd_log,
     error         => $path_ndb_mgmd_log,
     append        => 1,
     verbose       => $opt_verbose,
    );
  mtr_verbose("Started $ndb_mgmd->{proc}");
unknown's avatar
unknown committed
2412

2413 2414 2415
  # FIXME Should not be needed
  # Unfortunately the cluster nodes will fail to start
  # if ndb_mgmd has not started properly
2416
  if (ndb_mgmd_wait_started($cluster))
2417
  {
unknown's avatar
unknown committed
2418 2419
    mtr_warning("Failed to wait for start of ndb_mgmd");
    return 1;
2420
  }
2421

unknown's avatar
unknown committed
2422
  return 0;
unknown's avatar
unknown committed
2423 2424 2425
}


unknown's avatar
unknown committed
2426 2427 2428 2429
sub ndbd_start {
  my ($cluster, $ndbd)= @_;

  mtr_verbose("ndbd_start");
unknown's avatar
unknown committed
2430

unknown's avatar
unknown committed
2431 2432
  my $dir= $ndbd->value("DataDir");
  mkpath($dir) unless -d $dir;
unknown's avatar
unknown committed
2433

unknown's avatar
unknown committed
2434
  my $args;
unknown's avatar
unknown committed
2435
  mtr_init_args(\$args);
unknown's avatar
unknown committed
2436 2437
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $cluster->suffix());
unknown's avatar
unknown committed
2438 2439
  mtr_add_arg($args, "--nodaemon");

unknown's avatar
unknown committed
2440
# > 5.0 { 'character-sets-dir' => \&fix_charset_dir },
unknown's avatar
unknown committed
2441 2442


unknown's avatar
unknown committed
2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454
  my $path_ndbd_log= "$dir/ndbd.log";
  my $proc= My::SafeProcess->new
    (
     name          => $ndbd->after('cluster_config.'),
     path          => $exe_ndbd,
     args          => \$args,
     output        => $path_ndbd_log,
     error         => $path_ndbd_log,
     append        => 1,
     verbose       => $opt_verbose,
    );
  mtr_verbose("Started $proc");
2455

unknown's avatar
unknown committed
2456
  $ndbd->{proc}= $proc;
unknown's avatar
unknown committed
2457

unknown's avatar
unknown committed
2458
  return;
unknown's avatar
unknown committed
2459 2460 2461
}


unknown's avatar
unknown committed
2462
sub ndbcluster_start ($) {
unknown's avatar
unknown committed
2463 2464
  my $cluster= shift;

unknown's avatar
unknown committed
2465
  mtr_verbose("ndbcluster_start '".$cluster->name()."'");
unknown's avatar
unknown committed
2466

unknown's avatar
unknown committed
2467
  foreach my $ndb_mgmd ( in_cluster($cluster, ndb_mgmds()) )
2468
  {
unknown's avatar
unknown committed
2469 2470
    next if started($ndb_mgmd);
    ndb_mgmd_start($cluster, $ndb_mgmd);
2471 2472
  }

unknown's avatar
unknown committed
2473
  foreach my $ndbd ( in_cluster($cluster, ndbds()) )
unknown's avatar
unknown committed
2474
  {
unknown's avatar
unknown committed
2475 2476
    next if started($ndbd);
    ndbd_start($cluster, $ndbd);
unknown's avatar
unknown committed
2477 2478
  }

unknown's avatar
unknown committed
2479 2480 2481 2482
  return 0;
}


unknown's avatar
unknown committed
2483 2484 2485 2486 2487
sub create_config_file_for_extern {
  my %opts=
    (
     socket     => '/tmp/mysqld.sock',
     port       => 3306,
2488
     user       => $opt_user,
unknown's avatar
unknown committed
2489 2490 2491
     password   => '',
     @_
    );
unknown's avatar
unknown committed
2492

unknown's avatar
unknown committed
2493 2494 2495 2496 2497 2498 2499 2500
  mtr_report("Creating my.cnf file for extern server...");
  my $F= IO::File->new($path_config_file, "w")
    or mtr_error("Can't write to $path_config_file: $!");

  print $F "[client]\n";
  while (my ($option, $value)= each( %opts )) {
    print $F "$option= $value\n";
    mtr_report(" $option= $value");
unknown's avatar
unknown committed
2501 2502
  }

unknown's avatar
unknown committed
2503
  print $F <<EOF
unknown's avatar
unknown committed
2504

unknown's avatar
unknown committed
2505 2506 2507
# binlog reads from [client] and [mysqlbinlog]
[mysqlbinlog]
character-sets-dir= $path_charsetsdir
unknown's avatar
unknown committed
2508

unknown's avatar
unknown committed
2509 2510 2511 2512 2513 2514
# mysql_fix_privilege_tables.sh don't read from [client]
[mysql_fix_privilege_tables]
socket            = $opts{'socket'}
port              = $opts{'port'}
user              = $opts{'user'}
password          = $opts{'password'}
unknown's avatar
unknown committed
2515

unknown's avatar
unknown committed
2516

unknown's avatar
unknown committed
2517 2518
EOF
;
2519

unknown's avatar
unknown committed
2520 2521
  $F= undef; # Close file
}
2522

unknown's avatar
unknown committed
2523

unknown's avatar
unknown committed
2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538
#
# Kill processes left from previous runs, normally
# there should be none so make sure to warn
# if there is one
#
sub kill_leftovers ($) {
  my $rundir= shift;
  return unless ( -d $rundir );

  mtr_report("Checking leftover processes...");

  # Scan the "run" directory for process id's to kill
  opendir(RUNDIR, $rundir)
    or mtr_error("kill_leftovers, can't open dir \"$rundir\": $!");
  while ( my $elem= readdir(RUNDIR) )
unknown's avatar
unknown committed
2539
  {
unknown's avatar
unknown committed
2540 2541
    # Only read pid from files that end with .pid
    if ( $elem =~ /.*[.]pid$/ )
2542
    {
unknown's avatar
unknown committed
2543 2544 2545 2546 2547 2548 2549 2550 2551 2552
      my $pidfile= "$rundir/$elem";
      next unless -f $pidfile;
      my $pid= mtr_fromfile($pidfile);
      unlink($pidfile);
      unless ($pid=~ /^(\d+)/){
	# The pid was not a valid number
	mtr_warning("Got invalid pid '$pid' from '$elem'");
	next;
      }
      mtr_report(" - found old pid $pid in '$elem', killing it...");
unknown's avatar
unknown committed
2553

2554
      my $ret= kill("KILL", $pid);
unknown's avatar
unknown committed
2555 2556 2557 2558
      if ($ret == 0) {
	mtr_report("   process did not exist!");
	next;
      }
unknown's avatar
unknown committed
2559

unknown's avatar
unknown committed
2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571
      my $check_counter= 100;
      while ($ret > 0 and $check_counter--) {
	mtr_milli_sleep(100);
	$ret= kill(0, $pid);
      }
      mtr_report($check_counter ? "   ok!" : "   failed!");
    }
    else
    {
      mtr_warning("Found non pid file '$elem' in '$rundir'")
	if -f "$rundir/$elem";
    }
unknown's avatar
unknown committed
2572
  }
unknown's avatar
unknown committed
2573 2574
  closedir(RUNDIR);
}
unknown's avatar
unknown committed
2575

unknown's avatar
unknown committed
2576 2577 2578 2579
#
# Check that all the ports that are going to
# be used are free
#
2580
sub check_ports_free ($)
unknown's avatar
unknown committed
2581
{
2582 2583 2584 2585 2586 2587
  my $bthread= shift;
  my $portbase = $bthread * 10 + 10000;
  for ($portbase..$portbase+9){
    if (mtr_ping_port($_)){
      mtr_report(" - 'localhost:$_' was not free");
      return 0; # One port was not free
unknown's avatar
unknown committed
2588
    }
unknown's avatar
unknown committed
2589 2590
  }

2591
  return 1; # All ports free
unknown's avatar
unknown committed
2592 2593 2594
}


unknown's avatar
unknown committed
2595
sub initialize_servers {
2596

unknown's avatar
unknown committed
2597
  if ( using_extern() )
2598 2599 2600 2601 2602 2603 2604 2605 2606
  {
    # Running against an already started server, if the specified
    # vardir does not already exist it should be created
    if ( ! -d $opt_vardir )
    {
      setup_vardir();
    }
    else
    {
2607
      mtr_verbose("No need to create '$opt_vardir' it already exists");
2608 2609 2610
    }
  }
  else
2611
  {
unknown's avatar
unknown committed
2612 2613 2614 2615
    # Kill leftovers from previous run
    # using any pidfiles found in var/run
    kill_leftovers("$opt_vardir/run");

2616
    if ( ! $opt_start_dirty )
2617
    {
2618 2619 2620
      remove_stale_vardir();
      setup_vardir();

Magnus Svensson's avatar
Magnus Svensson committed
2621
      mysql_install_db(default_mysqld(), "$opt_vardir/install.db");
2622
    }
2623
  }
unknown's avatar
unknown committed
2624 2625 2626
}


unknown's avatar
unknown committed
2627
#
2628
# Remove all newline characters expect after semicolon
unknown's avatar
unknown committed
2629
#
2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647
sub sql_to_bootstrap {
  my ($sql) = @_;
  my @lines= split(/\n/, $sql);
  my $result= "\n";
  my $delimiter= ';';

  foreach my $line (@lines) {

    # Change current delimiter if line starts with "delimiter"
    if ( $line =~ /^delimiter (.*)/ ) {
      my $new= $1;
      # Remove old delimiter from end of new
      $new=~ s/\Q$delimiter\E$//;
      $delimiter = $new;
      mtr_debug("changed delimiter to $delimiter");
      # No need to add the delimiter to result
      next;
    }
2648

2649 2650 2651 2652 2653 2654 2655 2656
    # Add newline if line ends with $delimiter
    # and convert the current delimiter to semicolon
    if ( $line =~ /\Q$delimiter\E$/ ){
      $line =~ s/\Q$delimiter\E$/;/;
      $result.= "$line\n";
      mtr_debug("Added default delimiter");
      next;
    }
2657

2658 2659 2660 2661 2662 2663
    # Remove comments starting with --
    if ( $line =~ /^\s*--/ ) {
      mtr_debug("Discarded $line");
      next;
    }

2664 2665 2666
    # Replace @HOSTNAME with localhost
    $line=~ s/\'\@HOSTNAME\@\'/localhost/;

2667 2668 2669 2670 2671 2672
    # Default, just add the line without newline
    # but with a space as separator
    $result.= "$line ";

  }
  return $result;
2673 2674 2675
}


Magnus Svensson's avatar
Magnus Svensson committed
2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695
sub default_mysqld {
  # Generate new config file from template
  my $config= My::ConfigFactory->new_config
    ( {
       basedir         => $basedir,
       template_path   => "include/default_my.cnf",
       vardir          => $opt_vardir,
       tmpdir          => $opt_tmpdir,
       baseport        => 0,
       user            => $opt_user,
       password        => '',
      }
    );

  my $mysqld= $config->group('mysqld.1')
    or mtr_error("Couldn't find mysqld.1 in default config");
  return $mysqld;
}


unknown's avatar
unknown committed
2696
sub mysql_install_db {
Magnus Svensson's avatar
Magnus Svensson committed
2697 2698 2699 2700 2701 2702
  my ($mysqld, $datadir)= @_;

  my $install_datadir= $datadir || $mysqld->value('datadir');
  my $install_basedir= $mysqld->value('basedir');
  my $install_lang= $mysqld->value('language');
  my $install_chsdir= $mysqld->value('character-sets-dir');
unknown's avatar
unknown committed
2703

unknown's avatar
unknown committed
2704
  mtr_report("Installing system database...");
unknown's avatar
unknown committed
2705

2706
  my $args;
unknown's avatar
unknown committed
2707 2708 2709
  mtr_init_args(\$args);
  mtr_add_arg($args, "--no-defaults");
  mtr_add_arg($args, "--bootstrap");
Magnus Svensson's avatar
Magnus Svensson committed
2710 2711
  mtr_add_arg($args, "--basedir=%s", $install_basedir);
  mtr_add_arg($args, "--datadir=%s", $install_datadir);
unknown's avatar
unknown committed
2712
  mtr_add_arg($args, "--loose-skip-innodb");
2713
  mtr_add_arg($args, "--loose-skip-falcon");
unknown's avatar
unknown committed
2714
  mtr_add_arg($args, "--loose-skip-ndbcluster");
2715
  mtr_add_arg($args, "--tmpdir=%s", "$opt_vardir/tmp/");
2716
  mtr_add_arg($args, "--core-file");
unknown's avatar
unknown committed
2717

2718 2719
  if ( $opt_debug )
  {
unknown's avatar
unknown committed
2720 2721
    mtr_add_arg($args, "--debug=d:t:i:A,%s/log/bootstrap.trace",
		$path_vardir_trace);
2722 2723
  }

Magnus Svensson's avatar
Magnus Svensson committed
2724 2725
  mtr_add_arg($args, "--language=%s", $install_lang);
  mtr_add_arg($args, "--character-sets-dir=%s", $install_chsdir);
unknown's avatar
unknown committed
2726

2727 2728 2729 2730 2731
  # If DISABLE_GRANT_OPTIONS is defined when the server is compiled (e.g.,
  # configure --disable-grant-options), mysqld will not recognize the
  # --bootstrap or --skip-grant-tables options.  The user can set
  # MYSQLD_BOOTSTRAP to the full path to a mysqld which does accept
  # --bootstrap, to accommodate this.
Magnus Svensson's avatar
Magnus Svensson committed
2732 2733
  my $exe_mysqld_bootstrap =
    $ENV{'MYSQLD_BOOTSTRAP'} || find_mysqld($install_basedir);
2734

2735 2736 2737 2738 2739
  # ----------------------------------------------------------------------
  # export MYSQLD_BOOTSTRAP_CMD variable containing <path>/mysqld <args>
  # ----------------------------------------------------------------------
  $ENV{'MYSQLD_BOOTSTRAP_CMD'}= "$exe_mysqld_bootstrap " . join(" ", @$args);

Magnus Svensson's avatar
Magnus Svensson committed
2740

2741

2742 2743 2744
  # ----------------------------------------------------------------------
  # Create the bootstrap.sql file
  # ----------------------------------------------------------------------
2745
  my $bootstrap_sql_file= "$opt_vardir/tmp/bootstrap.sql";
2746

Magnus Svensson's avatar
Magnus Svensson committed
2747
  my $path_sql= my_find_file($install_basedir,
2748 2749
			     ["mysql", "sql/share", "share/mysql",
			      "share", "scripts"],
Magnus Svensson's avatar
Magnus Svensson committed
2750 2751 2752 2753
			     "mysql_system_tables.sql",
			     NOT_REQUIRED);

  if (-f $path_sql )
2754
  {
Magnus Svensson's avatar
Magnus Svensson committed
2755
    my $sql_dir= dirname($path_sql);
2756 2757
    # Use the mysql database for system tables
    mtr_tofile($bootstrap_sql_file, "use mysql\n");
2758

2759 2760
    # Add the offical mysql system tables
    # for a production system
Magnus Svensson's avatar
Magnus Svensson committed
2761
    mtr_appendfile_to_file("$sql_dir/mysql_system_tables.sql",
2762
			   $bootstrap_sql_file);
2763

2764 2765
    # Add the mysql system tables initial data
    # for a production system
Magnus Svensson's avatar
Magnus Svensson committed
2766
    mtr_appendfile_to_file("$sql_dir/mysql_system_tables_data.sql",
2767
			   $bootstrap_sql_file);
2768

2769 2770 2771
    # Add test data for timezone - this is just a subset, on a real
    # system these tables will be populated either by mysql_tzinfo_to_sql
    # or by downloading the timezone table package from our website
Magnus Svensson's avatar
Magnus Svensson committed
2772 2773 2774 2775 2776 2777 2778
    mtr_appendfile_to_file("$sql_dir/mysql_test_data_timezone.sql",
			   $bootstrap_sql_file);

    # Fill help tables, just an empty file when running from bk repo
    # but will be replaced by a real fill_help_tables.sql when
    # building the source dist
    mtr_appendfile_to_file("$sql_dir/fill_help_tables.sql",
2779 2780 2781 2782 2783 2784 2785
			   $bootstrap_sql_file);

  }
  else
  {
    # Install db from init_db.sql that exist in early 5.1 and 5.0
    # versions of MySQL
Magnus Svensson's avatar
Magnus Svensson committed
2786
    my $init_file= "$install_basedir/mysql-test/lib/init_db.sql";
2787 2788 2789 2790 2791 2792 2793
    mtr_report(" - from '$init_file'");
    my $text= mtr_grab_file($init_file) or
      mtr_error("Can't open '$init_file': $!");

    mtr_tofile($bootstrap_sql_file,
	       sql_to_bootstrap($text));
  }
2794

2795
  # Remove anonymous users
2796
  mtr_tofile($bootstrap_sql_file,
unknown's avatar
unknown committed
2797 2798 2799 2800 2801
	     "DELETE FROM mysql.user where user= '';\n");

  # Create mtr database
  mtr_tofile($bootstrap_sql_file,
	     "CREATE DATABASE mtr;\n");
2802

2803 2804 2805 2806
  # Add help tables and data for warning detection and supression
  mtr_tofile($bootstrap_sql_file,
             sql_to_bootstrap(mtr_grab_file("include/mtr_warnings.sql")));

2807 2808 2809 2810
  # Add procedures for checking server is restored after testcase
  mtr_tofile($bootstrap_sql_file,
             sql_to_bootstrap(mtr_grab_file("include/mtr_check.sql")));

2811 2812 2813
  # Log bootstrap command
  my $path_bootstrap_log= "$opt_vardir/log/bootstrap.log";
  mtr_tofile($path_bootstrap_log,
2814
	     "$exe_mysqld_bootstrap " . join(" ", @$args) . "\n");
2815

unknown's avatar
unknown committed
2816
  # Create directories mysql and test
Magnus Svensson's avatar
Magnus Svensson committed
2817 2818
  mkpath("$install_datadir/mysql");
  mkpath("$install_datadir/test");
unknown's avatar
unknown committed
2819 2820 2821 2822 2823 2824 2825 2826 2827 2828

  if ( My::SafeProcess->run
       (
	name          => "bootstrap",
	path          => $exe_mysqld_bootstrap,
	args          => \$args,
	input         => $bootstrap_sql_file,
	output        => $path_bootstrap_log,
	error         => $path_bootstrap_log,
	append        => 1,
2829
	verbose       => $opt_verbose,
unknown's avatar
unknown committed
2830
       ) != 0)
unknown's avatar
unknown committed
2831
  {
unknown's avatar
unknown committed
2832
    mtr_error("Error executing mysqld --bootstrap\n" .
2833 2834
              "Could not install system database from $bootstrap_sql_file\n" .
	      "see $path_bootstrap_log for errors");
unknown's avatar
unknown committed
2835 2836 2837 2838
  }
}


2839 2840 2841
sub run_testcase_check_skip_test($)
{
  my ($tinfo)= @_;
2842

unknown's avatar
unknown committed
2843 2844 2845 2846 2847 2848 2849 2850 2851
  # ----------------------------------------------------------------------
  # 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'} )
  {
2852
    mtr_report_test_skipped($tinfo) unless $start_only;
2853
    return 1;
unknown's avatar
unknown committed
2854 2855
  }

unknown's avatar
unknown committed
2856 2857 2858
  return 0;
}

2859

2860 2861
sub run_query {
  my ($tinfo, $mysqld, $query)= @_;
2862 2863 2864 2865 2866

  my $args;
  mtr_init_args(\$args);
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $mysqld->after('mysqld'));
2867 2868 2869

  mtr_add_arg($args, "-e %s", $query);

2870 2871
  my $res= My::SafeProcess->run
    (
2872
     name          => "run_query -> ".$mysqld->name(),
2873 2874
     path          => $exe_mysql,
     args          => \$args,
2875 2876
     output        => '/dev/null',
     error         => '/dev/null'
unknown's avatar
unknown committed
2877 2878
    );

2879
  return $res
2880
}
unknown's avatar
unknown committed
2881

2882

2883 2884 2885 2886
sub do_before_run_mysqltest($)
{
  my $tinfo= shift;

2887
  # Remove old files produced by mysqltest
2888 2889 2890 2891 2892 2893 2894 2895
  my $base_file= mtr_match_extension($tinfo->{result_file},
				     "result"); # Trim extension
  if (defined $base_file ){
    unlink("$base_file.reject");
    unlink("$base_file.progress");
    unlink("$base_file.log");
    unlink("$base_file.warnings");
  }
2896

unknown's avatar
unknown committed
2897 2898 2899 2900 2901 2902 2903 2904
  if ( $mysql_version_id < 50000 ) {
    # Set environment variable NDB_STATUS_OK to 1
    # if script decided to run mysqltest cluster _is_ installed ok
    $ENV{'NDB_STATUS_OK'} = "1";
  } elsif ( $mysql_version_id < 50100 ) {
    # Set environment variable NDB_STATUS_OK to YES
    # if script decided to run mysqltest cluster _is_ installed ok
    $ENV{'NDB_STATUS_OK'} = "YES";
2905
  }
2906
}
unknown's avatar
unknown committed
2907

2908

2909 2910 2911 2912 2913 2914 2915 2916
#
# Check all server for sideffects
#
# RETURN VALUE
#  0 ok
#  1 Check failed
#  >1 Fatal errro

2917
sub check_testcase($$)
2918
{
unknown's avatar
unknown committed
2919
  my ($tinfo, $mode)= @_;
2920
  my $tname= $tinfo->{name};
2921

2922 2923 2924
  # Start the mysqltest processes in parallel to save time
  # also makes it possible to wait for any process to exit during the check
  my %started;
unknown's avatar
unknown committed
2925
  foreach my $mysqld ( mysqlds() )
2926
  {
unknown's avatar
unknown committed
2927 2928
    if ( defined $mysqld->{'proc'} )
    {
2929 2930 2931 2932 2933
      my $proc= start_check_testcase($tinfo, $mode, $mysqld);
      $started{$proc->pid()}= $proc;
    }
  }

2934 2935 2936
  # Return immediately if no check proceess was started
  return 0 unless ( keys %started );

2937 2938
  my $timeout_proc= My::SafeProcess->timer(check_timeout());

2939 2940 2941 2942 2943 2944
  while (1){
    my $result;
    my $proc= My::SafeProcess->wait_any();
    mtr_report("Got $proc");

    if ( delete $started{$proc->pid()} ) {
2945 2946 2947 2948

      my $err_file= $proc->user_data();
      my $base_file= mtr_match_extension($err_file, "err"); # Trim extension

2949 2950 2951 2952 2953 2954
      # One check testcase process returned
      my $res= $proc->exit_status();

      if ( $res == 0){
	# Check completed without problem

2955 2956 2957
	# Remove the .err file the check generated
	unlink($err_file);

2958 2959 2960 2961 2962
	# Remove the .result file the check generated
	if ( $mode eq 'after' ){
	  unlink("$base_file.result");
	}

2963 2964
	if ( keys(%started) == 0){
	  # All checks completed
2965 2966 2967

	  $timeout_proc->kill();

2968 2969 2970 2971 2972 2973
	  return 0;
	}
	# Wait for next process to exit
	next;
      }
      else
unknown's avatar
unknown committed
2974
      {
2975 2976 2977
	if ( $mode eq "after" and $res == 1 )
	{
	  # Test failed, grab the report mysqltest has created
2978
	  my $report= mtr_grab_file($err_file);
2979
	  $tinfo->{check}.=
2980 2981 2982 2983 2984 2985
	    "\nMTR's internal check of the test case '$tname' failed.
This means that the test case does not preserve the state that existed
before the test case was executed.  Most likely the test case did not
do a proper clean-up.
This is the diff of the states of the servers before and after the
test case was executed:\n";
2986 2987 2988 2989 2990 2991 2992 2993
	  $tinfo->{check}.= $report;

	  # Check failed, mark the test case with that info
	  $tinfo->{'check_testcase_failed'}= 1;
	  $result= 1;
	}
	elsif ( $res )
	{
2994
	  my $report= mtr_grab_file($err_file);
2995
	  $tinfo->{comment}.=
2996 2997
	    "Could not execute 'check-testcase' $mode ".
	      "testcase '$tname' (res: $res):\n";
2998 2999 3000 3001 3002
	  $tinfo->{comment}.= $report;

	  $result= 2;
	}

3003 3004 3005
	# Remove the .result file the check generated
	unlink("$base_file.result");

unknown's avatar
unknown committed
3006 3007
      }
    }
3008 3009 3010 3011 3012 3013
    elsif ( $proc eq $timeout_proc ) {
      $tinfo->{comment}.= "Timeout $timeout_proc for ".
	"'check-testcase' expired after ".check_timeout().
	  " seconds";
      $result= 4;
    }
3014 3015 3016
    else {
      # Unknown process returned, most likley a crash, abort everything
      $tinfo->{comment}=
3017 3018
	"The server $proc crashed while running ".
	"'check testcase $mode test'";
3019 3020 3021 3022 3023 3024
      $result= 3;
    }

    # Kill any check processes still running
    map($_->kill(), values(%started));

3025 3026
    $timeout_proc->kill();

3027
    return $result;
3028
  }
3029 3030

  mtr_error("INTERNAL_ERROR: check_testcase");
unknown's avatar
unknown committed
3031
}
3032

3033

3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063
# Start run mysqltest on one server
#
# RETURN VALUE
#  0 OK
#  1 Check failed
#
sub start_run_one ($$) {
  my ($mysqld, $run)= @_;

  my $name= "$run-".$mysqld->name();

  my $args;
  mtr_init_args(\$args);

  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $mysqld->after('mysqld'));

  mtr_add_arg($args, "--silent");
  mtr_add_arg($args, "--skip-safemalloc");
  mtr_add_arg($args, "--test-file=%s", "include/$run.test");

  my $errfile= "$opt_vardir/tmp/$name.err";
  my $proc= My::SafeProcess->new
    (
     name          => $name,
     path          => $exe_mysqltest,
     error         => $errfile,
     output        => $errfile,
     args          => \$args,
     user_data     => $errfile,
Magnus Svensson's avatar
Magnus Svensson committed
3064
     verbose       => $opt_verbose,
3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097
    );
  mtr_verbose("Started $proc");
  return $proc;
}


#
# Run script on all servers, collect results
#
# RETURN VALUE
#  0 ok
#  1 Failure

sub run_on_all($$)
{
  my ($tinfo, $run)= @_;

  # Start the mysqltest processes in parallel to save time
  # also makes it possible to wait for any process to exit during the check
  # and to have a timeout process
  my %started;
  foreach my $mysqld ( mysqlds() )
  {
    if ( defined $mysqld->{'proc'} )
    {
      my $proc= start_run_one($mysqld, $run);
      $started{$proc->pid()}= $proc;
    }
  }

  # Return immediately if no check proceess was started
  return 0 unless ( keys %started );

3098
  my $timeout_proc= My::SafeProcess->timer(check_timeout());
3099 3100 3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128

  while (1){
    my $result;
    my $proc= My::SafeProcess->wait_any();
    mtr_report("Got $proc");

    if ( delete $started{$proc->pid()} ) {

      # One mysqltest process returned
      my $err_file= $proc->user_data();
      my $res= $proc->exit_status();

      # Append the report from .err file
      $tinfo->{comment}.= " == $err_file ==\n";
      $tinfo->{comment}.= mtr_grab_file($err_file);
      $tinfo->{comment}.= "\n";

      # Remove the .err file
      unlink($err_file);

      if ( keys(%started) == 0){
	# All completed
	$timeout_proc->kill();
	return 0;
      }

      # Wait for next process to exit
      next;
    }
    elsif ( $proc eq $timeout_proc ) {
3129 3130 3131
      $tinfo->{comment}.= "Timeout $timeout_proc for '$run' ".
	"expired after ". check_timeout().
	  " seconds";
3132 3133 3134 3135
    }
    else {
      # Unknown process returned, most likley a crash, abort everything
      $tinfo->{comment}.=
3136
	"The server $proc crashed while running '$run'";
3137 3138 3139 3140 3141 3142 3143 3144 3145
    }

    # Kill any check processes still running
    map($_->kill(), values(%started));

    $timeout_proc->kill();

    return 1;
  }
3146
  mtr_error("INTERNAL_ERROR: run_on_all");
3147 3148 3149
}


unknown's avatar
unknown committed
3150 3151 3152 3153
sub mark_log {
  my ($log, $tinfo)= @_;
  my $log_msg= "CURRENT_TEST: $tinfo->{name}\n";
  mtr_tofile($log, $log_msg);
3154 3155
}

unknown's avatar
unknown committed
3156

3157 3158 3159 3160
sub find_testcase_skipped_reason($)
{
  my ($tinfo)= @_;

3161 3162 3163
  # Set default message
  $tinfo->{'comment'}= "Detected by testcase(no log file)";

3164 3165
  # Open the test log file
  my $F= IO::File->new($path_current_testlog)
3166
    or return;
3167 3168 3169 3170
  my $reason;

  while ( my $line= <$F> )
  {
unknown's avatar
unknown committed
3171
    # Look for "reason: <reason for skipping test>"
3172
    if ( $line =~ /reason: (.*)/ )
unknown's avatar
unknown committed
3173
    {
3174 3175 3176
      $reason= $1;
    }
  }
3177

3178 3179
  if ( ! $reason )
  {
3180
    mtr_warning("Could not find reason for skipping test in $path_current_testlog");
3181
    $reason= "Detected by testcase(reason unknown) ";
3182
  }
3183 3184 3185 3186
  $tinfo->{'comment'}= $reason;
}


3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206
sub find_analyze_request
{
  # Open the test log file
  my $F= IO::File->new($path_current_testlog)
    or return;
  my $analyze;

  while ( my $line= <$F> )
  {
    # Look for "reason: <reason for skipping test>"
    if ( $line =~ /analyze: (.*)/ )
    {
      $analyze= $1;
    }
  }

  return $analyze;
}


3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226
# The test can leave a file in var/tmp/ to signal
# that all servers should be restarted
sub restart_forced_by_test
{
  my $restart = 0;
  foreach my $mysqld ( mysqlds() )
  {
    my $datadir = $mysqld->value('datadir');
    my $force_restart_file = "$datadir/mtr/force_restart";
    if ( -f $force_restart_file )
    {
      mtr_verbose("Restart of servers forced by test");
      $restart = 1;
      last;
    }
  }
  return $restart;
}


unknown's avatar
unknown committed
3227 3228 3229 3230 3231
# Return timezone value of tinfo or default value
sub timezone {
  my ($tinfo)= @_;
  return $tinfo->{timezone} || "GMT-3";
}
3232 3233


unknown's avatar
unknown committed
3234 3235
# Storage for changed environment variables
my %old_env;
3236

unknown's avatar
unknown committed
3237 3238 3239
#
# Run a single test case
#
unknown's avatar
unknown committed
3240 3241 3242 3243 3244
# RETURN VALUE
#  0 OK
#  > 0 failure
#

3245 3246 3247
sub run_testcase ($) {
  my $tinfo=  shift;

unknown's avatar
unknown committed
3248 3249
  mtr_verbose("Running test:", $tinfo->{name});

3250 3251 3252 3253 3254 3255
  # Allow only alpanumerics pluss _ - + . in combination names
  my $combination= $tinfo->{combination};
  if ($combination && $combination !~ /^\w[\w-\.\+]+$/)
  {
    mtr_error("Combination '$combination' contains illegal characters");
  }
3256 3257 3258
  # -------------------------------------------------------
  # Init variables that can change between each test case
  # -------------------------------------------------------
unknown's avatar
unknown committed
3259 3260 3261
  my $timezone= timezone($tinfo);
  $ENV{'TZ'}= $timezone;
  mtr_verbose("Setting timezone: $timezone");
3262

unknown's avatar
unknown committed
3263
  if ( ! using_extern() )
3264
  {
unknown's avatar
unknown committed
3265 3266 3267
    my @restart= servers_need_restart($tinfo);
    if ( @restart != 0) {
      stop_servers($tinfo, @restart );
3268
    }
unknown's avatar
unknown committed
3269

unknown's avatar
unknown committed
3270 3271
    if ( started(all_servers()) == 0 )
    {
3272 3273

      # Remove old datadirs
3274
      clean_datadir() unless $opt_start_dirty;
3275

unknown's avatar
unknown committed
3276 3277 3278 3279 3280
      # Restore old ENV
      while (my ($option, $value)= each( %old_env )) {
	if (defined $value){
	  mtr_verbose("Restoring $option to $value");
	  $ENV{$option}= $value;
Sven Sandberg's avatar
Sven Sandberg committed
3281

unknown's avatar
unknown committed
3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292 3293 3294 3295 3296 3297 3298
	} else {
	  mtr_verbose("Removing $option");
	  delete($ENV{$option});
	}
      }
      %old_env= ();

      mtr_verbose("Generating my.cnf from '$tinfo->{template_path}'");

      # Generate new config file from template
      $config= My::ConfigFactory->new_config
	( {
	   basedir         => $basedir,
	   template_path   => $tinfo->{template_path},
	   extra_template_path => $tinfo->{extra_template_path},
	   vardir          => $opt_vardir,
	   tmpdir          => $opt_tmpdir,
3299
	   baseport        => $baseport,
unknown's avatar
unknown committed
3300 3301 3302
	   #hosts          => [ 'host1', 'host2' ],
	   user            => $opt_user,
	   password        => '',
3303
	   ssl             => $opt_ssl_supported,
unknown's avatar
unknown committed
3304
	   embedded        => $opt_embedded_server,
unknown's avatar
unknown committed
3305 3306
	  }
	);
3307

unknown's avatar
unknown committed
3308 3309
      # Write the new my.cnf
      $config->save($path_config_file);
3310

unknown's avatar
unknown committed
3311 3312 3313 3314 3315 3316 3317 3318 3319 3320 3321 3322 3323 3324 3325 3326 3327 3328
      # Remember current config so a restart can occur when a test need
      # to use a different one
      $current_config_name= $tinfo->{template_path};

      #
      # Set variables in the ENV section
      #
      foreach my $option ($config->options_in_group("ENV"))
      {
	# Save old value to restore it before next time
	$old_env{$option->name()}= $ENV{$option->name()};

	mtr_verbose($option->name(), "=",$option->value());
	$ENV{$option->name()}= $option->value();
      }
    }

    # Write start of testcase to log
3329
    mark_log($path_current_testlog, $tinfo);
unknown's avatar
unknown committed
3330 3331

    if (start_servers($tinfo))
unknown's avatar
unknown committed
3332
    {
3333 3334
      report_failure_and_restart($tinfo);
      return 1;
unknown's avatar
unknown committed
3335
    }
3336
  }
unknown's avatar
unknown committed
3337

unknown's avatar
unknown committed
3338 3339
  # --------------------------------------------------------------------
  # If --start or --start-dirty given, stop here to let user manually
3340
  # run tests
3341 3342
  # If --wait-all is also given, do the same, but don't die if one
  # server exits
unknown's avatar
unknown committed
3343
  # ----------------------------------------------------------------------
3344

3345
  if ( $start_only )
unknown's avatar
unknown committed
3346
  {
unknown's avatar
unknown committed
3347
    mtr_print("\nStarted", started(all_servers()));
3348 3349 3350 3351 3352 3353 3354
    mtr_print("Using config for test", $tinfo->{name});
    mtr_print("Port and socket path for server(s):");
    foreach my $mysqld ( mysqlds() )
    {
      mtr_print ($mysqld->name() . "  " . $mysqld->value('port') .
	      "  " . $mysqld->value('socket'));
    }
unknown's avatar
unknown committed
3355
    mtr_print("Waiting for server(s) to exit...");
3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368
    if ( $opt_wait_all ) {
      My::SafeProcess->wait_all();
      mtr_print( "All servers exited" );
      exit(1);
    }
    else {
      my $proc= My::SafeProcess->wait_any();
      if ( grep($proc eq $_, started(all_servers())) )
      {
        mtr_print("Server $proc died");
        exit(1);
      }
      mtr_print("Unknown process $proc died");
3369 3370
      exit(1);
    }
unknown's avatar
unknown committed
3371 3372
  }

3373
  my $test_timeout_proc= My::SafeProcess->timer(testcase_timeout());
unknown's avatar
unknown committed
3374 3375 3376

  do_before_run_mysqltest($tinfo);

3377 3378 3379
  if ( $opt_check_testcases and check_testcase($tinfo, "before") ){
    # Failed to record state of server or server crashed
    report_failure_and_restart($tinfo);
3380 3381 3382 3383

    # Stop the test case timer
    $test_timeout_proc->kill();

3384
    return 1;
unknown's avatar
unknown committed
3385
  }
3386

unknown's avatar
unknown committed
3387
  my $test= start_mysqltest($tinfo);
3388 3389
  # Set only when we have to keep waiting after expectedly died server
  my $keep_waiting_proc = 0;
3390

unknown's avatar
unknown committed
3391 3392
  while (1)
  {
3393 3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404 3405 3406 3407 3408 3409 3410 3411 3412 3413 3414 3415 3416 3417 3418 3419
    my $proc;
    if ($keep_waiting_proc)
    {
      # Any other process exited?
      $proc = My::SafeProcess->check_any();
      if ($proc)
      {
	mtr_verbose ("Found exited process $proc");
	# If that was the timeout, cancel waiting
	if ( $proc eq $test_timeout_proc )
	{
	  $keep_waiting_proc = 0;
	}
      }
      else
      {
	$proc = $keep_waiting_proc;
      }
    }
    else
    {
      $proc= My::SafeProcess->wait_any();
    }

    # Will be restored if we need to keep waiting
    $keep_waiting_proc = 0;

unknown's avatar
unknown committed
3420
    unless ( defined $proc )
unknown's avatar
unknown committed
3421
    {
unknown's avatar
unknown committed
3422
      mtr_error("wait_any failed");
unknown's avatar
unknown committed
3423
    }
unknown's avatar
unknown committed
3424 3425 3426 3427 3428 3429
    mtr_verbose("Got $proc");

    # ----------------------------------------------------
    # Was it the test program that exited
    # ----------------------------------------------------
    if ($proc eq $test)
unknown's avatar
unknown committed
3430
    {
3431 3432 3433
      # Stop the test case timer
      $test_timeout_proc->kill();

unknown's avatar
unknown committed
3434 3435
      my $res= $test->exit_status();

3436
      if ($res == 0 and $opt_warnings and check_warnings($tinfo) )
unknown's avatar
unknown committed
3437
      {
3438 3439 3440 3441
	# Test case suceeded, but it has produced unexpected
	# warnings, continue in $res == 1
	$res= 1;
      }
unknown's avatar
unknown committed
3442

3443 3444
      if ( $res == 0 )
      {
3445
	my $check_res;
3446 3447
	if ( restart_forced_by_test() )
	{
3448
	  stop_all_servers($opt_shutdown_timeout);
3449 3450
	}
	elsif ( $opt_check_testcases and
3451
	     $check_res= check_testcase($tinfo, "after"))
unknown's avatar
unknown committed
3452
	{
3453 3454
	  if ($check_res == 1) {
	    # Test case had sideeffects, not fatal error, just continue
3455
	    stop_all_servers($opt_shutdown_timeout);
3456 3457 3458 3459 3460 3461 3462
	    mtr_report("Resuming tests...\n");
	  }
	  else {
	    # Test case check failed fatally, probably a server crashed
	    report_failure_and_restart($tinfo);
	    return 1;
	  }
unknown's avatar
unknown committed
3463
	}
3464
	mtr_report_test_passed($tinfo);
unknown's avatar
unknown committed
3465 3466 3467 3468 3469
      }
      elsif ( $res == 62 )
      {
	# Testcase itself tell us to skip this one
	$tinfo->{skip_detected_by_test}= 1;
3470
	# Try to get reason from test log file
unknown's avatar
unknown committed
3471 3472 3473 3474 3475 3476 3477 3478 3479 3480 3481 3482
	find_testcase_skipped_reason($tinfo);
	mtr_report_test_skipped($tinfo);
      }
      elsif ( $res == 65 )
      {
	# Testprogram killed by signal
	$tinfo->{comment}=
	  "testprogram crashed(returned code $res)";
	report_failure_and_restart($tinfo);
      }
      elsif ( $res == 1 )
      {
3483 3484 3485 3486 3487 3488 3489
	# Check if the test tool requests that
	# an analyze script should be run
	my $analyze= find_analyze_request();
	if ($analyze){
	  run_on_all($tinfo, "analyze-$analyze");
	}

unknown's avatar
unknown committed
3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500 3501
	# Test case failure reported by mysqltest
	report_failure_and_restart($tinfo);
      }
      else
      {
	# mysqltest failed, probably crashed
	$tinfo->{comment}=
	  "mysqltest failed with unexpected return code $res";
	report_failure_and_restart($tinfo);
      }

      # Save info from this testcase run to mysqltest.log
3502 3503 3504 3505 3506
      if( -f $path_current_testlog)
      {
	mtr_appendfile_to_file($path_current_testlog, $path_testlog);
	unlink($path_current_testlog);
      }
unknown's avatar
unknown committed
3507

unknown's avatar
unknown committed
3508
      return ($res == 62) ? 0 : $res;
3509

unknown's avatar
unknown committed
3510
    }
unknown's avatar
unknown committed
3511 3512 3513 3514

    # ----------------------------------------------------
    # Check if it was an expected crash
    # ----------------------------------------------------
3515 3516
    my $check_crash = check_expected_crash_and_restart($proc);
    if ($check_crash)
3517
    {
3518 3519 3520
      # Keep waiting if it returned 2, if 1 don't wait or stop waiting.
      $keep_waiting_proc = 0 if $check_crash == 1;
      $keep_waiting_proc = $proc if $check_crash == 2;
unknown's avatar
unknown committed
3521
      next;
3522
    }
unknown's avatar
unknown committed
3523

3524 3525 3526 3527 3528
    # ----------------------------------------------------
    # Stop the test case timer
    # ----------------------------------------------------
    $test_timeout_proc->kill();

unknown's avatar
unknown committed
3529 3530 3531 3532
    # ----------------------------------------------------
    # Check if it was a server that died
    # ----------------------------------------------------
    if ( grep($proc eq $_, started(all_servers())) )
unknown's avatar
unknown committed
3533
    {
unknown's avatar
unknown committed
3534 3535
      # Server failed, probably crashed
      $tinfo->{comment}=
3536
	"Server $proc failed during test run";
unknown's avatar
unknown committed
3537

3538 3539 3540 3541 3542
      # ----------------------------------------------------
      # It's not mysqltest that has exited, kill it
      # ----------------------------------------------------
      $test->kill();

unknown's avatar
unknown committed
3543
      report_failure_and_restart($tinfo);
unknown's avatar
unknown committed
3544
      return 1;
unknown's avatar
unknown committed
3545
    }
unknown's avatar
unknown committed
3546

3547 3548 3549 3550 3551 3552 3553 3554 3555 3556 3557 3558 3559 3560 3561
    # Try to dump core for mysqltest and all servers
    foreach my $proc ($test, started(all_servers())) 
    {
      mtr_print("Trying to dump core for $proc");
      if ($proc->dump_core())
      {
	$proc->wait_one(20);
      }
    }

    # ----------------------------------------------------
    # It's not mysqltest that has exited, kill it
    # ----------------------------------------------------
    $test->kill();

unknown's avatar
unknown committed
3562 3563 3564 3565
    # ----------------------------------------------------
    # Check if testcase timer expired
    # ----------------------------------------------------
    if ( $proc eq $test_timeout_proc )
unknown's avatar
unknown committed
3566
    {
Serge Kozlov's avatar
Serge Kozlov committed
3567
      my $log_file_name= $opt_vardir."/log/".$tinfo->{shortname}.".log";
3568
      $tinfo->{comment}=
3569 3570
        "Test case timeout after ".testcase_timeout().
	  " seconds\n\n";
3571
      # Add 20 last executed commands from test case log file
Serge Kozlov's avatar
Serge Kozlov committed
3572 3573 3574
      if  (-e $log_file_name)
      {
        $tinfo->{comment}.=
3575 3576
	   "== $log_file_name == \n".
	     mtr_lastlinesfromfile($log_file_name, 20)."\n";
Serge Kozlov's avatar
Serge Kozlov committed
3577
      }
3578
      $tinfo->{'timeout'}= testcase_timeout(); # Mark as timeout
3579
      run_on_all($tinfo, 'analyze-timeout');
3580

unknown's avatar
unknown committed
3581
      report_failure_and_restart($tinfo);
unknown's avatar
unknown committed
3582
      return 1;
unknown's avatar
unknown committed
3583
    }
3584

unknown's avatar
unknown committed
3585
    mtr_error("Unhandled process $proc exited");
3586
  }
unknown's avatar
unknown committed
3587
  mtr_error("Should never come here");
unknown's avatar
unknown committed
3588
}
unknown's avatar
unknown committed
3589

3590

Magnus Svensson's avatar
Magnus Svensson committed
3591 3592 3593 3594 3595
#
# Perform a rough examination of the servers
# error log and write all lines that look
# suspicious into $error_log.warnings
#
3596 3597
sub extract_warning_lines ($$) {
  my ($error_log, $tname) = @_;
Magnus Svensson's avatar
Magnus Svensson committed
3598 3599 3600 3601 3602 3603 3604

  # Open the servers .err log file and read all lines
  # belonging to current tets into @lines
  my $Ferr = IO::File->new($error_log)
    or mtr_error("Could not open file '$error_log' for reading: $!");

  my @lines;
3605
  my $found_test= 0;		# Set once we've found the log of this test
Magnus Svensson's avatar
Magnus Svensson committed
3606 3607
  while ( my $line = <$Ferr> )
  {
3608
    if ($found_test)
Magnus Svensson's avatar
Magnus Svensson committed
3609
    {
3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 3621 3622 3623 3624
      # If test wasn't last after all, discard what we found, test again.
      if ( $line =~ /^CURRENT_TEST:/)
      {
	@lines= ();
	$found_test= $line =~ /^CURRENT_TEST: $tname/;
      }
      else
      {
	push(@lines, $line);
      }
    }
    else
    {
      # Search for beginning of test, until found
      $found_test= 1 if ($line =~ /^CURRENT_TEST: $tname/);
Magnus Svensson's avatar
Magnus Svensson committed
3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638 3639 3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656
    }
  }
  $Ferr = undef; # Close error log file

  # mysql_client_test.test sends a COM_DEBUG packet to the server
  # to provoke a SAFEMALLOC leak report, ignore any warnings
  # between "Begin/end safemalloc memory dump"
  if ( grep(/Begin safemalloc memory dump:/, @lines) > 0)
  {
    my $discard_lines= 1;
    foreach my $line ( @lines )
    {
      if ($line =~ /Begin safemalloc memory dump:/){
	$discard_lines = 1;
      } elsif ($line =~ /End safemalloc memory dump./){
	$discard_lines = 0;
      }

      if ($discard_lines){
	$line = "ignored";
      }
    }
  }

  # Write all suspicious lines to $error_log.warnings file
  my $warning_log = "$error_log.warnings";
  my $Fwarn = IO::File->new($warning_log, "w")
    or die("Could not open file '$warning_log' for writing: $!");
  print $Fwarn "Suspicious lines from $error_log\n";

  my @patterns =
    (
3657 3658 3659 3660 3661
     # The patterns for detection of [Warning] and [ERROR]
     # in the server log files have been faulty for a longer period
     # and correcting them shows a few additional harmless warnings.
     # Thus those patterns are temporarily removed from the list
     # of patterns. For more info see BUG#42408
3662 3663
     qr/^Warning:|mysqld: Warning|\[Warning\]/,
     qr/^Error:|\[ERROR\]/,
3664
     qr/^==\d*==/, # valgrind errors
Magnus Svensson's avatar
Magnus Svensson committed
3665 3666 3667 3668 3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687
     qr/InnoDB: Warning|InnoDB: Error/,
     qr/^safe_mutex:|allocated at line/,
     qr/missing DBUG_RETURN/,
     qr/Attempting backtrace/,
     qr/Assertion .* failed/,
    );

  foreach my $line ( @lines )
  {
    foreach my $pat ( @patterns )
    {
      if ( $line =~ /$pat/ )
      {
	print $Fwarn $line;
	last;
      }
    }
  }
  $Fwarn = undef; # Close file

}


3688 3689 3690 3691 3692 3693
# Run include/check-warnings.test
#
# RETURN VALUE
#  0 OK
#  1 Check failed
#
3694
sub start_check_warnings ($$) {
3695 3696 3697 3698 3699
  my $tinfo=    shift;
  my $mysqld=   shift;

  my $name= "warnings-".$mysqld->name();

3700 3701 3702
  my $log_error= $mysqld->value('#log-error');
  # To be communicated to the test
  $ENV{MTR_LOG_ERROR}= $log_error;
3703
  extract_warning_lines($log_error, $tinfo->{name});
Magnus Svensson's avatar
Magnus Svensson committed
3704

3705 3706 3707 3708 3709 3710 3711 3712
  my $args;
  mtr_init_args(\$args);

  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $mysqld->after('mysqld'));

  mtr_add_arg($args, "--skip-safemalloc");
  mtr_add_arg($args, "--test-file=%s", "include/check-warnings.test");
3713
  mtr_add_arg($args, "--verbose");
3714

3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730 3731
  if ( $opt_embedded_server )
  {

    # Get the args needed for the embedded server
    # and append them to args prefixed
    # with --sever-arg=

    my $mysqld=  $config->group('embedded')
      or mtr_error("Could not get [embedded] section");

    my $mysqld_args;
    mtr_init_args(\$mysqld_args);
    my $extra_opts= get_extra_opts($mysqld, $tinfo);
    mysqld_arguments($mysqld_args, $mysqld, $extra_opts);
    mtr_add_arg($args, "--server-arg=%s", $_) for @$mysqld_args;
  }

3732
  my $errfile= "$opt_vardir/tmp/$name.err";
3733
  my $proc= My::SafeProcess->new
3734 3735 3736 3737 3738 3739
    (
     name          => $name,
     path          => $exe_mysqltest,
     error         => $errfile,
     output        => $errfile,
     args          => \$args,
3740
     user_data     => $errfile,
Magnus Svensson's avatar
Magnus Svensson committed
3741
     verbose       => $opt_verbose,
3742
    );
3743 3744
  mtr_verbose("Started $proc");
  return $proc;
3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755
}


#
# Loop through our list of processes and check the error log
# for unexepcted errors and warnings
#
sub check_warnings ($) {
  my ($tinfo)= @_;
  my $res= 0;

3756 3757
  my $tname= $tinfo->{name};

3758
  # Clear previous warnings
3759
  delete($tinfo->{warnings});
3760

3761 3762 3763
  # Start the mysqltest processes in parallel to save time
  # also makes it possible to wait for any process to exit during the check
  my %started;
3764 3765
  foreach my $mysqld ( mysqlds() )
  {
3766 3767 3768 3769 3770 3771 3772
    if ( defined $mysqld->{'proc'} )
    {
      my $proc= start_check_warnings($tinfo, $mysqld);
      $started{$proc->pid()}= $proc;
    }
  }

3773 3774 3775
  # Return immediately if no check proceess was started
  return 0 unless ( keys %started );

3776 3777
  my $timeout_proc= My::SafeProcess->timer(check_timeout());

3778 3779 3780 3781 3782 3783 3784 3785
  while (1){
    my $result= 0;
    my $proc= My::SafeProcess->wait_any();
    mtr_report("Got $proc");

    if ( delete $started{$proc->pid()} ) {
      # One check warning process returned
      my $res= $proc->exit_status();
3786
      my $err_file= $proc->user_data();
3787 3788 3789 3790 3791

      if ( $res == 0 or $res == 62 ){

	if ( $res == 0 ) {
	  # Check completed with problem
3792
	  my $report= mtr_grab_file($err_file);
3793 3794 3795 3796 3797 3798 3799 3800 3801 3802
	  # Log to var/log/warnings file
	  mtr_tofile("$opt_vardir/log/warnings",
		     $tname."\n".$report);

	  $tinfo->{'warnings'}.= $report;
	  $result= 1;
	}

	if ( $res == 62 ) {
	  # Test case was ok and called "skip"
3803 3804
	  # Remove the .err file the check generated
	  unlink($err_file);
3805 3806 3807 3808
	}

	if ( keys(%started) == 0){
	  # All checks completed
3809 3810 3811

	  $timeout_proc->kill();

3812 3813 3814 3815 3816 3817 3818
	  return $result;
	}
	# Wait for next process to exit
	next;
      }
      else
      {
3819
	my $report= mtr_grab_file($err_file);
3820
	$tinfo->{comment}.=
3821 3822
	  "Could not execute 'check-warnings' for ".
	    "testcase '$tname' (res: $res):\n";
3823 3824 3825 3826 3827
	$tinfo->{comment}.= $report;

	$result= 2;
      }
    }
3828 3829 3830 3831 3832 3833
    elsif ( $proc eq $timeout_proc ) {
      $tinfo->{comment}.= "Timeout $timeout_proc for ".
	"'check warnings' expired after ".check_timeout().
	  " seconds";
      $result= 4;
    }
3834 3835 3836
    else {
      # Unknown process returned, most likley a crash, abort everything
      $tinfo->{comment}=
3837
	"The server $proc crashed while running 'check warnings'";
3838
      $result= 3;
3839
    }
3840 3841 3842 3843

    # Kill any check processes still running
    map($_->kill(), values(%started));

3844 3845
    $timeout_proc->kill();

3846
    return $result;
3847
  }
3848

3849
  mtr_error("INTERNAL_ERROR: check_warnings");
3850 3851 3852
}


3853
#
unknown's avatar
unknown committed
3854 3855 3856
# Loop through our list of processes and look for and entry
# with the provided pid, if found check for the file indicating
# expected crash and restart it.
3857
#
unknown's avatar
unknown committed
3858 3859
sub check_expected_crash_and_restart {
  my ($proc)= @_;
3860

unknown's avatar
unknown committed
3861
  foreach my $mysqld ( mysqlds() )
3862
  {
unknown's avatar
unknown committed
3863 3864 3865 3866 3867 3868 3869
    next unless ( $mysqld->{proc} eq $proc );

    # Check if crash expected by looking at the .expect file
    # in var/tmp
    my $expect_file= "$opt_vardir/tmp/".$mysqld->name().".expect";
    if ( -f $expect_file )
    {
3870 3871
      mtr_verbose("Crash was expected, file '$expect_file' exists");

3872 3873
      for (my $waits = 0;  $waits < 50;  $waits++)
      {
3874 3875 3876
	# If last line in expect file starts with "wait"
	# sleep a little and try again, thus allowing the
	# test script to control when the server should start
3877
	# up again. Keep trying for up to 5s at a time.
Serge Kozlov's avatar
Serge Kozlov committed
3878
	my $last_line= mtr_lastlinesfromfile($expect_file, 1);
3879 3880
	if ($last_line =~ /^wait/ )
	{
3881
	  mtr_verbose("Test says wait before restart") if $waits == 0;
3882 3883 3884 3885 3886 3887 3888 3889 3890
	  mtr_milli_sleep(100);
	  next;
	}

	unlink($expect_file);

	# Start server with same settings as last time
	mysqld_start($mysqld, $mysqld->{'started_opts'});

3891
	return 1;
3892
      }
3893 3894
      # Loop ran through: we should keep waiting after a re-check
      return 2;
unknown's avatar
unknown committed
3895
    }
3896
  }
unknown's avatar
unknown committed
3897 3898 3899

  # Not an expected crash
  return 0;
3900 3901
}

3902

3903 3904 3905
# Remove all files and subdirectories of a directory
sub clean_dir {
  my ($dir)= @_;
unknown's avatar
unknown committed
3906
  mtr_verbose("clean_dir: $dir");
3907 3908 3909 3910 3911 3912 3913 3914 3915
  finddepth(
	  { no_chdir => 1,
	    wanted => sub {
	      if (-d $_){
		# A dir
		if ($_ eq $dir){
		  # The dir to clean
		  return;
		} else {
unknown's avatar
unknown committed
3916
		  mtr_verbose("rmdir: '$_'");
unknown's avatar
unknown committed
3917
		  rmdir($_) or mtr_warning("rmdir($_) failed: $!");
3918 3919 3920
		}
	      } else {
		# Hopefully a file
unknown's avatar
unknown committed
3921
		mtr_verbose("unlink: '$_'");
unknown's avatar
unknown committed
3922
		unlink($_) or mtr_warning("unlink($_) failed: $!");
3923 3924 3925 3926 3927 3928 3929
	      }
	    }
	  },
	    $dir);
}


3930 3931 3932 3933
sub clean_datadir {

  mtr_verbose("Cleaning datadirs...");

unknown's avatar
unknown committed
3934 3935 3936 3937
  if (started(all_servers()) != 0){
    mtr_error("Trying to clean datadir before all servers stopped");
  }

3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 3951 3952 3953 3954 3955
  foreach my $cluster ( clusters() )
  {
    my $cluster_dir= "$opt_vardir/".$cluster->{name};
    mtr_verbose(" - removing '$cluster_dir'");
    rmtree($cluster_dir);

  }

  foreach my $mysqld ( mysqlds() )
  {
    my $mysqld_dir= dirname($mysqld->value('datadir'));
    if (-d $mysqld_dir ) {
      mtr_verbose(" - removing '$mysqld_dir'");
      rmtree($mysqld_dir);
    }
  }

  # Remove all files in tmp and var/tmp
3956
  clean_dir("$opt_vardir/tmp");
3957
  if ($opt_tmpdir ne "$opt_vardir/tmp"){
3958
    clean_dir($opt_tmpdir);
3959 3960 3961 3962 3963 3964 3965 3966 3967
  }
}


#
# Save datadir before it's removed
#
sub save_datadir_after_failure($$) {
  my ($dir, $savedir)= @_;
unknown's avatar
unknown committed
3968

3969 3970 3971
  mtr_report(" - saving '$dir'");
  my $dir_name= basename($dir);
  rename("$dir", "$savedir/$dir_name");
3972
}
3973

3974

Magnus Svensson's avatar
Magnus Svensson committed
3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985
sub remove_ndbfs_from_ndbd_datadir {
  my ($ndbd_datadir)= @_;
  # Remove the ndb_*_fs directory from ndbd.X/ dir
  foreach my $ndbfs_dir ( glob("$ndbd_datadir/ndb_*_fs") )
  {
    next unless -d $ndbfs_dir; # Skip if not a directory
    rmtree($ndbfs_dir);
  }
}


3986 3987 3988 3989 3990 3991 3992 3993
sub after_failure ($) {
  my ($tinfo)= @_;

  mtr_report("Saving datadirs...");

  my $save_dir= "$opt_vardir/log/";
  $save_dir.= $tinfo->{name};
  # Add combination name if any
unknown's avatar
unknown committed
3994
  $save_dir.= "-$tinfo->{combination}"
3995 3996
    if defined $tinfo->{combination};

3997 3998 3999
  # Save savedir  path for server
  $tinfo->{savedir}= $save_dir;

4000 4001 4002 4003 4004
  mkpath($save_dir) if ! -d $save_dir;

  # Save the used my.cnf file
  copy($path_config_file, $save_dir);

4005 4006 4007
  # Copy the tmp dir
  copytree("$opt_vardir/tmp/", "$save_dir/tmp/");

4008 4009 4010
  if ( clusters() ) {
    foreach my $cluster ( clusters() ) {
      my $cluster_dir= "$opt_vardir/".$cluster->{name};
Magnus Svensson's avatar
Magnus Svensson committed
4011 4012 4013 4014 4015 4016 4017 4018

      # Remove the fileystem of each ndbd
      foreach my $ndbd ( in_cluster($cluster, ndbds()) )
      {
        my $ndbd_datadir= $ndbd->value("DataDir");
        remove_ndbfs_from_ndbd_datadir($ndbd_datadir);
      }

4019
      save_datadir_after_failure($cluster_dir, $save_dir);
4020 4021
    }
  }
4022 4023 4024 4025 4026
  else {
    foreach my $mysqld ( mysqlds() ) {
      my $data_dir= $mysqld->value('datadir');
      save_datadir_after_failure(dirname($data_dir), $save_dir);
    }
4027
  }
4028 4029
}

unknown's avatar
unknown committed
4030

unknown's avatar
unknown committed
4031 4032 4033
sub report_failure_and_restart ($) {
  my $tinfo= shift;

4034
  stop_all_servers();
4035

4036 4037 4038 4039 4040 4041 4042 4043 4044 4045 4046 4047 4048
  $tinfo->{'result'}= 'MTR_RES_FAILED';

  my $test_failures= $tinfo->{'failures'} || 0;
  $tinfo->{'failures'}=  $test_failures + 1;


  if ( $tinfo->{comment} )
  {
    # The test failure has been detected by mysql-test-run.pl
    # when starting the servers or due to other error, the reason for
    # failing the test is saved in "comment"
    ;
  }
4049 4050

  if ( !defined $tinfo->{logfile} )
4051
  {
4052
    my $logfile= $path_current_testlog;
4053
    if ( defined $logfile )
4054
    {
4055 4056 4057 4058 4059 4060 4061 4062 4063 4064 4065 4066 4067
      if ( -f $logfile )
      {
	# Test failure was detected by test tool and its report
	# about what failed has been saved to file. Save the report
	# in tinfo
	$tinfo->{logfile}= mtr_fromfile($logfile);
      }
      else
      {
	# The test tool report didn't exist, display an
	# error message
	$tinfo->{logfile}= "Could not open test tool report '$logfile'";
      }
4068
    }
unknown's avatar
unknown committed
4069
  }
4070

4071
  after_failure($tinfo);
4072

4073 4074
  mtr_report_test($tinfo);

unknown's avatar
unknown committed
4075 4076 4077
}


unknown's avatar
unknown committed
4078 4079
sub run_sh_script {
  my ($script)= @_;
unknown's avatar
unknown committed
4080

unknown's avatar
unknown committed
4081
  return 0 unless defined $script;
4082

unknown's avatar
unknown committed
4083 4084 4085
  mtr_verbose("Running '$script'");
  my $ret= system("/bin/sh $script") >> 8;
  return $ret;
unknown's avatar
unknown committed
4086 4087
}

unknown's avatar
unknown committed
4088

unknown's avatar
unknown committed
4089 4090
sub mysqld_stop {
  my $mysqld= shift or die "usage: mysqld_stop(<mysqld>)";
unknown's avatar
unknown committed
4091

unknown's avatar
unknown committed
4092 4093
  my $args;
  mtr_init_args(\$args);
4094

unknown's avatar
unknown committed
4095
  mtr_add_arg($args, "--no-defaults");
4096
  mtr_add_arg($args, "--character-sets-dir=%s", $mysqld->value('character-sets-dir'));
unknown's avatar
unknown committed
4097 4098 4099 4100 4101 4102
  mtr_add_arg($args, "--user=%s", $opt_user);
  mtr_add_arg($args, "--password=");
  mtr_add_arg($args, "--port=%d", $mysqld->value('port'));
  mtr_add_arg($args, "--host=%s", $mysqld->value('#host'));
  mtr_add_arg($args, "--connect_timeout=20");
  mtr_add_arg($args, "--protocol=tcp");
unknown's avatar
unknown committed
4103

unknown's avatar
unknown committed
4104
  mtr_add_arg($args, "shutdown");
4105

unknown's avatar
unknown committed
4106 4107 4108 4109 4110 4111
  My::SafeProcess->run
    (
     name          => "mysqladmin shutdown ".$mysqld->name(),
     path          => $exe_mysqladmin,
     args          => \$args,
     error         => "/dev/null",
unknown's avatar
unknown committed
4112

unknown's avatar
unknown committed
4113
    );
unknown's avatar
unknown committed
4114 4115
}

unknown's avatar
unknown committed
4116

unknown's avatar
unknown committed
4117
sub mysqld_arguments ($$$) {
unknown's avatar
unknown committed
4118
  my $args=              shift;
4119
  my $mysqld=            shift;
4120
  my $extra_opts=        shift;
unknown's avatar
unknown committed
4121

unknown's avatar
unknown committed
4122
  mtr_add_arg($args, "--defaults-file=%s",  $path_config_file);
4123

unknown's avatar
unknown committed
4124
  # When mysqld is run by a root user(euid is 0), it will fail
unknown's avatar
unknown committed
4125 4126
  # to start unless we specify what user to run as, see BUG#30630
  my $euid= $>;
unknown's avatar
unknown committed
4127
  if (!IS_WINDOWS and $euid == 0 and
4128
      (grep(/^--user/, @$extra_opts)) == 0) {
unknown's avatar
unknown committed
4129
    mtr_add_arg($args, "--user=root");
unknown's avatar
unknown committed
4130 4131
  }

unknown's avatar
unknown committed
4132
  if ( $opt_valgrind_mysqld )
unknown's avatar
unknown committed
4133
  {
unknown's avatar
unknown committed
4134
    mtr_add_arg($args, "--skip-safemalloc");
4135 4136 4137

    if ( $mysql_version_id < 50100 )
    {
unknown's avatar
unknown committed
4138
      mtr_add_arg($args, "--skip-bdb");
4139
    }
unknown's avatar
unknown committed
4140 4141
  }

4142 4143
  if ( $mysql_version_id >= 50106 )
  {
4144 4145
    # Turn on logging to file
    mtr_add_arg($args, "--log-output=file");
4146 4147
  }

4148
  # Check if "extra_opt" contains skip-log-bin
4149
  my $skip_binlog= grep(/^(--|--loose-)skip-log-bin/, @$extra_opts);
unknown's avatar
unknown committed
4150

unknown's avatar
unknown committed
4151
  # Indicate to mysqld it will be debugged in debugger
unknown's avatar
unknown committed
4152
  if ( $glob_debugger )
unknown's avatar
unknown committed
4153
  {
unknown's avatar
unknown committed
4154
    mtr_add_arg($args, "--gdb");
unknown's avatar
unknown committed
4155 4156
  }

unknown's avatar
unknown committed
4157
  my $found_skip_core= 0;
4158
  foreach my $arg ( @$extra_opts )
unknown's avatar
unknown committed
4159
  {
4160
    # Allow --skip-core-file to be set in <testname>-[master|slave].opt file
unknown's avatar
unknown committed
4161 4162 4163 4164
    if ($arg eq "--skip-core-file")
    {
      $found_skip_core= 1;
    }
4165 4166 4167 4168
    elsif ($skip_binlog and mtr_match_prefix($arg, "--binlog-format"))
    {
      ; # Dont add --binlog-format when running without binlog
    }
4169 4170 4171 4172 4173
    elsif ($arg eq "--loose-skip-log-bin" and
           $mysqld->option("log-slave-updates"))
    {
      ; # Dont add --skip-log-bin when mysqld have --log-slave-updates in config
    }
unknown's avatar
unknown committed
4174 4175
    else
    {
unknown's avatar
unknown committed
4176
      mtr_add_arg($args, "%s", $arg);
unknown's avatar
unknown committed
4177 4178
    }
  }
4179
  $opt_skip_core = $found_skip_core;
unknown's avatar
unknown committed
4180 4181
  if ( !$found_skip_core )
  {
unknown's avatar
unknown committed
4182
    mtr_add_arg($args, "%s", "--core-file");
unknown's avatar
unknown committed
4183 4184 4185 4186 4187 4188
  }

  return $args;
}


4189

unknown's avatar
unknown committed
4190
sub mysqld_start ($$) {
unknown's avatar
unknown committed
4191
  my $mysqld=            shift;
4192 4193 4194
  my $extra_opts=        shift;

  mtr_verbose(My::Options::toStr("mysqld_start", @$extra_opts));
unknown's avatar
unknown committed
4195

4196
  my $exe= find_mysqld($mysqld->value('basedir'));
unknown's avatar
unknown committed
4197 4198
  my $wait_for_pid_file= 1;

4199
  mtr_error("Internal error: mysqld should never be started for embedded")
unknown's avatar
unknown committed
4200
    if $opt_embedded_server;
unknown's avatar
unknown committed
4201

unknown's avatar
unknown committed
4202
  my $args;
unknown's avatar
unknown committed
4203 4204
  mtr_init_args(\$args);

unknown's avatar
unknown committed
4205
  if ( $opt_valgrind_mysqld )
unknown's avatar
unknown committed
4206
  {
unknown's avatar
unknown committed
4207
    valgrind_arguments($args, \$exe);
unknown's avatar
unknown committed
4208 4209
  }

unknown's avatar
unknown committed
4210
  mtr_add_arg($args, "--defaults-group-suffix=%s", $mysqld->after('mysqld'));
4211
  mysqld_arguments($args,$mysqld,$extra_opts);
unknown's avatar
unknown committed
4212

unknown's avatar
unknown committed
4213 4214 4215 4216 4217 4218
  if ( $opt_debug )
  {
    mtr_add_arg($args, "--debug=d:t:i:A,%s/log/%s.trace",
		$path_vardir_trace, $mysqld->name());
  }

4219 4220 4221 4222 4223 4224
  if (IS_WINDOWS)
  {
    # Trick the server to send output to stderr, with --console
    mtr_add_arg($args, "--console");
  }

unknown's avatar
unknown committed
4225
  if ( $opt_gdb || $opt_manual_gdb )
unknown's avatar
unknown committed
4226
  {
unknown's avatar
unknown committed
4227
    gdb_arguments(\$args, \$exe, $mysqld->name());
unknown's avatar
unknown committed
4228 4229 4230
  }
  elsif ( $opt_ddd || $opt_manual_ddd )
  {
unknown's avatar
unknown committed
4231
    ddd_arguments(\$args, \$exe, $mysqld->name());
unknown's avatar
unknown committed
4232
  }
4233 4234
  elsif ( $opt_debugger )
  {
unknown's avatar
unknown committed
4235
    debugger_arguments(\$args, \$exe, $mysqld->name());
unknown's avatar
unknown committed
4236
  }
4237 4238
  elsif ( $opt_manual_debug )
  {
4239
     print "\nStart " .$mysqld->name()." in your debugger\n" .
4240 4241 4242 4243 4244 4245 4246 4247
           "dir: $glob_mysql_test_dir\n" .
           "exe: $exe\n" .
	   "args:  " . join(" ", @$args)  . "\n\n" .
	   "Waiting ....\n";

     # Indicate the exe should not be started
    $exe= undef;
  }
unknown's avatar
unknown committed
4248 4249 4250 4251 4252
  else
  {
    # Default to not wait until pid file has been created
    $wait_for_pid_file= 0;
  }
unknown's avatar
unknown committed
4253

unknown's avatar
unknown committed
4254 4255
  # Remove the old pidfile if any
  unlink($mysqld->value('pid-file'));
4256

4257
  my $output= $mysqld->value('#log-error');
unknown's avatar
unknown committed
4258
  if ( $opt_valgrind and $opt_debug )
unknown's avatar
unknown committed
4259
  {
unknown's avatar
unknown committed
4260 4261 4262 4263
    # When both --valgrind and --debug is selected, send
    # all output to the trace file, making it possible to
    # see the exact location where valgrind complains
    $output= "$opt_vardir/log/".$mysqld->name().".trace";
unknown's avatar
unknown committed
4264 4265
  }

unknown's avatar
unknown committed
4266
  if ( defined $exe )
unknown's avatar
unknown committed
4267
  {
unknown's avatar
unknown committed
4268 4269 4270 4271 4272 4273 4274 4275 4276
    $mysqld->{'proc'}= My::SafeProcess->new
      (
       name          => $mysqld->name(),
       path          => $exe,
       args          => \$args,
       output        => $output,
       error         => $output,
       append        => 1,
       verbose       => $opt_verbose,
4277
       nocore        => $opt_skip_core,
unknown's avatar
unknown committed
4278 4279 4280 4281
       host          => undef,
       shutdown      => sub { mysqld_stop($mysqld) },
      );
    mtr_verbose("Started $mysqld->{proc}");
unknown's avatar
unknown committed
4282 4283
  }

unknown's avatar
unknown committed
4284 4285 4286 4287 4288
  if ( $wait_for_pid_file &&
       !sleep_until_file_created($mysqld->value('pid-file'),
				 $opt_start_timeout,
				 $mysqld->{'proc'}))
  {
4289 4290
    my $mname= $mysqld->name();
    mtr_error("Failed to start mysqld $mname with command $exe");
unknown's avatar
unknown committed
4291
  }
4292 4293

  # Remember options used when starting
4294
  $mysqld->{'started_opts'}= $extra_opts;
4295

unknown's avatar
unknown committed
4296
  return;
unknown's avatar
unknown committed
4297 4298
}

unknown's avatar
unknown committed
4299

unknown's avatar
unknown committed
4300
sub stop_all_servers () {
4301
  my $shutdown_timeout = $_[0] or 0;
unknown's avatar
unknown committed
4302

unknown's avatar
unknown committed
4303
  mtr_verbose("Stopping all servers...");
unknown's avatar
unknown committed
4304

unknown's avatar
unknown committed
4305
  # Kill all started servers
4306
  My::SafeProcess::shutdown($shutdown_timeout,
unknown's avatar
unknown committed
4307
			    started(all_servers()));
unknown's avatar
unknown committed
4308

unknown's avatar
unknown committed
4309 4310 4311 4312 4313 4314 4315
  # Remove pidfiles
  foreach my $server ( all_servers() )
  {
    my $pid_file= $server->if_exist('pid-file');
    unlink($pid_file) if defined $pid_file;
  }

unknown's avatar
unknown committed
4316 4317
  # Mark servers as stopped
  map($_->{proc}= undef, all_servers());
unknown's avatar
unknown committed
4318

unknown's avatar
unknown committed
4319 4320
}

unknown's avatar
unknown committed
4321

unknown's avatar
unknown committed
4322 4323 4324
# Find out if server should be restarted for this test
sub server_need_restart {
  my ($tinfo, $server)= @_;
unknown's avatar
unknown committed
4325

unknown's avatar
unknown committed
4326
  if ( using_extern() )
unknown's avatar
unknown committed
4327
  {
unknown's avatar
unknown committed
4328
    mtr_verbose_restart($server, "no restart for --extern server");
unknown's avatar
unknown committed
4329
    return 0;
4330
  }
unknown's avatar
unknown committed
4331 4332

  if ( $tinfo->{'force_restart'} ) {
unknown's avatar
unknown committed
4333
    mtr_verbose_restart($server, "forced in .opt file");
unknown's avatar
unknown committed
4334
    return 1;
unknown's avatar
unknown committed
4335
  }
unknown's avatar
unknown committed
4336 4337

  if ( $tinfo->{template_path} ne $current_config_name)
4338
  {
unknown's avatar
unknown committed
4339
    mtr_verbose_restart($server, "using different config file");
unknown's avatar
unknown committed
4340
    return 1;
4341
  }
unknown's avatar
unknown committed
4342 4343

  if ( $tinfo->{'master_sh'}  || $tinfo->{'slave_sh'} )
unknown's avatar
unknown committed
4344
  {
unknown's avatar
unknown committed
4345
    mtr_verbose_restart($server, "sh script to run");
unknown's avatar
unknown committed
4346
    return 1;
unknown's avatar
unknown committed
4347
  }
unknown's avatar
unknown committed
4348 4349

  if ( ! started($server) )
4350
  {
unknown's avatar
unknown committed
4351
    mtr_verbose_restart($server, "not started");
unknown's avatar
unknown committed
4352
    return 1;
4353
  }
unknown's avatar
unknown committed
4354 4355 4356

  my $started_tinfo= $server->{'started_tinfo'};
  if ( defined $started_tinfo )
4357
  {
unknown's avatar
unknown committed
4358 4359 4360 4361

    # Check if timezone of  test that server was started
    # with differs from timezone of next test
    if ( timezone($started_tinfo) ne timezone($tinfo) )
4362
    {
unknown's avatar
unknown committed
4363
      mtr_verbose_restart($server, "different timezone");
unknown's avatar
unknown committed
4364
      return 1;
4365
    }
4366
  }
4367

4368 4369 4370 4371 4372 4373 4374 4375 4376 4377 4378
  # Temporary re-enable the "always restart slave" hack
  # this should be removed asap, but will require that each rpl
  # testcase cleanup better after itself - ie. stop and reset
  # replication
  # Use the "#!use-slave-opt" marker to detect that this is a "slave"
  # server
  if ( $server->option("#!use-slave-opt") ){
    mtr_verbose_restart($server, "Always restart slave(s)");
    return 1;
  }

4379
  my $is_mysqld= grep ($server eq $_, mysqlds());
4380 4381
  if ($is_mysqld)
  {
unknown's avatar
unknown committed
4382

4383 4384
    # Check that running process was started with same options
    # as the current test requires
4385
    my $extra_opts= get_extra_opts($server, $tinfo);
4386
    my $started_opts= $server->{'started_opts'};
4387 4388

    if (!My::Options::same($started_opts, $extra_opts) )
4389
    {
4390
      my $use_dynamic_option_switch= 0;
unknown's avatar
unknown committed
4391 4392 4393 4394 4395 4396 4397
      if (!$use_dynamic_option_switch)
      {
	mtr_verbose_restart($server, "running with different options '" .
			    join(" ", @{$extra_opts}) . "' != '" .
			    join(" ", @{$started_opts}) . "'" );
	return 1;
      }
4398

4399 4400 4401 4402 4403 4404 4405 4406 4407 4408
      mtr_verbose(My::Options::toStr("started_opts", @$started_opts));
      mtr_verbose(My::Options::toStr("extra_opts", @$extra_opts));

      # Get diff and check if dynamic switch is possible
      my @diff_opts= My::Options::diff($started_opts, $extra_opts);
      mtr_verbose(My::Options::toStr("diff_opts", @diff_opts));

      my $query= My::Options::toSQL(@diff_opts);
      mtr_verbose("Attempting dynamic switch '$query'");
      if (run_query($tinfo, $server, $query)){
4409
	mtr_verbose("Restart: running with different options '" .
4410
		    join(" ", @{$extra_opts}) . "' != '" .
unknown's avatar
unknown committed
4411
		    join(" ", @{$started_opts}) . "'" );
4412 4413
	return 1;
      }
4414 4415 4416

      # Remember the dynamically set options
      $server->{'started_opts'}= $extra_opts;
4417
    }
unknown's avatar
unknown committed
4418
  }
4419

unknown's avatar
unknown committed
4420 4421
  # Default, no restart
  return 0;
4422 4423
}

unknown's avatar
unknown committed
4424

unknown's avatar
unknown committed
4425 4426 4427 4428
sub servers_need_restart($) {
  my ($tinfo)= @_;
  return grep { server_need_restart($tinfo, $_); } all_servers();
}
unknown's avatar
unknown committed
4429 4430 4431



unknown's avatar
unknown committed
4432 4433 4434 4435 4436 4437 4438 4439 4440 4441
#
# Return list of specific servers
#  - there is no servers in an empty config
#
sub _like   { return $config ? $config->like($_[0]) : (); }
sub mysqlds { return _like('mysqld.'); }
sub ndbds   { return _like('cluster_config.ndbd.');}
sub ndb_mgmds { return _like('cluster_config.ndb_mgmd.'); }
sub clusters  { return _like('mysql_cluster.'); }
sub all_servers { return ( mysqlds(), ndb_mgmds(), ndbds() ); }
unknown's avatar
unknown committed
4442 4443


unknown's avatar
unknown committed
4444 4445 4446 4447 4448 4449 4450 4451 4452
#
# Filter a list of servers and return only those that are part
# of the specified cluster
#
sub in_cluster {
  my ($cluster)= shift;
  # Return only processes for a specific cluster
  return grep { $_->suffix() eq $cluster->suffix() } @_;
}
unknown's avatar
unknown committed
4453

unknown's avatar
unknown committed
4454 4455


unknown's avatar
unknown committed
4456 4457 4458 4459 4460 4461
#
# Filter a list of servers and return the SafeProcess
# for only those that are started or stopped
#
sub started { return grep(defined $_, map($_->{proc}, @_));  }
sub stopped { return grep(!defined $_, map($_->{proc}, @_)); }
4462

unknown's avatar
unknown committed
4463

4464 4465 4466 4467 4468 4469 4470 4471 4472 4473 4474 4475
sub envsubst {
  my $string= shift;

  if ( ! defined $ENV{$string} )
  {
    mtr_error(".opt file references '$string' which is not set");
  }

  return $ENV{$string};
}


4476
sub get_extra_opts {
unknown's avatar
unknown committed
4477
  my ($mysqld, $tinfo)= @_;
unknown's avatar
unknown committed
4478

4479
  my $opts=
unknown's avatar
unknown committed
4480 4481
    $mysqld->option("#!use-slave-opt") ?
      $tinfo->{slave_opt} : $tinfo->{master_opt};
4482 4483 4484 4485 4486 4487 4488 4489

  # Expand environment variables
  foreach my $opt ( @$opts )
  {
    $opt =~ s/\$\{(\w+)\}/envsubst($1)/ge;
    $opt =~ s/\$(\w+)/envsubst($1)/ge;
  }
  return $opts;
unknown's avatar
unknown committed
4490
}
unknown's avatar
unknown committed
4491 4492


unknown's avatar
unknown committed
4493 4494
sub stop_servers($$) {
  my ($tinfo, @servers)= @_;
unknown's avatar
unknown committed
4495

unknown's avatar
unknown committed
4496 4497
  # Remember if we restarted for this test case (count restarts)
  $tinfo->{'restarted'}= 1;
unknown's avatar
unknown committed
4498

unknown's avatar
unknown committed
4499 4500 4501 4502
  if ( join('|', @servers) eq join('|', all_servers()) )
  {
    # All servers are going down, use some kind of order to
    # avoid too many warnings in the log files
unknown's avatar
unknown committed
4503

4504
   mtr_report("Restarting all servers");
4505

unknown's avatar
unknown committed
4506 4507
    #  mysqld processes
    My::SafeProcess::shutdown( $opt_shutdown_timeout, started(mysqlds()) );
4508

unknown's avatar
unknown committed
4509 4510 4511 4512 4513 4514
    # cluster processes
    My::SafeProcess::shutdown( $opt_shutdown_timeout,
			       started(ndbds(), ndb_mgmds()) );
  }
  else
  {
4515 4516
    mtr_report("Restarting ", started(@servers));

unknown's avatar
unknown committed
4517 4518 4519
     # Stop only some servers
    My::SafeProcess::shutdown( $opt_shutdown_timeout,
			       started(@servers) );
4520 4521
  }

unknown's avatar
unknown committed
4522
  foreach my $server (@servers)
unknown's avatar
unknown committed
4523
  {
unknown's avatar
unknown committed
4524 4525 4526 4527 4528 4529 4530
    # Mark server as stopped
    $server->{proc}= undef;

    # Forget history
    delete $server->{'started_tinfo'};
    delete $server->{'started_opts'};
    delete $server->{'started_cnf'};
unknown's avatar
unknown committed
4531
  }
unknown's avatar
unknown committed
4532 4533
}

4534

4535
#
unknown's avatar
unknown committed
4536
# start_servers
4537
#
unknown's avatar
unknown committed
4538
# Start servers not already started
4539 4540 4541 4542 4543
#
# RETURN
#  0 OK
#  1 Start failed
#
unknown's avatar
unknown committed
4544 4545
sub start_servers($) {
  my ($tinfo)= @_;
4546

unknown's avatar
unknown committed
4547 4548 4549 4550 4551
  # Start clusters
  foreach my $cluster ( clusters() )
  {
    ndbcluster_start($cluster);
  }
unknown's avatar
unknown committed
4552

unknown's avatar
unknown committed
4553 4554
  # Start mysqlds
  foreach my $mysqld ( mysqlds() )
unknown's avatar
unknown committed
4555
  {
unknown's avatar
unknown committed
4556
    if ( $mysqld->{proc} )
unknown's avatar
unknown committed
4557
    {
unknown's avatar
unknown committed
4558 4559 4560
      # Already started

      # Write start of testcase to log file
4561
      mark_log($mysqld->value('#log-error'), $tinfo);
unknown's avatar
unknown committed
4562 4563

      next;
unknown's avatar
unknown committed
4564
    }
unknown's avatar
unknown committed
4565

unknown's avatar
unknown committed
4566
    my $datadir= $mysqld->value('datadir');
4567
    if ($opt_start_dirty)
unknown's avatar
unknown committed
4568
    {
4569
      # Don't delete anything if starting dirty
4570 4571 4572 4573 4574 4575 4576 4577 4578 4579 4580 4581 4582 4583 4584 4585 4586
      ;
    }
    else
    {

      my @options= ('log-bin', 'relay-log');
      foreach my $option_name ( @options )  {
	next unless $mysqld->option($option_name);

	my $file_name= $mysqld->value($option_name);
	next unless
	  defined $file_name and
	    -e $file_name;

	mtr_debug(" -removing '$file_name'");
	unlink($file_name) or die ("unable to remove file '$file_name'");
      }
4587

4588 4589 4590
      if (-d $datadir ) {
	mtr_verbose(" - removing '$datadir'");
	rmtree($datadir);
unknown's avatar
unknown committed
4591 4592
      }
    }
unknown's avatar
unknown committed
4593

Magnus Svensson's avatar
Magnus Svensson committed
4594 4595 4596
    my $mysqld_basedir= $mysqld->value('basedir');
    if ( $basedir eq $mysqld_basedir )
    {
4597 4598 4599 4600 4601 4602 4603 4604 4605 4606
      if (! $opt_start_dirty)	# If dirty, keep possibly grown system db
      {
	# Copy datadir from installed system db
	for my $path ( "$opt_vardir", "$opt_vardir/..") {
	  my $install_db= "$path/install.db";
	  copytree($install_db, $datadir)
	    if -d $install_db;
	}
	mtr_error("Failed to copy system db to '$datadir'")
	  unless -d $datadir;
Magnus Svensson's avatar
Magnus Svensson committed
4607 4608 4609 4610
      }
    }
    else
    {
4611
      mysql_install_db($mysqld); # For versional testing
Magnus Svensson's avatar
Magnus Svensson committed
4612 4613 4614 4615

      mtr_error("Failed to install system db to '$datadir'")
	unless -d $datadir;

4616
    }
unknown's avatar
unknown committed
4617

4618 4619 4620 4621
    # Create the servers tmpdir
    my $tmpdir= $mysqld->value('tmpdir');
    mkpath($tmpdir) unless -d $tmpdir;

unknown's avatar
unknown committed
4622
    # Write start of testcase to log file
4623
    mark_log($mysqld->value('#log-error'), $tinfo);
unknown's avatar
unknown committed
4624

unknown's avatar
unknown committed
4625 4626 4627
    # Run <tname>-master.sh
    if ($mysqld->option('#!run-master-sh') and
       run_sh_script($tinfo->{master_sh}) )
unknown's avatar
unknown committed
4628
    {
unknown's avatar
unknown committed
4629
      $tinfo->{'comment'}= "Failed to execute '$tinfo->{master_sh}'";
4630
      return 1;
unknown's avatar
unknown committed
4631
    }
unknown's avatar
unknown committed
4632

unknown's avatar
unknown committed
4633 4634 4635
    # Run <tname>-slave.sh
    if ($mysqld->option('#!run-slave-sh') and
	run_sh_script($tinfo->{slave_sh}))
unknown's avatar
unknown committed
4636
    {
unknown's avatar
unknown committed
4637 4638
      $tinfo->{'comment'}= "Failed to execute '$tinfo->{slave_sh}'";
      return 1;
unknown's avatar
unknown committed
4639 4640
    }

unknown's avatar
unknown committed
4641 4642 4643 4644 4645 4646 4647 4648
    if (!$opt_embedded_server)
    {
      my $extra_opts= get_extra_opts($mysqld, $tinfo);
      mysqld_start($mysqld,$extra_opts);

      # Save this test case information, so next can examine it
      $mysqld->{'started_tinfo'}= $tinfo;
    }
4649

unknown's avatar
unknown committed
4650 4651
  }

4652
  # Wait for clusters to start
unknown's avatar
unknown committed
4653
  foreach my $cluster ( clusters() )
unknown's avatar
unknown committed
4654
  {
4655
    if (ndbcluster_wait_started($cluster, ""))
4656 4657
    {
      # failed to start
unknown's avatar
unknown committed
4658
      $tinfo->{'comment'}= "Start of '".$cluster->name()."' cluster failed";
4659
      return 1;
4660
    }
unknown's avatar
unknown committed
4661 4662
  }

unknown's avatar
unknown committed
4663 4664
  # Wait for mysqlds to start
  foreach my $mysqld ( mysqlds() )
4665
  {
unknown's avatar
unknown committed
4666 4667
    next if !started($mysqld);

unknown's avatar
unknown committed
4668 4669 4670 4671 4672
    if (sleep_until_file_created($mysqld->value('pid-file'),
				 $opt_start_timeout,
				 $mysqld->{'proc'}) == 0) {
      $tinfo->{comment}=
	"Failed to start ".$mysqld->name();
4673

4674
      my $logfile= $mysqld->value('#log-error');
4675 4676 4677 4678 4679 4680 4681 4682
      if ( defined $logfile and -f $logfile )
      {
	$tinfo->{logfile}= mtr_fromfile($logfile);
      }
      else
      {
	$tinfo->{logfile}= "Could not open server logfile: '$logfile'";
      }
4683
      return 1;
4684
    }
unknown's avatar
unknown committed
4685
  }
4686
  return 0;
unknown's avatar
unknown committed
4687 4688
}

unknown's avatar
unknown committed
4689

4690 4691
#
# Run include/check-testcase.test
unknown's avatar
unknown committed
4692
# Before a testcase, run in record mode and save result file to var/tmp
4693 4694
# After testcase, run and compare with the recorded file, they should be equal!
#
4695
# RETURN VALUE
4696
#  The newly started process
4697
#
4698
sub start_check_testcase ($$$) {
unknown's avatar
unknown committed
4699
  my $tinfo=    shift;
4700
  my $mode=     shift;
4701 4702
  my $mysqld=   shift;

unknown's avatar
unknown committed
4703
  my $name= "check-".$mysqld->name();
4704 4705 4706
  # Replace dots in name with underscore to avoid that mysqltest
  # misinterpret's what the filename extension is :(
  $name=~ s/\./_/g;
4707 4708 4709 4710

  my $args;
  mtr_init_args(\$args);

4711 4712 4713
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
  mtr_add_arg($args, "--defaults-group-suffix=%s", $mysqld->after('mysqld'));

4714 4715
  mtr_add_arg($args, "--skip-safemalloc");

unknown's avatar
unknown committed
4716 4717
  mtr_add_arg($args, "--result-file=%s", "$opt_vardir/tmp/$name.result");
  mtr_add_arg($args, "--test-file=%s", "include/check-testcase.test");
4718
  mtr_add_arg($args, "--verbose");
4719 4720 4721 4722 4723

  if ( $mode eq "before" )
  {
    mtr_add_arg($args, "--record");
  }
unknown's avatar
unknown committed
4724
  my $errfile= "$opt_vardir/tmp/$name.err";
4725
  my $proc= My::SafeProcess->new
unknown's avatar
unknown committed
4726 4727 4728 4729
    (
     name          => $name,
     path          => $exe_mysqltest,
     error         => $errfile,
4730
     output        => $errfile,
unknown's avatar
unknown committed
4731
     args          => \$args,
4732
     user_data     => $errfile,
4733
     verbose       => $opt_verbose,
unknown's avatar
unknown committed
4734
    );
4735

4736 4737
  mtr_report("Started $proc");
  return $proc;
4738 4739
}

4740

unknown's avatar
unknown committed
4741 4742 4743
sub run_mysqltest ($) {
  my $proc= start_mysqltest(@_);
  $proc->wait();
4744
}
unknown's avatar
unknown committed
4745

4746

unknown's avatar
unknown committed
4747
sub start_mysqltest ($) {
4748
  my ($tinfo)= @_;
unknown's avatar
unknown committed
4749 4750
  my $exe= $exe_mysqltest;
  my $args;
unknown's avatar
unknown committed
4751 4752 4753

  mtr_init_args(\$args);

unknown's avatar
unknown committed
4754
  mtr_add_arg($args, "--defaults-file=%s", $path_config_file);
unknown's avatar
unknown committed
4755 4756 4757
  mtr_add_arg($args, "--silent");
  mtr_add_arg($args, "--skip-safemalloc");
  mtr_add_arg($args, "--tmpdir=%s", $opt_tmpdir);
4758
  mtr_add_arg($args, "--character-sets-dir=%s", $path_charsetsdir);
4759
  mtr_add_arg($args, "--logdir=%s/log", $opt_vardir);
4760

4761 4762 4763 4764
  # Log line number and time  for each line in .test file
  mtr_add_arg($args, "--mark-progress")
    if $opt_mark_progress;

unknown's avatar
unknown committed
4765
  mtr_add_arg($args, "--database=test");
unknown's avatar
unknown committed
4766

unknown's avatar
unknown committed
4767 4768 4769 4770 4771
  if ( $opt_ps_protocol )
  {
    mtr_add_arg($args, "--ps-protocol");
  }

4772 4773 4774 4775 4776 4777 4778 4779 4780 4781 4782 4783 4784 4785 4786
  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
4787 4788
  if ( $opt_strace_client )
  {
unknown's avatar
unknown committed
4789
    $exe=  $opt_strace_client || "strace";
unknown's avatar
unknown committed
4790
    mtr_add_arg($args, "-o");
4791
    mtr_add_arg($args, "%s/log/mysqltest.strace", $opt_vardir);
unknown's avatar
unknown committed
4792 4793 4794
    mtr_add_arg($args, "$exe_mysqltest");
  }

unknown's avatar
unknown committed
4795
  mtr_add_arg($args, "--timer-file=%s/log/timer", $opt_vardir);
unknown's avatar
unknown committed
4796 4797 4798 4799 4800 4801 4802 4803 4804 4805 4806

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

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

4807 4808
  if ( $opt_ssl )
  {
4809
    # Turn on SSL for _all_ test cases if option --ssl was used
4810
    mtr_add_arg($args, "--ssl");
4811
  }
unknown's avatar
unknown committed
4812

unknown's avatar
unknown committed
4813 4814 4815 4816 4817 4818
  if ( $opt_embedded_server )
  {

    # Get the args needed for the embedded server
    # and append them to args prefixed
    # with --sever-arg=
unknown's avatar
unknown committed
4819

unknown's avatar
unknown committed
4820 4821 4822 4823 4824 4825 4826 4827
    my $mysqld=  $config->group('embedded')
      or mtr_error("Could not get [embedded] section");

    my $mysqld_args;
    mtr_init_args(\$mysqld_args);
    my $extra_opts= get_extra_opts($mysqld, $tinfo);
    mysqld_arguments($mysqld_args, $mysqld, $extra_opts);
    mtr_add_arg($args, "--server-arg=%s", $_) for @$mysqld_args;
4828 4829 4830 4831 4832 4833

    if (IS_WINDOWS)
    {
      # Trick the server to send output to stderr, with --console
      mtr_add_arg($args, "--server-arg=--console");
    }
unknown's avatar
unknown committed
4834
  }
unknown's avatar
unknown committed
4835

4836 4837 4838
  # ----------------------------------------------------------------------
  # export MYSQL_TEST variable containing <path>/mysqltest <args>
  # ----------------------------------------------------------------------
unknown's avatar
unknown committed
4839
  $ENV{'MYSQL_TEST'}= mtr_args2str($exe_mysqltest, @$args);
4840

4841
  # ----------------------------------------------------------------------
4842
  # Add arguments that should not go into the MYSQL_TEST env var
4843
  # ----------------------------------------------------------------------
4844
  if ( $opt_valgrind_mysqltest )
4845 4846 4847 4848 4849 4850 4851 4852 4853 4854
  {
    # Prefix the Valgrind options to the argument list.
    # We do this here, since we do not want to Valgrind the nested invocations
    # of mysqltest; that would mess up the stderr output causing test failure.
    my @args_saved = @$args;
    mtr_init_args(\$args);
    valgrind_arguments($args, \$exe);
    mtr_add_arg($args, "%s", $_) for @args_saved;
  }

4855
  mtr_add_arg($args, "--test-file=%s", $tinfo->{'path'});
unknown's avatar
unknown committed
4856

4857 4858 4859
  # Number of lines of resut to include in failure report
  mtr_add_arg($args, "--tail-lines=20");

4860
  if ( defined $tinfo->{'result_file'} ) {
4861
    mtr_add_arg($args, "--result-file=%s", $tinfo->{'result_file'});
4862
  }
4863

4864 4865
  client_debug_arg($args, "mysqltest");

4866 4867 4868
  if ( $opt_record )
  {
    mtr_add_arg($args, "--record");
4869

4870 4871 4872 4873 4874
    # When recording to a non existing result file
    # the name of that file is in "record_file"
    if ( defined $tinfo->{'record_file'} ) {
      mtr_add_arg($args, "--result-file=%s", $tinfo->{record_file});
    }
4875 4876
  }

unknown's avatar
unknown committed
4877 4878 4879 4880 4881 4882 4883 4884
  if ( $opt_client_gdb )
  {
    gdb_arguments(\$args, \$exe, "client");
  }
  elsif ( $opt_client_ddd )
  {
    ddd_arguments(\$args, \$exe, "client");
  }
4885 4886 4887
  elsif ( $opt_client_debugger )
  {
    debugger_arguments(\$args, \$exe, "client");
4888
  }
4889

unknown's avatar
unknown committed
4890 4891 4892 4893 4894
  my $proc= My::SafeProcess->new
    (
     name          => "mysqltest",
     path          => $exe,
     args          => \$args,
4895 4896
     append        => 1,
     error         => $path_current_testlog,
unknown's avatar
unknown committed
4897 4898 4899 4900
     verbose       => $opt_verbose,
    );
  mtr_verbose("Started $proc");
  return $proc;
unknown's avatar
unknown committed
4901
}
unknown's avatar
unknown committed
4902

unknown's avatar
unknown committed
4903

unknown's avatar
unknown committed
4904 4905 4906 4907 4908 4909 4910 4911 4912 4913
#
# Modify the exe and args so that program is run in gdb in xterm
#
sub gdb_arguments {
  my $args= shift;
  my $exe=  shift;
  my $type= shift;

  # Write $args to gdb init file
  my $str= join(" ", @$$args);
4914
  my $gdb_init_file= "$opt_vardir/tmp/gdbinit.$type";
unknown's avatar
unknown committed
4915

4916 4917 4918
  # Remove the old gdbinit file
  unlink($gdb_init_file);

unknown's avatar
unknown committed
4919 4920 4921 4922
  if ( $type eq "client" )
  {
    # write init file for client
    mtr_tofile($gdb_init_file,
4923 4924
	       "set args $str\n" .
	       "break main\n");
unknown's avatar
unknown committed
4925 4926 4927 4928 4929 4930 4931 4932 4933 4934
  }
  else
  {
    # write init file for mysqld
    mtr_tofile($gdb_init_file,
	       "set args $str\n" .
	       "break mysql_parse\n" .
	       "commands 1\n" .
	       "disable 1\n" .
	       "end\n" .
4935 4936 4937 4938 4939
	       "run");
  }

  if ( $opt_manual_gdb )
  {
4940
     print "\nTo start gdb for $type, type in another window:\n";
unknown's avatar
unknown committed
4941
     print "gdb -cd $glob_mysql_test_dir -x $gdb_init_file $$exe\n";
4942 4943 4944 4945

     # Indicate the exe should not be started
     $$exe= undef;
     return;
unknown's avatar
unknown committed
4946 4947 4948 4949 4950 4951
  }

  $$args= [];
  mtr_add_arg($$args, "-title");
  mtr_add_arg($$args, "$type");
  mtr_add_arg($$args, "-e");
4952

4953
  if ( $exe_libtool )
unknown's avatar
unknown committed
4954
  {
4955
    mtr_add_arg($$args, $exe_libtool);
unknown's avatar
unknown committed
4956 4957 4958 4959 4960 4961 4962 4963 4964
    mtr_add_arg($$args, "--mode=execute");
  }

  mtr_add_arg($$args, "gdb");
  mtr_add_arg($$args, "-x");
  mtr_add_arg($$args, "$gdb_init_file");
  mtr_add_arg($$args, "$$exe");

  $$exe= "xterm";
unknown's avatar
unknown committed
4965
}
unknown's avatar
unknown committed
4966

unknown's avatar
unknown committed
4967

unknown's avatar
unknown committed
4968 4969 4970 4971 4972 4973 4974 4975 4976 4977
#
# Modify the exe and args so that program is run in ddd
#
sub ddd_arguments {
  my $args= shift;
  my $exe=  shift;
  my $type= shift;

  # Write $args to ddd init file
  my $str= join(" ", @$$args);
4978
  my $gdb_init_file= "$opt_vardir/tmp/gdbinit.$type";
unknown's avatar
unknown committed
4979

4980 4981 4982
  # Remove the old gdbinit file
  unlink($gdb_init_file);

unknown's avatar
unknown committed
4983 4984 4985 4986 4987
  if ( $type eq "client" )
  {
    # write init file for client
    mtr_tofile($gdb_init_file,
	       "set args $str\n" .
4988
	       "break main\n");
unknown's avatar
unknown committed
4989 4990 4991 4992 4993 4994 4995 4996 4997 4998
  }
  else
  {
    # write init file for mysqld
    mtr_tofile($gdb_init_file,
	       "file $$exe\n" .
	       "set args $str\n" .
	       "break mysql_parse\n" .
	       "commands 1\n" .
	       "disable 1\n" .
4999
	       "end");
5000 5001 5002 5003
  }

  if ( $opt_manual_ddd )
  {
5004
     print "\nTo start ddd for $type, type in another window:\n";
unknown's avatar
unknown committed
5005
     print "ddd -cd $glob_mysql_test_dir -x $gdb_init_file $$exe\n";
5006 5007 5008 5009

     # Indicate the exe should not be started
     $$exe= undef;
     return;
unknown's avatar
unknown committed
5010
  }
unknown's avatar
unknown committed
5011

unknown's avatar
unknown committed
5012 5013
  my $save_exe= $$exe;
  $$args= [];
5014
  if ( $exe_libtool )
unknown's avatar
unknown committed
5015
  {
5016
    $$exe= $exe_libtool;
unknown's avatar
unknown committed
5017 5018 5019 5020 5021 5022 5023 5024 5025 5026 5027
    mtr_add_arg($$args, "--mode=execute");
    mtr_add_arg($$args, "ddd");
  }
  else
  {
    $$exe= "ddd";
  }
  mtr_add_arg($$args, "--command=$gdb_init_file");
  mtr_add_arg($$args, "$save_exe");
}

5028 5029 5030 5031 5032 5033 5034 5035 5036

#
# Modify the exe and args so that program is run in the selected debugger
#
sub debugger_arguments {
  my $args= shift;
  my $exe=  shift;
  my $debugger= $opt_debugger || $opt_client_debugger;

5037
  if ( $debugger =~ /vcexpress|vc|devenv/ )
5038 5039 5040 5041 5042 5043 5044
  {
    # vc[express] /debugexe exe arg1 .. argn

    # Add /debugexe and name of the exe before args
    unshift(@$$args, "/debugexe");
    unshift(@$$args, "$$exe");

5045 5046 5047
    # Set exe to debuggername
    $$exe= $debugger;

5048
  }
5049
  elsif ( $debugger =~ /windbg/ )
5050 5051 5052 5053 5054 5055
  {
    # windbg exe arg1 .. argn

    # Add name of the exe before args
    unshift(@$$args, "$$exe");

5056 5057 5058 5059 5060 5061 5062 5063 5064 5065 5066 5067 5068 5069 5070
    # Set exe to debuggername
    $$exe= $debugger;

  }
  elsif ( $debugger eq "dbx" )
  {
    # xterm -e dbx -r exe arg1 .. argn

    unshift(@$$args, $$exe);
    unshift(@$$args, "-r");
    unshift(@$$args, $debugger);
    unshift(@$$args, "-e");

    $$exe= "xterm";

5071 5072 5073 5074 5075 5076 5077 5078
  }
  else
  {
    mtr_error("Unknown argument \"$debugger\" passed to --debugger");
  }
}


unknown's avatar
unknown committed
5079 5080 5081
#
# Modify the exe and args so that program is run in valgrind
#
unknown's avatar
unknown committed
5082 5083 5084 5085
sub valgrind_arguments {
  my $args= shift;
  my $exe=  shift;

5086 5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098
  if ( $opt_callgrind)
  {
    mtr_add_arg($args, "--tool=callgrind");
    mtr_add_arg($args, "--base=$opt_vardir/log");
  }
  else
  {
    mtr_add_arg($args, "--tool=memcheck"); # From >= 2.1.2 needs this option
    mtr_add_arg($args, "--leak-check=yes");
    mtr_add_arg($args, "--num-callers=16");
    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
5099

5100
  # Add valgrind options, can be overriden by user
unknown's avatar
unknown committed
5101
  mtr_add_arg($args, '%s', $_) for (@valgrind_args);
5102

unknown's avatar
unknown committed
5103 5104
  mtr_add_arg($args, $$exe);

unknown's avatar
unknown committed
5105
  $$exe= $opt_valgrind_path || "valgrind";
5106 5107 5108 5109 5110 5111 5112 5113

  if ($exe_libtool)
  {
    # Add "libtool --mode-execute" before the test to execute
    # if running in valgrind(to avoid valgrinding bash)
    unshift(@$args, "--mode=execute", $$exe);
    $$exe= $exe_libtool;
  }
unknown's avatar
unknown committed
5114 5115 5116
}


unknown's avatar
unknown committed
5117
#
unknown's avatar
unknown committed
5118
# Usage
unknown's avatar
unknown committed
5119
#
unknown's avatar
unknown committed
5120
sub usage ($) {
Magnus Svensson's avatar
Magnus Svensson committed
5121
  my ($message)= @_;
5122 5123 5124

  if ( $message )
  {
unknown's avatar
unknown committed
5125
    print STDERR "$message\n";
5126 5127
  }

unknown's avatar
unknown committed
5128
  print <<HERE;
unknown's avatar
unknown committed
5129

unknown's avatar
unknown committed
5130
$0 [ OPTIONS ] [ TESTCASE ]
unknown's avatar
unknown committed
5131 5132 5133 5134 5135

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
5136 5137 5138 5139
  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
5140 5141
  compress              Use the compressed protocol between client and server
  ssl                   Use ssl protocol between client and server
5142
  skip-ssl              Dont start server with support for ssl connections
5143 5144
  vs-config             Visual Studio configuration used to create executables
                        (default: MTR_VS_CONFIG environment variable)
unknown's avatar
unknown committed
5145

5146
  defaults-file=<config template> Use fixed config template for all
unknown's avatar
unknown committed
5147
                        tests
5148
  defaults_extra_file=<config template> Extra config template to add to
unknown's avatar
unknown committed
5149
                        all generated configs
5150 5151 5152
  combination=<opt>     Use at least twice to run tests with specified 
                        options to mysqld
  skip-combinations     Ignore combination file (or options)
unknown's avatar
unknown committed
5153

5154 5155 5156
Options to control directories to use
  tmpdir=DIR            The directory where temporary files are stored
                        (default: ./var/tmp).
5157 5158 5159
  vardir=DIR            The directory where files generated from the test run
                        is stored (default: ./var). Specifying a ramdisk or
                        tmpfs will speed up tests.
5160 5161 5162
  mem                   Run testsuite in "memory" using tmpfs or ramdisk
                        Attempts to find a suitable location
                        using a builtin list of standard locations
5163 5164 5165
                        for tmpfs (/dev/shm)
                        The option can also be set using environment
                        variable MTR_MEM=[DIR]
unknown's avatar
unknown committed
5166 5167 5168
  client-bindir=PATH    Path to the directory where client binaries are located
  client-libdir=PATH    Path to the directory where client libraries are located

5169

unknown's avatar
unknown committed
5170 5171 5172
Options to control what test suites or cases to run

  force                 Continue to run the suite after failure
5173
  with-ndbcluster-only  Run only tests that include "ndb" in the filename
unknown's avatar
unknown committed
5174
  skip-ndb[cluster]     Skip all tests that need cluster
5175 5176 5177 5178 5179 5180
  do-test=PREFIX or REGEX
                        Run test cases which name are prefixed with PREFIX
                        or fulfills REGEX
  skip-test=PREFIX or REGEX
                        Skip test cases which name are prefixed with PREFIX
                        or fulfills REGEX
5181 5182 5183 5184
  start-from=PREFIX     Run test cases starting test prefixed with PREFIX where
                        prefix may be suite.testname or just testname
  suite[s]=NAME1,..,NAMEN
                        Collect tests in suites from the comma separated
5185
                        list of suite names.
5186
                        The default is: "$DEFAULT_SUITES"
unknown's avatar
unknown committed
5187
  skip-rpl              Skip the replication test cases.
5188
  big-test              Also run tests marked as "big"
5189
  enable-disabled       Run also tests marked as disabled
5190
  print-testcases       Don't run the tests but print details about all the
5191
                        selected tests, in the order they would be run.
unknown's avatar
unknown committed
5192 5193 5194

Options that specify ports

unknown's avatar
unknown committed
5195
  mtr-build-thread=#    Specify unique number to calculate port number(s) from.
unknown's avatar
unknown committed
5196
  build-thread=#        Can be set in environment variable MTR_BUILD_THREAD.
unknown's avatar
unknown committed
5197 5198
                        Set  MTR_BUILD_THREAD="auto" to automatically aquire
                        a build thread id that is unique to current host
unknown's avatar
unknown committed
5199 5200 5201 5202

Options for test case authoring

  record TESTNAME       (Re)genereate the result file for TESTNAME
5203
  check-testcases       Check testcases for sideeffects
5204
  mark-progress         Log line number and elapsed time to <testname>.progress
unknown's avatar
unknown committed
5205 5206 5207 5208 5209 5210 5211

Options that pass on options

  mysqld=ARGS           Specify additional arguments to "mysqld"

Options to run test on running server

unknown's avatar
unknown committed
5212 5213 5214 5215 5216 5217
  extern option=value   Run only the tests against an already started server
                        the options to use for connection to the extern server
                        must be specified using name-value pair notation
                        For example:
                         ./$0 --extern socket=/tmp/mysqld.sock

unknown's avatar
unknown committed
5218 5219
Options for debugging the product

5220 5221
  client-ddd            Start mysqltest client in ddd
  client-debugger=NAME  Start mysqltest in the selected debugger
unknown's avatar
unknown committed
5222 5223
  client-gdb            Start mysqltest client in gdb
  ddd                   Start mysqld in ddd
5224
  debug                 Dump trace output for all servers and client programs
5225
  debugger=NAME         Start mysqld in the selected debugger
5226 5227 5228 5229 5230
  gdb                   Start the mysqld(s) in gdb
  manual-debug          Let user manually start mysqld in debugger, before
                        running test(s)
  manual-gdb            Let user manually start mysqld in gdb, before running
                        test(s)
unknown's avatar
unknown committed
5231 5232
  manual-ddd            Let user manually start mysqld in ddd, before running
                        test(s)
unknown's avatar
unknown committed
5233 5234 5235
  strace-client=[path]  Create strace output for mysqltest client, optionally
                        specifying name and path to the trace program to use.
                        Example: $0 --strace-client=ktrace
5236 5237
  max-save-core         Limit the number of core files saved (to avoid filling
                        up disks for heavily crashing server). Defaults to
5238 5239 5240 5241 5242 5243
                        $opt_max_save_core, set to 0 for no limit. Set
                        it's default with MTR_MAX_SAVE_CORE
  max-save-datadir      Limit the number of datadir saved (to avoid filling
                        up disks for heavily crashing server). Defaults to
                        $opt_max_save_datadir, set to 0 for no limit. Set
                        it's default with MTR_MAX_SAVE_DATDIR
5244 5245 5246 5247
  max-test-fail         Limit the number of test failurs before aborting
                        the current test run. Defaults to
                        $opt_max_test_fail, set to 0 for no limit. Set
                        it's default with MTR_MAX_TEST_FAIL
unknown's avatar
unknown committed
5248

unknown's avatar
unknown committed
5249
Options for valgrind
unknown's avatar
unknown committed
5250

5251
  valgrind              Run the "mysqltest" and "mysqld" executables using
unknown's avatar
unknown committed
5252
                        valgrind with default options
5253
  valgrind-all          Synonym for --valgrind
5254 5255
  valgrind-mysqltest    Run the "mysqltest" and "mysql_client_test" executable
                        with valgrind
unknown's avatar
unknown committed
5256
  valgrind-mysqld       Run the "mysqld" executable with valgrind
unknown's avatar
unknown committed
5257 5258 5259
  valgrind-options=ARGS Deprecated, use --valgrind-option
  valgrind-option=ARGS  Option to give valgrind, replaces default option(s),
                        can be specified more then once
5260
  valgrind-path=<EXE>   Path to the valgrind executable
5261
  callgrind             Instruct valgrind to use callgrind
unknown's avatar
unknown committed
5262 5263

Misc options
5264
  user=USER             User for connecting to mysqld(default: $opt_user)
5265
  comment=STR           Write STR to the output
5266
  notimer               Don't show test case execution time
unknown's avatar
unknown committed
5267
  verbose               More verbose output(use multiple times for even more)
5268
  verbose-restart       Write when and why servers are restarted
unknown's avatar
unknown committed
5269 5270 5271 5272
  start                 Only initialize and start the servers, using the
                        startup settings for the first specified test case
                        Example:
                         $0 --start alias &
5273
  start-dirty           Only start the servers (without initialization) for
unknown's avatar
unknown committed
5274
                        the first specified test case
5275 5276
  wait-all              If --start or --start-dirty option is used, wait for all
                        servers to exit before finishing the process
unknown's avatar
unknown committed
5277 5278
  fast                  Run as fast as possible, dont't wait for servers
                        to shutdown etc.
5279
  parallel=N            Run tests in N parallel threads (default=1)
5280
                        Use parallel=auto for auto-setting of N
unknown's avatar
unknown committed
5281 5282
  repeat=N              Run each test N number of times
  retry=N               Retry tests that fail N times, limit number of failures
unknown's avatar
unknown committed
5283
                        to $opt_retry_failure
unknown's avatar
unknown committed
5284
  retry-failure=N       Limit number of retries for a failed test
5285
  reorder               Reorder tests to get fewer server restarts
unknown's avatar
unknown committed
5286 5287
  help                  Get this help text

unknown's avatar
unknown committed
5288 5289 5290 5291 5292 5293
  testcase-timeout=MINUTES Max test case run time (default $opt_testcase_timeout)
  suite-timeout=MINUTES Max test suite run time (default $opt_suite_timeout)
  shutdown-timeout=SECONDS Max number of seconds to wait for server shutdown
                        before killing servers (default $opt_shutdown_timeout)
  warnings              Scan the log files for warnings. Use --nowarnings
                        to turn off.
5294

5295
  sleep=SECONDS         Passed to mysqltest, will be used as fixed sleep time
5296 5297
  gcov                  Collect coverage information after the test.
                        The result is a gcov file per source and header file.
5298 5299 5300 5301 5302 5303
  experimental=<file>   Refer to list of tests considered experimental;
                        failures will be marked exp-fail instead of fail.
  report-features       First run a "test" that reports mysql features
  timestamp             Print timestamp before each test report line
  timediff              With --timestamp, also print time passed since
                        *previous* test started
unknown's avatar
unknown committed
5304

unknown's avatar
unknown committed
5305
HERE
unknown's avatar
unknown committed
5306
  exit(1);
5307

unknown's avatar
unknown committed
5308
}
unknown's avatar
unknown committed
5309