Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 -
- 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 -

Supporter timezone: Asia/Kathmandu (GMT+05:45)

Tagged: 

This topic contains 12 replies, has 2 voices.

Last updated by Shekhar Bhandari 1 year, 3 months ago.

Assisted by: Shekhar Bhandari.

Author Posts
March 14, 2024 at 10:36 am #15409020

stephenP-3

WordPress database error Deadlock found

March 14, 2024 at 10:57 am #15409283

stephenP-3

I'm having multiple (hundreds per hour) 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', '1710413680', '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, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, WPML\Utilities\Lock->create, QM_DB->query

Issues. I need urgent help.

March 14, 2024 at 12:05 pm #15409652

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

As discussed, can you provide me logs from the MySQL server?

Also, have you tried disabling all non-WPML plugins, switching to one of the default themes, and checking whether the issue persists or not?

Please remember to create a backup of your site (both files and the database) before making any updates or changes. This is always a good practice.

Look forward to your reply.

Thanks

March 14, 2024 at 3:01 pm #15410927

stephenP-3

Haven't tried to disable any plugins yet. MYSQL log (error.log, slow log and other logs) are literally empty.

March 15, 2024 at 4:19 am #15412658

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Can you please try to disable it and see if it helps?

Further, To debug this issue further, I would need to check your site settings once, for this I would need temporary access (wp-admin and ftp) to your site.

So could you please provide me with those details, you will find the needed fields for this below the comment area when you log in to leave your next reply.
hidden link

This info is private and available to you and WPML supporters only.
Read more about this: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

Note:
Backup your sites before providing the credentials or if possible provide credentials for the test site

Look forward to your reply.

Thanks

March 18, 2024 at 10:25 am #15420252

stephenP-3

Hello, we need urgent help as the website seems very slow when cache is not served.

March 18, 2024 at 10:51 am #15420419

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

I don't see the deadlock error while browsing the site, do I have to specifically look at debug.log for this? Can you provide more info?

I see that you are using Avada and it's not the latest version, so please update to the latest version as most WordPress themes and plugins add improvements to the latest versions.

Also, I suggest you update WordPress to the latest version and see if it helps.

Further, Please try to disable all non-WPML plugins, switch to one of the default themes, and check whether the issue persists or not.

Please remember to create a backup of your site (both files and the database) before making any updates or changes. This is always a good practice.

Look forward to your reply.

Thanks

March 18, 2024 at 11:35 am #15420617

stephenP-3

We're not debugging on display, only on "debug.log". Can you read that file? As this is staging site, the error occurence frequence is really low and you can't find a lot. On our live site, we have situations iwht 10-12 errors in a row in 5-6 seconds.

March 18, 2024 at 11:49 am #15420663

stephenP-3

wp and all plugins are upgraded now. I did the same on live site and I still get the errors. Not sure how to reproduce the errors. You can check in staging debug.log there were couple of them from last week.

March 18, 2024 at 11:56 am #15420704

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

I have enabled Advanced Translation Editor on the test site to check the issue further, I will keep monitoring.

At the same time, can you try to use the solution from here and see if it helps on your live site.
https://wpml.org/forums/topic/thousands-of-duplicate-queries/#post-14081673

Look forward to your reply.

Thanks

March 18, 2024 at 1:40 pm #15421458

stephenP-3

In the meantime, we 're regularly having 20-30 ish erorrs per hour on production site. What can I do to debug and to find the cause or fix the issue?

March 19, 2024 at 4:28 am #15424026

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

I checked the logs again and can't see the error on debug.log till now.

Did you try to use the solution from here and see if it helps on your live site?
https://wpml.org/forums/topic/thousands-of-duplicate-queries/#post-14081673

Thanks

March 20, 2024 at 5:05 am #15429385

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Let me know how it goes with the test.

Thanks

The topic ‘[Closed] WordPress database error Deadlock found’ is closed to new replies.