743164 - obsolete approval requests showing up intermittently in My Requests

Status: RESOLVED DUPLICATE of bug 743145

(bugzilla.mozilla.org :: General, defect)

Description

[Jonathan Kew [:jfkthame]]

Several times in the past day or so, when I've loaded "My Requests" on b.m.o, the result has listed not only currently-pending review requests by me and to me, but also several approval requests that I made (in bug 739925) on 2012-03-28 and that were granted on 2012-04-02 (so they should no longer appear in the list).

Perhaps related: on looking at the History in bug 739925 just now, I see a record of making the approval requests, but there is no record of their being granted. Nevertheless, the flags show "+" as expected (and I have bugmail from when this was done).

What's particularly odd is that this is intermittent: during the course of yesterday, I loaded My Requests a number of times, and these stale requests were sometimes present, sometimes not. It's as though we're sometimes accessing an older version of the database, at least for that particular bug's record - although brand new requests also appear correctly in the same report.

I hear there was a bugzilla upgrade on b.m.o very recently, and I have also only noticed this issue recently (I first saw it early on 2012-04-05); I don't know if this is merely coincidence.

Comment 1

[Jonathan Kew [:jfkthame]]

Shortly after filing this, I re-loaded the History of bug 739925, and this time the latest couple of changes, including granting the approval requests, *did* show in the bug history. And on force-reloading My Requests, the obsolete approval requests disappeared from the list. It's like bugzilla isn't quite sure whether it remembers those changes or not...

Comment 2

[Jonathan Kew [:jfkthame]]

OK... I just force-reloaded (shift-clicking the Reload icon in the location bar)

https://bugzilla.mozilla.org/request.cgi?requester=jfkthame%40gmail.com&requestee=jfkthame%40gmail.com&do_union=1&group=type&action=queue

a couple of dozen times in succession. The three obsolete requests appeared intermittently at the top of the list (several times, but less than 50%), with no rhyme or reason.

Comment 3

[Teemu Mannermaa (:wicked)]

Sounds like one of the DB nodes are not in sync, so first thing to check is BMO DB status.

Comment 4

[:glob ✱]

(In reply to Teemu Mannermaa (:wicked) from comment #3)
> Sounds like one of the DB nodes are not in sync, so first thing to check is
> BMO DB status.

indeed.