-
Posts
-
hello, I have your W3 Total Cache plugin installed. Your plug was causing a problem with my other All Import plugin. While importing XML I was getting error 500 and time errors. I had to turn off your plug and everything was back to normal. What is the problem and what can we do?
this error in the logs:
AH01071: Got error ‘PHP message: B\xc5\x82\xc4\x85d Deadlock found when trying to get lock; try restarting transaction bazy danych WordPressa podczas wykonywania zapytania DELETE FROM wp_wps_index WHERE object_id = 305849 AND object_type_id IN (9,10,11,12,13,14,15,16,20,24) wys\xc5\x82anego przez do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->adminInit, PMXI_Admin_Import->process, PMXI_Import_Record->process, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce_Product_Search_Admin_Product::save_post, WooCommerce_Product_Search_Indexer->index, Wo
oCommerce_Product_Search_Indexer->delete_indexes, W3TC\\DbCache_WpdbNew->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\_CallUnderlying->query, W3TC\\DbCache_WpdbNew->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_WpdbNew->default_query\n’, referer: https://[redacted]/wp-admin/admin.php?page=pmxi-admin-manage&id=47&action=updateHi Adrian-
Generally speaking, your Database engine will throw the error Deadlock Found When Trying To Get Lock; Try Restarting Transaction when two simultaneous transactions lock the same database keys in different orders, creating a “Traffic Jam” of queries.
As far as W3 Total Cache causing this error, the first thing I’d check is the Don’t cache queries for logged in users setting in Performance > Database Cache. Make sure that setting is checked, caching database queries for imports might well be causing that error.
Also, double check that you haven’t modified the Reject Query Words setting from the default, both INSERT and DELETE queries should not be cached if you’re using the default values:
^\s*insert\b ^\s*delete\b ^\s*update\b ^\s*replace\b ^\s*create\b ^\s*alter\b ^\s*show\b ^\s*set\b \bautoload\s+=\s+'yes' \bsql_calc_found_rows\b \bfound_rows\(\)
If both of those look right, you may want to consider disabling Database Cache altogether. Modern databases are very fast, and depending on the site may not actually improve performance.
- The topic ‘W3 Total Cache and All Import error PHP message: Deadlock found when trying to get lock; try restarting transaction’ is closed to new replies.
