Marostegui added a comment.
My guess is that as the schema change isn't made on the same transaction, the query arrives in between the drop+create and gets stuck with that huge full scan. I have depooled the hosts that are giving too many connections (as they others have the schema change already done) and see if that helps reducing the load and get the schema change done. I will change T284375 <https://phabricator.wikimedia.org/T284375> to make sure it is done on the same transaction for the next iterations. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Ladsgroup, Addshore, Aklapper, Marostegui, the0001, Invadibot, Selby, AndreCstr, maantietaja, XeroS_SkalibuR, Akuckartz, Adidsone1, WDoranWMF, holger.knust, EvanProdromou, DannyS712, Nandana, Mirahamira, Phukettaxigroup, Lahi, Gq86, Markhalsey, GoranSMilovanovic, Jayprakash12345, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, Scott_WUaS, Pchelolo, Wikidata-bugs, aude, mark, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org