Woocommerce Action Scheduler DB table crashing

  • Resolved WP Birdie

    (@tapanp)


    6 months ago

    great-taussig mariadbd: 2024-05-17 11:59:55 70 [ERROR] mariadbd: Table ‘./thisismydbname/agwb2_actionscheduler_actions’ is marked as crashed and last (automatic?) repair failed

    I am continuously getting this error on my woocommerce site and my site crashed periodically

    A look at WC / Status / logs/ Fatal Errors shows the following
    2024-05-25T12:23:08+00:00?Critical?Uncaught TypeError: call_user_func_array(): Argument #1 ($callback) must be a valid callback, function “adminNoticeUADismissHandler” not found or invalid function name in /var/www/vhosts/mysite.com/httpdocs/wp-includes/class-wp-hook.php:324

    { “error”: { “type”: 1, “file”: “\/var\/www\/vhosts\/mysite.com\/httpdocs\/wp-includes\/class-wp-hook.php”, “line”: 324 }, “backtrace”: [ “”, “#0 \/var\/www\/vhosts\/mysite.com\/httpdocs\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()”, “#1 \/var\/www\/vhosts\/mysite.com\/httpdocs\/wp-includes\/plugin.php(517): WP_Hook->do_action()”, “#2 \/var\/www\/vhosts\/mysite.com\/httpdocs\/wp-admin\/admin-ajax.php(192): do_action()”, “#3 {main}”, “thrown” ] }

    Scheduled Actions shows 29934 actions of which 587 failed and 4 pending. Is this normal ?

    Please suggest what do I need to look for to figure out the root cause. I have tried the disabling all plugins and enabling them one by one to figure out the culprit and even tried the plugin profiler but cannot pin point the issue

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello WP Birdie

    Thank you for contacting Woo support.

    First, could you tell me if this is a new or existing site?
    This will help me determine the next troubleshooting steps.

    To help you further, I’d like to review your site’s System Status Report.
    You can find it via WooCommerce > Status.
    Select Get system report and then Copy for support.

    Once you’ve done that, you can paste the text in https://gist.github.com
    After that, you can paste the Gist link here in your reply.

    Lastly, I suggest you contact your web host and ask them if there are any issues with the web server.
    Sometimes, server resources are maxed out or go offline and they result in errors.

    Looking forward to your response. ??

    Best regards.

    Thread Starter WP Birdie

    (@tapanp)

    This is a 5 year old site with approx 1500 daily visitors and 20-30 daily order volume

    Webhost confirms everything is good at their end find below the link to the gist

    https://gist.github.com/t-a-p-a-n/e8277ec984b3b3cb6560f7aa32aa358f

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @tapanp

    Thanks for sharing additional details.

    great-taussig mariadbd: 2024-05-17 11:59:55 70 [ERROR] mariadbd: Table ‘./thisismydbname/agwb2_actionscheduler_actions’ is marked as crashed and last (automatic?) repair failed

    It suggests that there could be a problem with your database. You may need to repair your database, and if that doesn’t work, you might need to contact your hosting provider for further assistance.

    2024-05-25T12:23:08+00:00 Critical Uncaught TypeError: call_user_func_array(): Argument #1 ($callback) must be a valid callback, function “adminNoticeUADismissHandler” not found or invalid function name in /var/www/vhosts/mysite.com/httpdocs/wp-includes/class-wp-hook.php:324

    The second error message is about a function called “adminNoticeUADismissHandler” that can’t be found. The error usually occurs when WordPress is unable to locate the class or function that is supposed to be used as a callback. If disabling all plugins and switching to a default theme doesn’t resolve the issue, the function might be located in a custom code snippet.

    Scheduled Actions shows 29934 actions of which 587 failed and 4 pending. Is this normal ?

    The number of failed and pending scheduled actions is quite high. This could be related to the crashed database table, or it could be a symptom of another issue. It’s hard to say if this is normal without knowing more about your site, but it’s definitely worth investigating. I would suggest using the WP Crontrol plugin to check whether your site’s cron has any issues or not.

    Additionally, to figure out the root cause, I would recommend the following steps:

    1. Repair your database. If you’re not sure how to do this, your hosting provider should be able to help.
    2. Try to identify where the “adminNoticeUADismissHandler” function is coming from. If it’s not in a plugin or theme, it could be in a custom code snippet.
    3. Look into the failed and pending scheduled actions. Try to identify any patterns or common factors. This could give you a clue about what’s causing the problem. It would be great to create a staging site and conduct a conflict test as you’ve too many plugins active.

    I hope this provides some clarity. Please let us know if you have any other questions!

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @tapanp

    I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or open a new topic.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.