A wiki_settings column should be added to the cw_wikis. I think a MEDIUMTEXT is sufficient here.
Description
Status | Assigned | Task | ||
---|---|---|---|---|
Resolved | John | T194 [TRACKING] Add a special page that allows bureaucrats to manage some wiki settings | ||
Resolved | John | T567 Add wiki_settings column to cw_wikis table |
Event Timeline
An attempt to do this via pt-online-schema-change failed a few days ago, and resulted in an OOM with 3 minutes downtime.
The cause should be investigated (what is the bad query?), reported upstream (MariaDB? Percona?), and due to the high importance of this schema change (blocker for a goal), for now a regular ALTER should be used. This will mean the dblist cronjobs should be stopped, and CreateWiki should be disabled (read/write on cw_wikis won't work).
MariaDB [metawiki]> ALTER TABLE cw_wikis ADD COLUMN wiki_settings MEDIUMTEXT NULL;
Query OK, 0 rows affected (0.06 sec)
This is done from my perspective. I've added it to cw_wikis.sql. Since you never shared the original query, I can't debug your issues and my query may vary massively from what you wanted but you can just ALTER mine now.
Also keep in mind all the information you shared with "wiki_settings" and MEDIUMTEXT so that's all I've done.