Page MenuHomePhabricator

Fatal database query error when scrolling up on Flow board
Closed, DuplicatePublic

Description

  1. View https://www.mediawiki.org/wiki/Talk:Compatibility
  2. Click "Browse topics" and scroll down in the list of topics to the 15th topic or lower in the list (basically any topic that hasn't already been preloaded on the page and needs to be lazy-loaded).
  3. Once the interface is done taking you down to section 15 and it loaded it, now slowly scroll back up, which should lazy-load topic 14, 13, 12 etc.

Instead:

Network debug
The following request is made repeatedly whenever I touch the trackpad to scroll up another pixel. Which means it keeps retrying. This is confirmed by the red error being replaced by a gear-spinner animation, and then back to another red error, and this repeats itself after every scroll event.

Console debug

[FLOW] apiRequest already in progress loadMoreTopics Array[3]
[FLOW] apiRequest already in progress loadMoreTopics Array[3]
[FLOW] apiRequest already in progress loadMoreTopics Array[3]
[FLOW] apiRequest already in progress loadMoreTopics Array[3]
[FLOW] apiRequest already in progress loadMoreTopics Array[3]
[FLOW] apiRequest already in progress loadMoreTopics Array[3]

  • 0: jQuery.Event
  • 1: Object
  • 2: Object
  • length: 3
  • __proto__: Array

Event Timeline

Krinkle created this task.Sep 29 2016, 6:54 PM
Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptSep 29 2016, 6:54 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Krinkle updated the task description. (Show Details)Sep 29 2016, 6:58 PM

Error: 1054 Unknown column 'workflow_last_update_timestamp' in 'order clause' (10.64.16.18)

SBisson added a subscriber: SBisson.EditedSep 29 2016, 7:02 PM

Sadly this has been known for a long time.

Getting rid of the Flow Index layer would solve that and many other issues while simplifying the code. I don't know if we can expect that to happen soon. There must be a quick fix we can put in place because this is really embarrassing.