Technical Support Notice:

#1118641
  • Pavol Šimek

    4 days, 16 hours ago

    Rank Math free

    Technical Support Notice: Rank Math / WooCommerce Issue and Database Overload during Imports

    To: Technical Support of the Import/Synchronization Plugin
    Good day,I am requesting urgent assistance with a persistent database performance issue that manifests when processing a large number of products (approximately 30,000 items).
    This problem directly causes the failure of the Rank Math SEO plugin and prevents the e-commerce site from functioning correctly after every bulk data update or import.

    1. Problem Manifestation and Error MessageAfter your plugin processes the data, a database overload occurs, resulting in two specific errors when editing a product (during the SEO analysis):

    Rank Math Error (Primary Technical Issue):Message: Hlavné kľúčové slová – Nepodarilo sa skontrolovať hlavné kľúčové slová v článkoch – meta tabuľka článku prekračuje limit veľkosti. (Translation: “Focus Keywords – Failed to check focus keywords in articles – article meta table exceeds size limit.”)

    This confirms the database is being blocked, preventing Rank Math from reading or writing meta data (specifically the wp_postmeta table).

    Product Title Error (Consequence of Failure):Instead of loading the actual product name (e.g., RIAL X12…), the %title% variable pulls the name of another page (originally “Konfigurátor,” now “Vyskúšajte disky”) as a fallback.
    This happens because your plugin overloads the database to the extent that Rank Math cannot fetch the product data and resorts to pulling a substitute page title.

    2. Steps Taken to Resolve the ErrorWe have performed every possible optimization step on the hosting and WordPress side to resolve this issue, without success.

    A. Increased PHP/Hosting Limits:PHP Memory: The WP_MEMORY_LIMIT is set to 512M in wp-config.php.Execution Time: max_execution_time is set to 1000 seconds.Database: The host has confirmed a high wait_timeout and is increasing connect_timeout.

    B. Cache Clearing and SEO Template Fixes:Cache Cleared: We have cleared all known cache layers (WooCommerce transients, WooCommerce template cache, and XStore theme cache).SEO Template Fix: The Product title template was fixed from the originally faulty setting (**Kúpiť %title% %pt_single%**) to the correct one: %title% %sep% %sitename%.

    3. Request for ResolutionAs the issues persist despite maximum performance settings, the sole remaining source of the problem is the inefficient data processing during bulk operations.

    Our request is definitive:

    We require the optimization of the SQL queries used by your plugin to write and update product data (specifically for the ~30,000 products and the wp_postmeta table). The plugin must be adjusted so that it does not lock the database tables during bulk operations, which is causing the article meta table exceeds size limit error.

    We look forward to a prompt resolution. Thank you for your understanding.

    Sincerely,

    Pavol Šimek

Viewing 3 replies - 1 through 3 (of 3 total)
  • RankBot

    4 days, 16 hours ago

    Hello,

    We apologize for the issue you are facing with the database performance during product imports and the subsequent errors with the Rank Math SEO plugin. It sounds like a complex situation, especially with the large number of products being processed.

    Possible Causes and Solutions

    1. Database Overload: The error message indicates that the wp_postmeta table is exceeding its size limit. This can happen if there are too many entries or if the database is not optimized for handling large datasets. You might want to consider:

      • Optimizing Database Tables: Use a plugin or a tool to optimize your database tables, which can help reduce overhead and improve performance.
      • Clearing Unused Data: If there are old revisions, transients, or unused metadata, clearing these can help reduce the load on your database.

    2. Caching Plugins: If you are using caching plugins, try clearing or disabling them temporarily to see if it resolves the issue. Sometimes, caching can interfere with dynamic data retrieval.

    3. Memory Limit: Although you have set the WP_MEMORY_LIMIT to 512M, if your hosting environment allows, consider increasing it further to see if it alleviates the problem.

    4. Staging Environment: If possible, create a staging site where you can test the import process with only Rank Math activated. This can help identify if another plugin is causing conflicts.

    5. Contact Hosting Provider: Since you’ve already increased some limits, it may be beneficial to discuss this issue further with your hosting provider. They might have additional insights or solutions specific to their environment.

    Next Steps

    If these suggestions do not resolve the issue, we recommend replying to your ticket with any additional details or updates on what you’ve tried. A human agent from our support team will be able to assist you further and provide more tailored support based on your specific setup.

    Thank you for bringing this concern to our attention, and we hope to help you resolve it soon!

    Sources:
    WordPress Database Error Commands Out of Sync; You Can’t Run This Command Now » Rank Math
    How to Fix the Error Establishing a Database Connection in WordPress » Rank Math

    This is an automated reply from Rank Math Support Bot. Your ticket has been assigned to a human agent and we will get back to you shortly.

    Pavol Šimek

    4 days, 16 hours ago

    Rank Math free

    Hello,
    ​Thank you for your quick response and the standard troubleshooting suggestions.
    ​Please note that we have already executed all of the optimization steps you recommended—and in many cases, we have pushed the server limits to the maximum possible. Despite these efforts, the issue persists.
    ​The root cause must be within the SQL query execution and data handling of your import/synchronization plugin during bulk operations with our 30,000 products.
    ​Here is a summary of what has been done:
    ​1. Limits and Configuration (Executed)
    ​PHP Memory: Set to WP_MEMORY_LIMIT 512M (extreme limit) in wp-config.php.
    ​Execution Time: Set to max_execution_time 1000s (extreme limit).
    ​Hosting Contacted: Confirmed maximum high wait_timeout and increased other database timeout parameters.
    ​2. Database Optimization and Cache (Executed)
    ​Cache Cleared: All layers of caching have been purged.
    ​Data Cleared: WooCommerce transients and template cache were cleared.
    ​SEO Template Fixed: The Rank Math product template was corrected to ensure it pulls the correct product title if the database is available.
    ​Conclusion and Urgent Request
    ​The error meta tabuľka článku prekračuje limit veľkosti still appears, confirming that the database is being locked by the plugin during the update process, regardless of high server limits.
    ​We require human assistance from your technical team, as suggested in your reply.
    ​The solution must be:
    To optimize the SQL queries within your import plugin for bulk product updates, ensuring they do not block the wp_postmeta and other database tables, which causes the failure of Rank Math and other critical WooCommerce functions.
    ​Please assign a human agent to this ticket to investigate the plugin’s code and provide a permanent solution.
    ​Thank you.
    ​Sincerely,

    Pavol Šimek

    2 days, 20 hours ago

    Rank Math free

    Hello. How are you doing with my case?

    Thank you for your reply.

    Best regards, Šimek.

    s*********@g********

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

You must be logged in to reply to this ticket.