db deadlock after upgrading to 1.2.1
-
after upgrading to 1.2.1 on the multisite installation I get quite a few of db error deadlocks for the fetch notifications
WordPress database error Deadlock found when trying to get lock; try restarting transaction for query
INSERT INTO wp_actionscheduler_actions ( hook, status, scheduled_date_gmt, scheduled_date_local, schedule, group_id, priority, args )
SELECT 'cache-warmer_fetch_notifications', 'pending', '2024-05-14 12:19:48', '2024-05-14 14:19:48', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0\0scheduled_timestamp\";i:1715689188;s:18:\"\0\0first_timestamp\";i:1715689188;s:13:\"\0*\0recurrence\";i:3600;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1715689188;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:3600;}', 5, 10, '[]' FROM DUAL
WHERE (
SELECT action_id FROM wp_actionscheduler_actions
WHERE status IN ( 'pending', 'in-progress' )
AND hook = 'cache-warmer_fetch_notifications'
AND group_id = 5
LIMIT 1 ) IS NULL made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Plugins_Core\Notifications->schedule_interval, as_schedule_recurring_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_db
- You must be logged in to reply to this topic.