Background of the issue:
I am experiencing issues with stuck translations and slow queries on my site hidden link. I am trying to execute the following SQL query: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id INNER JOIN wp_postmeta AS dgwt_wcasmsku ON ( wp_posts.ID = dgwt_wcasmsku.post_id ) WHERE 1=1 AND wp_posts.ID IN (104543,104545,104546,104547,104548,104549,104550,104551,104552,104553,104554,104555,104556,104557,104558,104559,104560,104561,104562,104563,104564,104566,104567,104568,104569,104570,104571,104572,104573,104575,104576,104578,104579,104580,104582,104583,104584,104585,104586,104587,104589,104590,104591,104592,104593,104594,104595,104596,104597,104598,104599,104600,104601,104602,104603,104604,104605,104606,104607,104608,104609,104610,104611,104612,104613,104614,104615,104616,104617,104618,104619,........
Symptoms:
The translations are stuck and the queries are running slowly.
Questions:
How can I resolve the issue of stuck translations?
What can I do to improve the performance of slow queries?
I can also see that you are using a plugin called "WPML Synchronize Post Status". I'm not sure if it is our plugin.
Can you please tell me where you got this plugin from?
I've found out that the WPML Synchronize Post Status plugin is a custom plugin we created for specific purposes. hidden link. It can cause performance issues, so if you don't need it, please deactivate it and see if this resolves the issue. If it doesn't solve the problem, please proceed with the following.
1. Take a backup of your site in case something goes wrong.
2. Go to WPML -> Translation Management -> Translation Jobs.
3. Filter for 'Translations in Progress' and cancel all the in-progress translations.
4. If it does not help, proceed to WPML's troubleshooting section.
A. Go to WPML -> Support -> Troubleshooting (link)
B. Once on the troubleshooting screen, press the following buttons and check if it helps. Press each button at a time and wait for the process to complete.
- 'Clear language information and repopulate languages' button (if it is showing)
- 'Clear the cache in WPML'
- 'Remove ghost entries from the translation tables'
- 'Fix element_type collation'
- 'Fix WPML tables collation'
- 'Synchronize local job ids with ATE jobs'
- 'Synchronize translators and translation managers with ATE'
- 'Assign translation status to duplicated content'
- 'Set language information'
- 'Reset languages' Press this button only if you didn't add a custom language!
- 'Fix post type assignment for translations'
*** Please make a backup of your database before using this.***
Regards,
Itamar.
The topic ‘[Closed] stuck translation and slow queries’ is closed to new replies.
