WordPress database error

  • Resolved myacoub

    (@myacoub)


    4 years, 7 months ago

    Some of our site users fail at the checkout point and we do see the following errors on our logs. Help is appreciated.

    ====== 1st error ==========
    mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 135168 bytes) in /var/www/vhosts/recreational8.com/httpdocs/wp-includes/wp-db.php on line 2056, referer: https://recreational8.com/checkout/

    ====== 2nd error ============
    mod_fcgid: stderr: WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO UnHs9_woocommerce_sessions (session_key,session_value,session_expiry) VALUES ('1', 'a:17:{s:4:\\"cart\\";s:414:\\"a:1:{s:32:\\"a6eea5aa95cc31102ab50d87b12ccde0\\";a:11:{s:3:\\"key\\";s:32:\\"a6eea5aa95cc31102ab50d87b12ccde0\\";s:10:\\"product_id\\";i:18588;s:12:\\"variation_id\\";i:0;s:9:\\"variation\\";a:0:{}s:8:\\"quantity\\";i:1;s:9:\\"data_hash\\";s:32:\\"b5c1d5ca8bae6d4896cf1807cdf763f0\\";s:13:\\"line_tax_data\\";a:2:{s:8:\\"subtotal\\";a:0:{}s:5:\\"total\\";a:0:{}}s:13:\\"line_subtotal\\";d:10;s:17:\\"line_subtotal_tax\\";i:0;s:10:\\"line_total\\";d:0.1;s:8:\\"line_tax\\";i:0;}}\\";s:11:\\"cart_totals\\";s:398:\\"a:15:{s:8:\\"subtotal\\";s:2:\\"10\\";s:12:\\"subtotal_tax\\";i:0;s:14:\\"shipping_total\\";s:4:\\"7.75\\";s:12:\\"shipping_tax\\";i:0;s:14:\\"shipping_taxes\\";a:0:{}s:14:\\"discount_total\\";d:9.9;s:12:\\"discount_tax\\";i:0;s:19:\\"cart_contents_total\\";s:3:\\"0.1\\";s:17:\\"cart_contents_tax\\";i:0;s:19:\\"cart_contents_taxes\\";a:0:{}s:9:\\"fee_total\\";s:1:\\"0\\";s:7:\\"fee_tax\\";i:0;s:9:\\"fee_taxes\\";a:0:{}s:5:\\"total\\";s:4:\\"7.85\\";s:9:\\"total_tax\\";d:0;}\\";s:15:\\"applied_coupons\\";s:25:\\"a:1:{i:0;s:8:\\"n7zszck7\\";}\\";s:22:\\"coupon_discount_totals\\";s:27:\\"a:1:{s:8:\\"n7zszck7\\";d:9.9;}\\";s:26:\\"coupon_discount_tax_totals\\";s:25:\\"a:1:{s:8:\\"n7zszck7\\";i:0;}\\";s:21:\\"removed_cart_contents\\";s:1646:\\"a:4:{s:32:\\"645098b086d2f9e1e0e939c27f9f2d6f\\";a:11:{s:3:\\"key\\";s:32:\\"645098b086d2f9e1e0e939c27f9f2d6f\\";s:10:\\"product_id\\";i:1809;s:12:\\"variation_id\\";i:0;s:9:\\"variation\\";a:0:{}s:8:\\"quantity\\";i:1;s:9:\\"data_hash\\";s:32:\\"b5c1d5ca8bae6d4896cf1807cdf763f0\\";s:13:\\"line_tax_data\\";a:2:{s:8:\\"subtotal\\";a:0:{}s:5:\\"total\\";a:0:{}}s:13:\\"line_subtotal\\";d:34.99;s:17:\\"line_subtotal_tax\\";i:0;s:10:\\"line_total\\";d:0.35;s:8:\\"line_tax\\";i:0;}s:32:\\"3fab5890d8113d0b5a4178201dc842ad\\";a:11:{s:3:\\"key\\";s:32:\\"3fab5890d8113d0b5a4178201dc842ad\\";s:10:\\"product_id\\";i:1803;s:12:\\"variation_id\\";i:0;s:9:\\"variation\\";a:0:{}s:8:\\"quantity\\";i:2;s:9:\\"data_hash\\";s:32:\\"b5c1d5ca8bae6d4896cf1807cdf763f0\\";s:13:\\"line_tax_data\\";a:2:{s:8:\\"subtotal\\";a:0:{}s:5:\\"total\\";a:0:{}}s:13:\\"line_subtotal\\";d:69.98;s:17:\\"line_subtotal_tax\\";i:0;s:10:\\"line_total\\";d:0.7;s:8:\\"line_tax\\";i:0;}s:32:\\"838aac83e00e8c5ca0f839c96d6cb3be\\";a:11:{s:3:\\"key\\";s:32:\\"838aac83e00e8c5ca0f839c96d6cb3be\\";s:10:\\"product_id\\";i:6042;s:12:\\"variation_id\\";i:0;s:9:\\"variation\\";a:0:{}s:8:\\"quantity\\";i:1;s:9:\\"data_hash\\";s:32:\\"b5c1d5ca8bae6d4896cf1807cdf763f0\\";s:13:\\"line_tax_data\\";a:2:{s:8:\\"subtotal\\";a:0:{}s:5:\\"total\\";a:0:{}}s:13:\\"line_subtotal\\";d:34.99;s:17:\\"line_subtotal_tax\\";i:0;s:10:\\"line_total\\";d:0.35;s:8:\\"line_tax\\";i:0;}s:32:\\"a6eea5aa95cc31102ab50d87b12ccde0\\";a:11:{s:3:\\"key\\";s:32:\\"a6eea5aa95cc31102ab50d87b12ccde0\\";s:10:\\"product_id\\";i:18588;s:12:\\"variation_id\\";i:0;s:9:\\"variation\\";a:0:{}s:8:\\"quantity\\";i:1;s:9:\\"data_hash\\";s:32:\\"b5c1d5ca8bae6d4896cf1807cdf763f0\\";s:13:\\"line_tax_data\\";a:2:{s:8:\\"subtotal\\";a:0:{}s:5:\\"total\\";a:0:{}}s:13:\\"line_subtotal\\";d:10;s:17:\\"line_subtotal_tax\\";i:0;s:10:\\"line_total\\";d:0.1;s:8:\\"line_tax\\";i:0;}}\\";s:16:\\"wca_session_data\\";s:0:\\"\\";s:19:\\"wcp_passed_rule_ids\\";s:17:\\"a:1:{i:0;i:9917;}\\";s:22:\\"shipping_for_package_0\\";s:790:\\"a:2:{s:12:\\"package_hash\\";s:40:\\"wc_ship_ff4133a39e243f02e4ecc683b81c5cfa\\";s:5:\\"rates\\";a:2:{s:11:\\"flat_rate:2\\";O:16:\\"WC_Shipping_Rate\\":2:{s:7:\\"\\0*\\0data\\";a:6:{s:2:\\"id\\";s:11:\\"flat_rate:2\\";s:9:\\"method_id\\";s:9:\\"flat_rate\\";s:11:\\"instance_id\\";i:2;s:5:\\"label\\";s:41:\\"USPS First Class- Shipping & Handling\\";s:4:\\"cost\\";s:4:\\"7.75\\";s:5:\\"taxes\\";a:0:{}}s:12:\\"\\0*\\0meta_data\\";a:1:{s:5:\\"Items\\";s:51:\\"Delta-8 THC Assorted Gummies Sampler Pack × 1\\";}}s:11:\\"flat_rate:5\\";O:16:\\"WC_Shipping_Rate\\":2:{s:7:\\"\\0*\\0data\\";a:6:{s:2:\\"id\\";s:11:\\"flat_rate:5\\";s:9:\\"method_id\\";s:9:\\"flat_rate\\";s:11:\\"instance_id\\";i:5;s:5:\\"label\\";s:42:\\"USPS Priority Mail-Shipping & Handling\\";s:4:\\"cost\\";s:5:\\"10.00\\";s:5:\\"taxes\\";a:0:{}}s:12:\\"\\0*\\0meta_data\\";a:1:{s:5:\\"Items\\";s:51:\\"Delta-8 THC Assorted Gummies Sampler Pack × 1\\";}}}}\\";s:25:\\"previous_shipping_methods\\";s:62:\\"a:1:{i:0;a:2:{i:0;s:11:\\"flat_rate:2\\";i:1;s:11:\\"flat_rate:5\\";}}\\";s:23:\\"chosen_shipping_methods\\";s:29:\\"a:1:{i:0;s:11:\\"flat_rate:2\\";}\\";s:22:\\"shipping_method_counts\\";s:14:\\"a:1:{i:0;i:2;}\\";s:8:\\"customer\\";s:901:\\"a:27:{s:2:\\"id\\";s:1:\\"0\\";s:13:\\"date_modified\\";s:0:\\"\\";s:8:\\"postcode\\";s:5:\\"33414\\";s:4:\\"city\\";s:15:\\"West Palm Beach\\";s:9:\\"address_1\\";s:18:\\"15610 Latina place\\";s:7:\\"address\\";s:18:\\"15610 Latina place\\";s:9:\\"address_2\\";s:0:\\"\\";s:5:\\"state\\";s:2:\\"FL\\";s:7:\\"country\\";s:2:\\"US\\";s:17:\\"shipping_postcode\\";s:5:\\"33414\\";s:13:\\"shipping_city\\";s:15:\\"West Palm Beach\\";s:18:\\"shipping_address_1\\";s:18:\\"15610 Latina place\\";s:16:\\"shipping_address\\";s:18:\\"15610 Latina place\\";s:18:\\"shipping_address_2\\";s:0:\\"\\";s:14:\\"shipping_state\\";s:2:\\"FL\\";s:16:\\"shipping_country\\";s:2:\\"US\\";s:13:\\"is_vat_exempt\\";s:0:\\"\\";s:19:\\"calculated_shipping\\";s:0:\\"\\";s:10:\\"first_name\\";s:5:\\"robyn\\";s:9:\\"last_name\\";s:6:\\"powell\\";s:7:\\"company\\";s:0:\\"\\";s:5:\\"phone\\";s:10:\\"5615555555\\";s:5:\\"email\\";s:18:\\"mouhab76@gamil.com\\";s:19:\\"shipping_first_name\\";s:5:\\"robyn\\";s:18:\\"shipping_last_name\\";s:6:\\"powell\\";s:16:\\"shipping_company\\";s:0:\\"\\";s:14:\\"shipping_phone\\";s:10:\\"5615555555\\";}\\";s:10:\\"wc_notices\\";N;s:21:\\"chosen_payment_method\\";s:35:\\"nmi_gateway_woocommerce_credit_card\\";s:22:\\"mailchimp_landing_site\\";b:0;s:22:\\"order_awaiting_payment\\";i:25246;}', 1632276104), referer: https://recreational8.com/checkout/

    ====== 3rd error ===========
    mod_fcgid: stderr: \t\t\t\t\tON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, referer: https://recreational8.com/checkout/

    We recognize the error that it is on the database/MySQL level, but we can’t figure out how to solve this..

    The server has 16GB and all of them are allowed and set to WordPress (WP_config.php) and PHP (php.ini) also for your info we are using PHP 7.4

    Any clue what do we need to look at?

    Mouhab

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

    (@rynald0s)

    Automattic Happiness Engineer

    4 years, 7 months ago

    Hi @myacoub!

    The first error is related to your hosting package and you will need to increase the amount of RAM that is allocated to your site.

    You can either ask your host to increase the limits, or increase is yourself following the guide below:

    https://docs.woothemes.com/document/increasing-the-wordpress-memory-limit/

    As for the second error, it seems like it is related to the first error, and by upping the memory, should be resolved. In case, however, the second error is not related, you can work through some of the troubleshooting here:

    https://rankmath.com/kb/wordpress-database-error-commands-out-of-sync/

    Cheers!

    Thread Starter myacoub

    (@myacoub)

    4 years, 7 months ago

    Dear Rynaldos, (@rynald0s)

    Many thanks for your response, i will try to perform as per your guidance here. But just for your info, the server HW has 16GB of RAM and the WordPress config file has been set to have them all! Also the php.ini is set for 512MB!

    Anyways, i will test and get to you back with some results to discuss specially on the DB syn side. I think it maybe corrupted!

    Did you see any problem with the third error line i posted above??

    Mouhab

    con

    (@conschneider)

    Engineer

    4 years, 7 months ago

    Hi again,

    Anyways, i will test and get to you back with some results to discuss specially on the DB syn side. I think it maybe corrupted!

    ✅ Happy testing.

    Did you see any problem with the third error line i posted above??

    Could be a caching problem, but it also looks very similar to your 2nd error message entry which also is complaining about session troubles. I would apply your tests first and see how this fares. Afterwards we can see if the 3rd error persists.

    Kind regards,

    mathewborja

    (@mathewborja)

    4 years, 7 months ago

    @rynald0s @conschneider This is a widespread issue and is caused by a memory leak somewhere. Hundreds of users reporting the same issue and no access to wp-admin after update.

    Thread Starter myacoub

    (@myacoub)

    4 years, 7 months ago

    @mathewborja

    In my case i still can access the wp-admin yet my /checkout on wooCommerce is troubled!!

    Always get Internal error code 500 on the page and some times the order gets processed and sometimes it gives “fail” on wooCommerce!

    What do you mean by after update? Yes, i saw a message earlier on wooCommerce that the Database was updated. Did you mean a DB update or WordPress update or wooCommerce update. for your info, we are using PHP 7.4

    Mouhab

    Plugin Support abwaita a11n

    (@abwaita)

    4 years, 7 months ago

    Thanks for your reply @myacoub, it seems that @mathewborja is referring to a different issue altogether. For your specific case, let us know how it goes after increasing the memory.

    Just to mention, @mathewborja, we’d prefer if you created a new separate thread if you’re facing an issue accessing WP-Admin after updating your WooCommerce plugin.

    Thanks.

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

The topic ‘WordPress database error’ is closed to new replies.