[AUTOCUT] Distribution Build Failed for sql-2.19.6

[opensearch-ci-bot]

Build Failed Error: sql failed during the distribution build for version: 2.19.6.
Please see build log at https://build.ci.opensearch.org/job/distribution-build-opensearch/11876/display/redirect.
The failed build stage will be marked as unstable ⚠️ . Please see ./build.sh step for more details.
Checkout the wiki to reproduce the failure locally.

[dai-chen]

Investigating if this is caused by 2.19.6 version bump PR not merged: #5270. Here is current findings in build log:

2026-03-31 01:58:00 INFO     Validating api request /_cat/plugins

2026-03-31 01:58:00 INFO     API request URL is https://localhost:9200/_cat/plugins

2026-03-31 01:58:00 INFO     Parameter is  and type is <class 'str'>

2026-03-31 01:58:00 INFO     header is {'Content-Type': 'application/json'}

/home/ci-runner/.local/share/virtualenvs/smoke-test-JYXHJ9my/lib/python3.9/site-packages/urllib3/connectionpool.py:1064: InsecureRequestWarning: Unverified HTTPS request is being made to host 'localhost'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings

  warnings.warn(

2026-03-31 01:58:00 INFO     Response is 
8ad248882161 opensearch-alerting                  2.19.6.0
8ad248882161 opensearch-anomaly-detection         2.19.6.0
8ad248882161 opensearch-asynchronous-search       2.19.6.0
8ad248882161 opensearch-cross-cluster-replication 2.19.6.0
8ad248882161 opensearch-custom-codecs             2.19.6.0
8ad248882161 opensearch-geospatial                2.19.6.0
8ad248882161 opensearch-index-management          2.19.6.0
8ad248882161 opensearch-job-scheduler             2.19.6.0
8ad248882161 opensearch-ltr                       2.19.6.0
8ad248882161 opensearch-notifications             2.19.6.0
8ad248882161 opensearch-notifications-core        2.19.6.0
8ad248882161 opensearch-observability             2.19.6.0
8ad248882161 opensearch-performance-analyzer      2.19.6.0
8ad248882161 opensearch-reports-scheduler         2.19.6.0
8ad248882161 opensearch-security                  2.19.6.0
8ad248882161 opensearch-security-analytics        2.19.6.0
8ad248882161 opensearch-system-templates          2.19.6.0
8ad248882161 query-insights                       2.19.6.0

...

2026-03-31 02:07:14 INFO     | sql                  | /_bulk POST          | PASS  |
2026-03-31 02:07:14 ERROR    | sql                  | /_plugins/_ppl POST  | FAIL  |
2026-03-31 02:07:14 ERROR    | sql                  | /_plugins/_ppl/_explain POST | FAIL  |
2026-03-31 02:07:14 ERROR    | sql                  | /_plugins/_ppl/stats GET | FAIL  |
2026-03-31 02:07:14 ERROR    | sql                  | /_plugins/_sql POST  | FAIL  |
2026-03-31 02:07:14 ERROR    | sql                  | /_plugins/_sql/_explain POST | FAIL  |
2026-03-31 02:07:14 ERROR    | sql                  | /_plugins/_sql/stats GET | FAIL  |

  warnings.warn(
2026-03-31 02:05:32 INFO     Response is 
{"error":"no handler found for uri [/_plugins/_sql] and method [POST]"}
2026-03-31 02:05:50 ERROR    Unexpected Error type is <class 'openapi_core.templating.responses.exceptions.ResponseNotFound'>
2026-03-31 02:05:50 ERROR    Unknown response http status: 400
2026-03-31 02:05:50 INFO     Response is not validated. Please check the response output text above.
2026-03-31 02:05:50 INFO     Recording test result for sql component, config POST___plugins__sql
2026-03-31 02:05:50 INFO     Walking tree from /var/jenkins/workspace/smoke-test/test-results/1170/smoke-test/sql/POST___plugins__sql

  warnings.warn(
2026-03-31 02:06:57 INFO     Response is 
{"error":"no handler found for uri [/_plugins/_ppl/stats] and method [GET]"}
2026-03-31 02:07:14 ERROR    Unexpected Error type is <class 'openapi_core.templating.responses.exceptions.ResponseNotFound'>
2026-03-31 02:07:14 ERROR    Unknown response http status: 400
2026-03-31 02:07:14 INFO     Response is not validated. Please check the response output text above.
2026-03-31 02:07:14 INFO     Recording test result for sql component, config GET___plugins__ppl_stats

[dai-chen]

#5270 merged.

[dai-chen]

Pending for ml-client version bump.