WordPress-Datenbank-Fehler Deadlock found when trying to get lock

  • Resolved krut1

    (@krut1)


    4 years, 6 months ago

    Hey, we use germanized in multisite. And I see sometimes such logs:

    [20-May-2020 00:17:46 UTC] WordPress-Datenbank-Fehler Deadlock found when trying to get lock; try restarting transaction für Abfrage INSERT INTO 5_options (option_name, option_value, autoload) VALUES ('woocommerce_gzd_plugin_header_data', 'a:1:{s:11:\"woocommerce\";a:5:{s:4:\"name\";s:11:\"WooCommerce\";s:6:\"tested\";s:3:\"4.0\";s:8:\"requires\";s:3:\"3.4\";s:7:\"version\";s:0:\"\";s:14:\"version_prefix\";s:11:\"woocommerce\";}}', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) von 

require('wp-blog-header.php'), 
require_once('wp-load.php'), 
require_once('wp-config.php'), 
require_once('wp-settings.php'), 
include_once('/plugins/woocommerce-germanized/woocommerce-germanized.php'),
WC_germanized,
WooCommerce_Germanized::instance,
WooCommerce_Germanized->__construct,
WC_GZD_Dependencies::instance,
WC_GZD_Dependencies->__construct,
WC_GZD_Dependencies->parse_plugin_header_data,
update_option,
add_option

    It happens not oft, but: 1-2 times FOR EACH blog per week.

    Could you please help to resolve this problem?

    • This topic was modified 4 years, 6 months ago by krut1.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author vendidero

    (@vendidero)

    Hi there,

    hm, seems quite strange to me as Germanized does that check on loading the plugin. We do only update the option once (if it does not exist on load) that’s why I can’t find a deadlock scenario here. I’ll review the code though to see what we can do to improve that.

    Cheers

    Thread Starter krut1

    (@krut1)

    Hi @vendidero,

    thank you. Could you please write here if you did any improvements for it?

    Plugin Author vendidero

    (@vendidero)

    yep

    Plugin Author vendidero

    (@vendidero)

    Hi there,

    please check our latest version. We’ve improved our dependency checks.

    Cheers

    Thread Starter krut1

    (@krut1)

    We will update next week ?? Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress-Datenbank-Fehler Deadlock found when trying to get lock’ is closed to new replies.