Plugin creates a 30GB database query

  • Resolved ntvmd

    (@ntvmd)


    8 months, 3 weeks ago

    I get a database query by the plug-in wp_gla_merchant_price_benchmarks 

    SELECT /*!40001 SQL_NO_CACHE */ * FROM 16749*****\_gla\_merchant\_price\_benchmarks WHERE (-9223372036854775808 <= product\_id AND product\_id <= 9223372036854775807)

    The size of a tabel in the database (wp_options) grows to 30 GB and crashes the website. After a manual cleanup it’s 15 MB.

    The day after it happended again.

    How can I stop wp_gla_merchant_price_benchmarks from doing this?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    8 months, 3 weeks ago

    Hi there!

    Thank you for sharing the details about the database issue and the query involving the wp_gla_merchant_price_benchmarks table. I understand how concerning it is when the wp_options table grows excessively large—especially up to 30 GB—and causes your website to crash repeatedly.

    Could you please ensure that you’re using the latest version 3.1.1 of the plugin? After updating, please monitor the site to see if the issue persists.

    A similar issue was reported in version 3.0.0, as mentioned here:
    🔗 https://github.com/woocommerce/google-listings-and-ads/pull/2995
    This has been resolved in the latest version.

    Let us know how it goes, and we’ll be happy to assist further if needed.

    Thread Starter ntvmd

    (@ntvmd)

    8 months, 3 weeks ago

    Yes we use 3.1.1

    Sai (woo-hc)

    (@saivutukuru)

    8 months, 3 weeks ago

    Hi @ntvmd,

    Thanks for confirming. While the latest version includes a fix for the earlier issue, it looks like your site may still be experiencing similar behavior.

    To help us investigate further, could you please share the following:

    • A fresh System Status Report (WooCommerce > Status > Get system report),  then paste it into https://pastebin.com or https://gist.github.com
    • A list of any scheduled tasks shown in the WP Crontrol plugin that reference:
      • gla_merchant_price_benchmarks
      • update_merchant_price_benchmarks
      • woo_google_listings_ads_* 

    Here’s how to check using WP Crontrol:

    1. Install and activate the WP Crontrol plugin.
    2. Go to Tools > Cron Events.
    3. Look for related hooks (mentioned above) and check their frequency, next run time, and whether any are stuck or failing.

    Temporary workaround to prevent site crashes:

    If one of the related cron events is causing the table to repopulate quickly or repeatedly:

    • Click Edit next to that cron event in WP Crontrol.
    • Either delete it or set its next run time far in the future. 

    This may temporarily disable certain Google Listings & Ads features like price benchmarks, but it can help stop the wp_options table from ballooning again.

    Once we have the requested info, we’ll be able to confirm whether this is a regression or a new issue, and escalate if needed. Appreciate your patience while we dig deeper into this.

    Thread Starter ntvmd

    (@ntvmd)

    8 months, 3 weeks ago

    I can’t find the cronjob using WP crontrol (It is NOT in the list).

    I do see it Woocommerce / Status / Planned actions (tab)

    gla/jobs/update_merchant_price_benchmarks/start

    It runs at 3:00 during the night but it seems I can’t stop it. I can click “annulate” but on a refresh it gets immediately re-added to the list with pending items.

    Thread Starter ntvmd

    (@ntvmd)

    8 months, 3 weeks ago

    I googled “how to disable update_merchant_price_benchmarks”.

    Seems possible in Google Merchant Center so I also tried that.

    • This reply was modified 8 months, 3 weeks ago by ntvmd.
    Sai (woo-hc)

    (@saivutukuru)

    8 months, 3 weeks ago

    Thanks for your continued updates.

    To help confirm and potentially stop this from recurring, please try the following steps:

    Disable Price Benchmarking in Google Merchant Center

    1. Log in to your Google Merchant Center.
    2. From the left-hand menu, go to Growth → Price competitiveness.
    3. Look for an option to disable or opt out of the Price benchmarks program.
    4. After disabling, give it a little time and monitor whether the cron job continues to regenerate in WooCommerce > Status > Scheduled Actions. 

    Disabling this should prevent the job from running again, which may help avoid the wp_options table growing excessively.

    Also, please share your latest System Status Report (SSR):

    This will help us confirm your environment and escalate further if needed.

    Let us know how it goes, your feedback could be helpful for others facing the same issue.

    Thread Starter ntvmd

    (@ntvmd)

    8 months, 2 weeks ago

    Changing the setting in Google Merchant Center is working.

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    8 months, 2 weeks ago

    Hi there!

    Thanks for the update — I’m glad to hear that changing the setting in Google Merchant Center resolved the issue!

    I’m so glad we were able to get that sorted for you! If you’re happy with the support you received, would you consider leaving us a quick review? It really helps us out: https://wordpress.org/support/plugin/google-listings-and-ads/reviews/#new-post

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

The topic ‘Plugin creates a 30GB database query’ is closed to new replies.