wp_vtprd_transient_cart_data table size over 6GB and keeps growing

  • Resolved jonwarmington

    (@jonwarmington)


    3 years, 10 months ago

    Our WordPress site database is over 8GB now, and it keeps growing. I took a deeper look and discovered that it is related to your plugin and the table

    wp_vtprd_transient_cart_data

    That table alone is about 6.4GB right now.

    What does this table do, can we clean it out?

    Shouldn’t there be some sort of cronjob that cleans this out?

    Thanks

    • This topic was modified 3 years, 10 months ago by jonwarmington.
Viewing 1 replies (of 1 total)
  • Plugin Author vark

    (@vark)

    Hi,
    vtprd_transient_cart_data is cleaned after every completed cart transaction,
    and by a daily cleanup routine (a cron job).

    There’s a module conflict in your installation which is preventing both of these from working.

    Suggest you debug as follows:
    1. go to phpMyAdmin and clear out the table
    2. Do a module conflict test, using the following directions:

    For each test using the directions outlined below, complete a Cart purchase, and then verify in phpMyAdmin if vtprd_transient_cart_data table has been cleaned up. When it hasn’t, you’ve found the conflicting module.

    To track down a module conflict, please follow these steps ** PRECISELY **:
    (1) Install and activate a maintenance mode plugin (if desired)
    (2) Then, DO ALL (*at the same time*):
    (-) do a full site backup!
    (-) deactivate ***all*** plugins except Woo, my 2 plugins (and maintenance mode plugin)
    (-) ** switch to a clean default theme like “twentynineteen” **
    — (This removes all other possible conflicts.)
    (-) turn off all deals except the one we are examining.

    (3) ** close your browser completely, retest in a fresh, clean browser session **
    (4) if good, add 1 module back in. ** Retest **
    (5) Repeat until conflict identified.

    ** This test depends on following the outlined steps fully. **

    Best,
    Vark

    (PS – If you do have a module conflict, it will likely boil down to choosing between the 2 conflicting modules…)

Viewing 1 replies (of 1 total)
  • The topic ‘wp_vtprd_transient_cart_data table size over 6GB and keeps growing’ is closed to new replies.