Page MenuHomePhabricator

Flow: db errors "Unknown column 'workflow_user_text' in UPDATE 'flow_workflow'
Closed, ResolvedPublic

Description

Had one error like this:

Fri Jun 6 14:17:15 UTC 2014 mw1201 enwiki Flow\Data\BasicDbStorage::update (flow_workflow) 10.64.16.18
Unknown column 'workflow_user_text' in 'field list' (10.64.16.18)
UPDATE flow_workflow SET workflow_namespace = '5',workflow_user_text = NULL WHERE workflow_id = '^E^O<E6><B8>^A<CD>o7G<A8><90>'

There were 32 of these errors earlier in June, none in May. We did indeed drop this column, so it's weird that something was trying to update it.

27 minutes after that error, User:Wbm1058 reported at https://en.wikipedia.org/wiki/User_talk:Jimbo_Wales#Article_feedback_.E2.86.92_Flow :

... on Wikipedia talk:WikiProject Breakfast. So I tried to start a new topic there and put this into the edit box:

{{subst:Requested move|Wikipedia:WikiProject Meals|reason=Breakfast is too limited a topic for a WikiProject. Expand coverage to include lunch and supper as well.}}

I was not successful, as I see:

An error occurred.
The error message received was: Database query error

<<<

Maybe it's a coincidence. I retried doing this at https://en.wikipedia.org/wiki/Wikipedia_talk:Flow/Developer_test_page and got no error. That particular SQL command looks like maintenance/FlowSetUserIp.php, which I thought was run some time ago in production.

The API reports "Database query error", so maybe there was something in the API log, but that's 83,000,000,000 characters long!


Version: master
Severity: normal

Details

Reference
bz66303

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:23 AM
bzimport set Reference to bz66303.
bzimport added a subscriber: Unknown Object (MLST).
Mattflaschen-WMF claimed this task.

This should be fixed.