WordPress database error Deadlock found when trying to get lock

  • Resolved anshu247

    (@anshu247)


    2 years, 8 months ago

    I am getting deadlock errors from a long time by the ithemes plugin

    The debug log shows errors like

    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM a6j3vhvz_options WHERE option_name = ‘itsec-lock-cron_test_fail_safe’ 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, itsec_cron_test_fail_safe, ITSEC_Lib::release_lock, delete_option

    PHP Warning: Cannot modify header information – headers already sent by (output started at /home2/irisdown/public_html/wp-content/plugins/ithemes-security-pro/core/modules/ssl/class-itsec-ssl.php:81) in /home2/irisdown/public_html/wp-includes/pluggable.php on line 1430

    Can you please look into this

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

    (@shanedelierrr)

    2 years, 8 months ago

    Hi @anshu247, the deadlock error means a plugin/theme has locked that specific table because it didn’t finish updating the record in the database. This deadlock prevented iThemes Security from writing into that table. Sometimes this can happen, and there isn’t a way to prevent it on our end.

    However, since you mentioned that this has been occurring for a long time, I’d suggest conducting a conflict check to try to debug which application is causing the issue. I’d also recommend contacting your host to check for any issues with the database and possibly optimize/clean the tables.

    As for the “Cannot modify header information – headers already sent” error, does it happen when only the iTSec plugin is activated and the site uses a default WP theme? If so, this could be due to a corrupted file, and I’d suggest installing a fresh copy of the plugin to see if it helps.

    Hope this helps, and I look forward to hearing from you!

    Plugin Support chandelierrr

    (@shanedelierrr)

    2 years, 8 months ago

    Hi there,

    I hope the information I provided helped resolve the issue. Tracking notifications on this forum can become tricky over time, and since we haven’t received a response, I’ll mark this post resolved.

    If you still require further assistance, feel free to open a new support topic, and we’d be happy to assist.

    Thank you.

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

The topic ‘WordPress database error Deadlock found when trying to get lock’ is closed to new replies.

Tags