WordPress database error Deadlock

  • dimal

    (@dimalifragis)


    4 years, 1 month ago

    Hello.

    Any ideas from where that comes from? How can i debug more this?

    [19-Apr-2022 01:08:57 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name = ‘_site_transient_theme_roots’ 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, cptch_init, bws_include_init, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_network_option, delete_option

    This is ALL the debug log contains, 2-3 times per day.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • a2hostingrj

    (@a2hostingrj)

    4 years, 1 month ago

    It usually means that there is an application that locked the table because it didn’t finish to update a record in the DB.

    Because of the lock, you cannot write to that table in that given moment.

    If that happens very often, you would need to try to debug your blog and to find out which application (probably a plugin or theme) is locking the table.

    Thread Starter dimal

    (@dimalifragis)

    4 years, 1 month ago

    @a2hostingrj Thanks. I already found the explanation of the issue on the web.

    The question is does the above log gives ANY information where to search? I have a lot of plugins ….

    Also could that be a theme issue? Or definitely a plugin?

    a2hostingrj

    (@a2hostingrj)

    4 years, 1 month ago

    Also could that be a theme issue? Or definitely a plugin?

    It could be that.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress database error Deadlock’ is closed to new replies.

Tags