3

At the moment of posting this, the SEDE homepage says it has been updated one hour ago:

enter image description here

However, when I try to execute a cross-site database query, it runs into an error:

enter image description here

According to Taryn's comment,

The job is scheduled to start at 3am UTC and runs for about 5 hours, so probably just some contention.

So that means I have to wait for an hour or so; no problem, but the 'Data updated' message is wrong right now (). Ideally (), it should show that a refresh is taking place right now.

  • 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 Sep 2 '18 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 Sep 4 '18 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 Sep 4 '18 at 14:19
  • It is clear that our multi-db scripts need to handle the existence of these _temp db's nicely. – rene Sep 4 '18 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 Sep 4 '18 at 14:42
  • @rene It looks like that's the current version being used. – Taryn Sep 4 '18 at 14:52

You must log in to answer this question.

Browse other questions tagged .