[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

Ladsgroup added a comment. In T151789#5900458 , @Addshore wrote: > This will likely end up being helped greatly by T244115: Investigate & Fix holes for aliases in new term tables (take 3) , the

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

Krinkle added a comment. Seen 3,500 times (evenly spread out throughout the month). Logstash: https://logstash.wikimedia.org/goto/f12480d76fe5fa011e52110a94927d3e. @Ladsgroup I don't know if is the same issue or not. It does have the same stack trace from DataUpdateAdapter::doUpdate

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

Addshore added a comment. Very occasionally happening in June still: addshore@mwlog1001:/srv/mw-log$ zgrep -c 'TermSqlIndex::deleteTerms' archive/exception.log-201906* archive/exception.log-20190601.gz:0 archive/exception.log-20190602.gz:1 archive/exception.log-20190603.gz:0

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

Addshore added a comment. Feb 2019, still happening occasionally: addshore@mwlog1001:/srv/mw-log$ zgrep -c 'TermSqlIndex::deleteTerms' archive/exception.log-201902* archive/exception.log-20190201.gz:0 archive/exception.log-20190202.gz:0 archive/exception.log-20190203.gz:6

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

hoo added a comment. Still happening (very occasionally): $ zgrep -c 'TermSqlIndex::deleteTerms' archive/exception.log-201901* archive/exception.log-20190101.gz:0 archive/exception.log-20190102.gz:0 archive/exception.log-20190103.gz:2 archive/exception.log-20190104.gz:0 archive/exception.log-20190

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

Addshore added a comment. Has this stopped? Or has it moved? @hoo ? addshore@mwlog1001:/srv/mw-log$ zgrep -cP 'TermSqlIndex::deleteTerms.*Deadlock' archive/hhvm.log-201901* archive/hhvm.log-20190101.gz:0 archive/hhvm.log-20190102.gz:0 archive/hhvm.log-20190103.gz:0 archive/hhvm.log-20190104.gz:0

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

Krinkle added a comment. (Still seen on 1.33-wmf.8)TASK DETAILhttps://phabricator.wikimedia.org/T151789EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: KrinkleCc: Krinkle, Aklapper, hoo, Dinadineke, Nandana, tabish.shaikh91, Lahi, Gq86, GoranSMilovanovic, Soter

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

hoo added a comment. Still seeing this, but the numbers don't seem very bad: $ zgrep -c TermSqlIndex::deleteTerms archive/DBQuery.log-201710* archive/DBQuery.log-20171001.gz:1 archive/DBQuery.log-20171002.gz:6 archive/DBQuery.log-20171003.gz:1 archive/DBQuery.log-20171004.gz:1 archive/DBQuery.log-

[Wikidata-bugs] [Maniphest] [Commented On] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

hoo added a comment. Probably the same thing, still happening fairly often: $ zgrep -c TermSqlIndex::deleteTerms archive/DBQuery.log-201702* archive/DBQuery.log-20170201.gz:11 archive/DBQuery.log-20170202.gz:0 archive/DBQuery.log-20170203.gz:6 archive/DBQuery.log-20170204.gz:5 archive/DBQuery.log-