layout_builder__layout_section column hitting database limit

Created on 1 February 2019, almost 6 years ago
Updated 11 March 2024, 8 months ago

Problem/Motivation

I have been working on an installation of Drupal 8 that is making use of the Layout Builder module extensively to build pages with Block Content. After adding about 10 blocks and various layouts to a page the limit for the column is hit resulting in the error:

String data, right truncated: 1406 Data too long for column 'layout_builder__layout_section' at row 2: INSERT INTO {node__layout_builder__layout}

Proposed resolution

Increase the size of the column from 'normal' to 'big'.

For MySQL/MariaDB, this will change the underlying field from a BLOB to a LONGBLOB, which allows much more data to be stored (over 65,000 times more). It's overkill, but Drupal doesn't have support for MEDIUMBLOB which is just a 256x increase over BLOB. The impact of this change on database storage should be very small. MySQL will use an extra 2 bytes of storage for each record when using a longblob vs blob.

Remaining tasks

Write upgrade path tests

User interface changes

N/A

API changes

N/A

Data model changes

Yes, non-disruptive change to field schema.

Release notes snippet

N/A

🐛 Bug report
Status

Needs work

Version

11.0 🔥

Component
Layout builder 

Last updated about 8 hours ago

Created by

🇨🇦Canada dpfitzsi

Live updates comments and jobs are added and updated live.
  • Blocks-Layouts

    Blocks and Layouts Initiative. See the #2811175 Add layouts to Drupal issue.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024