There has been a critical error on this website

Hello @mguo!

I can see that the error is related to the WooCommerce plugin’s action scheduler and seems to have occurred at the database level. This error could be because of a corrupted database, or query duration limits or its size.

Did you check your database (MySql) error log? If you haven’t, please check it, and paste the errors here for us to review of you see any.

Also, share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

I found this article about such an issue and it mainly talks about the corrupted database.

Best!

Hi @pranavrana89,
I am actually not able to access my admin dashboard, the website is crashed when I tried to access it, so I cannot check the current system status.
The message display as :
Fatal error: Uncaught RuntimeException: Error saving action: Database is limited in /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:86 Stack trace: #0 /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action)) #1 /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(105): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #2 /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(54): ActionScheduler_ActionFactory->recurring('woocommerce_cle...', Array, false, 86400, '') #3 /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Domain/Services/DraftOrders.php(65): as_schedule_recurring_action(false, 86400, 'woocommerce_cle...') #4 /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Domain/Services/DraftOrders.php(57): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->maybe_create_cronjobs() #5 /home/customer/www/our_site_path/public_html/wp-includes/class-wp-hook.php(307): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->install('') #6 /home/customer/www/our_site_path/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array) #7 /home/customer/www/our_site_path/public_html/wp-includes/plugin.php(476): WP_Hook->do_action(Array) #8 /home/customer/our_site_path/public_html/wp-admin/admin.php(175): do_action('admin_init') #9 /home/customer/www/our_site_path/public_html/wp-admin/themes.php(10): require_once('/home/customer/...') #10 {main} thrown in /home/customer/www/our_site_path/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 86

Not sure where to find the database error log?
Thank you.

• This reply was modified 2 years ago by mguo.

Hi @pranavrana89,
I just enabled the debug mode and checked the debug.log.
There are thousand of log lines on it. I just copied the last one and it says:
wordpress database error database is limited for query INSERT INTO ‘actionscheduler_log(‘action_id’,’message’,’log_data_gmt’,’log_date_gmt’,’log_date_lical’) VALUES (…).
The article you shared actually I tried. But we don’t have any 0 action_id so I think it would be different issue.

• This reply was modified 2 years ago by mguo.

Hey @mguo!

Thank you for providing the error log, and the exact query that is creating issues; this is very helpful.

We know the problematic query; but, I do not see the actual values that the system is trying to put in there. Maybe, unsupported value types are causing this problem. such issues may occur on updating plugins but not WordPress.

Q1) Did you recently update your plugins?
Q2) Any idea of what WordPress version was your site on?

Anyways, I suggest you enable MySql error log as well as MySql General log. Here are the instructions to enable these (only enable general and error log).

If you face any issues enabling these, your host should be able to assist you with enabling these log files.

Best!

Hi @pranavrana89,

Here are the values for the query:

WordPress database error Database is limited for query INSERT INTOqfz_actionscheduler_logs(action_id,message,log_date_gmt,log_date_local) VALUES (20153, 'action ignored via WP Cron', '2022-11-02 12:04:53', '2022-11-02 12:04:53') 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_Abstract_QueueRunner->process_action, do_action('action_scheduler_execution_ignored'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_Logger->log_ignored_action, ActionScheduler_DBLogger->log

1. I think I updated the other plugin recently, I tried to deactived all the plugin from WP troubleshooting forums at https://www.ads-software.com/support/article/faq-troubleshooting/, but the error still persists.
2. I cannot remember what version the wordpress is really.

• This reply was modified 2 years ago by mguo.

Hi @pranavrana89,

Could you help us with the problem please. Our site is crashed at the moment.

Thank you.

Hello @mguo,

If disabling all plugins didn’t solve this and you can’t even access the admin dashboard, then this is better taken to your hosting service.

Please reach out to them and explain the whole situation, perhaps we can help based on their reply.

Let us know how it goes.

Hi @babylon1999,

I tried to rename the plugin folders and finally I login the admin and but when I tried to active your plugin, I can see the site crash again and error message shows

WordPress database error: [Database is limited]
INSERT INTO <code>qfz_actionscheduler_actions</code> (<code>hook</code>, <code>status</code>, <code>scheduled_date_gmt</code>, <code>scheduled_date_local</code>, <code>schedule</code>, <code>group_id</code>, <code>args</code>) VALUES ('woocommerce_cleanup_draft_orders', 'pending', '2022-11-02 15:57:54', '2022-11-02 15:57:54', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1667404674;s:18:\"\0*\0first_timestamp\";i:1667404674;s:13:\"\0*\0recurrence\";i:86400;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1667404674;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:86400;}', '0', '[]')

.

It seems the data cannot be write to the qfz_actionscheduler_actions and I don’t why.

Hello @mguo,

Thanks for clarifying that renaming the plugin folders made a difference, and you were able to see the WordPress backend.

Since this issue was reported a few hours ago, let’s also try the following:
1. Restore from the most recent backup that was made while the site was functioning properly.
2. Upon restore being completed, could you go ahead with updating database and verifying database tables? The options can be found under WooCommerce > Status > Tools.
3. Follow the instructions of my colleague here, in order to enable the two logs.

Let us know how that goes!

I trust that points you in the right direction, but if you have more questions, let us know. We’re happy to help.

Hi @anastas10s,
When I login to WP admin page and activate woocommerce my whole site crashed and shows “Fatal error: Uncaught RuntimeException: Error saving action: Database is limited”. I cannot access our admin page at all.
I have cleared some database data to make more space. The log shows the query should not write to wp_actionscheduler_actions.

• This reply was modified 2 years ago by mguo.

Hey @mguo!

This looks like an incompatibility between the codes of the installed plugins and WordPress. Please, temporarily disable your WooCoomerce plugin by changing its folder name to gain access to your WordPress installation.

then, log in to the admin panel; and update WordPress (if it is not on the latest version). But, do take a full backup of your site before proceeding with the updates. Make sure other plugins are updated too.

After that, generate your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Clear all types of caches; even the ones provided by your hosting provider. Now, activate WooCommerce to see if this solves the problem.

If the problem persists, paste here the generated SSR; we’ll check and get back to you.

Best!

Hi @pranavrana89,

My admin site would be total craches after I active woocommerce plugin, so how can I navigate to woocommerce/status to generate the system report?
If I deactivate your plugin, woocommerce would not appear on my admin sidebar anyway.

Thank you.

• This reply was modified 2 years ago by mguo.

Hello @mguo!

My bad to have missed that part; you cannot fetch SSR as WooCommerce would be disabled.

However, you can still take a backup of your site and update WordPress. But, if you don’t want to update your LIVE site; you can create a staging version of your site and try updating that instead. This way, you can check if that would fix the problem for you or not and then update your LIVE site.

Idea is to ensure that this problem is not oaccuring because of any conflict between different versions.

Also, if possible, let us know the exact version number of the installed WooCommerce plugin.

Best!

Hi @pranavrana89,

The php version is and woocommerce version is 7.0.0 and PHP is 8.0.25.

Hey @mguo!

Thanks for letting us know. So, the plugin version shouldn’t be a problem here as you are on the latest versions already.

What about WordPress?
Please check its version as well; following is how to do this:

Here, if you see a notice to update WordPress; please update it after taking your site backup.

Let us know how it goes.

Best!