#6709 Performance issues in ACL logic for blocking users

v1.0.1
closed
General
2015-08-20
2013-09-24
No

Suspect changes from [#6392] like https://sourceforge.net/p/allura/pastebin/5241fe8d1be1ce40366e7b29 are at fault.

Seeing a lot of queries like:

Tue Sep 24 20:52:23.721 [conn5127276] query pyforge.project_role query: { project_id: ObjectId('50c218025fcbc909b58b271b'), name: "*anonymous" } ntoreturn:0 ntoskip:0 nscanned:1591 keyUpdates:0 numYields: 10 locks(micros) r:1780438 nreturned:1 reslen:108 1094ms

Which is an unindexed query and perhaps not even a necessary query, when it is *anonymous

Related

Tickets: #6392

Discussion

  • Tim Van Steenburgh

    • status: open --> in-progress
    • assigned_to: Tim Van Steenburgh
     
  • Tim Van Steenburgh

    • status: in-progress --> code-review
     
  • Tim Van Steenburgh

    allura:tv/6709

     
  • Dave Brondsema

    Dave Brondsema - 2013-09-25
    • QA: Dave Brondsema
     
  • Dave Brondsema

    Dave Brondsema - 2013-09-25
    • status: code-review --> closed
    • Size: --> 2
     

Log in to post a comment.