WordPress database error Deadlock found

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)

Tagged: Bug

This topic contains 22 replies, has 5 voices.

Last updated by Nigel 9 months ago.

Assisted by: Itamar.

Author	Posts
February 9, 2024 at 3:59 pm #15286913
Philip	Hi Itamar, I have sent you privately link to DB dump. Thank you and have a great weekend.
February 11, 2024 at 3:26 pm #15290148
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+02:00)	Thanks! I've shared it with our second-tier supporter and will keep you updated. Regards, Itamar.
February 12, 2024 at 8:22 am #15291248
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+02:00)	Hi, Our second-tier supporter would like to know if, since the fix he made, you are still getting the deadlock error. Regards, Itamar.
February 12, 2024 at 1:31 pm #15293365
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+02:00)	Hi, Our second-tier supporter found the source of the problem, debugging the issue with the DB dump you sent us. He escalated this issue to our developers. We'll keep you updated here on any news regarding this issue. Regards, Itamar.
February 12, 2024 at 5:10 pm #15294193
Philip	Hi Itamar, As for: >> Our second-tier supporter would like to know if, since the fix he made, you are still getting the deadlock error. The thing is that we are not using the DEV server and database prepared for you now. If you find a bug and fix it - we would like to ask you for details, how do we fix it on the live version of the database? Thanks in advance and have a nice day.
February 13, 2024 at 8:57 am #15296055
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+02:00)	Hi, Our second-tier supporter explains you have two options to fix this issue. A. Go to WPML -> Settings -> Translation Editor -> Editor for new translations, and change it from 'Classic Translation Editor' to 'Advanced Translation Editor (recommended)'. And press the Save button. B. To remove all entries from the icl_background_task table. To do this run this SQL line in the DB of your site. TRUNCATE TABLE `wp_icl_background_task`; ** Important! Please make a full site backup (files and DB) before you proceed with those steps** Regards, Itamar.
February 14, 2024 at 2:05 pm #15302860
Philip	Hi Itamar, Thank you. The first option is not suitable for us, the second option we will try to make on DEV and check. Can you tell me, what are potential issues we may get after clearing this table? What does it affect and what should we check in this regard to make sure that nothing is broken elsewhere? Thank you.
February 15, 2024 at 7:33 am #15305176
Nigel Supporter Timezone: Europe/Madrid (GMT+01:00)	Hi there Itamar is currently off, so let me step in for a moment. I checked with the second tier about your question. They said that the table is responsible for scheduled wpml actions, and in the context of your site there should not be any repercussions, but it should unblock the reported issue. You won't lose any translations, they are stored in different tables.

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