[wp-trac] [WordPress Trac] #52722: Long rinning query causing site down

[WordPress Trac]

#52722: Long rinning query causing site down
--------------------------+-----------------------------
 Reporter:  naveenbos1    |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:
 Severity:  critical      |   Keywords:  needs-patch
  Focuses:                |
--------------------------+-----------------------------
 We have a site that is running on WordPress 5.2.9 and it is continuously
 site went down at 3 AM central every day due to running a long query on
 WordPress

 We did not find this query on the theme or plugin, Indly help to identify
 the issue.

 Query | 42546 | Sending data | SELECT COUNT(*) FROM sw_wp_posts LEFT JOIN
 sw_wp_term_relationships ON (sw_wp_posts.ID =
 sw_wp_term_relationships.object_id) LEFT JOIN sw_wp_term_relationships AS
 tt1 ON (sw_wp_posts.ID = tt1.object_id) LEFT JOIN sw_wp_term_relationships
 AS tt2 ON (sw_wp_posts.ID = tt2.object_id) LEFT JOIN
 sw_wp_term_relationships AS tt3 ON (sw_wp_posts.ID = tt3.object_id) LEFT
 JOIN sw_wp_term_relationships AS tt4 ON (sw_wp_posts.ID = tt4.object_id)
 LEFT JOIN sw_wp_term_relationships AS tt5 ON (sw_wp_posts.ID =
 tt5.object_id) LEFT JOIN sw_wp_term_relationships AS tt6 ON
 (sw_wp_posts.ID = tt6.object_id) LEFT JOIN sw_wp_term_relationships AS tt7
 ON (sw_wp_posts.ID = tt7.object_id) LEFT JOIN sw_wp_term_relationships AS
 tt8 ON (sw_wp_posts.ID = tt8.object_id) LEFT JOIN sw_wp_term_relationships
 AS tt9 ON (sw_wp_posts.ID = tt9.object_id) LEFT JOIN
 sw_wp_term_relationships AS tt10 ON (sw_wp_posts.ID = tt10.object_id) LEFT
 JOIN sw_wp_term_relationships AS tt11 ON (sw_wp_posts.ID = tt11.object_id)
 LEFT JOIN sw_wp_term_relationships AS tt12 ON (sw_wp_posts.ID =
 tt12.object_id) LEFT JOIN sw_wp_term_relationships AS tt13 ON
 (sw_wp_posts.ID = tt13.object_id) LEFT JOIN sw_wp_term_relationships AS
 tt14 ON (sw_wp_posts.ID = tt14.object_id) LEFT JOIN
 sw_wp_term_relationships AS tt15 ON (sw_wp_posts.ID = tt15.object_id) LEFT
 JOIN sw_wp_term_relationships AS tt16 ON (sw_wp_posts.ID = tt16.object_id)
 LEFT JOIN sw_wp_term_relationships AS tt17 ON (sw_wp_posts.ID =
 tt17.object_id) WHERE 1=1 AND (

 (

 sw_wp_term_relationships.term_taxonomy_id IN (8)

 AND

 tt1.term_taxonomy_id IN (28)

 AND

 tt2.term_taxonomy_id IN (59)

 )

 OR

 (

 tt3.term_taxonomy_id IN (8)

 AND

 tt4.term_taxonomy_id IN (28)

 AND

 tt5.term_taxonomy_id IN (20)

 )

 OR

 (

 tt6.term_taxonomy_id IN (6)

 AND

 tt7.term_taxonomy_id IN (28)

 AND

 tt8.term_taxonomy_id IN (59)

 )

 OR

 (

 tt9.term_taxonomy_id IN (6)

 AND

 tt10.term_taxonomy_id IN (28)

 AND

 tt11.term_taxonomy_id IN (20)

 )

 OR

 (

 tt12.term_taxonomy_id IN (7)

 AND

 tt13.term_taxonomy_id IN (28)

 AND

 tt14.term_taxonomy_id IN (59)

 )

 OR

 (

 tt15.term_taxonomy_id IN (7)

 AND

 tt16.term_taxonomy_id IN (28)

 AND

 tt17.term_taxonomy_id IN (20)

 )

 ) AND sw_wp_posts.post_type = 'gallery' AND (sw_wp_posts.post_status =
 'publish' OR sw_wp_posts.post_status = 'acf-disabled' OR
 sw_wp_posts.post_status = 'future' OR sw_wp_posts.post_status = 'draft' OR
 sw_wp_posts.post_status = 'pending') |

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/52722>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform