4

Vanity causes me to visit this SEDE page from time to time to check out how hot I am. Today I felt like the evil queen in Cinderella because I received bad news:

received both errors:

Invalid object name 'StackExchange.Cstheory.Meta_Temp.dbo.posts'.

Invalid object name 'StackExchange.Tex_Temp.dbo.posthistory'.

Is this a temporary or transient error, or is this now broken?

Invalid object name 'StackExchange.Cstheory.Meta_Temp.dbo.posts'

The query was originally linked in a comment below How do I find out how hot I am? Is there an easy-to-see user's total HNQ (total hotness) counter?

3
  • 2
    It's the same issue as meta.stackexchange.com/questions/309917/…. As this is a new regression, not voting this as a duplicate. May 24, 2020 at 4:56
  • @SonictheStay-HomeHedgehog oh, today is Sunday, got it!
    – uhoh
    May 24, 2020 at 4:58
  • 1
    @SonictheStay-HomeHedgehog it's indeed strongly related; this time it's not a bug but a regular support question. I expect this might happen again in the future, so we can use this as an original.
    – Glorfindel Mod
    May 24, 2020 at 6:14

1 Answer 1

4

@Sonic is right, I encountered this before: What's the Codegolf_Temp database (and why does it mess up my query)?. That was a real bug; the SEDE refresh was stuck that Sunday and it took a staff member to repair the situation.

This time it's running smoothly; @rene explains here that it's part of the regular import process. You can check this simple query or a more complex one by @rene (fill a random number for the seed/cache breaker parameters) how the import is progressing; as I'm writing this, those _Temp databases don't exist anymore but Stack Overflow is still being imported.

You can either

  1. wait until the import is finished; I've set up a weekly monitor on a related query, and last week the import finished at 10:20 UTC.
  2. adjust the query so that it ignores _Temp databases. That is relatively easy (again, @rene explains how to do this), but the downside is that results are partially stale.
1

You must log in to answer this question.

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