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?

  • 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


@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.

You must log in to answer this question.

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