| Bug #117314 | Test innodb.tablespace_encrypt_9 failing | ||
|---|---|---|---|
| Submitted: | 28 Jan 14:41 | Modified: | 28 Oct 4:59 |
| Reporter: | Laurynas Biveinis (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 9.3.0 | OS: | MacOS (15.3) |
| Assigned to: | CPU Architecture: | ARM | |
[28 Jan 15:24]
MySQL Verification Team
Hello Laurynas, Thank you for the report and feedback. regards, Umesh
[28 Jan 15:25]
MySQL Verification Team
--
/export/home/tmp/ushastry/mysql-9.2.0/mysql-test]$ ./mtr innodb.tablespace_encrypt_9 --debug-server
Logging: ./mtr innodb.tablespace_encrypt_9 --debug-server
MySQL Version 9.2.0
Checking supported features
- Binaries are debug compiled
Using 'all' suites
Collecting tests
Checking leftover processes
Removing old var directory
Creating var directory '/export/home/tmp/ushastry/mysql-9.2.0/mysql-test/var'
Installing system database
Using parallel: 1
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 50%] innodb.tablespace_encrypt_9 [ fail ]
Test ended at 2025-01-28 16:24:08
CURRENT_TEST: innodb.tablespace_encrypt_9
--- /export/home/tmp/ushastry/mysql-9.2.0/mysql-test/suite/innodb/r/tablespace_encrypt_9.result 2024-12-15 23:00:33.000000000 +0300
+++ /export/home/tmp/ushastry/mysql-9.2.0/mysql-test/var/log/tablespace_encrypt_9.reject 2025-01-28 18:24:06.609019629 +0300
@@ -111,7 +111,7 @@
# connection con3
SELECT connection_id();
connection_id()
-10
+11
# Run a DDL with this connection con3
ALTER TABLESPACE temp_ts ENCRYPTION='Y';
set global innodb_buf_flush_list_now = 1;
mysqltest: Result content mismatch
The result from queries just before the failure was:
SOME VALUES
SOME VALUES
SOME VALUES
SOME VALUES
# Now try to encrypt tablespace. Without patch, an assert will be hit.
ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
###########
# Cleanup #
###########
DROP TABLE t1;
DROP TABLESPACE encrypt_ts;
# ----------------------------------------------------------------------
# Teardown
# Removing manifest file for current MySQL server instance
# Removing local keyring file for keyring component: component_keyring_file
# Removing local configuration file for keyring component: component_keyring_file
# Restarting server without the manifest file
# ----------------------------------------------------------------------
# Restarting server without keyring to restore server state
# restart:
safe_process[6560]: Child process: 6561, exit: 1
[16 May 10:18]
Laurynas Biveinis
Same on 9.3.0
[18 Jun 7:23]
Edward Gilmore
Posted by developer: Added the following note to the MySQL Server 9.4.0 release notes: The innodb.tablespace_encrypt_9 test case failed due to a result mismatch. Errors were returned similar to the following: mysqltest: Result content mismatch
[28 Oct 4:59]
Laurynas Biveinis
See bug 119253
Description: ./mtr innodb.tablespace_encrypt_9 ... [ 50%] innodb.tablespace_encrypt_9 [ fail ] Test ended at 2025-01-28 16:39:23 CURRENT_TEST: innodb.tablespace_encrypt_9 --- /Users/laurynas/vilniusdb/mysql-9.2.0/mysql-test/suite/innodb/r/tablespace_encrypt_9.result 2025-01-22 12:28:56 +++ /Users/laurynas/vilniusdb/mysql-9.2.0/_build-debug/mysql-test/var/log/tablespace_encrypt_9.reject 2025-01-28 17:39:22 @@ -111,7 +111,7 @@ # connection con3 SELECT connection_id(); connection_id() -10 +11 # Run a DDL with this connection con3 ALTER TABLESPACE temp_ts ENCRYPTION='Y'; set global innodb_buf_flush_list_now = 1; mysqltest: Result content mismatch How to repeat: Server built with -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=ON -DMYSQL_MAINTAINER_MODE=ON -DWITH_SYSTEM_LIBS=ON -DWITH_NDBCLUSTER_STORAGE_ENGINE=OFF -DCMAKE_CXX_FLAGS=-g -Wno-documentation -DCMAKE_CXX_FLAGS_DEBUG=-g -Wno-documentation -DCMAKE_CXX_FLAGS_RELEASE=-g -O2 -DNDEBUG -Wno-documentation