Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-12650

Typing a space or more into the user picker can result in heavy DB load

XMLWordPrintable

      Issue Summary

      By issuing a user search with multiple spaces it is possible to put high load on the database server.

      Steps to Reproduce

      1. In the user picker type '  a' (two spaces followed by an a, or indeed three spaces)

      Expected Results

      No requests made to server as the request should only be fired when three or more characters are typed.

      Actual Results

      The request is made to the server, it trims the spaces and issues a very inefficient query that may load the entire userbase into memory over a long period of time.

      Workaround

      Don't issue user searches with multiple leading spaces

              khughes@atlassian.com Kristy
              dkjellin Daniel (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: