[ Avaa Bypassed ]




Upload:

Command:

hmhc3928@3.135.191.228: ~ $
############################################################
# Tests startup options for mysql server pertaining binlog 
# This test doesnot require (as of now) to be run for all 
# the binlogging format as server startup in the cases
# below are independent of the format. We therefore run this
# test in only statement format.
############################################################
--source include/have_binlog_format_statement.inc

#------------------------------------------------------------------#
# BUG 11766817 - 60030: CRASH ON MYSQLD STARTUP WHEN USING LOG-BIN #
#------------------------------------------------------------------#

#fetch the basedir from the already started server
--let MYSQL_BASEDIR= `select @@basedir`

--perl
  use strict;
  my $vardir= $ENV{'MYSQLTEST_VARDIR'} or die ('MYSQLTEST_VARDIR not set! Aborting!\n');
  my $cnf1= $vardir.'cnf_1.cnf';
  my $basedir=  $ENV{'MYSQL_BASEDIR'} or die "Basedir not set";

# check if mysqld exists in basedir/sql folder or in basedir/bin 
  my $share_folder =$basedir."/sql/share/";
  if(-e $share_folder)
  {
   $basedir=$basedir."/sql/";
  }

#create a new datadir if there is none else remove and create a new one.
  unless(-e $basedir."/data")
  {
    mkdir($basedir."/data", 0777) or die "Can't make data directory: $!";
  }
  else
  {
# Ideally this section should not execute as this means that the default
# datadir exists which is not possible in the current scenario.
    use File::Path;
    rmtree($basedir."/data");
    use strict;
    mkdir($basedir."/data", 0777) or die "Can't make data directory: $!";
  }

#create cnf_1 file
  my $content= "[mysqld]\n";
  $content.="basedir=$basedir\n";
  $content.="socket=socket-5620.sock\n";
  $content.="log-error=error.log\n";
  $content.="port=5620\n";
  $content.="user=root\n";
  $content.="core\n";
  $content.="log-bin\n";
  open(FILE_CNF, ">$cnf1") or die("Unable to create $cnf1: $!\n");
  print FILE_CNF $content;
  close(FILE_CNF);

#export the cnf path to mtr
  open(FILE_INC, '>include/cnf_include.inc');
  print FILE_INC '--let $CNF1'." = $cnf1\n";
  close(FILE_INC);
EOF

--source include/cnf_include.inc  
--error 1
--exec $MYSQLD --defaults-file=$CNF1

#--------------------------------------------------------------------------------------------#
# BUG 12929941 - SEGFAULT IN STRMAKE/CONVERT_DIRNAME WHEN USING --RELAY-LOG=SLAVE-RELAY-BIN  #
#--------------------------------------------------------------------------------------------#

--perl
  use strict;

# Initialize the variables
  my $vardir= $ENV{'MYSQLTEST_VARDIR'} or die ('MYSQLTEST_VARDIR not set! Aborting!\n');
  my $basedir=  $ENV{'MYSQL_BASEDIR'} or die "Basedir not set: $!\n";

# check if mysqld exists in basedir/sql folder or in basedir/bin 
  my $share_folder =$basedir."/sql/share/\0";
  if(-e $share_folder)
  {
   $basedir=$basedir."/sql/";
  }

#create cnf_2 file.
  my $cnf2= $vardir.'cnf_2.cnf';
  my $content= "[mysqld]\n";
  $content.="basedir=$basedir\n";
  $content.="port=5620\n";
  $content.="core\n";
  open(FILE_CNF, ">$cnf2") or die("Unable to create $cnf2: $!\n");
  print FILE_CNF $content;
  close(FILE_CNF);

#export the cnf path and "actual basedir" to mtr
  open(FILE_INC, '>include/cnf_include.inc');
  print FILE_INC '--let $CNF2'." = $cnf2\n";
  print FILE_INC '--let REAL_BASEDIR'."=$basedir\n";
  close(FILE_INC);
EOF

--source include/cnf_include.inc
--error 1
--exec $MYSQLD --defaults-file=$CNF2 --relay-log=slave-relay-bin

#cleanup
--perl
  use File::Path;
  my $basedir= $ENV{'REAL_BASEDIR'};
  rmtree($basedir."/data/");
EOF

--remove_file include/cnf_include.inc
--remove_file $CNF1
--remove_file $CNF2

--echo End of test binlog.binlog_server_start_options.test


Filemanager

Name Type Size Permission Actions
binlog_base64_flag.test File 5.53 KB 0644
binlog_bug23533.test File 1.48 KB 0644
binlog_bug36391-master.opt File 32 B 0644
binlog_bug36391.test File 1.14 KB 0644
binlog_cache_write_failure-master.opt File 97 B 0644
binlog_cache_write_failure.test File 5.43 KB 0644
binlog_checksum.test File 1.04 KB 0644
binlog_crash_safe_master_checksum-master.opt File 51 B 0644
binlog_crash_safe_master_checksum.test File 2.56 KB 0644
binlog_database.test File 369 B 0644
binlog_delete_and_flush_index.test File 3.53 KB 0644
binlog_dmls_on_tmp_tables_readonly.test File 2.25 KB 0644
binlog_drop_if_exists.test File 3.47 KB 0644
binlog_enforce_gtid_consistency.test File 5.72 KB 0644
binlog_error_action-master.opt File 88 B 0644
binlog_error_action.test File 16.82 KB 0644
binlog_format_switch_in_tmp_table.test File 2.77 KB 0644
binlog_grant.test File 1.7 KB 0644
binlog_gtid_cache-master.opt File 117 B 0644
binlog_gtid_cache.test File 569 B 0644
binlog_gtid_errors-master.opt File 149 B 0644
binlog_gtid_errors.test File 7.28 KB 0644
binlog_gtid_exhausted-master.opt File 17 B 0644
binlog_gtid_exhausted.test File 2.34 KB 0644
binlog_gtid_implicit_commit.test File 121 B 0644
binlog_gtid_innodb.test File 132 B 0644
binlog_gtid_mysqlbinlog_row.test File 197 B 0644
binlog_gtid_mysqlbinlog_row_innodb.test File 707 B 0644
binlog_gtid_mysqlbinlog_row_myisam.test File 662 B 0644
binlog_gtid_mysqlbinlog_start_stop.test File 445 B 0644
binlog_gtid_row_ctype_ucs.test File 265 B 0644
binlog_gtid_simple_recovery.test File 4.7 KB 0644
binlog_gtid_stm_ctype_ucs.test File 280 B 0644
binlog_gtid_utils.test File 3.11 KB 0644
binlog_hexdump.test File 219 B 0644
binlog_implicit_commit.test File 290 B 0644
binlog_incident-master.opt File 53 B 0644
binlog_incident.test File 1.05 KB 0644
binlog_incident_ignore-master.opt File 77 B 0644
binlog_incident_ignore.test File 151 B 0644
binlog_index-master.opt File 16 B 0644
binlog_index.test File 16.48 KB 0644
binlog_innodb.test File 139 B 0644
binlog_innodb_row.test File 2.69 KB 0644
binlog_killed.test File 10.52 KB 0644
binlog_killed_simulate-master.opt File 39 B 0644
binlog_killed_simulate.test File 2.67 KB 0644
binlog_max_extension.test File 2.57 KB 0644
binlog_mixed_cache_stat.test File 276 B 0644
binlog_mixed_load_data.test File 501 B 0644
binlog_multi_engine.test File 3.18 KB 0644
binlog_mysqlbinlog-cp932-master.opt File 23 B 0644
binlog_mysqlbinlog-cp932.test File 1.07 KB 0644
binlog_mysqlbinlog_base64.test File 2.59 KB 0644
binlog_mysqlbinlog_concat.test File 4.1 KB 0644
binlog_mysqlbinlog_filter.test File 2.07 KB 0644
binlog_mysqlbinlog_raw.test File 3.53 KB 0644
binlog_mysqlbinlog_row.test File 204 B 0644
binlog_mysqlbinlog_row_innodb.test File 714 B 0644
binlog_mysqlbinlog_row_myisam.test File 669 B 0644
binlog_mysqlbinlog_row_trans.test File 4.55 KB 0644
binlog_mysqlbinlog_start_stop.test File 452 B 0644
binlog_mysqlbinlog_start_stop_slave_server_id.test File 1.96 KB 0644
binlog_old_versions.test File 5.6 KB 0644
binlog_query_filter_rules-master.opt File 40 B 0644
binlog_query_filter_rules.test File 854 B 0644
binlog_reset_master.test File 998 B 0644
binlog_rewrite.test File 3.01 KB 0644
binlog_rotate_bgc_sync.test File 3.62 KB 0644
binlog_row_binlog-master.opt File 55 B 0644
binlog_row_binlog.test File 782 B 0644
binlog_row_cache_stat.test File 273 B 0644
binlog_row_ctype_cp932.test File 267 B 0644
binlog_row_ctype_ucs.test File 272 B 0644
binlog_row_drop_tbl.test File 214 B 0644
binlog_row_drop_tmp_tbl.test File 232 B 0644
binlog_row_innodb_stat-master.opt File 26 B 0644
binlog_row_insert_select.test File 510 B 0644
binlog_row_mix_innodb_myisam-master.opt File 97 B 0644
binlog_row_mix_innodb_myisam.test File 584 B 0644
binlog_row_mysqlbinlog_db_filter.test File 4.1 KB 0644
binlog_row_mysqlbinlog_verbose.test File 5.59 KB 0644
binlog_row_query_log_events.test File 1.18 KB 0644
binlog_server_id.test File 1 KB 0644
binlog_server_start_options.test File 3.63 KB 0644
binlog_sf.test File 2.67 KB 0644
binlog_simplified_binlog_gtid_recovery-master.opt File 16 B 0644
binlog_spurious_ddl_errors-master.opt File 29 B 0644
binlog_spurious_ddl_errors.test File 4.16 KB 0644
binlog_sql_mode.test File 4.75 KB 0644
binlog_start_comment.test File 1.01 KB 0644
binlog_statement_insert_delayed.test File 500 B 0644
binlog_stm_binlog-master.opt File 55 B 0644
binlog_stm_binlog.test File 740 B 0644
binlog_stm_blackhole.test File 267 B 0644
binlog_stm_cache_stat.test File 279 B 0644
binlog_stm_ctype_cp932.test File 317 B 0644
binlog_stm_ctype_ucs.test File 287 B 0644
binlog_stm_do_db-master.opt File 38 B 0644
binlog_stm_do_db.test File 2.8 KB 0644
binlog_stm_drop_tbl.test File 229 B 0644
binlog_stm_drop_tmp_tbl.test File 247 B 0644
binlog_stm_innodb_stat-master.opt File 26 B 0644
binlog_stm_insert_select.test File 291 B 0644
binlog_stm_mix_innodb_myisam-master.opt File 145 B 0644
binlog_stm_mix_innodb_myisam.test File 551 B 0644
binlog_stm_ps.test File 866 B 0644
binlog_stm_row.test File 3.12 KB 0644
binlog_stm_unsafe_warning-master.opt File 38 B 0644
binlog_stm_unsafe_warning.test File 5.61 KB 0644
binlog_stm_user_variables.test File 3.16 KB 0644
binlog_switch_inside_trans.test File 7.6 KB 0644
binlog_tmp_table.test File 4.43 KB 0644
binlog_truncate_innodb-master.opt File 15 B 0644
binlog_truncate_kill.test File 1.96 KB 0644
binlog_truncate_myisam.test File 316 B 0644
binlog_unsafe-master.opt File 65 B 0644
binlog_unsafe.test File 26.31 KB 0644
binlog_unsafe_stmt_capable_engine-master.opt File 41 B 0644
binlog_unsafe_stmt_capable_engine.test File 12.55 KB 0644
binlog_use_gtid_skip.test File 1.03 KB 0644
binlog_variables_log_bin-master.opt File 16 B 0644
binlog_variables_log_bin.test File 135 B 0644
binlog_variables_log_bin_index-master.opt File 70 B 0644
binlog_variables_log_bin_index.test File 135 B 0644
binlog_variables_relay_log-master.opt File 24 B 0644
binlog_variables_relay_log.test File 183 B 0644
binlog_variables_relay_log_index-master.opt File 86 B 0644
binlog_variables_relay_log_index.test File 183 B 0644
binlog_write_error.test File 2.37 KB 0644
binlog_xa_handling.test File 769 B 0644
disabled.def File 404 B 0644
show_binlog_events_no_lock.test File 2.27 KB 0644