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

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

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync