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 4 years, 7 months ago.
Assisted by: 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 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! You mention you used the "clear" button in troubleshooting but can you confirm you ran the following ones? In WPML -> Support -> Troubleshooting , check 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. |
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. |
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. 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. |
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. best regards, |
September 19, 2019 at 11:38 am #4604319 | |
The Smalls |
My mysql version is mariadb 10.3. |