Help Desk

Update multi-site install now brings server down with high SQL load

  • Posts: 8 Topics: 11
    | Permalink

    I updated the events calendar plugin, community events and calendar PRO. but when I active the PRO on the /calendar site, the whole server comes crashing down. This happened three times when I tried to activate the Events Calendar PRO plugin after update.

    We only run the calendar on one site within the multisite and I checked the knowlege base (https://theeventscalendar.com/knowledgebase/multisite-license/) and it said that the personal license is sufficient if you are willing to do manual updates.

    Updated PRO from 4.3.3 to 4.4.19

    Hosting company has the issue was ….” caused by high load on server from queries like…..
    —————————————–
    | 151146 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1754 | Sending data | SELECT
    MAX(

    coords

    .

    lat

    ) AS

    max_lat

    ,
    MAX(

    coords

    .

    lng

    ) AS

    max_lng

    ,
    MIN( `coo | 0 | 54971622 | 54971622 |
    | 151158 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1751 | Sending data | SELECT
    MAX(

    coords

    .

    lat

    ) AS

    max_lat

    ,
    MAX(

    coords

    .

    lng

    ) AS

    max_lng

    ,
    MIN( `coo | 0 | 54893804 | 54893804 |
    | 151191 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1744 | Sending data | SELECT
    MAX(

    coords

    .

    lat

    ) AS

    max_lat

    ,
    MAX(

    coords

    .

    lng

    ) AS

    max_lng

    ,
    MIN( `coo | 0 | 53784322 | 53784322 |
    | 151416 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1709 | Sending data | SELECT
    —————————————-

    The are 35302 entries in the posts table.

    Ran this query and got all the posttypes:
    SELECT post_type, count(post_type) FROM

    ea_12_posts

    WHERE 1 group by post_type
    ——————
    “attachment”,”5453″
    “nav_menu_item”,”29″
    “page”,”5″
    “post”,”4″
    “revision”,”7621″
    “sidebar”,”2″
    “template”,”2″
    “tribe_events”,”14282″
    “tribe_filters”,”1″
    “tribe_organizer”,”2037″
    “tribe_venue”,”5865″
    “wp_router_page”,”1″

    the post_meta table has 50435 entries.
    Not sure what else you might need. The PRO plugin is current disabled

    help.

    Posts: 18089 Topics: 17 Answers: 973
    | Permalink

    Hi Alan,

    I’m sorry (and surprised!) to hear that.

    The fragment you shared points a finger at our geolocation query, which is used to figure out the appropriate ‘bounding box’ for map view (so that the map is zoomed in to the relevant part of the world).

    This should only run within map view – so your note that it takes down your site as soon as Events Calendar PRO is activated is rather alarming. Did you mean that quite literally – ie, the very instant you activate it things crash?

    Who is your host and what sort of hosting package are you currently using (if you prefer not to disclose this publicly, please make use of our private reply facility).

    “tribe_events”,”14282″

    That is not a small number of events … are there any that you could potentially delete (old events that are no longer relevant to your users, for instance)?

    Posts: 8 Topics: 11
    | Permalink
    This reply has been marked as private.
    Posts: 18089 Topics: 17 Answers: 973
    | Permalink

    Thanks Linda.

    It turns out that a number of other users have also highlighted similar problems relating to the same query (again, following an update to 4.4.19).

    We have a bug report filed and I’ll attach this topic so we can provide an update once a fix has been created.

    Posts: 7
    | Permalink

    Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

    Thanks so much!
    The Events Calendar Support Team

    | Permalink
    Posts: 6521 Topics: 11
    | Permalink

    Hi there,

    Just wanted to share with you that a new maintenance release (for the Week of 7th January 2018) is out, including a fix for this issue :slightly_smiling_face:

    Find out more about this release → https://theeventscalendar.com/maintenance-release-week-7-january-2018/

    Please update the plugins and let us know if the fix works for your site,
    Best,
    Nico

    Posts: 8 Topics: 11
    | Permalink

    Hello Nico,

    Thank you for letting me know about the recent update.

    I installed the latest version of the calendar pro and am still experiencing performance issue when I activate the calendar events PRO.

    currently have:
    Wordpress 4.9.2
    The Events Calendar: 4.6.10.1
    The Events Calendar: Community Events: 4.5.8
    The Events Calendar PRO: Version 4.4.22

    Again, not right away, but access to the site slows over a 2-3 minutes and then become unresponsive.

    I have been deleteing past events. we are not at 7,700 events.

    Can you tell me if this is only an issue with the multi-site installs?

    If there is anything else I can provide to help resolve this, please let me know.
    Thanks,
    Linda

    Posts: 18089 Topics: 17 Answers: 973
    | Permalink

    Hi Linda,

    What we found when we investigated this was that the query you referenced was running far more frequently than necessary. The change we made was to restrict this so that it would run less often, reducing the net impact.

    However, the query itself remains essentially the same and it may be that this still presents a problem in some hosting environments, even if it does run only infrequently.

    I’ve re-opened a bug ticket about this so we can take another look.

    Posts: 6110 Topics: 16
    | Permalink

    Hi Linda!

    Just wanted to share with you that a new maintenance release (for the Week of 5 March 2018) is out, including a fix for this issue

    Find out more about this release → https://theeventscalendar.com/maintenance-release-week-5-march-2018/

    Please update the plugins and let us know if the fix works for your site.

    Best,
    Victor

    Posts: 7
    | Permalink

    Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

    Thanks so much!
    The Events Calendar Support Team

The topic ‘Update multi-site install now brings server down with high SQL load’ is closed to new replies.