This API provides access to the Buildbot test failure data. You can filter results using query parameters to retrieve specific test failures.

cr/api/testfailures/

/cr/health

• returns 200 OK if the database is reachable
• returns 500 otherwise

You can filter the results using the following optional query parameters:

GET cr/api/testfailures/

GET cr/api/testfailures/?branch=10.11&commit=95782e5cf2dbd977473f91a59bdb47da4bf6261e

GET cr/api/testfailures/?builder_name=amd64-ubasan-clang-20-debug&test_type=nm&limit=50

The API returns JSON list[dict] where each item is a unique test failure.

[
    {
        "builder_name": "amd64-ubasan-clang-20-debug",
        "commit": "95782e5cf2dbd977473f91a59bdb47da4bf6261e",
        "branch": "10.11",
        "test_name": "main.sp-error",
        "test_variant": "",
        "info_text": null,
        "failure_text": "\ncreate procedure proc_36510()\nbegin\ndeclare should_be_illegal condition for 0;\ndeclare continue handler for should_be_illegal set @x=0;\nend$$\nERROR HY000: Incorrect CONDITION value: '0'\ncreate procedure proc_36510()\nbegin\ndeclare continue handler for 0 set @x=0;\nend$$\nERROR HY000: Incorrect CONDITION value: '0'\nset @old_recursion_depth = @@max_sp_recursion_depth;\nset @@max_sp_recursion_depth = 255;\ncreate procedure p1(a int)\nbegin\ndeclare continue handler for 1436 -- ER_STACK_OVERRUN_NEED_MORE\nselect 'exception';\ncall p1(a+1);\nend|\ncall p1(1);\n\n\n\t\t\t"
    },
    {
        "builder_name": "amd64-ubasan-clang-20-debug",
        "commit": "95782e5cf2dbd977473f91a59bdb47da4bf6261e",
        "branch": "10.11",
        "test_name": "roles.acl_load_mutex-5170",
        "test_variant": "",
        "info_text": null,
        "failure_text": "\ncreate user user1@localhost;\ncreate role r1 with admin user1@localhost;\ngrant all on test.* to r1;\nflush tables;\nselect 1;\n1\n1\ndrop role r1;\ndrop user user1@localhost;\nline\n==333573==ERROR: LeakSanitizer: detected memory leaks\nSUMMARY: AddressSanitizer: 456 byte(s) leaked in 2 allocation(s).\n250912 11:07:55 [ERROR] /home/buildbot/bld/sql/mariadbd got signal 6 ;\nAttempting backtrace. Include this in the bug report.\n^ Found warnings in /dev/shm/normal/16/log/mysqld.1.err\nok\n\n\n\t\t\t"
    }
]

import requests

BASE_URL = "https://buildbot.mariadb.org/cr/api/testfailures/"

params = {
    "branch": "main",
    "commit": "abc123",
    "limit": 10
}

response = requests.get(BASE_URL, params=params)
data = response.json()
print(data)

• All query parameters are optional. Omitting them will return results up to a default limit of 50.
• Dates should be provided in ISO 8601 format: YYYY-MM-DDTHH:MM:SSZ.

The same filter semantics apply whether the user submits the fields via the GUI or via the API.
All inputs are treated as strings; an empty string (or null) means “ignore this field”.

Backed by test_run_id__branch.

Supported inputs:

1. Exact match (special syntax)

   • Input: =branch_name
   • Lookup: branch__exact
   • Example: =10.6

2. Major.minor prefix (question mark)

   • Input: 10.?
   • Lookup: branch__startswith with ? stripped
   • Example: 10.? → matches branches starting with 10.

3. Exact numeric branch

   • Input: 10.6
   • Lookup: branch__exact

4. Substring match (surrounded by *)

   • Input: *10.6*
   • Lookup: branch__icontains with * stripped

5. Substring match with ? (surrounded by *)

   • Input: *10.?*
   • Lookup: branch__icontains with * and ? stripped
   • Example: *10.?* → searches for substring 10.

6. Default (free text, no wildcards)

   • Input: feature_x, 10.6.1, release-2026
   • Lookup: branch__icontains

Notes:

• Allowed characters: letters, digits, _ . - * ? (and = only for the special exact syntax).
• If the value contains other characters (e.g., spaces), it may fail to match any supported pattern and will be skipped.

Backed by test_run_id__revision.

• Input: abc123
• Lookup: revision__startswith
• Allowed characters: letters and digits only ([a-zA-Z0-9])

Backed by test_run_id__platform.

1. Exact match
   • Input: amd64-centos-7-bintar
   • Lookup: platform__exact
2. Substring match
   • Input: *bintar*
   • Lookup: platform__icontains with * stripped

Backed by test_run_id__dt.

• Input formats accepted:
  • YYYY-MM-DD (e.g., 2026-01-01)
  • YYYY-MM-DD HH:MM:SS (e.g., 2026-01-01 12:30:00)
• Lookup: dt__gte (inclusive)

If parsing fails, the date filter is not applied.

Backed by test_run_id__typ.

1. Exact
   • Input: nm
   • Lookup: typ__exact
2. Prefix
   • Input: rocks*
   • Lookup: typ__startswith with * stripped

Backed by test_failure.test_name.

1. Exact
   • Input: spider.auto_increment
   • Lookup: test_name__exact
2. Substring (special *. prefix)
   • Input: *.sp-error
   • Lookup: test_name__icontains with * stripped (the leading . remains)
   • Example: *.sp-error → searches for substring .sp-error inside test_name

Allowed characters: / a-z A-Z 0-9 _ . -

Backed by test_failure.failure_text.

1. Default substring search

   • Input: Unknown error -11
   • Lookup: failure_text__icontains

2. Substring wrapped in * (alnum only)

   • Input: *timeout*
   • Lookup: failure_text__icontains with * stripped

Notes:

• The “no-asterisks” form is the most flexible (can include spaces/symbols).
• The *...* form only matches alphanumeric content per the regex.

• Default: 50
• Input: numeric string (e.g., 100)
• Applied as slice after ordering: newest first (order_by('-test_run_id__dt')[:limit])