[MDEV-30119] INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces Created: 2022-11-29  Updated: 2022-11-29  Resolved: 2022-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.11.2, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3

Type: Bug Priority: Blocker
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: regression-10.6

Issue Links:
Blocks
blocks MDEV-29986 Set innodb_undo_tablespaces=3 by default Closed
Relates
relates to MDEV-25312 Remove fil_space_t::name and related ... Closed

 Description   

marko encountered that few test cases in encryption and mariabackup suite are hanging
when innodb_undo_tablespaces > 0 (MDEV-29986). Test cases in encryption suites are

 encrypt_and_grep
 
 debug_key_management
 
 innodb-remove-encryption
 
 innodb-spatial-index
 
 innodb-encrypt-freed
 
 innodb_encrypt_key_rotation_age
 
 innodb_first_page

InnoDB:

 encryption_threads_shutdown

Mariabackup:

 mdev-14447
 
 skip_innodb
 
 xb_partition

Thanks to marko for finding out the test while working on MDEV-29986
As a part of the patch, InnoDB should display undo tablespace name as undo001, undo002 and soon.

 Comments   
Comment by Marko Mäkelä [ 2022-11-29 ]

Before MDEV-25312, the names of undo tablespaces were innodb_undo001, innodb_undo002, and so on. In MDEV-25312, the reported names for undo tablespaces were changed to NULL.

To avoid dynamic allocation of strings, it could be better to introduce names like undo001, so that we can simply use a substring of the underlying file name. Regular tablespaces always contain a / in their names.

Comment by Marko Mäkelä [ 2022-11-29 ]

In i_s_dict_fill_tablespaces_encryption(), could we allocate a buffer from the stack for the strings like innodb_undo001? In that way, the reported names for undo tablespaces would be the same as they were before MDEV-25312.

Comment by Marko Mäkelä [ 2022-11-29 ]

OK to push.

Generated at Thu Feb 08 10:13:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.