wp_posts table locking problem

[Cheryl]

Our database was brought to its knees today when our user was trying to update Events. The database was repaired by the host and then their support person said said “the queries were stuck. It looks like a problem copying them to the temp files and then they get locked up. He said this did relate to the Events; he said one of the fields was event start date.”
We were sent this from their logs:

| 194 | 1018979 | 66.39.3.120:16443 | creativehaverhil_wp | Query | 1320
| Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*,
eventStart.meta_value as EventStartDate, IFNULL(DATE |
| 356 | 1018979 | 66.39.3.120:19251 | creativehaverhil_wp | Query | 1140
| Locked | UPDATE `wp_posts` SET `post_author` = 781,
`post_date` = ‘2012-12-14 12:55:03’, `post_date_gmt` = ‘2 |
| 417 | 1018979 | 66.39.3.120:21477 | creativehaverhil_wp | Query | 999
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 437 | 1018979 | 66.39.3.120:22077 | creativehaverhil_wp | Query | 959
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 505 | 1018979 | 66.39.3.120:24452 | creativehaverhil_wp | Query | 829
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 509 | 1018979 | 66.39.3.120:24661 | creativehaverhil_wp | Query | 813
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 511 | 1018979 | 66.39.3.120:24807 | creativehaverhil_wp | Query | 804
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 562 | 1018979 | 66.39.3.120:26475 | creativehaverhil_wp | Query | 710
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 592 | 1018979 | 66.39.3.120:27436 | creativehaverhil_wp | Query | 660
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 594 | 1018979 | 66.39.3.120:27455 | creativehaverhil_wp | Query | 659
| Locked | SELECT id from wp_posts WHERE post_content LIKE
‘%[tribe_community_events]%’ AND post_type in (‘page |
| 625 | 1018979 | 66.39.3.120:28896 | creativehaverhil_wp | Query | 585

etc…..

I have updated the plugins to the latest versions, but whenever this particular user attempts to access the Events thru admin, the whole database seizes.

I could not find where in the plug-in(s) this particular query is coming from.
Help!?!?!?!?!?

Thank you.

[Jonah]

Hi Cheryl,

Sorry to hear about the issues. Aside from increasing server memory or switching web hosts I’m not sure there is much we can do with the plugin on this. Have you tried deactivating all other plugins to see if there’s another plugin conflicting here? Or, reverting your theme to the Twenty Eleven/Twelve theme?

Let me know,
Jonah

[Author]

Posts