WordPress database error: Deadlock

  • Resolved wp_kc

    (@wp_kc)


    4 years, 1 month ago

    I found this in the debug log of one of my staging servers. I’m not sure if it is an issue with WordPress’ transient API, or with NinjaFirewall, either way I’m passing it on to you…

    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROMwp_optionsWHEREoption_name= '_transient_timeout_nfw_db_check' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, get_transient, delete_option

    OS: Debian GNU/Linux 9.13 (stretch)
    DB Server: MariaDB 10.2.33-MariaDB-10.2.33+maria~stretch
    PHP: 7.3.22-1+0~20200909.67+debian9~1.gbpdd7b72
    WordPress: 5.5.1
    NinjaFirewall: Version 4.2.5

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author nintechnet

    (@nintechnet)

    It means there’s an application that has locked the table because it didn’t finish to update a record in the DB. Because of the lock, NinjaFirewall cannot write to that table.
    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. Otherwise, there’s no need to worry, it can happen from time to time with a DB.

    Thread Starter wp_kc

    (@wp_kc)

    Thanks.

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