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

Incorrect ENGINE type of table after crash for CONNECT table

    XMLWordPrintable

    Details

      Description

      We had a mariadb crash today due to out of disk.

      After restoring the server all CONNECT tables had become ENGINE=SEQUENCE in their definition.

      Example schema:

      CREATE TABLE `history` (
        `itemid` bigint(20) unsigned NOT NULL,
        `clock` int(11) NOT NULL DEFAULT 0,
        `value` double(16,4) NOT NULL DEFAULT 0,
        `ns` int(11) NOT NULL DEFAULT 0
      ) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin `table_type`=MYSQL `option_list`='connect=mysql://[...]'
       PARTITION BY RANGE (`clock`)
      (PARTITION `p202202042100` VALUES LESS THAN (1644012000) ENGINE = CONNECT,
      [...])
      

      After crash:

      CREATE TABLE `history` (
        `itemid` bigint(20) unsigned NOT NULL,
        `clock` int(11) NOT NULL DEFAULT 0,
        `value` double(16,4) NOT NULL DEFAULT 0,
        `ns` int(11) NOT NULL DEFAULT 0
      ) ENGINE=SEQUENCE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin `table_type`=MYSQL `option_list`='connect=mysql://[...]'
       PARTITION BY RANGE (`clock`)
      (PARTITION `p202202042100` VALUES LESS THAN (1644012000) ENGINE = CONNECT,
      [...])
      

      I've checked a few things, the frm file has a refernce to CONNECT and the header doesnt indicate a Sequence either.

      00000020: 0005 0000 0000 2e00 0000 0000 0000 0010
      

      My guess is that it's the table repair process?

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            splitice Mathew
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.