Bloating table wp_actionscheduler_actions

  • Resolved chwebdevelopment

    (@chwebdevelopment)


    3 years ago

    Hi,
    we’ve been in touch a couple times, I’m a long time customer of yours (I’d claim). I made this account just to report this.

    I’m about to move a wordpress installation. I left the site in question largely unattended. During the database export I noticed a bloated table (wp_actionscheduler_actions), and it’s all rows from your table plugin. It creates a new entry every single second (by the looks of it)!

    I’m running FiboSearch – AJAX Search for WooCommerce (Pro)?Version 1.14.1

    This is my indexer log: https://pastebin.com/raw/nqvZE92b

    If you want I can also send you the SQL dump, it’s 38mb! Edit: here’s a 10 row export: https://pastebin.com/9yetbCLu it’s basically all the same later.

    I also checked my installation on other sites, same problem.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter chwebdevelopment

    (@chwebdevelopment)

    I also find this error in the logs

    13-Oct-2020 07:08:38 UTC] WordPress database error Table 'cchgram.wp_dgwt_wcas_tax_index' doesn't exist for query SELECT *
                                      FROM wp_dgwt_wcas_tax_index
                                      WHERE 1 = 1
                                       AND (  taxonomy = 'product_cat' OR taxonomy = 'product_tag')
                                      AND term_name LIKE '%Converse x c%'
                                      ORDER BY taxonomy made by DgoraWcas\Engines\TNTSearchMySQL\SearchQuery\MainQuery->searchTaxonomy, DgoraWcas\Engines\TNTSearchMySQL\SearchQuery\TaxQuery->search
    Thread Starter chwebdevelopment

    (@chwebdevelopment)

    and also this error countless times
    [30-Oct-2020 04:38:35 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status='in-progress', last_attempt_gmt = '2020-10-30 04:38:35', last_attempt_local = '2020-10-30 05:38:35' WHERE action_id = 553654053771 made by do_action('wp_ajax_nopriv_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_DBStore->log_execution

    Plugin Author Damian Góra

    (@damian-gora)

    Hi @chwebdevelopment,

    This forum is for FiboSearch Free users only, and because you’re using the Pro version and your issue is strictly related to Pro features, please contact us via our website: https://fibosearch.com/contact/.

    Regards,
    Damian

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Bloating table wp_actionscheduler_actions’ is closed to new replies.