Deadlocks in website logs

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.

No supporters are available to work today on this forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-	-
14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-	-

Supporter timezone: Asia/Jerusalem (GMT+02:00)

This topic contains 3 replies, has 3 voices.

Last updated by Itamar 7 months, 1 week ago.

Assisted by: Itamar.

Author	Posts
April 5, 2024 at 12:16 pm #15488064
Philip	Dear WPML Support, We previously had this support thread where you found the problem and advised how to fix: https://wpml.org/forums/topic/wordpress-database-error-deadlock-found-2/ We again found a lot of deadlocks related to WPML, can you please recommend what to do about it? Example: FastCGI: server "/var/run/hcgi/442" stderr: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO wp_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML\\\\TM\\\\Settings\\\\ProcessNewTranslatableFields.lock', '1712307887', '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, WPML\\Utilities\\Lock->create, WPM, referer hidden link* This is the link to our debug log: hidden link
April 7, 2024 at 8:57 pm #15492028
Philip	Another example: FastCGI: server "/var/run/hcgi/1976" stderr: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO wp_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML\\\\TM\\\\Settings\\\\ProcessNewTranslatableFields.lock', '1712523245', '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, WPML\\Utilities\\Lock->create, WPM, referer hidden link*
April 8, 2024 at 10:39 am #15493685
Alejandro Supporter Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+01:00)	Hello! I'll help you get started while a supporter takes your case. IT seems this issue is a bit different from before, but it also results in a deadlock. 1) You didn't send us the debug LOG but the Debug Information. can you please check if there are any warnings or errors in the debug.log: https://wpml.org/documentation/support/debugging-wpml/ Try to recreate the issue (maybe deactivate and reactivate WPML) after adding the code from the link to your wp-config.php file, and then go to the "wp-content" folder in your WordPress installation. If there were any issues on the site, a file called "debug.log" will appear. If you find it, please upload it to your preferred storage platform (Google Drive, Dropbox, etc.) and share the link to me in your reply (make sure it's shared with the right permissions so we can access its content). 2) Can you let us know if this is happening when you access the settings page in WPML or try to save a page or a setting on your site? 3) Can you allow us access like last time, and send us a database dump just like last time so we can send it to our devs for a check? Thanks in advance.
April 8, 2024 at 3:14 pm #15495189
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+02:00)	Hi, I'll continue to help you with this issue. Please follow my colleague Alejandro's advice and share further information about this case. If you need further help with this, please share the access details to your site with me. I'm enabling a private message for the following reply. Privacy and Security Policy We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ IMPORTANT - - Please backup the site files and database before providing us access. -- -- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.-- Regards, Itamar.

The topic ‘[Closed] Deadlocks in website logs’ is closed to new replies.