Title: WordPress database error Deadlock for query INSERT IGNORE INTO `wp_wfConfig`
Last modified: November 13, 2018

---

# WordPress database error Deadlock for query INSERT IGNORE INTO `wp_wfConfig`

 *  Resolved [jomo](https://wordpress.org/support/users/jonathanmoorebcsorg/)
 * (@jonathanmoorebcsorg)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/)
 * Anyone else seeing errors like this in the wordpress error logs recently?
 * > WordPress database error Deadlock found when trying to get lock; try restarting
   > transaction for query INSERT IGNORE INTO `wp_wfConfig` (`name`, `val`, `autoload`)
   > VALUES (‘wfSyncGeoIP.lock’, ‘1541827733’, ‘no’)

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

 *  [wfasa](https://wordpress.org/support/users/wfasa/)
 * (@wfasa)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-10895570)
 * Hi Jonathan,
    A couple of customers have reported this and we’ve made a bit of
   progress on debugging it. We think it may be happening on sites where the GeoLite2-
   Country.mmdb (The GeoIP country database) fails to sync as it should.
 * I’m not sure how comfortable you are modifying the database directly via phpMyAdmin
   but if you are, you can try this
 * 1. Delete GeoLite2-Country.mmdb file located in wflogs
    2. Delete “_transient_timeout_wfSyncGeoIPActive”
   and “_transient_wfSyncGeoIPActive” from the wp_options table
 * If that works, let me know!
 *  [wfdave](https://wordpress.org/support/users/wfdave/)
 * (@wfdave)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-10948149)
 * Hi [@jonathanmoorebcsorg](https://wordpress.org/support/users/jonathanmoorebcsorg/),
 * We haven’t heard back from you in a while, so I’ve gone ahead and marked this
   thread as resolved. Please feel free to open another thread if you’re still having
   issues with Wordfence!
 * Thanks!
 *  Thread Starter [jomo](https://wordpress.org/support/users/jonathanmoorebcsorg/)
 * (@jonathanmoorebcsorg)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-10961811)
 * Hi, I did take the recommended actions around 1 december, but still seeing these
   pop up in the logs:
 * [07-Dec-2018 14:09:16 UTC] WordPress database error Deadlock found when trying
   to get lock; try restarting transaction for query INSERT IGNORE INTO `wp_wfConfig`(`
   name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544191756’, ‘no’) made
   by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock
    [07-Dec-2018 14:09:16 UTC] WordPress database error Deadlock found
   when trying to get lock; try restarting transaction for query INSERT IGNORE INTO`
   wp_wfConfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544191756’,‘
   no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock [07-Dec-2018 14:09:16 UTC] WordPress database error Deadlock found
   when trying to get lock; try restarting transaction for query INSERT IGNORE INTO`
   wp_wfConfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544191756’,‘
   no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock [07-Dec-2018 16:16:35 UTC] WordPress database error Deadlock found
   when trying to get lock; try restarting transaction for query INSERT IGNORE INTO`
   wp_wfConfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544199395’,‘
   no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock [07-Dec-2018 16:16:35 UTC] WordPress database error Deadlock found
   when trying to get lock; try restarting transaction for query INSERT IGNORE INTO`
   wp_wfConfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544199395’,‘
   no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock [07-Dec-2018 16:16:35 UTC] WordPress database error Deadlock found
   when trying to get lock; try restarting transaction for query INSERT IGNORE INTO`
   wp_wfConfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544199395’,‘
   no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock [08-Dec-2018 01:16:49 UTC] WordPress database error Deadlock found
   when trying to get lock; try restarting transaction for query INSERT IGNORE INTO`
   wp_wfConfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1544231809’,‘
   no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’),
   WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::
   createLock
 *  [Testing Things](https://wordpress.org/support/users/atx/)
 * (@atx)
 * [7 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-10995199)
 * Same problem here for some weeks.
    No fixes so far. Any idea?
 *  Thread Starter [jomo](https://wordpress.org/support/users/jonathanmoorebcsorg/)
 * (@jonathanmoorebcsorg)
 * [7 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-11024323)
 * still ongoing..
 *  [obyno80](https://wordpress.org/support/users/obyno80/)
 * (@obyno80)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-11247626)
 * Same here…
    I am getting this error
 * INSERT INTO photo_wfConfig (name, val, autoload) values (‘lastNotificationID’,‘
   1’, ‘no’)
    + wfConfig::atomicInc() Plugin: wordfence Duplicate entry ‘lastNotificationID’
   for key ‘PRIMARY’ 1062
 *  Thread Starter [jomo](https://wordpress.org/support/users/jonathanmoorebcsorg/)
 * (@jonathanmoorebcsorg)
 * [7 years ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-11501032)
 * not seen this more recently, assume it is resolved with other updates since this
   discussion

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

The topic ‘WordPress database error Deadlock for query INSERT IGNORE INTO `wp_wfConfig`’
is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

## Tags

 * [wfConfig](https://wordpress.org/support/topic-tag/wfconfig/)

 * 7 replies
 * 5 participants
 * Last reply from: [jomo](https://wordpress.org/support/users/jonathanmoorebcsorg/)
 * Last activity: [7 years ago](https://wordpress.org/support/topic/wordpress-database-error-deadlock-for-query-insert-ignore-into-wp_wfconfig/#post-11501032)
 * Status: resolved