607448 - New add-ons can take many hours to appear

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Developer Pages, defect, P1)

Description

[Justin Scott [:fligtar]]

We've seen a number of complaints that after submitting an add-on in the sandbox, the details page is 404 for most of the day afterwards.

I just showed Jeff an example of an add-on that was submitted 4 hours ago but still 404 because the latest version field was empty. (It's since been fixed.)

Comment 1

[Jeff Balogh (:jbalogh)]

QA: I'm going to add more logging around changing current versions.  Then we can try to reproduce on prod (or wait for someone else to complain) and narrow down the cause.

Comment 2

[Wil Clouser [:clouserw]]

Looks like a dupe of Bug 556250?

Comment 3

[Justin Scott [:fligtar]]

Delays of 10 or more hours for an add-on to appear are totally unacceptable. We can't bump this again.

Comment 4

[Wil Clouser [:clouserw]]

(In reply to comment #3)
> Delays of 10 or more hours for an add-on to appear are totally unacceptable. We
> can't bump this again.

I didn't think it was still reproducible?  Jeff, what did the logging in comment 1 turn up?

Comment 5

[Jeff Balogh (:jbalogh)]

I looked at the log when adblock was bumped and the current version got set at least five times before it stuck.  When I was playing with this in the shell, I couldn't see the effect of bumping a current_version on a slave until I restarted ipython.  That sounds like we have an open transaction that's not committing properly.

Comment 6

[Jeff Balogh (:jbalogh)]

Calling this tentatively fixed by https://github.com/mozilla/nuggets/commit/0d369653626.  We're committing transactions after every test now, and I suspect that was the problem.