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

Row size too large (> 8126)

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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19292 "Row size too large" error when creating table with lots columns when row format is DYNAMIC or COMPRESSED

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-16969 Fix error message as promised in upstream Bug #69336

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-23521 Implement an InnoDB row format that can use overflow pages for smaller columns

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          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.