WordPress database error Commands out of sync

Hello,

Please could you confirm the version of WP-Optimize you are currently using? Would it be possible for you to perform a plugin conflict test on one of your sites and de-activate all plugins aside from WP-Optimize please? After doing this clear the cache and then see if the issue repeats itself in the error log.

Using WP-Optimize version 3.3.0. Performing the plugin test on outwitrivals.com. Will provide an update as available.

Thank you for the prompt reply …… Rick

No sync errors when checking the log today. I’ve got other sites using the same plugins disabled for this test that do not thro the sync errors. How do you suggest proceeding?

Thank you for the support …… Rick

I stand corrected, checked a few other sites and they have sync errors as well.

Hello,

Thank you for the update, so currently there are sync errors on sites where only WP-Optimize is active?

That is not my observation. I was correcting my comment about not seeing sync error on some sites w/ the same active plugins as sites with sync errors. Enabling them slowly to discover the culprit.

This could be a number of different things.

– The hosting has a restriction on queries per second which makes the queries behave slower than what it needs. you could try your hosting about query limits, database restrictions, etc.

– The site has some cache and is trying to run queries of things it had already processed. flushing the cache on the server and the site would help here.

– There are simply too many queries that your server can’t handle at the moment

– The server could be overloaded or your plan doesn’t have enough resources to handle all these queries.

See replies/questions below:

– The hosting has a restriction on queries per second which makes the queries behave slower than what it needs. you could try your hosting about query limits, database restrictions, etc.

Here’s what they allow me to alter and the values set. Please let me know if there are others and/or specific values you suggest.

max_execution_time – 120

max_input_time – 60

max_input_vars – 1000

memory_limit-1024M

post_max_size – 64M

upload_max_filesize – 200M

– The site has some cache and is trying to run queries of things it had already processed. flushing the cache on the server and the site would help here.

We’re using WP-Optimize for caching, no clear wat you’re suggesting, please explain.

– There are simply too many queries that your server can’t handle at the moment

– The server could be overloaded or your plan doesn’t have enough resources to handle all these queries.

The hosting company states the errors are due to the caching plugin. Memory usage is typically 70-80% in the account, file usage, number of processes, storage/bandwidth, cpu are all very low.

Your max execution time is really low, I would normally recommend 900.

Sever cache – ask your hosts to clear it. In WPO purge your cache.

Changed max_execution_time to 900 and requested server cache be purged.

Host says:

There is no server side cache configured. we are running litespeed webserver, and for wordpress installs we recommend litespeed cache plugin.

Litespeed are always going to recommend litespeed (in all honestly we will always recommend WPO).

Have you had the issue again since you upped your max execution time?

I have not, but all the plugins were disabled. Enabling them over time and checking the error log. Hope to have my testing done over the weekend. Appreciate your help and patience ….. Rick

I have sites (cincinnatianimalcare.org below) w/ the new setting that are still getting the out of sync warnings in the logfile.

[11-Mar-2024 18:51:40 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp7p_options WHERE option_name = 'wsal_adapter-type' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog::close_external_connection, WSAL\Helpers\Settings_Helper::get_option_value, WSAL\Helpers\Settings_Helper::get_option_value_internal, get_option
[11-Mar-2024 19:10:53 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp7p_options WHERE option_name = 'wsal_adapter-type' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog::close_external_connection, WSAL\Helpers\Settings_Helper::get_option_value, WSAL\Helpers\Settings_Helper::get_option_value_internal, get_option