Getting Fatal Error Emails Regularly for Wocommerce Plugin

  • Resolved Smart Site

    (@polishyourimage)


    1 year, 2 months ago

    Error Details
    =============
    An error of type E_ERROR was caused in line 126 of the file /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error message: Uncaught RuntimeException: Error saving action: Deadlock found when trying to get lock; try restarting transaction in /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:126
    Stack trace:
    #0 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(69): ActionScheduler_DBStore->save_action_to_db(Object(ActionScheduler_Action), NULL, false)
    #1 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
    #2 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
    #3 /www/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(102): ActionScheduler_ActionFactory->create(Array)
    #4 /www/wp-content/plugins/mailchimp-for-woocommerce/bootstrap.php(168): as_schedule_single_action(1693340758, ‘MailChimp_WooCo…’, Array, ‘mc-woocommerce’)
    #5 /www/wp-content/plugins/mailchimp-for-woocommerce/bootstrap.php(217): mailchimp_as_push(Object(MailChimp_WooCommerce_Single_Product), 5)
    #6 /www/wp-content/plugins/mailchimp-for-woocommerce/includes/class-mailchimp-woocommerce-service.php(415): mailchimp_handle_or_queue(Object(MailChimp_WooCommerce_Single_Product), 5)
    #7 /wordpress/wp-includes/class-wp-hook.php(308): MailChimp_Service->handleProcessProductMeta(Object(WC_Product_Simple), Array)
    #8 /wordpress/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(”, Array)
    #9 /wordpress/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #10 /www/wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php(682): do_action(‘woocommerce_pro…’, Object(WC_Product_Simple), Array)
    #11 /www/wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php(266): WC_Product_Data_Store_CPT->handle_updated_props(Object(WC_Product_Simple))
    #12 /www/wp-content/plugins/woocommerce/includes/class-wc-data-store.php(196): WC_Product_Data_Store_CPT->update(Object(WC_Product_Simple))
    #13 /www/wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-product.php(1432): WC_Data_Store->update(Object(WC_Product_Simple))
    #14 /www/wp-content/plugins/woocommerce/includes/admin/meta-boxes/class-wc-meta-box-product-data.php(424): WC_Product->save()
    #15 /wordpress/wp-includes/class-wp-hook.php(308): WC_Meta_Box_Product_Data::save(39053, Object(WP_Post))
    #16 /wordpress/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
    #17 /wordpress/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #18 /www/wp-content/plugins/woocommerce/includes/admin/class-wc-admin-meta-boxes.php(268): do_action(‘woocommerce_pro…’, 39053, Object(WP_Post))
    #19 /wordpress/wp-includes/class-wp-hook.php(310): WC_Admin_Meta_Boxes->save_meta_boxes(39053, Object(WP_Post))
    #20 /wordpress/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(”, Array)
    #21 /wordpress/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #22 /wordpress/wp-includes/post.php(4715): do_action(‘save_post’, 39053, Object(WP_Post), true)
    #23 /wordpress/wp-includes/post.php(4817): wp_insert_post(Array, false, true)
    #24 /wordpress/wp-admin/includes/post.php(439): wp_update_post(Array)
    #25 /wordpress/wp-admin/post.php(227): edit_post()
    #26 {main}
    thrown

    The issue appears to be related to the woocommerce plugin, in the logs I spotted the following error messages:?

    [04-Sep-2023 23:40:45] WARNING: [pool site-grreserve.com] child 50846 said into stderr: “NOTICE: PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_ql9np3zjel_actionscheduler_actions SET claim_id=1104584, last_attempt_gmt=’2023-09-04 23:40:45′, last_attempt_local=’2023-09-04 19:40:45′ WHERE claim_id = 0 AND scheduled_date_gmt <= ‘2023-09-04 23:40:45′ AND status=’pending’ ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 25 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->claim_actions”

    [04-Sep-2023 23:40:45] WARNING: [pool site-grreserve.com] child 50846 said into stderr: “NOTICE: PHP message: PHP Fatal error:? Uncaught RuntimeException: Unable to claim actions. Database error. in /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:938”

    can you provide additional information on the errors from above?

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

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

  • Hi,

    The error message you provided indicates that there is a database error related to the Action Scheduler in WooCommerce. Action Scheduler is a background processing library used by WooCommerce and other plugins to schedule and manage tasks.

    The specific error you’re encountering is a “Deadlock found when trying to get lock” error, which means that there was a conflict in the database when trying to update or claim certain actions in the Action Scheduler queue. Deadlocks can occur when multiple processes or queries are trying to access and modify the same data simultaneously.

    Here are some steps you can take to address this issue:

    1. Check for Plugin Conflicts: Sometimes, conflicts with other plugins or themes can cause database issues. To identify if this is the case, try disabling other plugins one by one and check if the issue persists after each deactivation. If the problem goes away after deactivating a specific plugin, that plugin might be the culprit.
    2. Update WooCommerce and Plugins: Ensure that you are using the latest versions of WooCommerce and all related plugins. Developers often release updates to address known issues and improve compatibility.
    3. Check Database Health: It’s possible that your database tables may need optimization or repair. You can use plugins like “WP-Optimize” or “WP-DBManager” to perform these tasks.
    4. Review Your Server: Check if your web hosting environment meets the requirements for WooCommerce and WordPress. Sometimes, server limitations or misconfigurations can cause database issues.

    Additionally, the error message includes a reference to the “MailChimp for WooCommerce” plugin. If you suspect that this plugin might be contributing to the issue, you can also try disabling or updating it.

    Always make sure to back up your website before making any significant changes, especially when dealing with database-related issues. This way, you can restore your site in case anything goes wrong during troubleshooting.

    Hi @polishyourimage

    Please let us know how it goes with @owadud655 suggestions.

    Additionally, please provide us with your full system report if you haven’t found an issue with the plugins.

    • System Status Report: navigate to WooCommerce → Status. Select Get system report and then Copy for support.
    • Fatal Error log: Share a copy of any fatal error log found under WooCommerce → Status → Logs.
    Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Getting Fatal Error Emails Regularly for Wocommerce Plugin’ is closed to new replies.