error_log swelling up with WordPress database errors

Resolved

(@eljkmw)

I’m unsure why the error_log files (both in the root and admin directories) are filled with rows of WordPress database errors, which look like so.

[13-Jan-2021 08:01:18 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT umeta_id FROM wp_usermeta WHERE meta_key = 'wp_yoast_notifications' AND user_id = 3 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata
[13-Jan-2021 08:01:18 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM <code>wp_usermeta</code> made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata, add_metadata

What is wrong here? And how can this issue be fixed?
Please advise. Thank you very much.

Viewing 6 replies - 1 through 6 (of 6 total)

Priscilla Chapman
(@priscillamc)

5 years, 4 months ago

Hi @eljkmw,

We see that you’re getting “Commands out of sync” errors. Just to help us troubleshoot, we’d like to get the following information:

1. Can you confirm that your web server meets the plugin’s minimum requirements?

2. Are all your plugins and themes updated? If not, does updating solve the problem?

3. Are you using the latest version of Yoast SEO {15.6.2)? If not, does updating solve the problem? We have update instructions available in this guide: How can I update my (free) plugin?.

4. Check for conflicts by temporarily deactivating all plugins except for Yoast SEO and switching to a default WordPress theme like Twenty Twenty-One. Do these errors still appear?
Thread Starter Jason Wong
(@eljkmw)

5 years, 4 months ago
To answer your questions.
```
1. YES
WordPress 5.6
PHP 7.4.13
PHP Memory 512MB
MariaDB 10.2.36

2. YES.  All plugins are up to date
3. YES.  Yoast SEO 15.6.2
4. I'll test this in the next 48 hours, and update here later.
```
Thread Starter Jason Wong
(@eljkmw)

5 years, 4 months ago

I’ve proceeded with Question 4, and I noticed the error_log file is logged whenever and wherever wp-admin is accessed. By the way, this happens to either Yoast SEO 15.6.2 and Yoast SEO Premium 14.8.

Suwash Kunwar
(@suascat_wp)

5 years, 4 months ago

@eljkmw

Unfortunately, we’re unable to replicate those errors in the error log of our test environment. If you’re a premium user of Yoast SEO, would you please contact our support team directly. This would help us investigate the issue on your specific setup and find the exact cause.

devnihil
(@devnihil)

5 years, 4 months ago

We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

Thread Starter Jason Wong
(@eljkmw)

5 years, 4 months ago

@devnihil

I found this thread, which Karel-Jan Tolsma mentioned that by pumping up the memory_limit to 1024 MB helps to remove this issue.

So far, it appears as though this increase of the memory_limit is working. I’ll continue monitoring until end of this month.