This query has been running for 42 days already (as of today) on dbstore1005:3318 (wikidatawiki) coming from stat1007:
| 298648 | research | 10.64.21.118:38696 | wikidatawiki | Query | 3680610 | Sending data | SELECT page_title, page_touched, page_latest FROM page WHERE page_title IN ( SELECT DISTINCT CONCAT('P', wbpt_property_id) as page_title FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wby_name = 'label' AND wbx_text IS NULL ORDER BY wbpt_property_id )
It sometimes causes lag on dbstore1005:3318 but nothing too worrying - https://grafana.wikimedia.org/d/000000273/mysql?orgId=1&refresh=1m&var-dc=eqiad%20prometheus%2Fops&var-server=dbstore1005&var-port=13318&from=1580173362981&to=1580259762982
I am not sure if the query will ever finish, but just reporting this in case you want to report it to the user.
I am going to disable notifications for this specific check on icinga, to avoid the noise on -operations (the slave lag check only).
Again, not a big deal for us (DBAs), but just reporting this just in case you want to follow up.