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

Still getting assertion failure in file data0type.cc line 67

    XMLWordPrintable

Details

    Description

      This error is essentially the same as MDEV-20726, except that is still happens for me. I'm running mariadb server version 10.4.13-MariaDB-1:10.4.13+maria~bionic.

      Here is a very short example which reproduces the error (Careful - crashes the server and prevents it from restarting!)

      CREATE TABLE `Foo`
      (
          `Bar` char(2) CHARACTER SET utf8,
          KEY `Bar` (`Bar`(1))
      ) ENGINE = InnoDB;
       
      ALTER TABLE `Foo` MODIFY `Bar` char(2) CHARACTER SET utf8mb4;
       
      INSERT INTO Foo VALUES ('a');
      

      At this point the server crashes and cannot restart, always crashing again with the error message "InnoDB: Failing assertion: !(prefix_len % mbmaxlen)".

      Observations: The error only occurs if the index is a prefix index. It also doesn't occur if the collation is changed in the ALTER TABLE - going from utf8_bin to utf8mb4_bin triggers the bug, as does going from utf8_general_ci to utf8mb4_general_ci, but when going from utf8_general_ci to utf8mb4_bin it does not occur.

      Attachments

        Issue Links

          Activity

            People

              kevg Eugene Kosov (Inactive)
              medo Simeon Maxein
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.