3415: Incoming counts on left nav panel is different from no. of review requests displayed

aj**@brookm******* (Google Code) (Is this you? Claim this profile.)
June 16, 2014
2268
What version are you running?
2.0.1

What's the URL of the page containing the problem?
/dashboard/

What steps will reproduce the problem?
1. Just go to /dashboard

What is the expected output? What do you see instead?
Expect to see Open count (and To Me count) of 3, but I see 4.  Only 3 review requests are displayed though.

What operating system are you using? What browser?
Centos, Firefox

Please provide any additional information below.
david
#1 david
This is a long-standing bug, and nobody has been able to nail down a series of steps to get the counts off for a while. Is this a relatively new server, or one which has been around for a long time (and upgraded from older versions)?
  • +NeedInfo
#2 aj**@brookm******* (Google Code) (Is this you? Claim this profile.)
Not sure how I got there either, but it suddenly showed up.

It is a relatively new install (couple of days ago).  Installed 1.7.25 to begin with and then upgraded to 2.0.1 yesterday.

Wouldn't a clue be the sql query or code that calculates the incoming count?  I can run the query against the sql db.
david
#3 david
The problem is that those counts are maintained by incrementing/decrementing counters, rather than querying it each time the dashboard is shown (it used to be a query, and we changed that for performance reasons). That's why we're trying to track down a specific set of reproduction steps (to find the missing increment/decrement)

If you'd like to just fix it now, you can run:
rb-site manage /path/to/site fixreviewcounts
#4 aj**@brookm******* (Google Code) (Is this you? Claim this profile.)
Yep - that worked.  Okay, will keep an eye out for this and see if it happens again.

Also, if you can just give me a pointer to where this code might be, I can put another set of eyes on it and see if something obvious pops up.
david
#5 david
If you want to look through the code, search for *_request_count
david
#6 david
Actually, Christian thinks he's got a solution.