11

So far, it seems to be:

The first query gives me no results, the second gives me two rows:

    TagName           UpVotes
    ==========================
    javascript        10
    hidden-features   10

What's strange about this is that I have an answer in Hidden features of JavaScript, which is tagged as above. My answer has 10 up votes, so it's as if the second query is only finding those up votes.

These queries worked before, so I'm not sure what broke them. I've tested them with a few user IDs from the top user list with similar results. I've also tried several other queries that worked fine. The same queries appear to work for the other sites in the main trilogy.

10
  • Same for me, though I do see cached results form the previous month.
    – Kobi
    Commented Sep 7, 2010 at 9:56
  • 1
    Same for me too. The queries work on MSO not SO Commented Sep 7, 2010 at 9:58
  • @Barry: yes, you're right. It looks like it's only broken for Stack Overflow.
    – Andy E
    Commented Sep 7, 2010 at 10:29
  • Possible Duplicate: meta.stackexchange.com/questions/61253/… Commented Sep 7, 2010 at 12:25
  • Just made an account so nothing is cached for me. Numbers for SO are displaying only for comments, so only queries against the comment table are working for me. Commented Sep 7, 2010 at 14:18
  • @Bobby: judging from waffles' answer this problem relates to the size of the latest data dump. A similar issue, yes, but in this case the data isn't being returned because it's not there and not because the result set is too large.
    – Andy E
    Commented Sep 7, 2010 at 15:02
  • @Andy E's head: True. Commented Sep 7, 2010 at 18:23
  • Yeah for some reason PostTags is blank, working on a fix
    – waffles
    Commented Sep 8, 2010 at 2:56
  • Mony more queries do not work.
    – Iznogood
    Commented Sep 8, 2010 at 4:44
  • @waffles - I still get incomplete results, for example, 128 on the jQuery tag, when I have over 400: odata.stackexchange.com/stackoverflow/s/299/… (oh, I see this already reported in the answer, sorry. Good luck, and thanks!)
    – Kobi
    Commented Sep 8, 2010 at 8:03

1 Answer 1

11

I have attempted once, twice or thrice four times to upload the Data and SQL Azure just shuts the connection on me after loading up a few million votes.

I will fix SO slow tomorrow so it has a more graceful way of restarting / resuming the process.

It should be online again in the next day or so.

Fixed now I added retry logic which made the importer go through, this should not be a problem again next month.

Damn you question number 98566 ... https://stackoverflow.com/questions/98566 .. why no tags?

Its fixed now ... for reals

9
  • uh... I'm not sure that it is. It's still reporting far fewer votes for each tag for me - my highest ([javascript]) reports 45 up votes even though I have the gold specialist badge for that tag. Also, the generalist query shows that I only have 1 tag qualified in the top 40, whereas I previously had around 12 or 13.
    – Andy E
    Commented Sep 8, 2010 at 7:51
  • @Andy GAHHHHHH .... perhaps our data dump for august is buggy ... will look at this tomorrow
    – waffles
    Commented Sep 8, 2010 at 7:59
  • It probably has no tags because of the removal of meta tags - [subjective] and the like - from the database.
    – ChrisF Mod
    Commented Sep 8, 2010 at 8:05
  • 3
    Is it fixed? The data is from October 2009? odata.stackexchange.com
    – Jonas
    Commented Sep 8, 2010 at 8:57
  • @ChrisF: strange, it should've at least be automatically tagged [untagged]. Commented Sep 8, 2010 at 9:20
  • Just noticed that someone voted to close that question (98566) as "belongs on superuser.com". I doubt that would go down well with the SU community. Added my vote for off-topic, I can't believe it's survived this long without being at least closed, locked and made CW.
    – Andy E
    Commented Sep 8, 2010 at 9:27
  • 1
    @Andy: added my OT vote too. Commented Sep 8, 2010 at 11:04
  • Death of Meta Tags
    – ChrisF Mod
    Commented Sep 8, 2010 at 11:42
  • @waffles: 'tis fixed now. Did you do that?
    – Andy E
    Commented Sep 8, 2010 at 13:55

You must log in to answer this question.

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