transient problem
-
Hello,
I have a problem with my website (wordpress/woocommerce shop).
Some database quesries stays sleeping and are not closing (my host told me that).
is is an query like:| 2081818 | databasenaam | localhost | databasenaam | Query | 17 | init | DELETE FROM ma_options WHERE option_name LIKE ‘\\_transient\\_%1442240055’ ORDER BY option_id LIMIT |
and then multiple of this query’s.
and in my error log the following 2 errors are coming often there.
The first around 25 times a minute, the second a couple times a day:
[14-Sep-2015 09:53:42 UTC] WordPress databasefout Lock wait timeout exceeded; try restarting transaction bij query DELETE FROM ma_options WHERE option_name LIKE ‘\\_transient\\_%1442224363’ ORDER BY option_id LIMIT 1000; gemaakt door require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), call_user_func_array, pmxi_wp_loaded, PMXI_Import_Record->execute, PMXI_Import_Record->process, PMWI_Import_Record->import, wc_delete_product_transients, WC_Cache_Helper::get_transient_version, WC_Cache_Helper::delete_version_transients
and
[14-Sep-2015 10:00:38 UTC] WordPress databasefout Deadlock found when trying to get lock; try restarting transaction bij query DELETE FROM
ma_options
WHEREoption_name
= ‘_transient_doing_cron’ gemaakt door delete_transient, delete_optionanyone an idea what this can be and how to solve this? I’m not a programmer.
becouse of this my website is going offline multiple times a day.
Hope someone can help me with this.
- The topic ‘transient problem’ is closed to new replies.