28469 - Query for UNCONFIRMED returns a bug report in NEW state

Status: VERIFIED FIXED

(Bugzilla :: Bugzilla-General, defect, P3)

Description

[John Morrison]

Noticed this bit of "teething pain" for the new UNCONFIRMED state.

The URL in the bug_file_loc for this bug report is the result of a
query.cgi, where I selected UNCONFIRMED for status, and sorted by Bug
Number (although the sort is not the issue). [All other fields were
left as the default value].

I get back 28 bugs (at this time). If you look through the list you
will see bug #28421.

Click on that bug report, and you'll see that it's actually in the NEW
state, and the assigned to field is now karnaze (not troy as it
appears in the query result set).  [I was the one who confirmed the
bug and reassigned to karnaze/HTMLFrames].

Not sure why the query result set is returning the stale information
(and I quit Nav4.7, deleted my cache, restarted and re-ran the query
-- I still see the wrong info in the result set -- so not a cache issue).

Thanks again, John

p.s. I did look for a dupl, but could not find one.
p.p.s. I get the same result set using either Nav4 or mozilla

Comment 1

[John Morrison]

So, now I see that running this query does not return bug 28421 in the result
set. Perhaps I was hitting a database cache (new code?) or some temporary 
quirk.

If the transient nature of this "bug" makes sense to you, then just mark this 
as WORKSFORME and I'll VERIFY. (Perhaps I should look at more of the code, but 
if this is 'by design' then toss me a quick explanation :-]). 

Comment 2

[Terry Weissman]

My apologies.

I was repairing a database inconsistancy I caused a couple of days ago.  I chose
a poor repair technique, and it caused the read-only shadow database (which is
used for reports queries) to lag many hours behind the real database (which is
used for everything else).

I fixed it last night.  I'm very sorry for the confusion.

Comment 3

[John Morrison]

Hey. No apologies necessary. (When I saw this automagically correct itself, I 
figured there was some kind of db cache -- or in this case a read-only shadow
database (see, I learned something new about Bugzilla)). Thanks. John.

Comment 4

[Dave Miller [:justdave]]

Moving to Bugzilla product

Comment 5

[BMO Automation]

Attachment: [mozilla-mobile/fenix] Close #28469: Add notification permission prompt onboarding strings (#28470)

Comment 6

[BMO Automation]

Attachment: [mozilla-mobile/fenix] Close #28469: Update notification permission prompt onboarding strings (#28482)

Comment 7

[BMO Automation]

Attachment: [mozilla-mobile/fenix] Close #28469: Use placeholders in notification permission prompt onboarding strings (#28491)