WordPress database error Commands out of sync

Hi,

So these look like they are related to your MainWP plugin activity log: https://mainwp.com/using-the-activity-log-for-mainwp-extension/. It looks like it might actually be having issue closing the log.

Have you tried clearing some the log events?

Is there anything else in your php error log (any fatal errors)?

Do you optimize your DB (this might help)?

Interesting, the site’s not running MainWP. It is running ManageWP w/ the worked plugin installed.

Site was optimized when we changed hosts, doing so again and will clear the error log. No fatal errors in the log file.

Hosting company suggested caching as the cause of the out of sync issues. The below messages were in the log for the site djbridal.com. I disabled WP-Optimize and cleared the log file. Will review tomorrow to see if the messages return.

[12-Mar-2024 12:51:23 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_timeout_bnfw-async-notifications’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, BNFW->on_shutdown, get_transient, get_option
[12-Mar-2024 12:51:23 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_bnfw-async-notifications’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, BNFW->on_shutdown, get_transient, get_option
[12-Mar-2024 12:51:23 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_timeout_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option
[12-Mar-2024 12:51:23 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option
[12-Mar-2024 12:51:23 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_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
[12-Mar-2024 12:51:54 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT autoload FROM wp6w_options WHERE option_name = ‘_transient_wpo_get_cache_size’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ob_end_flush_all, ob_end_flush, wpo_cache, WPO_Page_Cache->delete_cache_size_information, delete_transient, delete_option
[12-Mar-2024 12:51:54 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_timeout_bnfw-async-notifications’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, BNFW->on_shutdown, get_transient, get_option
[12-Mar-2024 12:51:54 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_bnfw-async-notifications’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, BNFW->on_shutdown, get_transient, get_option
[12-Mar-2024 12:51:54 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_timeout_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option
[12-Mar-2024 12:51:54 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_options WHERE option_name = ‘_transient_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option
[12-Mar-2024 12:51:54 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp6w_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
[12-Mar-2024 13:30:42 UTC] PHP Warning: Creating default object from empty value in /home/intercep/public_html/djbridal.com/wp-content/plugins/testify/ags-update-checker/ags-update-checker.php on line 235

No errors in the log file with WP-Optimize disabled.

Any additional thoughts on how to use WP Optimize without the out of sync errors?

Can ask your hosting provider to see if they can find anything in the MySQL logs, LiteSpeed’s logs, or syslog around the same time that the errors occur.

Can you ask them to do this for multiple sites that are affected to see if this helps us narrow things down a bit?

Requested their support, awaiting reply.

They suggested increasing the php.ini memory_limit setting to 2048. It’s eliminated most of the sync messages. Will monitor for a few more days and report back. Appreciate your patience …… Rick.

Let us know how you get along

I give up, nothing I’ve tried eliminates the errors in the log. They still appear when WP Optimize is disabled so no need for you to pursue assistance finding a solution. Appreciate you hanging in there with me while we explored ideas, thank you …… Rick

Hi @rbarron . Did you try set manual cron instead?
I am facing the same issue and it appear when I reach the limit of the available CPU usage.
I set manual cron from Cpanel and I disabled the WP_CRON in wp-config.php because it usually run each time you load any page. It helped me but I am still facing some errors when the manual cron runs. Currently I am trying to disable some cron jobs because when it reach the 100% of processing it start to get freezing and is not able to stop again. Basically I had to kill process by command line and it back to work well. PD: 512MB ram is enough to work well. Check healt of wordpress if it is recognizing this config.

• This reply was modified 3 months, 3 weeks ago by obxion.

@obxion have not tried disabling WP_CRON. Will explore your idea, thank you for sharing your experience.

@obxion still getting out pf sync warnings disabling WP_CRON and using cPanel cron.

[30-Jul-2024 13:30:04 UTC] PHP Warning: Cannot modify header information – headers already sent in /home/cincinna/public_html/wp-content/plugins/wp-optimize/cache/file-based-page-cache-functions.php on line 692
[30-Jul-2024 13:41:20 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
[30-Jul-2024 13:45:03 UTC] PHP Warning: Cannot modify header information – headers already sent in /home/cincinna/public_html/wp-content/plugins/wp-optimize/cache/file-based-page-cache-functions.php on line 692
[30-Jul-2024 14:00:05 UTC] PHP Warning: Cannot modify header information – headers already sent in /home/cincinna/public_html/wp-content/plugins/wp-optimize/cache/file-based-page-cache-functions.php on line 692
[30-Jul-2024 14:00:08 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
[30-Jul-2024 14:04:21 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
[30-Jul-2024 14:04:21 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT autoload FROM wp7p_options WHERE option_name = ‘rank_math_notifications’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Notifications\Notification_Center->update_storage, delete_option

From the latest logs and steps taken, it seems the issue persists even after increasing max_execution_time and memory_limit, disabling WP_CRON, and running manual CRON jobs. Given that the errors still occur when WP-Optimize is disabled, this suggests the problem might not only be connected with WP-Optimize but possibly with your hosting setup too.

I recommend using tools like New Relic or your hosting provider’s server monitoring tools to track server performance and identify any resource bottlenecks. Additionally, request your hosting provider to provide detailed MySQL logs for the times when the errors occur. This might offer more insight into the root cause of the “Commands out of sync” errors.