SEDE currently states it was updated 11 minutes ago:

enter image description here

However this does not appear to be the case, as this query:

  max(creationdate) [last action],
  datediff(day, max(creationdate), getdate()) [days ago]
from posthistory

When run on SO, currently yields:

last action         days ago 
------------------- -------- 
2017-07-02 05:18:54 8   

Which suggests that no data exists for the past 7 days.

I had originally just assumed this was an issue on all sites but the comment below points out (and I've confirmed) that it's not. So far I haven't found any other sites that exhibit this behavior besides SO (including MSO, which is up-to-date).

  • 1
    When running on MSE it returns the MAX(CreationSate) as 2017-07-10 17:16:34
    – Arulkumar
    Commented Jul 10, 2017 at 17:54
  • @adamlear I don't follow the status by design. Do you mean SEDE is not supposed to update or that when partial updates took place the outcome will be as the OP noticed or did you maybe pick the wrong tag? In the latter case there is coffee for you in the Tavern ...
    – rene
    Commented Jul 10, 2017 at 21:18
  • @rene See Nick's answer. The date is updated as DBs are refreshed, going from newest site to oldest. The display is confusing, but "by design" if you tilt your head and squint a little. (Update failure over the weekend is a separate issue and not what's being reported here.)
    – Adam Lear StaffMod
    Commented Jul 10, 2017 at 21:22
  • I closed my eyes and now I see what you mean .. ;) ... I'll take the coffee ...
    – rene
    Commented Jul 10, 2017 at 21:27

1 Answer 1


The job failed this weekend because the READ UNCOMMITTED gods were against us. Luckily we sacrificed some regexes on the pillar of please-let-this-workiness to the hamster gods and it's re-running. It takes many hours.

The screen isn't wrong, but I totally see how it's misleading here. Some data was refreshed just now, but Stack Overflow hasn't been hit yet, it'll take several more hours to finish. The process goes from newest sites to oldest (meaning Stack Overflow is last), I'll be keeping an eye on it.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .