Bug #117314 Test innodb.tablespace_encrypt_9 failing

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

Hello Laurynas,

Thank you for the report and feedback.

regards,
Umesh

--

/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

Same on 9.3.0

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

See bug 119253