Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30119

INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces

Details

    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.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-29986 Set innodb_undo_tablespaces=3 by default

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-25312 Remove fil_space_t::name and related code

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            thiru Thirunarayanan Balathandayuthapani created issue -
            thiru Thirunarayanan Balathandayuthapani made changes -
            Field Original Value New Value
            marko Marko Mäkelä added a comment -

            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.

            marko Marko Mäkelä added a comment - 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.
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Labels regression-10.6
            Priority Critical [ 2 ] Blocker [ 1 ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Thirunarayanan Balathandayuthapani [ thiru ] Marko Mäkelä [ marko ]
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            marko Marko Mäkelä added a comment -

            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.

            marko Marko Mäkelä added a comment - 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 .
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Thirunarayanan Balathandayuthapani [ thiru ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Summary Encryption and Mariabackup test case hangs when innodb_undo_tablespaces > 0 Encryption test hangs when innodb_undo_tablespaces > 0 and INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces
            thiru Thirunarayanan Balathandayuthapani made changes -
            Summary Encryption test hangs when innodb_undo_tablespaces > 0 and INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces
            marko Marko Mäkelä added a comment -

            OK to push.

            marko Marko Mäkelä added a comment - OK to push.
            thiru Thirunarayanan Balathandayuthapani made changes -
            Fix Version/s 10.6.12 [ 28513 ]
            Fix Version/s 10.7.8 [ 28515 ]
            Fix Version/s 10.8.7 [ 28517 ]
            Fix Version/s 10.9.5 [ 28519 ]
            Fix Version/s 10.10.3 [ 28521 ]
            Fix Version/s 10.11.2 [ 28523 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.