⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
t
/
View File Name :
log_alter_table.test
--source include/have_innodb.inc --source include/have_debug.inc # Embedded server does not support crashing --source include/not_embedded.inc --echo # --echo # Bug#21801423 INNODB REDO LOG DOES NOT INDICATE WHEN --echo # FILES ARE CREATED --echo # --echo # Bug#21796691 INNODB REDO LOG DOES NOT INDICATE WHEN --echo # REDO LOGGING IS SKIPPED --echo # --source include/no_checkpoint_start.inc CREATE TABLE t1 (a INT NOT NULL, b INT UNIQUE) ENGINE=InnoDB TABLESPACE=innodb_file_per_table; # MLOG_INDEX_LOAD will not be emitted for empty tables. Insert a row. INSERT INTO t1 VALUES (1,2); # We should get two MLOG_INDEX_LOAD for this. ALTER TABLE t1 ADD PRIMARY KEY(a), ALGORITHM=INPLACE; # And one MLOG_INDEX_LOAD for this. ALTER TABLE t1 DROP INDEX b, ADD INDEX (b); --let CLEANUP_IF_CHECKPOINT=DROP TABLE t1; --source include/no_checkpoint_end.inc --let $restart_parameters = restart: --debug=d,ib_log --source include/start_mysqld.inc let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err; # Look for at least one MLOG_FILE_CREATE2 in the error log. # Theoretically, it may have been written by this test or an earlier test. # FIXME: redirect the error log of the restart to a new file, # and ensure that we have exactly 2 records there. let SEARCH_PATTERN=scan .*: multi-log rec MLOG_FILE_CREATE2.*page .*:0; --source include/search_pattern_in_file.inc # Look for at least one MLOG_INDEX_LOAD in the error log. # Theoretically, it may have been written by this test or an earlier test. # FIXME: redirect the error log of the restart to a new file, # and ensure that we have exactly 3 records there. let SEARCH_PATTERN=scan .*: log rec MLOG_INDEX_LOAD; --source include/search_pattern_in_file.inc CHECK TABLE t1; # Remove the --debug=d,ib_log setting. --let $restart_parameters = restart; --source include/restart_mysqld.inc DROP TABLE t1;