[MDEV-10364] Row size too large (> 8126) - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Duplicate
Affects Version/s: 10.1.10, 10.1.15
Fix Version/s: 10.2.26, 10.3.17, 10.4.7
Component/s: Storage Engine - InnoDB
Labels:
- upstream
Environment:
Linux 2.6.32-573.el6.x86_64 #1 SMP Wed Jul 1 18:23:37 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux

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

MDEV-19292 "Row size too large" error when creating table with lots columns when row format is DYNAMIC or COMPRESSED

Closed

relates to

MDEV-16969 Fix error message as promised in upstream Bug #69336

Open

MDEV-23521 Implement an InnoDB row format that can use overflow pages for smaller columns

Open

Activity

People

Assignee:: Eugene Kosov (Inactive)

Reporter:: ManasaTulluri

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2016-07-12 11:01

Updated:: 2019-10-23 13:30

Resolved:: 2019-08-14 19:16

Git Integration

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