[EXPORTING] Data too long for column 'roles' when importing feature

Created on 26 November 2014, almost 11 years ago
Updated 9 September 2025, 23 days ago

With a relatively large workflow that has many roles, we started getting this warning after rebuilding a site based on a features export. The lengths the transitions were greater than 255 characters. I noticed that all the transitions that had long lengths were specified for a transition from the state to the same state. e.g 1_1, 2_2, 3_3, etc. And the reason the length was greater than 255 was because each of those self transitions included every one of our roles (of which we had many).

"a:20:{i:-1;i:-1;i:3;s:1:"3";i:21;s:2:"21";i:5;s:1:"5";i:8;s:1:"8";i:11;s:2:"11";i:6;s:1:"6";i:9;s:1:"9";i:12;s:2:"12";i:7;s:1:"7";i:14;s:2:"14";i:18;s:2:"18";i:19;s:2:"19";i:17;s:2:"17";i:20;s:2:"20";i:16;s:2:"16";i:13;s:2:"13";i:15;s:2:"15";i:10;s:2:"10";i:4;s:1:"4";}"

For the time being I have created a patch which allows us to proceed by changing the column type to 'text'. But I'd be curious to know why these self transitions are needed.

🐛 Bug report
Status

Closed: outdated

Version

2.0

Component

Features

Created by

🇨🇦Canada arvinsingla

Live updates comments and jobs are added and updated live.
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