openshift-eng Payload Autodl JSON
This skill defines the schema for the payload-analysis-{tag}-autodl.json file. The file is a flat denormalized table designed for database ingestion, with one row per (failed blocking job, candidate PR) pair.
When to Use This Skill
Use this skill when you need to generate the autodl JSON file during payload-analysis (Step 8).
File Location
The file is written to the current working directory:
payload-analysis-<sanitized_tag>-autodl.json
The filename must end with -autodl.json. Sanitize the tag for filename safety (replace colons and slashes with hyphens).
Schema
{
"table_name": "payload_triage",
"schema": {
"payload_tag": "string",
"version": "string",
"stream": "string",
"architecture": "string",
"phase": "string",
"release_controller_url": "string",
"analyzed_at": "string",
"rejection_streak": "int64",
"total_blocking_jobs": "int64",
"failed_blocking_jobs": "int64",
"force_accept_recommended": "int64",
"job_name": "string",
"prow_url": "string",
"failure_type": "string",
"root_cause_summary": "string",
"streak_length": "int64",
"is_new_failure": "int64",
"originating_payload_tag": "string",
"candidate_pr_url": "string",
"candidate_title": "string",
"candidate_repo": "string",
"candidate_confidence_score": "int64",
"candidate_rationale": "string",
"revert_pr_url": "string",
"revert_pr_status": "string",
"rhcos_change_suspected": "int64",
"rhcos_suspect_packages": "string"
},
"schema_mapping": null,
"rows": [
{
"payload_tag": "4.22.0-0.nightly-2026-02-25-152806",
"version": "4.22",
"stream": "nightly",
"architecture": "amd64",
"phase": "Rejected",
"release_controller_url": "https://amd64.ocp.releases.ci.openshift.org/...",
"analyzed_at": "2026-02-26T10:30:00Z",
"rejection_streak": "5",
"total_blocking_jobs": "42",
"failed_blocking_jobs": "4",
"force_accept_recommended": "0",
"job_name": "periodic-ci-openshift-release-main-ci-4.22-e2e-aws-ovn",
"prow_url": "https://prow.ci.openshift.org/view/gs/...",
"failure_type": "test",
"root_cause_summary": "OVN gateway mode selection regression",
"streak_length": "5",
"is_new_failure": "0",
"originating_payload_tag": "4.22.0-0.nightly-2026-02-20-150000",
"candidate_pr_url": "https://github.com/openshift/cno/pull/2037",
"candidate_title": "Fix OVN gateway mode selection",
"candidate_repo": "openshift/cluster-network-operator",
"candidate_confidence_score": "95",
"candidate_rationale": "Error references code changed by this PR",
"revert_pr_url": "https://github.com/openshift/cno/pull/2038",
"revert_pr_status": "open",
"rhcos_change_suspected": "0",
"rhcos_suspect_packages": ""
},
{
"payload_tag": "4.22.0-0.nightly-2026-02-25-152806",
"version": "4.22",
"stream": "nightly",
"architecture": "amd64",
"phase": "Rejected",
"release_controller_url": "https://amd64.ocp.releases.ci.openshift.org/...",
"analyzed_at": "2026-02-26T10:30:00Z",
"rejection_streak": "5",
"total_blocking_jobs": "42",
"failed_blocking_jobs": "4",
"force_accept_recommended": "0",
"job_name": "periodic-ci-openshift-release-main-ci-4.22-e2e-gcp-ovn",
"prow_url": "https://prow.ci.openshift.org/view/gs/...",
"failure_type": "install",
"root_cause_summary": "Install timeout waiting for etcd quorum",
"streak_length": "2",
"is_new_failure": "0",
"originating_payload_tag": "4.22.0-0.nightly-2026-02-23-080000",
"candidate_pr_url": "",
"candidate_title": "",
"candidate_repo": "",
"candidate_confidence_score": "0",
"candidate_rationale": "",
"revert_pr_url": "",
"revert_pr_status": "",
"rhcos_change_suspected": "1",
"rhcos_suspect_packages": "systemd,glibc"
}
],
"chunk_size": 0,
"expiration_days": 0,
"partition_column": ""
}
Row Cardinality Rules
| Scenario | Rows for that job |
|---|---|
| Failed job, no candidate | 1 row — candidate fields are "" / "0" |
| Failed job, 1 candidate | 1 row — candidate fields populated |
| Failed job, 2+ candidates | N rows — job fields identical, candidate fields differ per candidate |
| Passed job | 0 rows — not included |
Field Rules
- All row values MUST be strings — wrap every value in double quotes (e.g.,
"5"not5). The schema declares the downstream types. - Empty/missing values are empty strings (
""). For int64 fields with no value, use"0". is_new_failure:"1"for true,"0"for false.candidate_confidence_score: Integer 0-100, e.g."95"."0"when no candidate.revert_pr_url: URL of the revert PR — either a pre-existing revert discovered during analysis, or one created bystage-payload-reverts.""if no revert exists.revert_pr_status:"open","merged","draft","closed", or""if no revert.schema_mappingis alwaysnull.chunk_size,expiration_days, andpartition_columnare always0,0, and"".
Field Descriptions
Payload-level fields (denormalized across all rows)
| Field | Type | Description |
|---|---|---|
payload_tag |
string | Full payload tag |
version |
string | OCP version (e.g., "4.22") |
stream |
string | Canonical stream type: "nightly" or "ci". For OKD payloads (e.g. okd-scos-nightly, okd-scos), map to the base type: okd-scos-nightly → "nightly", okd-scos → "ci". |
architecture |
string | "amd64", "arm64", "multi", etc. |
phase |
string | Payload phase: "Rejected", "Accepted", "Ready" |
release_controller_url |
string | URL to the payload on the release controller |
analyzed_at |
string | ISO 8601 timestamp of when the analysis was performed |
rejection_streak |
int64 | Number of consecutive rejected payloads leading up to the target |
total_blocking_jobs |
int64 | Total number of blocking jobs in the payload |
failed_blocking_jobs |
int64 | Number of failed blocking jobs |
force_accept_recommended |
int64 | 1 if all failures are temporary infrastructure, no more than 2 blocking jobs failed, and no payload accepted in 18+ hours; 0 otherwise |
Job-level fields
| Field | Type | Description |
|---|---|---|
job_name |
string | Full periodic job name |
prow_url |
string | Prow URL for the failing run |
failure_type |
string | "test", "install", "upgrade", or "infra" |
root_cause_summary |
string | Brief description of the failure mode |
streak_length |
int64 | Consecutive payloads this job has been failing |
is_new_failure |
int64 | 1 if the job first started failing in the target payload, 0 otherwise |
originating_payload_tag |
string | The payload where this job first started failing in the current streak |
Candidate-level fields
| Field | Type | Description |
|---|---|---|
candidate_pr_url |
string | GitHub PR URL, or "" if no candidate |
candidate_title |
string | PR title, or "" |
candidate_repo |
string | GitHub org/repo, or "" |
candidate_confidence_score |
int64 | 0-100 confidence score, 0 when no candidate |
candidate_rationale |
string | Explanation of why this PR is a candidate, or "" |
revert_pr_url |
string | URL of a revert PR if one exists, or "" |
revert_pr_status |
string | "open", "merged", "draft", "closed", or "" |
RHCOS suspect fields
| Field | Type | Description |
|---|---|---|
rhcos_change_suspected |
int64 | "1" if RHCOS RPM changes are suspected to contribute to this job's failure, "0" otherwise |
rhcos_suspect_packages |
string | Comma-separated RPM package names suspected as causes (e.g., "kernel,systemd"), or "" when not suspected |
Operations
Create (used by payload-analysis)
Generate the full autodl JSON file with all rows populated from the analysis results. Each failed blocking job produces at least one row. Candidate fields are populated when a PR is correlated to the failure, otherwise they are empty strings / "0".
Update Revert Status (used by stage-payload-reverts)
After staging reverts, find rows matching candidate_pr_url and set:
revert_pr_url: URL of the revert PR (created or pre-existing)revert_pr_status:"open"(or"draft"if draft)
Update Experiment Status (used by payload-experimental-reverts)
Phase 1 (dispatch): After creating draft revert PRs, find rows matching candidate_pr_url and set:
revert_pr_url: URL of the draft revert PRrevert_pr_status:"draft"
Phase 2 (collection): After collecting experiment results, find rows matching candidate_pr_url and update:
- PASS (confirmed cause):
revert_pr_status:"open" - FAIL (innocent):
revert_pr_url:"",revert_pr_status:""(draft was closed)
See Also
Validator: run
python3 plugins/ci/skills/payload-autodl-json/scripts/validate.py <payload-autodl-file>to check generated JSON for correctness.Related Skill:
payload-analysis— creates this file in Step 8Related Skill:
stage-payload-reverts— updates revert fields after staging revertsRelated Skill:
payload-experimental-reverts— updates revert fields after experimentsRelated Skill:
payload-results-yaml— the YAML results file for downstream agentic actions