Page MenuHomePhabricator

Unknown column 'workflow_last_update_timestamp' in 'order clause'
Closed, DuplicatePublic

Description

Rolled out 1.29.0-wmf.17 to group0 and started seeing a lot of DBQueryErrors

At a glance all appear to be related to Flow

Details: https://logstash.wikimedia.org/goto/86ad9f1b0aec2c367d0a2d49dddbe1c5

Full error:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: SELECT  *  FROM `flow_topic_list`    WHERE topic_list_id = '<foo>'  ORDER BY workflow_last_update_timestamp desc LIMIT 11  
Function: Flow\Data\Storage\BasicDbStorage::find (flow_topic_list)
Error: 1054 Unknown column 'workflow_last_update_timestamp' in 'order clause' (10.64.16.18)

Event Timeline

Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptMar 21 2017, 9:03 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
demon added a subscriber: demon.Mar 21 2017, 9:05 PM

Full stracktrace:

#0 /srv/mediawiki/php-1.29.0-wmf.17/includes/libs/rdbms/database/Database.php(919): Database->reportQueryError(string, integer, string, string, boolean)
#1 /srv/mediawiki/php-1.29.0-wmf.17/includes/libs/rdbms/database/Database.php(1255): Database->query(string, string)
#2 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Data/Storage/BasicDbStorage.php(148): Database->select(string, string, array, string, array)
#3 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Data/Storage/BasicDbStorage.php(163): Flow\Data\Storage\BasicDbStorage->find(array, array)
#4 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Data/Storage/BasicDbStorage.php(180): Flow\Data\Storage\BasicDbStorage->fallbackFindMulti(array, array)
#5 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Data/ObjectLocator.php(103): Flow\Data\Storage\BasicDbStorage->findMulti(array, array)
#6 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Data/ObjectLocator.php(64): Flow\Data\ObjectLocator->findMulti(array, array)
#7 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Data/Pager/Pager.php(130): Flow\Data\ObjectLocator->find(array, array)
#8 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Block/TopicList.php(479): Flow\Data\Pager\Pager->getPage(Closure$Flow\Block\TopicListBlock::getPage;495966428)
#9 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Block/TopicList.php(266): Flow\Block\TopicListBlock->getPage(array)
#10 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Api/ApiFlowBaseGet.php(33): Flow\Block\TopicListBlock->renderApi(array)
#11 /srv/mediawiki/php-1.29.0-wmf.17/extensions/Flow/includes/Api/ApiFlow.php(98): Flow\Api\ApiFlowBaseGet->execute()
#12 /srv/mediawiki/php-1.29.0-wmf.17/includes/api/ApiMain.php(1544): Flow\Api\ApiFlow->execute()
#13 /srv/mediawiki/php-1.29.0-wmf.17/includes/api/ApiMain.php(545): ApiMain->executeAction()
#14 /srv/mediawiki/php-1.29.0-wmf.17/includes/api/ApiMain.php(516): ApiMain->executeActionWithErrorHandling()
#15 /srv/mediawiki/php-1.29.0-wmf.17/api.php(83): ApiMain->execute()
#16 /srv/mediawiki/w/api.php(3): include(string)
#17 {main}
demon renamed this task from DBQueryError line 1061 to Unknown column 'workflow_last_update_timestamp' in 'order clause'.Mar 21 2017, 9:06 PM
demon updated the task description. (Show Details)
Reedy added a subscriber: Reedy.Mar 21 2017, 9:09 PM

workflow_last_update_timestamp is in table flow_workflow, not flow_topic_list

Reedy added a comment.Mar 21 2017, 9:14 PM
This comment was removed by Reedy.
mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:10 PM