Make WordPress Core

Opened 6 months ago

#59974 new defect (bug)

MAX_JOIN_SIZE wp-blog-header.php

Reported by: wkeithgardner's profile wkeithgardner Owned by:
Milestone: Awaiting Review Priority: normal
Severity: minor Version: 6.3.2
Component: Database Keywords:
Focuses: Cc:

Description

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

Change History (0)

Note: See TracTickets for help on using tickets.