Tribe attendees transients

  • Resolved Merv

    (@mervforneyerolscom)


    8 years, 1 month ago

    Hi,
    I have a technical question about how transients are stored in the database for RSVP tickets.
    Have a relatively new site up using Events Calendar, Event Tickets (RSVP) and Woocommerce.
    In the process of investigation high CPU time I found thses transients being routinely and periodically being set on totally unrelated posts and post types. I have Event Tickets set to Events only.

    Transients:
    _transient_tribe_attendees
    _transient_timeout_tribe_attendees

    I have 560+ of theses on various post types. See screenshot of phpMyAdmin custom select for these at drive.google.com

    The question is why are all these transients stored on unrelated pages, posts and other post types? Are they necessary? Or, is it a plugin bug?

    Thanks in advance for your enlightenment.
    Merv

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

  • Hi Merv.

    I could replicate the issue but someone else I checked with (one of our developers) couldn’t and didn’t see how this could be happening.

    You could DELETE * FROM wp_postmeta WHERE meta_key LIKE '_transient%tribe%' (not valid SQL code but is correct LIKE string with wildcards)
    I also did this in my local testing site.

    (Of course, make a database backup before doing anything like this.)

    Then we’ll both wait and see if this happens again for us.

    Please report back after a while.

    Thanks.

    Thread Starter Merv

    (@mervforneyerolscom)

    Hi Clifford,
    I haven’t deleted the extraneous tribe postmeta but am watching activity.
    Here’s a new snapshot as of 9/23/2016. I included post_date in the SELECT and only tribe timeouts: https://drive.google.com/open?id=0B_PI5RZVOe0QUEs1enVVX2xKNlE

    I converted the date of the transient on the first record and it is:
    1474663526 = Friday, September 23, 2016 4:45:26 PM GMT-4:00 DST

    So, it appears these are being generated on new posts, products, pages, etc. If I delete them they will come back on new posts.
    Merv

    Thread Starter Merv

    (@mervforneyerolscom)

    BTW,
    I just saw this in the Release notes for 4.2.7:
    Fix – Stop logic for dealing with recurring events from impacting other post types (Originally reported by @ryan on the support forums. Thanks!)

    Could this be what we are seeing impacting postmeta even though my events are not recurring?
    Merv

    nicosantos

    (@nicosantos)

    Hey Merv,

    I don’t think that fix is related to the transients you mention. From you last message I’m not quite sure if this transients are proliferating or not.

    Please keep us updated, this one surely sounds like a bug!

    Best,
    Nico

    jwsmith300

    (@jwsmith300)

    My database currently has 454 _transient_tribe_attendees and 454 _transient_timeout_tribe_attendees records in the postmeta table.

    are these needed?

    Plugin Contributor GeoffBel

    (@geoffbel)

    Hey @jwsmith300,

    Normally, the transients are useful only temporarily (until their expiry).
    It might be that some of those proliferated unintentionally.

    I would always advise a database backup before deleting these. But if they are older transients, you should be able to get rid of them should you want to.

    Let us know how that goes.

    Best regards,
    Geoff B.

    Hey there! This thread has been inactive for a while so we’re going to go ahead and mark it Resolved. Please feel free to open a new thread if any other questions come up and we’d be happy to help. ??

    Cheers!
    Geoff

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Tribe attendees transients’ is closed to new replies.