Ladsgroup added a comment.
I sampled and went through errors caused by the new term store. Here's the summary of one hour I sampled: - We had 69 cases of lock time exceeding. Here's an example: https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4StabwP44edBvOOGZy&_g=h@44136fa - We had 46 cases of readQuery exceeding limit of 5 seconds during the write. Here's an example: https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4StlMMx3rdj6D8TaM4&_g=h@44136fa - We had 38 cases of deadlock. Here's an example: https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4StoKvx3rdj6D8Ta_h&_g=h@44136fa - We had 28 cases of writeQuery exceeding one second limit. Here's an example: https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4Stwg6P44edBvOON4M&_g=h@44136fa - We had 12 cases of query returning unbelievable large number of rows. In this example, 8,806,667 rows: https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4SxtTxghP2xm4vXKSL&_g=h@44136fa - We had 7 cases of T236466 <https://phabricator.wikimedia.org/T236466> - We had 2 cases of duplicate row insertion error. Here's an example: https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4Stab7x3rdj6D8TWm1&_g=h@44136fa - We had 2 cases of mwmaint1002 complaining about the load. I will find an example - We had one case of "suboptimal query": https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-mediawiki-2019.10.28/mediawiki?id=AW4S6cGnx3rdj6D8W7B1&_g=h@44136fa TASK DETAIL https://phabricator.wikimedia.org/T234948 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: #dba, Liuxinyu970226, hashar, LarsWirzenius, Lydia_Pintscher, alaa_wmde, Jdforrester-WMF, WMDE-leszek, Marostegui, Ladsgroup, Aklapper, jcrespo, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, Gq86, Pablo-WMDE, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Jonas, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs