[02:15:34] 10DBA, 10Parsoid, 10Parsoid-Tests: testreduce_vd database in m5 still in use? - https://phabricator.wikimedia.org/T245408 (10ssastry) >>! In T245408#5994037, @Marostegui wrote: > ... > The `testreduce` database isn't included on those, do you want me to include it too? Thanks for initializing this db! Yes,... [06:17:07] 10DBA, 10Parsoid, 10Parsoid-Tests: testreduce_vd database in m5 still in use? - https://phabricator.wikimedia.org/T245408 (10Marostegui) >>! In T245408#6004004, @ssastry wrote: >>>! In T245408#5994037, @Marostegui wrote: >> ... >> The `testreduce` database isn't included on those, do you want me to include... [06:18:11] 10DBA, 10Gerrit: Investigate Gerrit troubles to reach the MariaDB database - https://phabricator.wikimedia.org/T247591 (10Marostegui) @hashar any more issues with this? [07:52:48] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) [09:44:40] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) To make things even more interesting with the drift between `tinyblob` and `varbinary` we have seen that 10.4 now (from 10.2 onwards https://mariadb.com/kb/en/blo... [09:45:39] 10DBA: Install 1 buster+10.4 host per section - https://phabricator.wikimedia.org/T246604 (10Marostegui) [09:45:48] 10DBA, 10Patch-For-Review: wmfmariadbpy/CuminExecution must capture Exception cumin.transports.WorkerError - https://phabricator.wikimedia.org/T218189 (10jcrespo) 05Open→03Resolved This is fixed, thanks @Guozr.im . I will now create a different ticket for the other issue with the return error handling. [09:45:49] 10DBA, 10Goal: Implement database binary backups into the production infrastructure - https://phabricator.wikimedia.org/T206203 (10jcrespo) [09:52:26] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10jcrespo) [09:59:37] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10jcrespo) [09:59:50] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10jcrespo) p:05Triage→03Medium [10:02:41] 10DBA, 10Gerrit: Investigate Gerrit troubles to reach the MariaDB database - https://phabricator.wikimedia.org/T247591 (10hashar) 05Stalled→03Resolved That mysteriously stopped even before the m2-master database got upgraded and hasn't occurred since. I guess that rules out the database. Maybe there is wa... [10:03:27] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) s5 hosts "fixed" ` db1096:3315 *************************** 1. row *************************** @@version: 10.4.12-MariaDB-log *************************** 1. row **... [10:04:04] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10jcrespo) [10:19:13] 10DBA, 10Wikidata, 10Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), 10cloud-services-team (Kanban): Move wb_terms data in cloud replicas to wb_terms_no_longer_updated - https://phabricator.wikimedia.org/T248592 (10Addshore) [10:19:41] 10DBA, 10Wikidata, 10User-Addshore, 10Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), 10cloud-services-team (Kanban): Move wb_terms data in cloud replicas to wb_terms_no_longer_updated - https://phabricator.wikimedia.org/T248592 (10Addshore) a:03Addshore [10:29:41] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) db2125 from s2 "fixed" on all its wikis [10:29:51] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) [11:21:19] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) s2 eqiad progress [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [x] dbstore1004 [] db1140 [] db1129 [] db1125 [] db1122 [] db1105 [] db1103 [] db1090 [... [12:04:33] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) [13:03:17] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10L0st3xpl0r3r) @jcrespo I cloned the repo to my local system. I tried to follow the README, transfer.py's wiki page, and other places to make it work but I couldn't follow through properly. It feels like a simple f... [13:43:24] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10L0st3xpl0r3r) a:03L0st3xpl0r3r [13:58:59] 10DBA: Fix return code handling on transfer.py error - https://phabricator.wikimedia.org/T248661 (10L0st3xpl0r3r) @jcrespo Refer to transfer.py for the following. I think I have got the fix. When sanity check fails, the `run` function returns a `-1` instead of a list. And then the `main` function ends up execu... [14:07:30] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Anomie) Good to learn that `tinyblob NOT NULL DEFAULT ''` works correctly on 10.4, so in the future once everything is on 10.4 we can do that instead of having to do the more... [15:16:56] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10jcrespo) Note that in terms of mediawiki in general (not WMF-specific)- MySQL hasn't adapted the default for blobs of any kind, so mw tables outside of WMF will still have to...