18

Normally, at 03:00 UTC each Sunday the Stack Exchange Data Explorer is being refreshed with the weekly full backup from all sites.

I have this query to check on the status of the refresh as it takes 6 to 8 hours to complete. The current output at 10:50 UTC is

enter image description here

which makes me believe the job didn't start at all.

This is similar to SEDE refresh didn't happen this Sunday.

I know an e-mail will be sent to the SRE mailbox in case the job fails but I'm not sure if an e-mail is sent if the job doesn't start at all.

Can you look into what caused the failure to start and while you're at it, start the job manually for us?

Improve this question
0

1 Answer 1

Reset to default
15

The job did kick off but it failed immediately. I made a quick change to the procedure to bypass the failed query to allow the refresh to continue. I've kicked off the process and the refresh has started again.

I suspect there might be something in the latest patch of SQL Server that impacted this, as we just pushed the latest patch this week, but that's a future me problem (aka a tomorrow problem).

Thanks for the report.

Improve this answer
0

You must log in to answer this question.

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