Deadlock

  • Hello friends,

    We have been observing an error that occurs occasionally. It's NOT all the time, but it doesn't worry one bit.

So checking the error we found 'WSAL_Sensors_MainWP', and that's why we write to you to find out if it is related to the WP Activity Log plugin or it can be related to another plugin or even wordpress.

Here we copy the error messages:

'[24-Mar-2022 11:01:29 UTC] Error Deadlock found when trying to get lock; try restarting transaction de la base de datos de WordPress para la consulta DELETE FROM <code>w47fa_options</code> WHERE <code>option_name</code> = '_site_transient_timeout_theme_roots' realizada por do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, <strong>WSAL_Sensors_MainWP</strong>->EventAdminInit, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_network_option, delete_option

[24-Mar-2022 11:01:29 UTC] Error Deadlock found when trying to get lock; try restarting transaction de la base de datos de WordPress para la consulta DELETE FROM <code>w47fa_options</code> WHERE <code>option_name</code> = '_site_transient_timeout_theme_roots' realizada por do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, <strong>WSAL_Sensors_MainWP</strong>->EventAdminInit, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_network_option, delete_option

    [29-Mar-2022 09:12:41 UTC] Error Deadlock found when trying to get lock; try restarting transaction de la base de datos de WordPress para la consulta DELETE FROMw47fa_optionsWHEREoption_name` = ‘_site_transient_theme_roots’ realizada por do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, <strong>WSAL_Sensors_MainWP</strong>->EventAdminInit, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_network_option, delete_option

    [29-Mar-2022 09:12:41 UTC] Error Deadlock found when trying to get lock; try restarting transaction de la base de datos de WordPress para la consulta DELETE FROM w47fa_options WHERE option_name = ‘_site_transient_timeout_theme_roots’ realizada por do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, <strong>WSAL_Sensors_MainWP</strong>->EventAdminInit, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_network_option, delete_option`

    Thanks in advance for your help
    Luis

    The page I need help with: [log in to see the link]

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

    (@robert681)

    Hello @lemdeals

    Thank you for using our plugin.

    I am sorry to read about your issue. This is happening because WordPress is trying to delete a transient _site_transient_theme_roots related to the roots theme in the process, however, the options table is locked for some reason.

    Can you check or do you know if the options table is locked completely by a specific process, or is it just this record? Also, is it getting locked repeatedly for short period of time?

    We can get a better indication of what is happening if we can see all the logs (are there any more entries in the logs)? If you can share more technical details we can better understand the context of the problem. Please do not share any technical details here. Instead send us an email at [email protected].

    Also, something you might want to do is try to delete the option _site_transient_theme_roots manually using phpMyAdmin for example. However, always backup the database before doing any changes.

    Looking forward to hearing from you.

    Plugin Support robertabela

    (@robert681)

    Hello @lemdeals

    Thank you very much for sending us the logs over email. Updating this ticket as well so there is a record of the problem:

    As explained in our email in your logs there are many “deadlocks” reported from several other plugins and the theme itself. This means that this is not a plugin / theme specific problem, but a setup problem. Something is hindering WordPress and the plugins from deleting transients from the database.

    The best way forward to solve this is to look into what might be causing this, at server level, or maybe something from WordPress. I would recommend speaking to the web host, since typically they have the right tools to troubleshoot these type of issues.

    Should there be anything else we can assist you with, please do not hesitate to ask.

    Have a great day.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Deadlock’ is closed to new replies.