Database lock

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Exception

This topic contains 1 reply, has 2 voices.

Last updated by Andrey 1 year, 9 months ago.

Assisted by: Andrey.

Author	Posts
November 2, 2023 at 1:08 pm #14716957
Murat Gumrukcuoglu	When in backend we have some translators that translating posts the backend become almost not functional. the debug log can become over 6Gb within few minutes and every single error is this one: [02-Nov-2023 12:56:43 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO first_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML\\TM\\Settings\\ProcessNewTranslatableFields.lock', '1698929803', 'no') /* LOCK */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\BackgroundTask\BackgroundTaskLoader->WPML\BackgroundTask\{closure}, WPML\BackgroundTask\BackgroundTaskLoader->getSerializedTasks, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\BackgroundTask\BackgroundTaskLoader->WPML\BackgroundTask\{closure}, WPML\BackgroundTask\BackgroundTaskViewModel::get, WPML\Utilities\Lock->create How can this be solved ??
November 3, 2023 at 10:02 am #14724171
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	To ensure the best possible troubleshooting experience, we recommend updating your WPML plugin and add-ons to the latest version 4.6.7, which includes the latest bug fixes and improvements. Please note that this may not necessarily solve your issue, but it will provide us with the newest code to work with. You can find the latest released versions under "My Account -> Downloads" on this site. For instructions on how to update, please visit http://wpml.org/faq/install-wpml/. If the update does not solve the problem, you can try clearing the cache in WPML by going to WPML -> Support -> Troubleshooting and clicking the 'Clear the Cache in WPML' button. Please also click the 'Remove all messages and notifications' button in the same panel. If the issue persists, it may be due to an interaction issue with a third-party functionality. In this case, we recommend deactivating all plugins except those related to WPML and switching to a WordPress default theme like Twenty Twenty-one. If the issue is resolved, try activating the plugins one by one to identify the one causing the interaction issue. Please make sure to backup your database before proceeding, using a plugin such as http://wordpress.org/plugins/duplicator/.