https://bugzilla.wikimedia.org/show_bug.cgi?id=63500
Bug ID: 63500 Summary: Flow: broken flow table on beta labs Product: Wikimedia Labs Version: unspecified Hardware: All URL: http://en.wikipedia.beta.wmflabs.org/wiki/Talk:Flow_QA OS: All Status: NEW Severity: normal Priority: Unprioritized Component: deployment-prep (beta) Assignee: wikibugs-l@lists.wikimedia.org Reporter: sp...@wikimedia.org CC: benap...@gmail.com, cmcma...@wikimedia.org, g...@wikimedia.org, has...@free.fr, mhershber...@wikimedia.org, platoni...@gmail.com Web browser: --- Mobile Platform: --- Gerrit 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 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 115576. So the maintenance script has to be smart about whether it applies. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l