Database errors

Resolved

nam1962

(@nam1962)

Hi,
Having had 504 on my site, I checked the error.log and see errors that seem to involve nfw.
What should I do ?
Best


16-Mar-2022 16:44:24 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête INSERT INTOwp1_options(option_name,option_value,autoload) VALUES ('_transient_timeout_nfw_db_check', '1647449124', 'no') ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload`) faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, set_transient, add_option
[16-Mar-2022 16:44:24 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête INSERT INTO wp1_options (option_name, option_value, autoload) VALUES ('_transient_nfw_db_check', '1', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, set_transient, add_option
[21-Mar-2022 12:24:12 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête SELECT option_value FROM wp1_options WHERE option_name = '_transient_timeout_nfw_db_check' LIMIT 1 faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, get_transient, get_option
[21-Mar-2022 12:24:12 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête SELECT option_value FROM wp1_options WHERE option_name = '_transient_nfw_db_check' LIMIT 1 faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, get_transient, get_option
[21-Mar-2022 12:24:12 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête SELECT wp1_users.ID,wp1_users.user_login,wp1_users.user_pass,wp1_users.user_nicename,wp1_users.user_email,wp1_users.user_registered,wp1_users.display_name
		FROM wp1_users
		INNER JOIN wp1_usermeta
		ON ( wp1_users.ID = wp1_usermeta.user_id )
		WHERE 1=1
		AND ( ( ( wp1_usermeta.meta_key = 'wp1_capabilities'
		AND wp1_usermeta.meta_value LIKE '%"administrator"%' ) ) ) faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, nf_get_dbdata
[21-Mar-2022 12:24:12 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête INSERT INTO wp1_options (option_name, option_value, autoload) VALUES ('_transient_timeout_nfw_db_check', '1647865512', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, set_transient, add_option
[21-Mar-2022 12:24:12 UTC] Erreur de la base de données WordPress : Commands out of sync; you can't run this command now pour la requête INSERT INTO wp1_options (option_name, option_value, autoload) VALUES ('_transient_nfw_db_check', '1', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) faite par shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, set_transient, add_option

The page I need help with: [log in to see the link]

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

Plugin Author

nintechnet

(@nintechnet)

4 years, 2 months ago

There are a couple of discussions about this issue on the WordPress.org forum, including this subforum:
https://wordpress.org/support/topic/wp-database-error-commands-out-of-sync/
https://wordpress.org/support/topic/database-error-please-help-me/

There’s an application (plugin or theme) that is locking the DB and prevent NinjaFirewall from accessing it when WordPress is about to exit.

Do you see many similar errors in your log?
Do you have a caching plugin?

Thread Starter

nam1962

(@nam1962)

4 years, 2 months ago

Hi,
thank you for caring.

Yes, site is running with LiteSpeed.

This error appears from time to time (not everyday).

LiteSpeed is supposed to refresh when a plugin or theme update happens (all updates are set on auto)

Plugin list attached 🙂

Best


www]$ wp plugin list --statut=active
+--------------------------------------------+----------+--------+---------+
| name                                       | status   | update | version |
+--------------------------------------------+----------+--------+---------+
| wc-abandoned-carts-by-small-fish-analytics | active   | none   | 2.6.2   |
| cwginstocknotifier-export-csv              | active   | none   | 1.1     |
| amr-shortcode-any-widget                   | active   | none   | 4.0     |
| amuga-ajax-log                             | inactive | none   | 1.0     |
| antispambot                                | active   | none   | 1.1.6   |
| back-in-stock-notifier-for-woocommerce     | active   | none   | 2.7     |
| blackhole-bad-bots                         | active   | none   | 3.3.2   |
| bounce-handler-mailpoet                    | active   | none   | 1.3.21  |
| broken-link-checker                        | inactive | none   | 1.11.16 |
| child-theme-configurator                   | inactive | none   | 2.5.9   |
| classic-editor                             | active   | none   | 1.6.2   |
| code-profiler                              | active   | none   | 1.4     |
| disable-cart-fragments                     | active   | none   | 2.0     |
| dologin                                    | active   | none   | 3.2     |
| elementor                                  | active   | none   | 3.6.2   |
| elementor-pro                              | active   | none   | 3.6.4   |
| enable-media-replace                       | inactive | none   | 3.6.3   |
| facebook-for-woocommerce                   | inactive | none   | 2.6.12  |
| litespeed-cache                            | active   | none   | 4.6     |
| loco-translate                             | active   | none   | 2.6.1   |
| mailpoet                                   | active   | none   | 3.85.1  |
| mailpoet-premium                           | active   | none   | 3.85.0  |
| matomo                                     | active   | none   | 4.6.0   |
| mollie-payments-for-woocommerce            | active   | none   | 7.0.4   |
| mondialrelay-wordpress                     | active   | none   | 3.1     |
| my-custom-functions                        | active   | none   | 4.51    |
| ninjafirewall                              | active   | none   | 4.5.1   |
| ninjascanner                               | active   | none   | 3.0.10  |
| outdated-plugin-notifier                   | active   | none   | 1.0.6   |
| wc-password-strength-settings              | active   | none   | 3.0.0   |
| payplug                                    | active   | none   | 1.6.0   |
| polylang-wc                                | active   | none   | 1.6.3   |
| polylang-pro                               | active   | none   | 3.1.4   |
| woocommerce-delivery-notes                 | active   | none   | 4.6.5   |
| capability-manager-enhanced                | active   | none   | 2.3.4   |
| recently-registered                        | active   | none   | 3.4.4   |
| redirection                                | active   | none   | 5.2.3   |
| wp-seopress                                | active   | none   | 5.5.1   |
| shopmagic-abandoned-carts                  | inactive | none   | 2.0.5   |
| so-css                                     | active   | none   | 1.5.2   |
| stock-exporter-for-woocommerce             | inactive | none   | 1.0.0   |
| stop-emails                                | inactive | none   | 1.2.1   |
| vevida-optimizer                           | inactive | none   | 1.4     |
| woocommerce                                | active   | none   | 6.3.1   |
| woocommerce-bulk-stock-management          | active   | none   | 2.2.31  |
| woo-cart-abandonment-recovery              | inactive | none   | 1.2.14  |
| woocommerce-customer-order-csv-export      | inactive | none   | 5.0.11  |
| woocommerce-google-analytics-pro           | active   | none   | 1.8.11  |
| woocommerce-pre-orders                     | inactive | none   | 1.5.3   |
| woocommerce-remove-product-sorting         | active   | none   | 1.1.1   |
| woocommerce-shipment-tracking              | inactive | none   | 1.6.26  |
| woocommerce-smart-coupons                  | active   | none   | 4.21.0  |
| woocommerce-gateway-stripe                 | active   | none   | 6.3.0   |
| woostify-pro                               | active   | none   | 1.6.9   |
| wp-optimize                                | inactive | none   | 3.2.3   |
| wp-sweep                                   | inactive | none   | 1.1.5   |
| honeypot                                   | active   | none   | 1.9.1   |
| wp-mail-logging                            | active   | none   | 1.10.4  |
| zammad-wp                                  | inactive | none   | 0.8.3   |
| zero-spam                                  | inactive | none   | 5.3.2   |
| 0----code-profiler                         | must-use | none   | 1.0     |
| 0-ninjafirewall                            | must-use | none   | 1.0     |
| elementor-safe-mode                        | must-use | none   | 1.0.0   |
| advanced-cache.php                         | dropin   | none   |         |
+--------------------------------------------+----------+--------+---------+
PHP: 2022-04-05 16:39:01 [notice X 0][/home/mysite314/public_html/wp-content/plugins/elementor/modules/dev-tools/deprecation.php::301] L’argument $control_id est obsolète depuis la version 3.5.0 ! [array (
  'trace' => '
#0: Elementor\Core\Logger\Manager -> shutdown()
',
)]





	
		This reply was modified 4 years, 2 months ago by nam1962.

Plugin Author

nintechnet

(@nintechnet)

4 years, 2 months ago

Maybe you could try to enable the DB general query log and try to find which query is sent right before NinjaFirewall when the error occurs:
https://dev.mysql.com/doc/refman/8.0/en/query-log.html

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

The topic ‘Database errors’ is closed to new replies.