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
- 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 -
- 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 -

Supporter timezone: Asia/Singapore (GMT+08:00)

Tagged: ,

This topic contains 7 replies, has 2 voices.

Last updated by Kor 1 year ago.

Assisted by: Kor.

Author Posts
January 9, 2024 at 7:49 pm #15166391

garethM-3

Experiencing database deadlocks intermittently. Since the solution offered is always, clear the WPML cache, is there a way to do this via the WP CLI so I can set up a cron to do this once a week?

January 9, 2024 at 8:15 pm #15166453

Kor
Supporter

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

Here is the ticket. Please share as much information as you can so that I can escalate this to our 2nd Tier Support for further investigation.

January 10, 2024 at 2:24 pm #15169346

Kor
Supporter

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your reply.

I've reported the issue to our 2nd Tier Support and I will come back to you once I've feedback.

January 10, 2024 at 3:05 pm #15169607

Kor
Supporter

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your patience.

I have feedback and please try this workaround.

Truncate the table icl_background_task so all entries are removed - clean slate
OR
Make sure that cron works
Enable Advanced Translation Editor if not enabled as an editor.

Please let me know how it goes.

January 10, 2024 at 3:52 pm #15169946

garethM-3

Thank you. I have tried option 1.

Can you tell me if any of the troubleshooting actions are available via the WP CLI? It would still be very useful to be able to execute some of these tasks via the command line instead of logging into the admin panel.

January 10, 2024 at 4:00 pm #15170039

Kor
Supporter

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your reply.

We have an unofficially WP-CLI integration used mostly by our development team and QA departments.

It's not officially announced, but safe enough to use. Please create a full backup and run the following WP-CLI command, which will exactly do what you wish:

$ wp wpml clear-cache

Once it's successfully done, the prompt will respond with "Success: WPML cache cleared"

January 11, 2024 at 3:07 pm #15175401

garethM-3

Thank you.

January 11, 2024 at 3:30 pm #15175591

Kor
Supporter

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

You're welcome and have a great day!

The topic ‘[Closed] Experiencing database deadlocks intermittently’ is closed to new replies.