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

Incompatibility on INDEX lenght after upgrade, bogus error message

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.15
    • 10.3
    • Server
    • FreeBSD 11.2-RELEASE-p10 amd64 GENERIC
      mysql Ver 15.1 Distrib 10.3.15-MariaDB, for FreeBSD11.2 (amd64) using readline 5.1

    Description

      Previous version was MariaDB 10.1.37. Affected table was created long time ago on MariaDB 5.5. All previous upgrades was fine, but after upgrade to 10.3.15 and run of mysql_upgrade there is an inaccessible table "mailbox" with following error:

      Error : Table 'mailbox' uses an extension that doesn't exist in this MariaDB version
      error : Corrupt

      The original table:

      CREATE TABLE `mailbox` (
      `username` varchar(255) COLLATE utf8_czech_ci NOT NULL,
      `password` varchar(255) COLLATE utf8_czech_ci NOT NULL,
      `name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
      `maildir` varchar(255) COLLATE utf8_czech_ci NOT NULL,
      `quota` bigint(20) NOT NULL DEFAULT '0',
      `local_part` varchar(255) COLLATE utf8_czech_ci NOT NULL,
      `domain` varchar(255) COLLATE utf8_czech_ci NOT NULL,
      `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `active` tinyint(1) NOT NULL DEFAULT '1',
      PRIMARY KEY (`username`),
      KEY `domain` (`domain`),
      KEY `active` (`active`),
      KEY `username_domain_active` (`username`,`domain`,`active`)
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Postfix Admin - Virtual Mailboxes'

      MariaDB 10.3.15 has problem with KEY username_domain_active. This key is too long for this version. But why? Why if this key worked for many years?
      This table cannot be fixed / altered on MariaDB 10.3. The only way to workaround this issue is to drop this table and recreate it from backup without mentioned index or with shortened index prefix length.

      Attachments

        Activity

          People

            bar Alexander Barkov
            Lachman Miroslav Lachman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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