martinmaurer

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'

AND group_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'

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, 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'

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, 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'

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, 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

• This reply was modified 4 months, 1 week ago by martinmaurer.

Hi

just a quick follow up: when do you plan to release the next version with the bugfix?

Thank you!

perfect thank you so much. I will test this then again asap.

yes both checkboxes are checked.

it’s ChIJZXG0iMjXukcRqNt4Ez5n0yo