Search functionality on the pull request page in Bitbucket Data center 10.2 with Oracle DB fails when the pull request description exceeds 4000 characters

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Medium
    • None
    • Affects Version/s: 10.2.0
    • Component/s: Pull Requests
    • None
    • Severity 2 - Major

      Issue Summary

      Search functionality on the pull request page in Bitbucket 10.2 with Oracle DB fails when the pull request description exceeds 4000 characters

      Steps to Reproduce

      1. Install Bitbucket 10.2 with an Oracle database.
      2. Create a pull request with a description exceeding 4000 characters.
      3. Use the search box on the pull request page to search for a specific string.

      Expected Results

      The search function should successfully return matching pull requests without any errors.

      Actual Results

      The below error is thrown in the atlassian-bitbucket.log file and 'A database error has occurred.' error shown in the UI.

      2026-03-19 13:11:30,530 WARN  [http-nio-7990-exec-3] admin @13BKHXEx791x708x0 hc6rq7 10.140.13.46,172.50.0.2 "GET /rest/api/latest/projects/PRO1/repos/repo5/pull-requests HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 22835, SQLState: 99999
2026-03-19 13:11:30,530 ERROR [http-nio-7990-exec-3] admin @13BKHXEx791x708x0 hc6rq7 10.140.13.46,172.50.0.2 "GET /rest/api/latest/projects/PRO1/repos/repo5/pull-requests HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4399, maximum: 4000)

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              Assignee:
              Unassigned
              Reporter:
              Aman Shrivastava
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: