Uncaught RuntimeException: Unable to claim actions. Database error.

Hi @perfectad

I have an issue with accessing Woocommerce->Orders and Woocommerce Products. Throw the error “There has been a critical error on this website. Please check your site admin email inbox for instructions.”

From what I understand, you’re experiencing issues with accessing WooCommerce Orders and Products.

The error message you’re seeing usually indicates a problem with the Action Scheduler library, which is a part of WooCommerce. It’s responsible for managing scheduled tasks, and it seems to be encountering a database error while trying to claim actions.

Here are a few steps you can take to troubleshoot this issue:

1. Disable all plugins except WooCommerce: Sometimes, other plugins can interfere with WooCommerce’s functionality. By disabling all other plugins, we can determine if there’s a conflict. If the issue is resolved, enable the plugins one by one to identify the conflicting one.
2. Switch to a default WordPress theme: Occasionally, issues can arise due to conflicts with your current theme. Switching to a default theme like Storefront can help identify if this is the case.
3. Increase PHP Memory Limit: Sometimes, such issues could stem from an insufficient PHP memory limit. You can increase the PHP memory limit by editing the wp-config.php file or contacting your hosting provider. Here’s a helpful guide on how to do that: ?? Increasing the WordPress Memory Limit Here

Here’s a helpful guide on how to test for conflicts: ?? How to Test for Plugin and Theme Conflicts

In case none of the above steps work, could you send us a copy of your site’s System Status? This will give us a clearer picture of your site’s setup and help us pinpoint the problem. You can find it via WooCommerce > Status. Select Get system report and then Copy for support.

Once you have that, please paste it inside a Code block in your reply, or use https://pastebin.com/ to paste it and share the link with us.

Thank you for your patience and cooperation in this matter. I’m looking forward to your response so we can solve this issue for you.

Thank you for the reply. I followed all the advice provided. Unfortunately, they didn’t help to get the issues off. The system report can be found here https://pastebin.com/HZqb08dX

Here is the error report received through the email for more clarity
Error Details
=============
An error of type E_ERROR was caused in line 938 of the file /****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error message: Uncaught RuntimeException: Unable to claim actions. Database error. in /****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:938
Stack trace:
#0 /****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions()
#1 /****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(157): ActionScheduler_DBStore->stake_claim()
#2 /****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(136): ActionScheduler_QueueRunner->do_batch()
#3 /****/****/public_html/wp-includes/class-wp-hook.php(308): ActionScheduler_QueueRunner->run()
#4 /****/****/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#5 /****/****/public_html/wp-includes/plugin.php(565): WP_Hook->do_action()
#6 /****/****/public_html/wp-cron.php(188): do_action_ref_array()
#7 {main}
? thrown

Also, here is the error displays when changing to define( ‘WP_DEBUG’, true );

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Warning: Undefined property: stdClass::$priority in?/****/****/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php?on line?379

Just to let you know about your concern, This website is hosted on a VPS running with Centos Web Panel. I have another 3 websites hosted on this server running Woocommerce. Two of them are working fine without any issues so far and yesterday I found that one of them having the same issue. It was working well before. I am building another new website hosted on the same server. I just tried installing Woocommerce on here too unfortunately, I got the same issue.

Yout support will be greatly appriciated to get the issues sorted.

And here are some of server info

Apache version: Apache/2.4.57
PHP version: 8.0.0
MySQL version: 10.4.31-MariaDB

Just to let you know that I could have find a solution by following https://support.rankmath.com/ticket/multiple-database-errors-every-30-seconds-about-unknown-column/

just added a field on to the the data base as their advice

The field should be called?priority?and it should be set to a?tinyint?with a length of 3 on it. It should also be set to?unsigned?in the settings and should not accept null values.

Hi @perfectad

The team is already aware of this issue: https://github.com/woocommerce/action-scheduler/issues/973

At the time being, we can’t give you an estimated for when the team will look into or fix the issue, as bug reports are prioritized based on a few criteria. If you’d like to receive updates, please subscribe to the issue on GitHub.

If you have SSH access, can you please run this command wp action-scheduler fix-schema ?

Ensure that your Database user has administrative privileges. Without these, the command won’t function properly. If necessary, don’t hesitate to reach out to your hosting provider for assistance.

Let us know how that goes. Looking forward to helping you.