Unhandled exception when accessing Badges

Reproduction Instructions

  1. When accessing a badges page (i.e. https://phabricator.miraheze.org/people/badges/1434/) the error appears

Please note that it’s not happening for all users, only some. Here is the PHP log:

php.log:[08-Aug-2019 08:09:18 UTC] [2019-08-08 08:09:18] EXCEPTION: (Exception) Query (of class "PhabricatorBadgesQuery") overheated: examined more than 10 raw rows without finding 1 visible objects. at [<phabricator>/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:339]

Details:
https://phabricator.miraheze.org/T4618

Phabricator/Arcanist Version

phabricator

0561043a1f575567b9619637837e86723d977207 (Wed, Aug 7)

arcanist

d92fa96366c0ed50e4257508148aa75192d4fb1f (Jun 21 2019)

phutil

b416093386a225b1d9a2de906899b94cbf4babcb (Jul 9 2019)

php

7.3.7-2+0~20190725.42+debian9~1.gbp848ca5

diff

3.5 at /usr/bin/diff

git

2.20.1 at /usr/bin/git

hg

Not Available

pygmentize

2.2.0 at /usr/bin/pygmentize

svn

1.9.5 at /usr/bin/svn

BTW: if you need device info etc. I am the reporting user

Thanks!

This is sort of similar to https://secure.phabricator.com/T13349. The reproduction steps are likely something like this:

  • As user Alice, create 12 secret badges which are visible to only you.
  • Award yourself all 12 badges.
  • As user Bailey, view Alice’s badges.

I’ll confirm this and file it upstream.

(For more discussion of “overheated queries”, see: https://phurl.io/u/overheated).

Thank you. In this case the user is visiting their own profile, and gets the error (even though they don’t have any badges)

I reproduce this and filed it upstream as https://secure.phabricator.com/T13370. The actual issue was slightly different than I guessed above.

This should be resolved by https://secure.phabricator.com/D20702.

Thanks for the quick response.

@Reception123: can we look at adding this to our instance?

I’d assume it will be part of the next update

Thanks for getting to this so quick and releasing updates!