Database query remains stuck

An SQL Query done by Rankmath keeps calling again and again until the page won’t load anymore and the process has to be stopped manually.

SELECT wp_posts.ID, wp_posts.post_type FROM wp_posts
  LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
  LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = 'rank_math_robots' )
  WHERE 1=1
    AND ( wp_postmeta.meta_key = 'rank_math_focus_keyword' AND ( ( mt1.meta_key = 'rank_math_robots' AND mt1.meta_value NOT LIKE '%noindex%' ) OR mt2.post_id IS NULL ) )
    AND wp_posts.post_type IN ('post', 'page', 'attachment', 'products', 'wp_solutions', 'open-positions', 'am_event')
    AND (wp_posts.post_status = 'publish')
    AND wp_posts.post_title NOT REGEXP REPLACE(wp_postmeta.meta_value, ',', '|')
  GROUP BY wp_posts.ID 

It’s about this call.
The query remains stuck as a zombie process, so the process can not be shot down after 10 minutes and the database connections are released again

• This topic was modified 5 years, 3 months ago by Bastian Fießinger.
• This topic was modified 5 years, 3 months ago by Bastian Fießinger.