Server IP : 172.67.216.182 / Your IP : 172.68.164.132 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/t/ |
Upload File : |
#------------------------------------------------------------------------------ ## InnoDB transparent tablespace data encryption ## This test case will test basic recovery from know DBUG_SUICIDE point . ## - ib_crash_during_rotation_for_encryption (assert during key rotation) ## - ib_crash_during_create_for_encryption (assert during create) ## - ib_crash_during_decrypt_page (assert during page decryption) ##------------------------------------------------------------------------------ # --source include/no_valgrind_without_big.inc # Disable in valgrind because of timeout, cf. Bug#22760145 --source include/not_valgrind.inc --source include/have_innodb.inc --source include/not_embedded.inc # Avoid CrashReporter popup on Mac --source include/not_crashrep.inc # # innodb-force-recovery-crash needs debug --source include/have_debug.inc --disable_query_log call mtr.add_suppression("\\[ERROR\\] InnoDB: Encryption can't find master key, please check the keyring plugin is loaded."); call mtr.add_suppression("ibd can't be decrypted"); call mtr.add_suppression("does not exist in the InnoDB internal data dictionary though MySQL is trying to drop it"); call mtr.add_suppression("Cannot open table tde_db/.* from the internal data dictionary of InnoDB"); call mtr.add_suppression("\\[Warning\\] InnoDB: Tablespace for table `tde_db`.`t1` is set as discarded"); call mtr.add_suppression("\\[ERROR\\] InnoDB: The table .* doesn't have a corresponding tablespace, it was discarded."); call mtr.add_suppression("\\[Warning\\] InnoDB: Cannot calculate statistics for table .* because the \.ibd file is missing"); --enable_query_log let $innodb_file_per_table = `SELECT @@innodb_file_per_table`; --disable_warnings DROP DATABASE IF EXISTS tde_db; CREATE DATABASE tde_db; USE tde_db; --enable_warnings SET GLOBAL innodb_file_per_table = 1; SELECT @@innodb_file_per_table; --echo # Starting server with keyring plugin restart with keying let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT ; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --replace_regex /\.dll/.so/ --source include/restart_mysqld.inc ##### Set crash ib_crash_during_decrypt_page CREATE TABLE tde_db.t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB; SHOW CREATE TABLE tde_db.t1; INSERT INTO tde_db.t1 VALUES(0, "aaaaa"); INSERT INTO tde_db.t1 VALUES(1, "bbbbb"); INSERT INTO tde_db.t1 VALUES(2, "ccccc"); INSERT INTO tde_db.t1 VALUES(3, "ddddd"); INSERT INTO tde_db.t1 VALUES(4, "eeeee"); INSERT INTO tde_db.t1 VALUES(5, "fffff"); INSERT INTO tde_db.t1 VALUES(6, "ggggg"); INSERT INTO tde_db.t1 VALUES(7, "hhhhh"); INSERT INTO tde_db.t1 VALUES(8, "iiiii"); INSERT INTO tde_db.t1 VALUES(9, "jjjjj"); let $MYSQLD_DATADIR = `SELECT @@datadir`; # Write file to make mysql-test-run.pl start up the server again --exec echo "restart:--early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,ib_crash_during_rotation_for_encryption"; # Execute the statement that causes the crash CREATE TABLE tde_db.t2(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB; SHOW CREATE TABLE tde_db.t2; INSERT INTO tde_db.t2 VALUES(0, "aaaaa"); INSERT INTO tde_db.t2 VALUES(1, "bbbbb"); --error 2013 ALTER INSTANCE ROTATE INNODB MASTER KEY; --enable_reconnect --source include/wait_until_connected_again.inc --disable_reconnect SET SESSION debug="-d,ib_crash_during_rotation_for_encryption"; SELECT * FROM tde_db.t1 ORDER BY c1 LIMIT 5; INSERT INTO tde_db.t1 VALUES(12, "mmmmm"); SELECT * FROM tde_db.t1 ORDER BY c1 ; SELECT * FROM tde_db.t2 ORDER BY c1 ; ALTER INSTANCE ROTATE INNODB MASTER KEY; SELECT * FROM tde_db.t1 ORDER BY c1 ; DROP TABLE tde_db.t2; # Write file to make mysql-test-run.pl start up the server again --exec echo "restart:--early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,ib_crash_during_create_for_encryption"; # Execute the statement that causes the crash --error 2013 CREATE TABLE tde_db.t2(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB; --enable_reconnect --source include/wait_until_connected_again.inc --disable_reconnect SET SESSION debug="-d,ib_crash_during_create_for_encryption"; SELECT * FROM tde_db.t1 ORDER BY c1 LIMIT 5; INSERT INTO tde_db.t1 VALUES(13, "nnnnn"); SELECT * FROM tde_db.t1 ORDER BY c1 ; --error 1146 SELECT * FROM tde_db.t2; let $MYSQLD_DATADIR = `SELECT @@datadir`; # Write file to make mysql-test-run.pl start up the server again --exec echo "restart:--early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect FLUSH TABLE tde_db.t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/tde_db/t1.cfg $MYSQLD_DATADIR/t1.cfg_back --copy_file $MYSQLD_DATADIR/tde_db/t1.cfp $MYSQLD_DATADIR/t1.cfp_back --copy_file $MYSQLD_DATADIR/tde_db/t1.ibd $MYSQLD_DATADIR/t1.ibd_back UNLOCK TABLES; ALTER TABLE tde_db.t1 DISCARD TABLESPACE; --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/tde_db/t1.cfg --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/tde_db/t1.cfp --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/tde_db/t1.ibd SET SESSION debug="+d,ib_crash_during_decrypt_page"; # Execute the statement that causes the crash --error 2013 eval ALTER TABLE tde_db.t1 IMPORT TABLESPACE; --enable_reconnect --source include/wait_until_connected_again.inc --disable_reconnect SET SESSION debug="-d,ib_crash_during_decrypt_page"; --error ER_TABLESPACE_DISCARDED INSERT INTO tde_db.t1 VALUES(11, "lllll"); --error ER_TABLESPACE_DISCARDED SELECT * FROM tde_db.t1 ORDER BY c1 ; DROP TABLE tde_db.t1; #DROP DATABASE tde_db; --exec echo "restart: " > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect --enable_reconnect --source include/wait_until_connected_again.inc --disable_reconnect # Cleanup #DROP DATABASE tde_db; eval SET GLOBAL innodb_file_per_table=$innodb_file_per_table; --remove_file $MYSQL_TMP_DIR/mysecret_keyring