WordPress

plugins – Komunikat PHP: Błąd bazy danych WordPress Znaleziono zakleszczenie podczas próby odblokowania

  • 14 września, 2018
  • 4 min read
plugins – Komunikat PHP: Błąd bazy danych WordPress Znaleziono zakleszczenie podczas próby odblokowania


Próbuję rozwiązać ten problem impasu w mojej witrynie bez powodzenia. Używam WordFence i kiedy go wyłączam, błąd znika. Wyłączyłem wtyczkę, usuwając ją całkowicie i ponownie instalując, ale błąd pojawia się również za każdym razem, gdy ją ponownie instaluję.

Pamiętaj, że całkowicie odinstalowałem wtyczkę zgodnie z sugestią WordFence.

Czy ktoś wie, co jest tego przyczyną?

Oto log na moim serwerze:

2018/09/14 01:13:38 [error] 21753#21753: *2868716 FastCGI sent in stderr: "PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES ('wfSyncGeoIP.lock', '1536912818', '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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query" while reading response header from upstream, client: 34.232.72.139, server: mysite.com, request: "GET /2017/09/19/sample-article/feed/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9011", host: "mysite.com"
2018/09/14 01:13:57 [error] 21753#21753: *2869493 FastCGI sent in stderr: "PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES ('wfSyncGeoIP.lock', '1536912837', '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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query" while reading response header from upstream, client: 54.241.188.65, server: mysite.com, request: "GET /test-article/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9011", host: "mysite.com", referrer: "search.yahoo.com/"
2018/09/14 01:14:03 [error] 21753#21753: *2869668 FastCGI sent in stderr: "PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES ('wfSyncGeoIP.lock', '1536912842', '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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query" while reading response header from upstream, client: 13.56.241.76, server: mysite.com, request: "GET /2013/07/17/testing/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9011", host: "philnews.ph", referrer: "android-app://com.google.android.googlequicksearchbox"
2018/09/14 01:14:03 [error] 21753#21753: *2869683 FastCGI sent in stderr: "PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES ('wfSyncGeoIP.lock', '1536912843', '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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query" while reading response header from upstream, client: 54.193.113.108, server: mysite.com, request: "GET /sample/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9011", host: "mysite.com", referrer: "mysite.com/articl1/"
2018/09/14 01:15:14 [error] 21753#21753: *2871964 FastCGI sent in stderr: "PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES ('wfSyncGeoIP.lock', '1536912914', 'no') made by 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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query


Źródło

Warto przeczytać!  Jak zweryfikować numery telefonów klientów (2 sposoby)