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
