-
Bug
-
Resolution: Done
-
Blocker
-
None
-
None
-
None
When submitting a playbook run request for satellite managed systems, playbook dispatcher logs unique value constraint errors.
POST body for playbook-dispatcher/internal/v2/dispatch:
{
"recipient": "df45e413-5eb6-4882-8aab-f06e8c82f209",
"org_id": "11789772",
"principal": "insights-qa",
"name": "jaudet-remedy-73",
"recipient_config": {
"sat_id": "4e8f322b-3315-5346-8f15-d7d1fc868efc",
"sat_org_id": "3"
},
"url": "https://cert.cloud.redhat.com/api/remediations/v1/remediations/1f347ef4-685e-43b9-a609-78ae6702ce97/playbook?hosts=58be3ffe-5456-433e-bd3f-f1ecd6b7fe4c&hosts=d094f8a0-e93a-4a20-a907-ac6d3aca59d6",
"labels": {
"playbook-run": "9c597e5f-6153-4981-92d1-d52cd63f4167"
},
"hosts": [
{
"ansible_host": "",
"inventory_id": "58be3ffe-5456-433e-bd3f-f1ecd6b7fe4c"
},
{
"ansible_host": "",
"inventory_id": "d094f8a0-e93a-4a20-a907-ac6d3aca59d6"
}
],
"web_console_url": "https://console.redhat.com/insights/remediations"
}
Error logged by playbook dispatcher:
{
"ID": "c5b3a635-7869-404f-a2dd-421f87063bdb",
"RunID": "c51e4dd6-ac42-46ca-abed-a1e3ac2305a4",
"InventoryID": "58be3ffe-5456-433e-bd3f-f1ecd6b7fe4c",
"Host": "",
"SatSequence": null,
"Status": "running",
"Log": "",
"CreatedAt": "2022-06-17T14:05:33.411278232Z",
"UpdatedAt": "2022-06-17T14:05:33.411278232Z"
},
{
"ID": "79409f4c-56a1-49f3-9951-2a46967c8121",
"RunID": "c51e4dd6-ac42-46ca-abed-a1e3ac2305a4",
"InventoryID": "d094f8a0-e93a-4a20-a907-ac6d3aca59d6",
"Host": "",
"SatSequence": null,
"Status": "running",
"Log": "",
"CreatedAt": "2022-06-17T14:05:33.411278232Z",
"UpdatedAt": "2022-06-17T14:05:33.411278232Z"
}
ERROR: duplicate key value violates unique constraint "run_hosts_run_id_host_key" (SQLSTATE 23505)
- is related to
-
RHCLOUD-19965 [QE][playbook-dispatcher] Test playbook run targeting multiple satellite hosts
-
- Closed
-
