Last modified: 2014-04-04 00:10:50 UTC
Gerrit change #122865 added a maintenance script (db_patches/patch-add_workflow_type.sql) that did too much, dropping the DB column `flow_workflow.workflow_definition_id` prematurely. We fixed the script in Gerrit change #123501 but beta labs somehow ran the buggy version, and now the column is gone causing Unknown column 'workflow_definition_id' in 'where clause' There are three ways to fix this on beta labs: a) Manually add back the DB column the buggy maintenance script dropped. We've already gone through the steps on our labs instance. b) Drop all the Flow tables and let maintenance scripts re-add them. c) Write a smart maintenance script that figures out if the column was dropped and adds it back. a) or b) is quick but will require beta labs DB access by the Flow team... how? c) we can do on our own, but it's tricky because as I understand it, we really do want to drop that column, but not until Gerrit change #115576. So the maintenance script has to be smart about whether it applies.
Matthias Mullie repaired the beta labs DB, approach (a). Old content is visible on Talk:Flow, but currently http://en.wikipedia.beta.wmflabs.org/wiki/Talk:Flow_QA only shows recent posts; this is probably a caching issue.
