Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • I would like to hear if the SRE team did get their email ... or if this is caused by another not yet known fail case
    – rene
    Commented Sep 2, 2018 at 8:10
  • @rene There was no failure, the job ran successfully. As far as the 'updated x' time, I'll see what we can do about fixing it.
    – Taryn
    Commented Sep 4, 2018 at 13:49
  • @Taryn I don't think you can or you have to move the update of that LastPost field for all sites (databases) to the end of the job, no? Then it still is inaccurate as some sites got their refresh already... Maybe I should add that LastPost field to show in an hover for each site in the SEDE front page. Alternatively/additionally we could add an extra appsetting to indicate if the data is being updated. At the start of the job it has to be set to true, at the end to false.
    – rene
    Commented Sep 4, 2018 at 14:19
  • It is clear that our multi-db scripts need to handle the existence of these _temp db's nicely.
    – rene
    Commented Sep 4, 2018 at 14:21
  • @Taryn Is the sp_refreshDatabase.sql updated and if it is would it be possible to share that newer version? I find myself trying to guess what is in the black-box and I realize it is easier if I know which scripts run and what they touch in SEDE so I can make a better judgement call on what is going on and on which end the work needs to be done to have the simplest solution that might work.
    – rene
    Commented Sep 4, 2018 at 14:42
  • @rene It looks like that's the current version being used.
    – Taryn
    Commented Sep 4, 2018 at 14:52