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

Row size too large (> 8126)

    XMLWordPrintable

Details

    Description

      This warning:

      Warning |  139 | Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, *BLOB prefix of 768 bytes is stored inline
      

      that one gets while creating an InnoDB table (see comments below for specific syntax) with many columns, including varchar(N) with small enough N and utf8 character set, is misleading. Using ROW_FORMAT=DYNAMIC is not going to help. You'll get error instead:

      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.
      

      I'd also rephrase the error above, "0 bytes is stored inline" does not seem the best way to explain how the data are stored.

      Attachments

        Issue Links

          Activity

            People

              kevg Eugene Kosov (Inactive)
              Manasa ManasaTulluri
              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.