WordPress database error Deadlock: wp_mail_smtp_queue_processwp_mail_smtp_queue_
-
Constant error:
WordPress database error Deadlock found when trying to get lock; try restarting transaction for query
INSERT INTO QCN_actionscheduler_actions (?hook,status,scheduled_date_gmt,scheduled_date_local,schedule,group_id,priority,args)
SELECT ‘wp_mail_smtp_queue_process’, ‘pending’, ‘2024-10-29 14:18:19’, ‘2024-10-29 07:18:19’, ‘O:32:\”ActionScheduler_IntervalSchedule\”:5:{s:22:\”\0*\0scheduled_timestamp\”;i:1730211499;s:18:\”\0*\0first_timestamp\”;i:1730211499;s:13:\”\0*\0recurrence\”;i:60;s:49:\”\0ActionScheduler_IntervalSchedule\0start_timestamp\”;i:1730211499;s:53:\”\0ActionScheduler_IntervalSchedule\0interval_in_seconds\”;i:60;}’, 3, 10, ‘[null]’ FROM DUAL
WHERE (
SELECT action_id FROM QCN_actionscheduler_actions
WHERE status IN (?‘pending’, ‘in-progress’ )
AND hook = ‘wp_mail_smtp_queue_process’
ANDgroup_id= 3
LIMIT 1 )?IS NULL made by require(‘wp-blog-header.php’), 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, WPMailSMTP\Core->get_tasks, WPMailSMTP\Tasks\Tasks->init, WPMailSMTP\Tasks\Queue\ProcessQueueTask->init, WPMailSMTP\Tasks\Task->register, WPMailSMTP\Tasks\Task->register_recurring, as_schedule_recurring_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_db
-
Hi.
I have the same problem, it occurs so many times a day:[10-Nov-2024 23:32:09 UTC] 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 'wp_mail_smtp_queue_process', 'pending', '2024-11-10 23:32:09', '2024-11-11 00:32:09', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1731281529;s:18:\"\0*\0first_timestamp\";i:1731281529;s:13:\"\0*\0recurrence\";i:60;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1731281529;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:60;}', 5, 10, '[null]' FROM DUAL
WHERE (
SELECT action_id FROM wp_actionscheduler_actions
WHERE status IN ( 'pending', 'in-progress' )
AND hook = 'wp_mail_smtp_queue_process'
ANDgroup_id= 5
LIMIT 1 ) IS NULL made by require('wp-blog-header.php'), 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, WPMailSMTP\Core->get_tasks, WPMailSMTP\Tasks\Tasks->init, WPMailSMTP\Tasks\Queue\ProcessQueueTask->init, WPMailSMTP\Tasks\Task->register, WPMailSMTP\Tasks\Task->register_recurring, as_schedule_recurring_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_db
[11-Nov-2024 01:16:09 UTC] 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 'wp_mail_smtp_queue_process', 'pending', '2024-11-11 01:16:09', '2024-11-11 02:16:09', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1731287769;s:18:\"\0*\0first_timestamp\";i:1731287769;s:13:\"\0*\0recurrence\";i:60;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1731287769;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:60;}', 5, 10, '[null]' FROM DUAL
WHERE (
SELECT action_id FROM wp_actionscheduler_actions
WHERE status IN ( 'pending', 'in-progress' )
AND hook = 'wp_mail_smtp_queue_process'
ANDgroup_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, WPMailSMTP\Core->get_tasks, WPMailSMTP\Tasks\Tasks->init, WPMailSMTP\Tasks\Queue\ProcessQueueTask->init, WPMailSMTP\Tasks\Task->register, WPMailSMTP\Tasks\Task->register_recurring, as_schedule_recurring_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_db
[11-Nov-2024 01:16:09 UTC] 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 'wp_mail_smtp_queue_process', 'pending', '2024-11-11 01:16:09', '2024-11-11 02:16:09', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1731287769;s:18:\"\0*\0first_timestamp\";i:1731287769;s:13:\"\0*\0recurrence\";i:60;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1731287769;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:60;}', 5, 10, '[null]' FROM DUAL
WHERE (
SELECT action_id FROM wp_actionscheduler_actions
WHERE status IN ( 'pending', 'in-progress' )
AND hook = 'wp_mail_smtp_queue_process'
ANDgroup_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, WPMailSMTP\Core->get_tasks, WPMailSMTP\Tasks\Tasks->init, WPMailSMTP\Tasks\Queue\ProcessQueueTask->init, WPMailSMTP\Tasks\Task->register, WPMailSMTP\Tasks\Task->register_recurring, as_schedule_recurring_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_db
[11-Nov-2024 01:16:09 UTC] 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 'wp_mail_smtp_queue_process', 'pending', '2024-11-11 01:16:09', '2024-11-11 02:16:09', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1731287769;s:18:\"\0*\0first_timestamp\";i:1731287769;s:13:\"\0*\0recurrence\";i:60;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1731287769;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:60;}', 5, 10, '[null]' FROM DUAL
WHERE (
SELECT action_id FROM wp_actionscheduler_actions
WHERE status IN ( 'pending', 'in-progress' )
AND hook = 'wp_mail_smtp_queue_process'
ANDgroup_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, WPMailSMTP\Core->get_tasks, WPMailSMTP\Tasks\Tasks->init, WPMailSMTP\Tasks\Queue\ProcessQueueTask->init, WPMailSMTP\Tasks\Task->register, WPMailSMTP\Tasks\Task->register_recurring, as_schedule_recurring_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_dbWordPress database error Deadlock found when trying to get lock; try restarting transaction for query
INSERT INTO QCN_actionscheduler_actions (?hook,status,scheduled_date_gmt,scheduled_date_local,schedule,group_id,priority,args)
SELECT ‘wp_mail_smtp_queue_process’, ‘pending’, ‘2024-11-18 17:10:30’, ‘2024-11-18 09:10:30’, ‘O:32:\”ActionScheduler_IntervalSchedule\”:5:{s:22:\”\0*\0scheduled_timestamp\”;i:1731949830;s:18:\”\0*\0first_timestamp\”;i:1731949830;s:13:\”\0*\0recurrence\”;i:60;s:49:\”\0ActionScheduler_IntervalSchedule\0start_timestamp\”;i:1731949830;s:53:\”\0ActionScheduler_IntervalSchedule\0interval_in_seconds\”;i:60;}’, 3, 10, ‘[null]’ FROM DUAL
WHERE (
SELECT action_id FROM QCN_actionscheduler_actions
WHERE status IN (?‘pending’, ‘in-progress’ )
AND hook = ‘wp_mail_smtp_queue_process’
ANDgroup_id= 3
LIMIT 1 )?IS NULL made by require(‘wp-blog-header.php’), 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, WPMailSMTP\Core->get_tasks, WPMailSMTP\Tasks\Tasks->init, WPMailSMTP\Tasks\Queue\ProcessQueueTask->init, WPMailSMTP\Tasks\Task->register, WPMailSMTP\Tasks\Task->register_recurring, 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.
