[Escalated to WPML Developers team] Database Error
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.
Elementor users - please update WPML to the latest version to maintain compatibility. More details here - https://wpml.org/changelog/2024/12/wpml-4-6-15-critical-update-for-elementor-sites/
Background of the issue:
I am trying to: it's hanging my database server and php-fpm. Link to a page where the issue can be seen: hidden link
Symptoms:
My logs are flooded. WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO sibz_6_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML\TM\Settings\ProcessNewTranslatableFields.lock', '1733727120', 'no') /* LOCK */. PHP Warning: Attempt to read property "post_title" on null in /var/www/html/ibser/wp-content/themes/wpestate/libs/help_functions.php on line 1122. PHP Warning: Undefined variable $hook in /var/www/html/ibser/wp-content/plugins/availability-calendar/availability-calendar.php on line 29.
Questions:
How can I resolve the database deadlock error?
What is causing the PHP warnings in my logs?
before your ticket is assigned to one of my colleagues, please allow me to walk you through some initial debugging steps. This will help speed up the support process.
Please excuse the oversight—the link was not correctly copied to the clipboard, but I have replaced it above. If you encounter any specific issues with Bricks in combination with object caching, please create a separate ticket, and we’ll be happy to investigate further.
Now my logs are flooded by this, i'm not runing just one site, i have several wpml installations on this server...
And honestly if the solution is delete a table i cannot imagine the mess this backgroundtask class is making... bacause is spreaded around all these files
WordPress database error Table 'box_isid.isds_7_icl_background_task' doesn't exist for query SELECT * FROM isds_7_icl_background_task WHERE task_status IN ('1','0','2') AND 1=1 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\Core\BackgroundTask\Repository\BackgroundTaskRepository->getAllRunnableTasks, WPML\Core\BackgroundTask\Repository\BackgroundTaskRepository->getAllByTaskStatus
yeah... i deleted the table, anyhow who does guarantee the plugin it's not going to create records who knows why and when? and suddenly put the sites down again because i've never used any kind of translation services, or set up any automated translations or so on... so the plugin itself did it and on a enterprise level these kind of bugs are not acceptable.
So until you provide me a solution to fully disable any kind of background processing from this plugin, for me it's safe to have that table deleted to fully disable the disaster this plugin is causing, because i saw support tickets from february 2024 and still the issue is happening...
