'Lock wait timeout exceeded' при единственном INSERT
Форум — Admin
Доброго дня!
Делаю INSERT в mysql - транзакция висит в состоянии ‘LOCK WAIT’, никаких других запросов на запись в эту таблицу нет. Нахожу только рекомендации поискать конфликтующий процесс и грохнуть его.
insert into `events` (`flow_id`, `status_id`, `event_id`, `event_type`, `updated_at`, `created_at`) values (38, 29, 13246969, 'App\\Models\\Hehe', '2021-04-06 12:29:53', '2021-04-06 12:29:53')
CREATE TABLE `events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`event_id` int(10) unsigned DEFAULT NULL,
`flow_id` int(10) unsigned DEFAULT NULL,
`parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`time` timestamp NOT NULL DEFAULT current_timestamp(),
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`event_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status_id` int(10) unsigned DEFAULT NULL,
`place_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `events_flow_id_foreign` (`flow_id`),
KEY `events_position_id_foreign` (`event_id`),
KEY `events_event_type_event_id_index` (`event_type`,`event_id`),
KEY `events_status_id_foreign` (`status_id`),
KEY `events_place_id_foreign` (`place_id`),
KEY `events_created_at_index` (`created_at`),
KEY `events_deleted_at_index` (`deleted_at`),
KEY `events_time_index` (`time`),
KEY `events_event_type_flow_id_created_at_index` (`event_type`,`flow_id`,`created_at`),
KEY `events_flow_status_deleted_index` (`flow_id`,`status_id`,`deleted_at`),
KEY `events_id_status_type_del_ids` (`event_id`,`status_id`,`event_type`,`deleted_at`),
KEY `events_type_status_idx` (`event_type`,`status_id`),
KEY `events_status_deleted_type_idx` (`status_id`,`deleted_at`,`event_type`),
KEY `events_status_type_created` (`status_id`,`event_type`,`created_at`),
KEY `events_e_id_e_type_e_del_idx` (`event_id`,`event_type`,`deleted_at`),
CONSTRAINT `events_flow_id_foreign` FOREIGN KEY (`flow_id`) REFERENCES `flows` (`id`),
CONSTRAINT `events_place_id_foreign` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`),
CONSTRAINT `events_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37170294 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci