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

create table fails with row size too large in 10.3 but not 10.1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.3.17
    • N/A
    • Server
    • None

    Description

      The following create table fails on 10.3 but works fine on 10.1.

      Error is: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

      How to reproduce:

      CREATE TABLE `orders` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `field1` varchar(255) DEFAULT NULL,   `field2` varchar(255) DEFAULT NULL,   `creationDate` datetime DEFAULT NULL,   `modificationDate` datetime DEFAULT NULL,   `modifiedBy` varchar(255) DEFAULT NULL,   `modifiedBySystem` varchar(255) DEFAULT NULL,   `field4` datetime DEFAULT NULL,   `field5` varchar(255) DEFAULT NULL,   `field6` varchar(255) DEFAULT NULL,   `field7` varchar(255) DEFAULT NULL,   `field8` datetime DEFAULT NULL,   `fuffa` varchar(255) DEFAULT NULL,   `field9` varchar(255) DEFAULT NULL,   `field10` varchar(255) DEFAULT NULL,   `fuffa2` datetime DEFAULT NULL,   `field11` varchar(255) DEFAULT NULL,   `field12` varchar(255) DEFAULT NULL,   `field13` varchar(255) DEFAULT NULL,   `field14` varchar(255) DEFAULT NULL,   `field15` varchar(255) DEFAULT NULL,   `field16` varchar(255) DEFAULT NULL,   `field17` int(11) DEFAULT NULL,   `field18` varchar(255) DEFAULT NULL,   `field19` varchar(255) DEFAULT NULL,   `field20` varchar(255) DEFAULT NULL,   `field21` varchar(255) DEFAULT NULL,   `field22` int(11) DEFAULT NULL,   `field23` varchar(255) DEFAULT NULL,   `field24` varchar(255) DEFAULT NULL,   `field25` varchar(255) DEFAULT NULL,   `field26` varchar(255) DEFAULT NULL,   `field27` varchar(255) DEFAULT NULL,   `field28` varchar(255) DEFAULT NULL,   `field29` varchar(255) DEFAULT NULL,   `field30` varchar(255) DEFAULT NULL,   `field31` int(11) DEFAULT NULL,   `field32` varchar(255) DEFAULT NULL,   `field33` varchar(255) DEFAULT NULL,   `field34` varchar(255) DEFAULT NULL,   `field35` varchar(255) DEFAULT NULL,   `field36` varchar(255) DEFAULT NULL,   `field37` varchar(255) DEFAULT NULL,   `field38` varchar(255) DEFAULT NULL,   `field39` varchar(255) DEFAULT NULL,   `field40` varchar(255) DEFAULT NULL,   `field41` varchar(25T NULL,   `field46` varchar(255) DEFAULT NULL,   `field47` varchar(255) DEFAULT NULL,   `field48` varchar(255) DEFAULT NULL,   `field49` varchar(255) DEFAULT NULL,   `field50` varchar(255) DEFAULT NULL,   `field51` varchar(255) DEFAULT NULL,   `field52` int(11) DEFAULT NULL,   `field53` varchar(255) DEFAULT NULL,   `field54` varchar(255) DEFAULT NULL,   `field55` tinyint(1) DEFAULT NULL,   `field56` varchar(255) DEFAULT NULL,   `field57` varchar(255) DEFAULT NULL,   `field58` varchar(255) DEFAULT NULL,   PRIMARY KEY (`id`)) Engine=InnoDB;
      ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
      

      Attachments

        Issue Links

          Activity

            People

              kevg Eugene Kosov (Inactive)
              rpizzi Rick Pizzi
              Votes:
              1 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.