Last modified: 2014-11-03 22:43:21 UTC
Short description: The workflow_user_* fields of the flow_workflow table are being dropped in the gerrit patch linked below. In preparation for the patch that stops inserting data into these rows the null constraints need to be removed. A followup request will be filed to drop the fields. Which wikis are affected: currently flow data is shared between wikis in flowdb on the extension1db cluster Which tables: flow_workflow What is the change to those tables: ALTER TABLE /*_*/flow_workflow CHANGE workflow_user_id workflow_user_id bigint(20) unsigned default null, CHANGE workflow_user_wiki workflow_user_wiki varbinary(32) default null; Links to gerrit changes and/or other related bug reports. https://gerrit.wikimedia.org/r/#/c/170503 https://gerrit.wikimedia.org/r/#/c/168553/
Done.
Sorry to bug you springle, I forgot we were deploying to officewiki this week which means there is a second database to update(due to officewiki being a privatewiki). We also need to apply this database change to the officewiki database.
(In reply to Erik Bernhardson from comment #2) > Sorry to bug you springle, I forgot we were deploying to officewiki this > week which means there is a second database to update(due to officewiki > being a privatewiki). > > We also need to apply this database change to the officewiki database. The table is empty, so I jfdi mysql:wikiadmin@db1038 [officewiki]> select * from flow_workflow; Empty set (0.02 sec) mysql:wikiadmin@db1038 [officewiki]> ALTER TABLE /*_*/flow_workflow -> CHANGE workflow_user_id workflow_user_id bigint(20) unsigned default null, -> CHANGE workflow_user_wiki workflow_user_wiki varbinary(32) default null; Query OK, 0 rows affected (0.64 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql:wikiadmin@db1038 [officewiki]>
