What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

The tag synonym list on Stack Overflow offers as one of the tags I can vote synonyms to.

Well, I did have one post in that tag, but since 20 days ago I have none (the tag had been misapplied to that one question; note that it hadn't been present in the original revision either).

It looks like the tag creation privilege verification is either using long-obsolete information or not tidying up properly.

The tag synonym FAQ isn't clear on what the rules are, but I'm pretty sure “users who have had enough upvotes in that tag at some point” isn't desirable. I'd expect “users who currently have enough upvotes in that tag” (with perhaps some caching, but not that long).

share|improve this question
    
some of those udf synonyms don't seem right, but some are obvious –  Lance Roberts Jun 28 '11 at 23:57
1  
It seems I can vote for synonym tags I have not suggested, when they are listed under the "suggested" tab, even if I don't have up-votes for the master tag. It doesn't happen for synonyms shown under the "all" tag, for which I get the message, "You do not have the required score on this tag to vote for this tag synonym." I don't know if this is by-design, or not; if it is by-design, then the explanation reported in the synonym page needs to be changed. –  kiamlaluno Jun 29 '11 at 0:15

1 Answer 1

up vote 6 down vote accepted

That would be cause I had a rather silly bug.

-- remove additional
delete ut 
from UserTagTotals ut 
left join #temp t on t.TagId = ut.TagId and t.UserId = ut.UserId 
where ut.Id is null

Should have been...

-- remove additional
delete ut 
from UserTagTotals ut 
left join #temp t on t.TagId = ut.TagId and t.UserId = ut.UserId 
where t.TagId is null

300,000 rows were just successfully deleted.

This was a caching only issue. We build a cache daily for the various top user pages, and also happen to use it for the vote check.

share|improve this answer
    
Wow.. that looks like a headache! +1 –  Billy ONeal Jul 4 '11 at 4:15

You must log in to answer this question.

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