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.

This topic contains 13 replies, has 2 voices.

Last updated by The Smalls 1 month ago.

Assigned support staff: Alejandro.

Author Posts
September 16, 2019 at 2:20 pm #4581241

The Smalls

Hi, after updating wpml plugins my logs are full of :

WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = '_wpml_transient__wpml_st_file_scan_in_progress' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Scan_Hooks->import_translations_files, WPML_ST_Translations_File_Queue->is_locked, WPML_Transient->get, get_option

errors every few minutes.

Also in my slow queries i get 3-8 seconds to execute this query :

SELECT DISTINCT
s.id,
s.name,
s.context,
st.status,
s.gettext_context,
st.value AS tra,
st.mo_string AS mo_string,
s.value AS orig
FROM wp_icl_string_pages sp
INNER JOIN wp_icl_string_urls su
ON su.id = sp.url_id
INNER JOIN wp_icl_strings s
ON s.id = sp.string_id
LEFT JOIN wp_icl_string_translations st
ON s.id=st.string_id
AND st.language=su.language
AND s.language!=su.language
WHERE (su.language='el' and su.url='ajax-request')
or (su.language='el' and su.url IS NULL);

These two errors (i dont know if one produces the other, or are 2 independent errors) slow down my site (big difference than before update).

How can i solve these? I've tried clearing cache, etc, using the clear buttons in troubleshooting etc.

best regards,

September 17, 2019 at 7:37 am #4586097

Alejandro
Supporter

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Hello!
Welcome to WPML Support.
I'll do my best to help you solve this issue.

You mention you used the "clear" button in troubleshooting but can you confirm you ran the following ones?

In WPML -> Support -> Troubleshooting , check
• "Clear the cache in WPML"
• "Remove ghost entries from the translation tables"
• "Fix element_type collation"
• "Set language information"
• "Fix post type assignment for translations"
• "Recreate ST DB Tables"

If these weren't the buttons you pressed, please press them but ❌ Before doing so please make a full website backup! ❌

Then, try to delete your transients. you can do so by installing a plugin like hidden link

in there yu just have to select to delete all transient.

Try it out and let me know if that fixed the problem.

September 17, 2019 at 11:59 am #4588243

The Smalls

Hi, even after these steps the problems are still there.
What else can i check?
best regards,

September 17, 2019 at 1:13 pm #4588723

Alejandro
Supporter

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

At this point i believe the best we can do is migrate the site to one of our temporary staging servers so we can check the site and start running some tests on the database.

Once i find the issue and manage to solve it i'll proceed to do the same on your site.

The reason why i suggest this is because we might have to do some agressive testing and we don't want to stress your server or make any change to your site since it looks as if it is a live site.

I'll send you the instructions on the next reply, on a private message.

Regards.

September 17, 2019 at 3:13 pm #4589613

The Smalls

Hi, migration completed.
best regards,

September 17, 2019 at 4:12 pm #4590071

The Smalls

Hi, i see the errors in my php error log. cant replicate these errors in web, can't you tail -f the error.log, tail -f mysql-slow-queries.log and browse the site (view products, add to cart, order etc), in order to fill the logs.
I believe that the site is slow due to many errors in the log file, when messages are being written in the log file, it takes some time for that.

best regards,

September 17, 2019 at 5:33 pm #4590455

Alejandro
Supporter

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Oh ok, but do you get the errors when using the site or something? Because I just checked my php error log and it was empty, I'm trying to browse the site to see if it gets populated with the issues you mean but so far I haven't been able to recreate the problem.

If you were doing something like creating a page, update it or something else, please let me know so I can try to recreate it on the Cloudways site.

Regards.

September 18, 2019 at 9:20 am #4594301

The Smalls

Hi, these errors come by using the website, cant tell if is both by users and admin browsing and working.
I have errors that are generated when admin is logged out, so is at least from users.
Can't you understand from the query what this is reffered to?
best regards,

September 18, 2019 at 3:27 pm #4598151

Alejandro
Supporter

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Hello, i haven't forgotten about this ticket. i'm checking to see if y any chance there's something i'm missing so i'm trying to replicate this issue.

I'll update you as soon as i have something.

Regards.

September 19, 2019 at 7:27 am #4601919

Alejandro
Supporter

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Could you please send me the PHP log from your end? on our end we do not get any similar issues so i'm starting to think it could be a server related issue (but i can't confirm anything yet).

Please upload it to a platform like dropbox or any other similar and then add the link in the "Duplicator Package" field, i'll send it to our developers to see if there's something wrong and what can be done.

One other thing i noticed on your end is that you have "Redis Object Cache", could you try disabling that plugin and see if by any chance the errors in the database are gone?

September 19, 2019 at 8:00 am #4602271

Alejandro
Supporter

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

I just remembered that, usually, this out of command is linked to exhausted memory issues.

I can see in your debug information, though, that you have over 700mb allocated to this installation so at first i ruled this issue out.

Could you check if you encounter ehausted memory issues on the php error logs as well or if you have any other error related to WPML or with other plugins?

Since WPML needs to "touch" everything on your site, it becomes a target sometimes and when a plugin fails, it could create a chain reaction that would get to some tables, mostly from String Translations and create database issues.

Something else i saw but that it's hardly relevant is your MYSQL version which is 5.5.5 and our minimum requirement is actually 5.6, so you can try to update that as well just to rule that out.

Regards.

September 19, 2019 at 11:37 am #4604317

The Smalls

Hi, the error has been gone after some tweaks in mysql.
Maybe the new WPML version needed more resources to run.

best regards,

September 19, 2019 at 11:38 am #4604319

The Smalls

My mysql version is mariadb 10.3.

September 19, 2019 at 11:38 am #4604323

The Smalls

My issue is resolved now. Thank you!