Seems like a schema confusion error with either ProblemPager (not sure if that is a thing), flagged reviews or change tags. Example error:
{ "_index": "logstash-2018.10.01", "_type": "mediawiki", "_id": "AWYwqQJtccmrnEbcIcos", "_version": 1, "_score": null, "_source": { "server": "de.wikipedia.org", "db_server": "10.192.48.18", "wiki": "dewiki", "channel": "DBQuery", "type": "mediawiki", "error": "Key 'change_tag_rev_tag' doesn't exist in table 'change_tag' (10.192.48.18)", "http_method": "GET", "@version": 1, "host": "mw2175", "shard": "s5", "sql1line": "SELECT /*! STRAIGHT_JOIN */ page_namespace,page_title,page_latest,fp_stable AS stable,fp_quality AS quality,fp_pending_since AS pending_since,fp_pending_since FROM `flaggedpages` FORCE INDEX (fp_pending_since),`revision`,`change_tag` FORCE INDEX (change_tag_rev_tag),`page` WHERE (fp_pending_since IS NOT NULL) AND (rev_page = fp_page_id) AND (rev_id > fp_stable) AND (ct_rev_id = rev_id) AND (page_id = fp_page_id) AND page_namespace IN ('0','6','10','828','14') GROUP BY fp_pending_since,fp_page_id ORDER BY fp_pending_since,fp_page_id LIMIT 51 ", "fname": "IndexPager::buildQueryInfo (ProblemChangesPager)", "errno": 1176, "unique_id": "W7JYUgrAID8AACQkPaIAAAAW", "method": "Wikimedia\\Rdbms\\Database::makeQueryException", "level": "ERROR", "ip": "10.192.16.133", "mwversion": "1.32.0-wmf.23", "message": "IndexPager::buildQueryInfo (ProblemChangesPager)\t10.192.48.18\t1176\tKey 'change_tag_rev_tag' doesn't exist in table 'change_tag' (10.192.48.18)\tSELECT /*! STRAIGHT_JOIN */ page_namespace,page_title,page_latest,fp_stable AS stable,fp_quality AS quality,fp_pending_since AS pending_since,fp_pending_since FROM `flaggedpages` FORCE INDEX (fp_pending_since),`revision`,`change_tag` FORCE INDEX (change_tag_rev_tag),`page` WHERE (fp_pending_since IS NOT NULL) AND (rev_page = fp_page_id) AND (rev_id > fp_stable) AND (ct_rev_id = rev_id) AND (page_id = fp_page_id) AND page_namespace IN ('0','6','10','828','14') GROUP BY fp_pending_since,fp_page_id ORDER BY fp_pending_since,fp_page_id LIMIT 51 ", "normalized_message": "{fname}\t{db_server}\t{errno}\t{error}\t{sql1line}", "url": "/wiki/Spezial:Seiten_mit_problematischen_Versionen", "tags": [ "syslog", "es", "es" ], "reqId": "W7JYUgrAID8AACQkPaIAAAAW", "referrer": "https://<external site>'", "@timestamp": "2018-10-01T17:24:34.000Z", "db_name": "dewiki", "db_user": "wikiuser" }, "fields": { "@timestamp": [ 1538414674000 ] }, "sort": [ 1538414674000 ] }
Not the same than T176232.
CC @Marostegui @Ladsgroup Any ongoing schema change related to change tag? CC T185355