Page MenuHomePhabricator

Update ENC Hiera value column type to MEDIUMTEXT
Closed, ResolvedPublic

Description

Turns out the Hiera values set in deployment-prep's common ENC hiera are very close to the 65k limit of a TEXT field, and well over if combined with the Hiera data currently set for deployment-prep in puppet.git. We want to encourage using ENC since it lets more people work on deployment-prep, so the field needs bumping to MEDIUMTEXT. (Per docs.)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

In codfw1dev, seems to work just fine:

MariaDB [labspuppet]> ALTER TABLE hieraassignment CHANGE COLUMN hiera_data hiera_data MEDIUMTEXT NOT NULL;
Query OK, 31 rows affected (0.092 sec)             
Records: 31  Duplicates: 0  Warnings: 0

Data is still there.

Change #1332802 had a related patch set uploaded (by Majavah; author: Majavah):

[operations/puppet@production] openstack: puppet-enc: Allow MEDIUMTEXT worth of Hiera

https://gerrit.wikimedia.org/r/1332802

Mentioned in SAL (#wikimedia-cloud) [2026-08-31T20:07:53Z] <taavi> convert enc hiera field to MEDIUMTEXT to fit all of deployment-prep's data in there T436561

Change #1332802 merged by Majavah:

[operations/puppet@production] openstack: puppet-enc: Allow MEDIUMTEXT worth of Hiera

https://gerrit.wikimedia.org/r/1332802