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:

Screen Shot 2016-09-29 at 19.54.06.png (911×1 px, 124 KB)

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

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

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

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.