Page MenuHomePhabricator

Display a notice if database appears to be significantly behind current time
Closed, ResolvedPublic

Description

Occasionally the collection script stops working (T214060), and while there are now a couple of things in place to prevent that from happening randomly, it still may be the case from time to time that the script is stopped and the tool is out of date.

We should check the most recent timestamp in the database and if it's more than, say, an hour or two back from the current time, display an informational notice to users that the latest edits may not be reflected in the tool.

Obviously we'd ideally avoid this case arising at all, but this will be a nice feature to have if it ever needs to, such as if we have to load the db from a backup or stop the collection script for any significant period of time.

Event Timeline

Samwalton9-WMF renamed this task from Show a notice if database appears to be significantly behind current time to Display a notice if database appears to be significantly behind current time.Feb 21 2019, 4:13 PM
Samwalton9-WMF triaged this task as Low priority.
Samwalton9-WMF created this task.

What table will it be looking at for this timestamp? Also, what style of notice will it be displaying; is there another one like it, that it can be modeled after? Thanks.

I am working on it. I will raise a PR soon. :)

Samwalton9-WMF claimed this task.
Samwalton9-WMF moved this task from Features to Doing on the Hashtags board.