The site admin panel shows about 7,000 duplicate requests related to WPML.
The same happens when editing a post.
For example, such requests are duplicated:
What to do?
INSERT IGNORE INTO wp_options ( option_name, option_value, autoload )
VALUES ('wpml.WPML\TM\Settings\ProcessNewTranslatableFields.lock', '1708719851', 'no') /* LOCK */
tarasL :
INSERT IGNORE INTO wp_options ( option_name, option_value, autoload )
VALUES ('wpml.WPML\TM\Settings\ProcessNewTranslatableFields.lock', '1708719852', 'no') /* LOCK */
The problem for you could also be related to many stuck jobs for processing changes related to custom fields.
Normally those changes should be processed in order for the translation process to be correct for all posts which contain those fields.
However perhaps, if this process is stuck for you, you might want to test the workaround suggested in https://wpml.org/forums/topic/wordpress-database-error-deadlock-found-2/page/2/#post-15296055
Do note that you should do a complete website backup!!!
We are not responsible for any damages that might come from following that workaround.