Bug #17738
Updated by Marek Hulán almost 8 years ago
ERROR: Sequel::UniqueConstraintViolation Mysql2::Error: Duplicate entry '4cd571a5-56d5-4235-9404-15cf4c7d52d1-1' for key 'PRIMARY' <pre> Detail: execution_plan_uuid already exists in dynflow_steps Statement: INSERT INTO `dynflow_steps` (`execution_plan_uuid`, `id`, `data`, `state`, `started_at`, `ended_at`, `real_time`, `execution_time`, `action_id`, `progress_done`, `progress_weight`) VALUES ('4cd571a5-56d5-4235-9404-15cf4c7d52d1', 1, '{\"execution_plan_id\":\"4cd571a5-56d5-4235-9404-15cf4c7d52d1\",\"id\":1,\"state\":\"pending\",\"class\":\"Dynflow::ExecutionPlan::Steps::PlanStep\",\"action_class\":\"Actions::ForemanAnsible::PlayHostRoles\",\"action_id\":1,\"error\":null,\"started_at\":null,\"ended_at\":null,\"execution_time\":0.0,\"real_time\":0.0,\"progress_done\":0,\"progress_weight\":0,\"children\":[]}', 'pending', NULL, NULL, 0.0, 0.0, 1, 0, 0) UPDATE `dynflow_execution_plans` SET `uuid` = '4cd571a5-56d5-4235-9404-15cf4c7d52d1', `data` = '{\"id\":\"4cd571a5-56d5-4235-9404-15cf4c7d52d1\",\"class\":\"Dynflow::ExecutionPlan\",\"state\":\"planning\",\"result\":\"pending\",\"root_plan_step_id\":1,\"run_flow\":{\"class\":\"Dynflow::Flows::Concurrence\",\"flows\":[]},\"finalize_flow\":{\"class\":\"Dynflow::Flows::Sequence\",\"flows\":[]},\"step_ids\":[1],\"started_at\":\"2016-12-19 14:26:15\",\"ended_at\":null,\"execution_time\":null,\"real_time\":0.0,\"execution_history\":[]}', `state` = 'planning', `result` = 'pending', `started_at` = '2016-12-19 14:26:15', `ended_at` = NULL, `real_time` = 0.0, `execution_time` = NULL WHERE (`uuid` = '4cd571a5-56d5-4235-9404-15cf4c7d52d1') </pre> and a second time an insert, a little bit different in the same transaction: <pre> INSERT INTO `dynflow_steps` (`execution_plan_uuid`, `id`, `data`, `state`, `started_at`, `ended_at`, `real_time`, `execution_time`, `action_id`, `progress_done`, `progress_weight`) VALUES ('4cd571a5-56d5-4235-9404-15cf4c7d52d1', 1, '{\"execution_plan_id\":\"4cd571a5-56d5-4235-9404-15cf4c7d52d1\",\"id\":1,\"state\":\"running\",\"class\":\"Dynflow::ExecutionPlan::Steps::PlanStep\",\"action_class\":\"Actions::ForemanAnsible::PlayHostRoles\",\"action_id\":1,\"error\":null,\"started_at\":\"2016-12-19 14:26:15\",\"ended_at\":null,\"execution_time\":0.0,\"real_time\":0.0,\"progress_done\":0,\"progress_weight\":0,\"children\":[]}', 'running', '2016-12-19 14:26:15', NULL, 0.0, 0.0, 1, 0, 0) </pre>