18

Buddhism is interesting, surely, but either the weekly SEDE refresh has gained some Artificial Intelligence and is contemplating rebirth, or something is stuck. I'm not sure which one to hope for!

I'm looking at rene's SEDE query Status of the SEDE Refresh on Sunday 03:00 UTC to check the status, which is currently (in part):

. category database_id Description create_date days ago
3 restoring 70 StackExchange.Buddhism_Temp 2022-09-18 04:08:56 0

... which is about 11 hours before the time of this posting.

7
  • 4
    Yeah, that is stuck.
    – rene
    Sep 18, 2022 at 15:56
  • 4
    We're working on this.
    – Aaron Bertrand Staff
    Sep 19, 2022 at 14:50
  • @AaronBertrand thanks, this appears to happen more and more often recently, and every time someone first reports it, then wait until a moderator adds the status-review tag, then you guys doing awesome work of solving the case. Any chance this process can be simplified, e.g. automatic monitoring? Sep 19, 2022 at 14:55
  • 8
    @ShadowTheKidWizard To be clear, this meta post or any moderator action isn't what triggered us to work on this, in fact we were already working on it and one of us asked "I wonder if meta has a report yet?"
    – Aaron Bertrand Staff
    Sep 19, 2022 at 14:57
  • @Aaron oh, that's good to hear. That said, any update on the progress here? :) Sep 19, 2022 at 15:04
  • 3
    @ShadowTheKidWizard This is the first thing we started working on when we came online on a Monday morning, given that we don't currently have an SLA for weekend/overnight response.
    – Aaron Bertrand Staff
    Sep 19, 2022 at 15:09
  • Stack Overflow finally finished on Sep 20 @ ~22:07 UTC.
    – Aaron Bertrand Staff
    Sep 20, 2022 at 23:54

1 Answer 1

16

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours. Note: Stack Overflow takes the longest, and had a failure overnight, so finished Sep 20 @ ~22:07 UTC.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.
1
  • 4
    That's awesome, it's really not trivial you put so much effort into SEDE. Thanks! :) Sep 19, 2022 at 15:21

You must log in to answer this question.

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