[Satellite 6] Restart of Postgres service within Red Hat Satellite logs an error "ERROR: duplicate key value violates unique constraint "dynflow_coordinator_records_pkey"" in Postgres logs:
Issue
- Restart of Postgres service within Red Hat Satellite logs an error "ERROR: duplicate key value violates unique constraint "dynflow_coordinator_records_pkey"" in Postgres logs:
- Postgres error - duplicate key value violates unique constraint "dynflow_coordinator_records_pkey"
- Upon restart of Postgres within Satellite, see this message in the Postgres logs:
2017-12-22 10:21:30 MST ERROR: duplicate key value violates unique constraint "dynflow_coordinator_records_pkey"
2017-12-22 10:21:30 MST DETAIL: Key (id, class)=(delayed-executor, Dynflow::Coordinator::DelayedExecutorLock) already exists.
2017-12-22 10:21:30 MST STATEMENT: INSERT INTO "dynflow_coordinator_records" ("data", "id", "owner_id", "class") VALUES ('{"class":"Dynflow::Coordinator::DelayedExecutorLock","owner_id":"world:ddc77847-17d2-42c6-9017-2eda77ee7193","world_id":"ddc77847-17d2-42c6-9017-2eda77ee7193","id":"delayed-executor"}', 'delayed-executor', 'world:ddc77847-17d2-42c6-9017-2eda77ee7193', 'Dynflow::Coordinator::DelayedExecutorLock') RETURNING "id"
2017-12-22 10:21:31 MST ERROR: duplicate key value violates unique constraint "dynflow_coordinator_records_pkey"
2017-12-22 10:21:31 MST DETAIL: Key (id, class)=(execution-plan:a02514ff-cb42-4a24-90f5-c61059f66768, Dynflow::Coordinator::ExecutionLock) already exists.
2017-12-22 10:21:31 MST STATEMENT: INSERT INTO "dynflow_coordinator_records" ("data", "id", "owner_id", "class") VALUES ('{"class":"Dynflow::Coordinator::ExecutionLock","owner_id":"world:4a973421-87a0-450b-ae04-8313c41552d2","world_id":"4a973421-87a0-450b-ae04-8313c41552d2","id":"execution-plan:a02514ff-cb42-4a24-90f5-c61059f66768","execution_plan_id":"a02514ff-cb42-4a24-90f5-c61059f66768","client_world_id":"ddc77847-17d2-42c6-9017-2eda77ee7193","request_id":5}', 'execution-plan:a02514ff-cb42-4a24-90f5-c61059f66768', 'world:4a973421-87a0-450b-ae04-8313c41552d2', 'Dynflow::Coordinator::ExecutionLock') RETURNING "id
Environment
- Red Hat Satellite 6.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.