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

MariDB 10.2.2 errno: 140 "Wrong create options", when creating an innodb Table with 'ROW_FORMAT=FIXED' options

    XMLWordPrintable

Details

    Description

      When trying to create an innodb table with this settings

      CREATE TABLE `__syssequences` (
      `systemName` CHAR(50) NOT NULL,
      `sequenceName` CHAR(50) NOT NULL,
      `sequenceStep` INT(11) DEFAULT '1',
      `lastValue` INT(11) DEFAULT '1',
      `lastInsert` DATETIME DEFAULT '0000-00-00 00:00:00',
      `lastUpdate` DATETIME DEFAULT '0000-00-00 00:00:00',
      PRIMARY KEY (`systemName`,`sequenceName`)
      ) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED

      Can't create table `ezgobx`.`__syssequences` (errno: 140 "Wrong create options")

      If I remove ROW_FORMAT=FIXED or set ROW_FORMAT=DEFAULT it works perfect. I used that creation option in mysql 5.6 wihout issues

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            fduenas Francisco Dueñas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 5d
                5d
                Remaining:
                Remaining Estimate - 5d
                5d
                Logged:
                Time Spent - Not Specified
                Not Specified

                Git Integration

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