[04:30:25] 10DBA, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310164 (10MoheenReeyad) [04:31:06] 10DBA, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310155 (10MoheenReeyad) a:03RuyP [04:33:43] 10DBA, 10GlobalRename, 10MediaWiki-extensions-CentralAuth, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310169 (10Wong128hk) [04:44:11] 10DBA, 10GlobalRename, 10MediaWiki-extensions-CentralAuth, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310155 (10Wong128hk) The rename has completed... 12:04 (Global rename log) . . Moheen Reeyad (talk | contrib... [05:24:14] 10DBA, 10XTools, 10User-Matthewrbowker: Admin Score choosing Wikidata returns with fatal error - https://phabricator.wikimedia.org/T197165#4310182 (10Matthewrbowker) p:05Low>03Normal [05:25:06] 10DBA, 10GlobalRename, 10MediaWiki-extensions-CentralAuth, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310155 (10alanajjar) As appear [[https://meta.wikimedia.org/wiki/Special:GlobalRenameProgress?username=%E0%A6%... [05:25:13] 10DBA, 10GlobalRename, 10MediaWiki-extensions-CentralAuth, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310187 (10alanajjar) a:05RuyP>03None [05:25:29] 10DBA, 10GlobalRename, 10MediaWiki-extensions-CentralAuth, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310155 (10alanajjar) 05Open>03Resolved [05:26:20] 10DBA, 10Wikimedia-Site-requests: Global rename of Aftabuzzaman → আফতাবুজ্জামান: supervision needed - https://phabricator.wikimedia.org/T198047#4310155 (10alanajjar) [05:38:45] 10DBA, 10Schema-change: Schema change to drop default from externallinks.el_index_60 - https://phabricator.wikimedia.org/T197891#4310198 (10Marostegui) p:05Triage>03Normal [08:08:01] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automatize the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#1419799 (10Ladsgroup) I... [08:15:52] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automatize the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#4310502 (10jcrespo) Can... [08:36:54] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automatize the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#4310554 (10Ladsgroup) Ra... [08:49:24] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automatize the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#1496870 (10Marostegui) K... [09:50:40] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automatize the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#4310785 (10Ladsgroup) >>... [11:56:15] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automate the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#4311316 (10mark) [13:02:07] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Make several mediawiki table fields unsigned ints on wmf databases - https://phabricator.wikimedia.org/T89737#4311612 (10Marostegui) [13:02:16] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10MediaWiki-Database, 10Patch-For-Review, 10Wikidata-Ministry-Of-Magic: Schema change for ct_tag_id field to change_tag - https://phabricator.wikimedia.org/T195193#4311615 (10Marostegui) [13:02:23] 10DBA, 10Multi-Content-Revisions, 10Patch-For-Review, 10Schema-change: Schema change to drop archive.ar_text and archive.ar_flags - https://phabricator.wikimedia.org/T192926#4311620 (10Marostegui) [13:02:29] 10DBA, 10MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018), 10Patch-For-Review, 10Schema-change: Schema change to make archive.ar_rev_id NOT NULL - https://phabricator.wikimedia.org/T191316#4311623 (10Marostegui) [13:31:35] 10DBA, 10Wikidata, 10Wikidata-Campsite: Rename tmp1 index on wb_terms databases to something more meaningful. - https://phabricator.wikimedia.org/T197854#4311753 (10Marostegui) p:05Triage>03Normal This index caused an outage, meaning it is being used. If it is being used, we should make sure it is added... [13:32:52] 10DBA, 10Wikidata-Campsite, 10User-Ladsgroup: Script to compare schema and indexes between codebase and production - https://phabricator.wikimedia.org/T197844#4304419 (10Marostegui) Let's follow up on T104459 [13:33:32] 10DBA, 10Wikidata-Campsite, 10User-Ladsgroup: Script to compare schema and indexes between codebase and production - https://phabricator.wikimedia.org/T197844#4311782 (10Marostegui) [13:33:40] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Release-Engineering-Team (Watching / External), and 2 others: Automate the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459#1548414 (10Marostegui) [14:52:41] 10DBA, 10MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018), 10Patch-For-Review, 10Schema-change: Schema change to make archive.ar_rev_id NOT NULL - https://phabricator.wikimedia.org/T191316#4312195 (10Marostegui) [14:52:46] 10DBA, 10Multi-Content-Revisions, 10Patch-For-Review, 10Schema-change: Schema change to drop archive.ar_text and archive.ar_flags - https://phabricator.wikimedia.org/T192926#4312198 (10Marostegui) [14:52:52] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10MediaWiki-Database, 10Patch-For-Review, 10Wikidata-Ministry-Of-Magic: Schema change for ct_tag_id field to change_tag - https://phabricator.wikimedia.org/T195193#4312199 (10Marostegui) [14:52:56] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Make several mediawiki table fields unsigned ints on wmf databases - https://phabricator.wikimedia.org/T89737#4312200 (10Marostegui) [14:54:38] 10DBA, 10MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018), 10Patch-For-Review, 10Schema-change: Schema change to make archive.ar_rev_id NOT NULL - https://phabricator.wikimedia.org/T191316#4312206 (10Marostegui) s2 eqiad progress [] labsdb1009 [] labsdb1010 [] labsdb1011 [] db1102 [] db1125 [] dbstore1002 [... [14:54:40] 10DBA, 10Multi-Content-Revisions, 10Patch-For-Review, 10Schema-change: Schema change to drop archive.ar_text and archive.ar_flags - https://phabricator.wikimedia.org/T192926#4256234 (10Marostegui) s2 eqiad progress [] labsdb1009 [] labsdb1010 [] labsdb1011 [] db1102 [] db1125 [] dbstore1002 [] db1074 [] d... [14:54:45] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10MediaWiki-Database, 10Patch-For-Review, 10Wikidata-Ministry-Of-Magic: Schema change for ct_tag_id field to change_tag - https://phabricator.wikimedia.org/T195193#4252798 (10Marostegui) s2 eqiad progress [] labsdb1009 [] labsdb1010 [] labsdb1011 [... [14:54:47] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Make several mediawiki table fields unsigned ints on wmf databases - https://phabricator.wikimedia.org/T89737#4252617 (10Marostegui) s2 eqiad progress [] labsdb1009 [] labsdb1010 [] labsdb1011 [] db1102 [] db1125 [] dbstore1002 [] db1074 [] db1076 [] db... [14:55:05] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Make several mediawiki table fields unsigned ints on wmf databases - https://phabricator.wikimedia.org/T89737#4312215 (10Marostegui) [14:55:24] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10MediaWiki-Database, 10Patch-For-Review, 10Wikidata-Ministry-Of-Magic: Schema change for ct_tag_id field to change_tag - https://phabricator.wikimedia.org/T195193#4312216 (10Marostegui) [14:55:45] 10DBA, 10Multi-Content-Revisions, 10Patch-For-Review, 10Schema-change: Schema change to drop archive.ar_text and archive.ar_flags - https://phabricator.wikimedia.org/T192926#4312221 (10Marostegui) [14:56:03] 10DBA, 10MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018), 10Patch-For-Review, 10Schema-change: Schema change to make archive.ar_rev_id NOT NULL - https://phabricator.wikimedia.org/T191316#4312222 (10Marostegui) [19:53:35] 10DBA, 10MediaWiki-Database, 10MediaWiki-Platform-Team, 10Performance-Team (Radar), 10Wikimedia-Incident: Change pt-heartbeat model to not use super-user, avoid SPOF and switch automatically to the real master without puppet dependency - https://phabricator.wikimedia.org/T172497#4313171 (10Imarlier) [21:10:45] Hi everyone! I'm working on an AbuseFilter patch and I'm having a doubt for which I've been told I could find an answer here :-) First, DB schema for context: https://phabricator.wikimedia.org/diffusion/EABF/browse/master/abusefilter.tables.sql What I need to do is insert a new row on abuse_filter table with af_id = 0. This should be done both after table creation (for installer) and on DB update. The problem is that inserting 0 [21:10:46] on an auto incremented field triggers the auto_increment like NULL would. To overcome the problem I use 'SET SESSION SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";' right before the INSERT. Now, my question is: is it fine to leave the setting there in place, or should it be reverted after insertion? Actually, is there a way to remove the setting? Thanks for help! [22:41:40] I was also talking to Daimona about this. I read on StackOverflow you could do `SET SESSION SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"` and I presume the "session" would mean that particular connection? which probably would include everything else in update.php (maybe bad) [22:44:25] and if you want more context, we're exploring creating a "pseudo-filter" in AbuseFilter that runs before all other filters (since they are ran sequentially by ID), hence why we want one with an explicit ID of 0 [22:45:06] That's what I thought as well. BTW, the same problem comes out whenever we try to update such filter within PHP, and I couldn't find anything inside Database class to set such option [22:47:05] oh interesting, I guess that's a problem :/ [22:47:19] (I mean, apart from directly running the query. Also, there's the same problem of removing the options.)