WordPress database error commands out of sync

Hi @grevillea859,

Thanks for sharing some details from your PHP error log. Firstly, I’d like to take a look at the Jetpack connection for your site.

It appears that API calls to your site have been disabled. Jetpack uses XML-RPC and the?JSON API (REST API)?to communicate with your site. Please ensure that the JSON API is enabled on your site and that authentication is disabled.

If you would prefer not to disable authentication on the?JSON?API for your site, please allowlist the?/jetpack/v4/?and?/wpcom/v2/?namespaces instead. If you’re not sure how to do this, please contact your webhost’s customer support team for help.

After you’ve done that, you can try reconnecting Jetpack. Let us know if that resolves your issue and if not, we’d be happy to keep troubleshooting.

I don’t run a shop on my site.

Could you clarify what you mean by this? Jetpack is compatible with many types of sites, including e-commerce sites.

Hi (@lerrtle),

Thank you for replying. I am a bit confused as to what is happening.

Connections to the server seem variable. For example Site Health reports everything is good, connecting to the REST API then other times not when there are 50 or so cron jobs overdue.

I am not sure how to check that JSON API authentication is disabled? I understand that running https://example.com/wp-json/wp/v2 in the browser can reveal whether JSON API is working or not.

I disabled Jetpack and saw that I am now getting similar errors indicating a timing issue?

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 = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock

Today I tried to reinstall WordPress but it timed out. I have been experiencing 503 server errors and my host has advised I should upgrade to more memory. I am reaching the limits of my I/O usage when I have Jetpack running and another plugin which also relies on REST API. When I disable them the usage falls.

Since posting my ticket and issues since I will upgrade as advised and hope that resolves things, if not I will be back!

Thank you for your time.

Hi @grevillea859,

I am not sure how to check that JSON API authentication is disabled??

One way to do this is by using the Jetpack Modules page. The Modules page lists most of the Jetpack features, with the option to activate or deactivate these services. There will be a toggle for the JSON API feature on this page.

I disabled Jetpack and saw that I am now getting similar errors indicating a timing issue?

Since you’re getting similar errors even with Jetpack disabled, I think you have the right idea with pursuing an upgrade in your hosting environment. Once that’s been done, I’d be happy to look at your Jetpack connection again and help you get it running smoothly on your site.

Talk to you soon.

Hi there, @grevillea859,

Do you have updates about that? We usually close inactive threads after one week of no movement, but we want to make sure we’re all set before marking it as solved. Thanks!

Hi @erania-pinnera and @lerrtle

My apologies, I have recently upgraded my site to more memory and dealing with some issues (not Jetpack) with that.

At the moment it is looking alright. I will get back in touch if I need help.

Thank you again for your time.

Hey @grevillea859,

That’s great news about Jetpack working fine on your site, thanks for sharing it! I’m going to mark this thread as solved. If you have any further questions or need more help, you’re welcome to open another thread here. Cheers!