MySQL crashing when Pro activated

[jenunderscore]

Ever since the last update our website keeps crashing due to MySQL becoming unresponsive (due to CPU on the server being spun right up, not sure what comes first… chicken/egg)

In any case, consistently, it’s the following SQL query that fails first in the error log:

[16-Mar-2015 23:34:42 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' )  WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (107)
) AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish') AND ( 
  wp_postmeta.meta_key = '_EventStartDate'
) AND wp_posts.ID IN  (    SELECT ID FROM wp_posts WHERE ID NOT IN ( SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' )    UNION ALL    SELECT post_id AS ID FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' AND wp_postmeta.meta_value IN ('')  )  AND (wp_postmeta.meta_value >= '2015-03-16 00:00:00' OR (wp_postmeta.meta_value <= '2015-03-16 00:00:00' AND tribe_event_end_date.meta_value >= '2015-03-16 00:00:00' )) GROUP BY wp_posts.ID ORDER BY DATE(MIN(wp_postmeta.meta_value)) ASC, TIME(wp_postmeta.meta_value) ASC LIMIT 0, 3 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wbn/page-home.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, TribeEventsAdvancedListWidget->widget, TribeEventsListWidget->widget_output, tribe_get_events, TribeEventsQuery::getEvents, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

We don’t have reoccurring events. This query seems to be linked to the “event list” widget. Which is the reason I bought the plugin.

Any ideas on why this would be taking down my database? Running the query directly on the database seems fine. I’m at a total loss. The solution so far is to completely deactivate the plugin and code my own “events list” widget.

[jenunderscore]

Hi there,

Turns out GoDaddy is having system-wide problems with databases crashing on cPanel set-ups.

Web Hosting March 16, 2015 at 1:13 PM
We are aware of an issue with databases timeouts and intermittent 503 errors in our cPanel Hosting. We are working to get this resolved as quickly as possible.

I think it’s just an unfortunate circumstance that the Pro plugin puts just the right amount of load on the DB to take it down. To that – I don’t think there’s anything _wrong_ with your plugin. Just GoDaddy.

Thanks,
Jen

[Gustavo Bordoni]

Hi Jennifer,

Thanks for reaching out to us here on our forum.

Normally this happens on server structures that are done in one single machine, where the web server and the database run at the same level.

I will suggest you to take a look at some other hosting if you intend to make your site bigger, because this is always a hard thing to deal with.

Thanks for your feedback on your specific problem, we are aware that some of our functionalities need a performance improvement and we are working on that.

My best Regards,

[Author]

Posts