Closed Bug 709166 Opened 8 years ago Closed 8 years ago

Firefox 9.0b5 does not show in advanced query and Admin UI

Categories

(Socorro :: Webapp, task, major)

x86
macOS
task
Not set
major

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: marcia, Assigned: brandon)

References

()

Details

https://crash-stats.mozilla.com/query?advanced=1

I cannot drill down by platform for 9.0b5 in the advanced query. It does show in the "Current Versions" dropdown - https://crash-stats.mozilla.com/products/Firefox.

Haven't seen this issue before, so filing a bug.
Duplicate of this bug: 709786
Summary: Firefox 9.0b5 does not show in advanced query → Firefox 9.0b5 does not show in advanced query and Admin UI
This is urgent as we need to look at 9.0b5 data to figure out how the rapidly nearing 9.0 release will fare and if there's any last-minute things we need developers to look at.
Severity: normal → critical
Verified that 9.0b5 is present in the database and is marked current, and has been present since 12/06.  So this is not a database issue.
This now also affects 9.0b6 and we'd need 9.0b5 to be on the front page right now.

Are you sure this version is in all tables the UI is using? Maybe those pages are still using some table that is not considered to be necessary for current use.
Adrian, can you take a look please?
Assignee: nobody → adrian
I think this is a caching issue. Brandon recently cached the result of the current products list call from the middleware. I guess the time to live of that cache is not short enough, and should be reduced. 

CCing Brandon, can you please confirm?
Restarting memcached fixes this issue on prod.

It's supposed to refresh every 30 minutes, Brandon is taking a look at this.
Assignee: adrian → bsavage
It appears that what the code is doing is pulling the data, using it, and then restoring the same (stale) data with a new TTL. The only way that the data would ever expire is if we had no activity for 30 minutes, which is not the intent.

I have added a flag in https://github.com/mozilla/socorro/pull/221 that triggers a save only when the data is modified in some way. Otherwise the cache will be allowed to expire. The cache is manually expired, when changes are made, as well.
I see the entries for 9.0.b5 and 9.0b6 in the UI, but when I query for either I get an error.
Commit pushed to https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/51771628735a21b8219238825f14cc2ab7401c0a
Merge pull request #221 from brandonsavage/bug709166

Bug 709166 - Adding a flag to check and make sure we are refreshing the data from time to time.
Severity: critical → major
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → FIXED
Target Milestone: --- → 2.3.5
Commits pushed to https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/491612a8133722bf687d9d8c7eea5c66f358c3f7
Bug 709166 - Adding a flag to check and make sure we are refreshing the data from time to time.

https://github.com/mozilla/socorro/commit/51771628735a21b8219238825f14cc2ab7401c0a
Merge pull request #221 from brandonsavage/bug709166
Commit pushed to https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/d24fa718686e659efed1222966c34965257b66f8
Bug 709166 - Adding a flag to check and make sure we are refreshing the data from time to time.
Verified on stage: I can drill down by platform for 9.0b5 in the advanced query. Results look correct. The expected beta builds are also present in the admin ui.
Status: RESOLVED → VERIFIED
Component: Socorro → General
Product: Webtools → Socorro
Component: General → Webapp
You need to log in before you can comment on or make changes to this bug.