FernleafSystems / Shield-Security-for-WordPress

Reflection of the Shield plugin on WordPress.org
https://getshieldsecurity.com
8 stars 4 forks source link

Deadlock found when trying to get lock #43

Closed ghost closed 2 years ago

ghost commented 2 years ago

Hi, I'm not sure why happened, is there a way to debug this?

[01-Mar-2022 19:55:57 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for the query DELETE FROM `wp_options` WHERE `option_name` = '_site_transient_apto-db-ready-721ffaf864' done 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, icwp_wpsf_init, require_once('/plugins/wp-simple-firewall/init.php'), ICWP_WPSF_Shield_Security->start, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->loadAllFeatures, do_action('icwp-wpsf-run_processors'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\ModCon->onRunProcessors, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\ModCon->doExecuteProcessor, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\Processor->execute, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Processor->run, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\Common\ExecOnceModConsumer->execute, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->run, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\Common\ExecOnceModConsumer->execute, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->canRun, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\ModCon->getDbH_BotSignal, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\Databases->loadDbH, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->execute, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->run, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->tableInit, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->isReady, FernleafSystems\Wordpress\Services\Utilities\Options\Transient::Get, FernleafSystems\Wordpress\Services\Core\General->getTransient, get_site_transient, delete_site_option, delete_network_option, delete_option
[01-Mar-2022 19:55:57 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for the query DELETE FROM `wp_options` WHERE `option_name` = '_site_transient_apto-db-ready-fdaa4a3e87' done 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, icwp_wpsf_init, require_once('/plugins/wp-simple-firewall/init.php'), ICWP_WPSF_Shield_Security->start, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->loadAllFeatures, do_action('icwp-wpsf-run_processors'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\ModCon->onRunProcessors, FernleafSystems\Wordpress\Plugin\Shield\Modules\HackGuard\ModCon->isReadyToExecute, FernleafSystems\Wordpress\Plugin\Shield\Modules\HackGuard\ModCon->getDbH_ScanResults, FernleafSystems\Wordpress\Plugin\Shield\Modules\HackGuard\ModCon->getDbH_ResultItems, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\Databases->loadDbH, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->execute, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->run, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->tableInit, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Handler->isReady, FernleafSystems\Wordpress\Services\Utilities\Options\Transient::Get, FernleafSystems\Wordpress\Services\Core\General->getTransient, get_site_transient, delete_site_option, delete_network_option, delete_option
paulgoodchild commented 2 years ago

Fixed in v14.1