[wp-trac] [WordPress Trac] #59974: MAX_JOIN_SIZE wp-blog-header.php

[WordPress Trac]

#59974: MAX_JOIN_SIZE wp-blog-header.php
---------------------------+-----------------------------
 Reporter:  wkeithgardner  |      Owner:  (none)
     Type:  defect (bug)   |     Status:  new
 Priority:  normal         |  Milestone:  Awaiting Review
Component:  Database       |    Version:  6.3.2
 Severity:  minor          |   Keywords:
  Focuses:                 |
---------------------------+-----------------------------
 seeing this error in the error logs for a site with over 100k posts. seems
 to be non-critical.

 {{{
 [27-Nov-2023 15:42:16 America/New_York] WordPress database error The
 SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and
 use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for
 query
                                         SELECT SQL_CALC_FOUND_ROWS
 wp_posts.ID
                                         FROM wp_posts  LEFT JOIN
 wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
                                         WHERE 1=1  AND (
   wp_term_relationships.term_taxonomy_id IN
 (2,197,213,214,215,216,217,218,219,220,225,226,227,228,229)
   AND
   wp_posts.ID NOT IN (
                                 SELECT object_id
                                 FROM wp_term_relationships
                                 WHERE term_taxonomy_id IN
 (31926,31927,31928,31929,31930,31931,31932)
                         )
 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status =
 'publish')))
                                         GROUP BY wp_posts.ID
                                         ORDER BY wp_posts.post_date DESC
                                         LIMIT 0, 24
                                  made by require('/wordpress-
 versions/6.3.2/wp-blog-header.php'), wp, WP->main, WP->query_posts,
 WP_Query->query, WP_Query->get_posts
 [27-Nov-2023 15:43:10 America/New_York] WordPress database error The
 SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and
 use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for
 query
                                         SELECT SQL_CALC_FOUND_ROWS
 wp_posts.ID
                                         FROM wp_posts  LEFT JOIN
 wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
                                         WHERE 1=1  AND (
   wp_term_relationships.term_taxonomy_id IN
 (3,221,222,231,232,233,234,235,236,237,239,241,243,244,245,246,247,248,249,250,273,276,277,281,282,287,397,398)
   AND
   wp_posts.ID NOT IN (
                                 SELECT object_id
                                 FROM wp_term_relationships
                                 WHERE term_taxonomy_id IN
 (31926,31927,31928,31929,31930,31931,31932)
                         )
 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status =
 'publish')))
                                         GROUP BY wp_posts.ID
                                         ORDER BY wp_posts.post_date DESC
                                         LIMIT 0, 24
                                  made by require('/wordpress-
 versions/6.3.2/wp-blog-header.php'), wp, WP->main, WP->query_posts,
 WP_Query->query, WP_Query->get_posts
 }}}

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