Deadlock found when trying to get lock

  • Resolved vitsupport

    (@vitsupport)


    2 years, 6 months ago

    Hi.

    We have a lot of these errors on one of our customers sites. I believe it is in connection to TranslatePress. Anyone know what might be causing it?

    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROMsn_optionsWHEREoption_name= '_site_transient_available_translations' made by require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, TRP_Translate_Press->init_machine_translation, TRP_Machine_Translation_Tab->get_active_engine, TRP_Machine_Translator->__construct, TRP_Languages->get_iso_codes, TRP_Languages->get_wp_languages, wp_get_available_translations, get_site_transient, delete_site_option, delete_network_option, delete_option

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Alex

    (@alexcozmoslabs)

    Hi,

    It’s nothing to worry about especially since it only came up once. The error indicates that one particular TP query was unsuccessful due to DB deadlock.
    TranslatePress has an SQL error management system to handle this type of situation gracefully. It shouldn’t have affected your website at all.

    Best Regards,

    Thread Starter vitsupport

    (@vitsupport)

    Thanks for your quick reply, @alexcozmoslabs.

    I see was a bit quick in my deductions. The deadlock error only comes up twice in connection with TranslatePress. Approx one each day for the following error, but that is out of the scope for your support, so I better do some more research here.

    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATEsn_actionscheduler_actionsSETclaim_id= 0 WHEREclaim_id= 273691 made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_DBStore->release_claim

    Thanks again for your quick reply, though.

    • This reply was modified 2 years, 6 months ago by vitsupport.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Deadlock found when trying to get lock’ is closed to new replies.

Tags