[05:51:11] 10DBA, 10Data-Services, 10Quarry: Quarry: Lost connection to MySQL server during query - https://phabricator.wikimedia.org/T246970 (10Marostegui) labsdb1011 has been running a big alter table in the last few hours, so that's why it has been lagging s4 a bit - s4 is commons but it of course affects the whole... [06:11:04] 10DBA: Reimage labsdb1011 to Buster and 10.4 - https://phabricator.wikimedia.org/T249188 (10Marostegui) [06:11:37] 10DBA: Reimage labsdb1011 to Buster and 10.4 - https://phabricator.wikimedia.org/T249188 (10Marostegui) p:05Triage→03Medium [07:59:09] 10DBA: Create WikibaseQualityConstraints table on commons - https://phabricator.wikimedia.org/T248967 (10Marostegui) @Cparle I see that the table now exists on commons but not on `testcommonswiki`. Is this expected? Further, is there anything else expected to be done with this table or can I go ahead and compre... [09:49:03] 10DBA: Decommission dbproxy1010.eqiad.wmnet - https://phabricator.wikimedia.org/T248944 (10Marostegui) [09:49:29] 10DBA: Remove grants for the old dbproxy hosts from the misc databases - https://phabricator.wikimedia.org/T231280 (10Marostegui) [09:56:52] 10DBA: Create WikibaseQualityConstraints table on commons - https://phabricator.wikimedia.org/T248967 (10Cparle) Oh! No, I just never even thought to add it to `testcommonswiki`. I can do it in today's European mid-day swat and ping you afterwards [09:57:55] 10DBA: Create WikibaseQualityConstraints table on commons - https://phabricator.wikimedia.org/T248967 (10Marostegui) Cool, that sounds good. Let me know once it is done and I can compress both and close this task Thank you! [10:00:59] 10DBA: Remove grants for the old dbproxy hosts from the misc databases - https://phabricator.wikimedia.org/T231280 (10Marostegui) ` root@cumin1001:~# host dbproxy1010 dbproxy1010.eqiad.wmnet has address 10.64.37.14 root@cumin1001:~# for i in labsdb1009 labsdb1010 labsdb1011 labsdb1012; do mysql.py -h$i -e "show... [10:01:18] 10DBA: Remove grants for the old dbproxy hosts from the misc databases - https://phabricator.wikimedia.org/T231280 (10Marostegui) [10:01:47] 10DBA: Decommission dbproxy1010.eqiad.wmnet - https://phabricator.wikimedia.org/T248944 (10Marostegui) Dropped haproxy user: ` root@cumin1001:~# host dbproxy1010 dbproxy1010.eqiad.wmnet has address 10.64.37.14 root@cumin1001:~# for i in labsdb1009 labsdb1010 labsdb1011 labsdb1012; do mysql.py -h$i -e "show grant... [11:03:08] 10DBA: Create WikibaseQualityConstraints table on commons - https://phabricator.wikimedia.org/T248967 (10Cparle) @Marostegui done! [11:24:42] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10jcrespo) [11:25:20] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10jcrespo) [11:25:22] 10DBA: Reimage labsdb1011 to Buster and 10.4 - https://phabricator.wikimedia.org/T249188 (10jcrespo) [11:26:44] 10DBA, 10MediaWiki-General, 10Operations: Evaluate and decide the future of relational datastore at WMF after the upgrade of MariaDB 10.1 is finished - https://phabricator.wikimedia.org/T193224 (10jcrespo) [11:26:46] 10DBA: Reimage labsdb1011 to Buster and 10.4 - https://phabricator.wikimedia.org/T249188 (10jcrespo) [11:27:24] ^I've done this link, will leave to you closing the parent and open a new one if you prefer- I think that still qualifies as "testing" [13:19:34] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10jcrespo) One last thing, on the package, the patch is ok, but the file on /bin seems not touched. Not sure if that shouldn't be there at all or yes, but upda... [13:24:28] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10Marostegui) Not sure what you mean: ` root@db1077:/home/marostegui# head /usr/bin/wmf-pt-kill #!/usr/bin/env perl ### wmf-pt-kill ### # Patched version of w... [13:28:46] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10jcrespo) > The file on ~/wmf-pt-kill_3.1.0.orig/bin/ is the original non patched one. Yes, that is to be expected. But see: https://github.com/wikimedia/op... [13:30:35] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10Marostegui) Ah! You meant the old ones! Right, yeah. I will fix that [13:31:29] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10jcrespo) master/bin/wmf-pt-kill should either not exist (because it is decompressed and patched), or if it exists, be the new (3.1) file+patch. I think it i... [13:39:09] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10Marostegui) The actual package is created correctly. It is just a repo issue. I will update the original wmf-pt-kill to the 3.1 (that is, the non patched v... [13:52:01] 10DBA: Create WikibaseQualityConstraints table on commons - https://phabricator.wikimedia.org/T248967 (10Marostegui) 05Open→03Resolved a:03Cparle Tables compressed! ` root@cumin1001:/home/marostegui# for i in testcommonswiki commonswiki; do mysql.py -hdb1138 $i -e "show create table wbqc_constraints\G" > d... [14:50:10] 10DBA: Reimage labsdb1011 to Buster and 10.4 - https://phabricator.wikimedia.org/T249188 (10Marostegui) [14:50:14] 10DBA, 10Data-Services, 10Packaging, 10Patch-For-Review: Upgrade wmf-pt-kill package for Debian Buster - https://phabricator.wikimedia.org/T248843 (10Marostegui) 05Open→03Resolved a:03Marostegui This is all done - the package has been uploaded to the repo. [14:51:15] yay