[00:09:44] 10DBA, 10CirrusSearch, 10Discovery, 10Discovery-Search, and 3 others: archive table needs index starting with timestamp - https://phabricator.wikimedia.org/T164975#3480200 (10Smalyshev) Hm, I was under the impression that it's deletion timestamp. If it's creation timestamp than using it for deletes is wron... [00:32:22] 10DBA, 10CirrusSearch, 10Discovery, 10Discovery-Search, and 3 others: archive table needs index starting with timestamp - https://phabricator.wikimedia.org/T164975#3480246 (10Smalyshev) 05Open>03declined Since it looks like we're using the wrong timestamp, and don't need the index as described, I'm clo... [02:03:31] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#3480312 (10Legoktm) [02:05:24] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#2627711 (10Legoktm) >>! In T145366#3478642, @Reedy wrote: > I'm wondering what script actually needs running. I don't see a specific mai... [06:50:21] 10DBA, 10CirrusSearch, 10Discovery, 10Discovery-Search, and 3 others: archive table needs index starting with timestamp - https://phabricator.wikimedia.org/T164975#3480504 (10jcrespo) Sorry it took me more time than necessary to answer- sometimes one needs time and perspective to see "this is strange" (why... [10:16:02] 10DBA, 10MediaWiki-Parser, 10MediaWiki-Platform-Team, 10Patch-For-Review: WMF ParserCache disk space exhaustion - https://phabricator.wikimedia.org/T167784#3480838 (10jcrespo) After defragmenting (not fully finished, but most of it done), things seems a bit more stable. Purging, however, has not yet finish... [11:20:22] 10DBA: DROP OAI-related tables - https://phabricator.wikimedia.org/T139342#3480932 (10jcrespo) We have to check labsdb hosts- some views may be there pointing to updates tables or mark_as_helpful dropped tables. [12:43:19] 10DBA, 10Cloud-Services: Prepare and check storage layer for hi.wikiversity - https://phabricator.wikimedia.org/T171829#3481097 (10Urbanecm) p:05Triage>03Low [13:05:02] 10DBA, 10Wikimedia-Site-requests, 10Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3281974 (10Urbanecm) Seems we're waiting for real wiki creation. [13:51:22] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#3481268 (10Reedy) Guess `$wgBabelCentralDb` and `$wgBabelCentralApi` need setting too to meta? Guarded by CentralAuth being enabled. Bu... [14:56:59] 10DBA, 10Analytics, 10Analytics-EventLogging, 10Community-Tech, 10User-Elukey: Drop CookieBlock* tables from EventLogging DB - https://phabricator.wikimedia.org/T171883#3481417 (10elukey) [15:15:39] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown, 10Patch-For-Review: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#3481461 (10Legoktm) >>! In T145366#3481268, @Reedy wrote: > Guess `$wgBabelCentralDb` and `$wgBabelCentralApi` nee... [17:55:20] 10DBA, 10Wikidata: Populate term_full_entity_id on test.wikidata.org - https://phabricator.wikimedia.org/T171461#3482028 (10Ladsgroup) >>! In T171461#3470167, @daniel wrote: > But then, we still have to get rid of duplicates somehow. A specialized script is probably the best approach for that. The thing is th... [20:47:08] 10DBA, 10MediaWiki-Watchlist, 10Wikimedia-General-or-Unknown, 10Wikimedia-log-errors: User with 40000 entries in their Watchlist cannot access it on Commons anymore: Database error - https://phabricator.wikimedia.org/T171898#3482644 (10zhuyifei1999) [20:47:23] 10DBA, 10MediaWiki-Watchlist, 10Wikimedia-General-or-Unknown, 10Wikimedia-log-errors: User with 40000 entries in their Watchlist cannot access it on Commons anymore: Database error - https://phabricator.wikimedia.org/T171898#3479604 (10zhuyifei1999) a:05Jwh>03None [21:47:33] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata, 10Wikidata-Sprint, 10Wikimedia-log-errors: wikibase-addUsagesForPage doesn't batch properly - https://phabricator.wikimedia.org/T172015#3482899 (10Ladsgroup) [22:01:14] 10DBA, 10Wikidata: Populate term_full_entity_id on test.wikidata.org - https://phabricator.wikimedia.org/T171461#3482930 (10daniel) @Ladsgroup yey, but I think there's a middle way that is much faster than a complete rebuild, and more robust than a mega-query. I imagine an algorithm like this: Declare an e... [23:17:43] 10DBA, 10Reading-Web-Backlog: Drop WikiGrok tables from production - https://phabricator.wikimedia.org/T172020#3483109 (10MaxSem) [23:19:08] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#2564393 (10MaxSem) [23:23:24] 10DBA, 10Analytics, 10Chinese-Sites: Data Lake edit data missing for many wikis - https://phabricator.wikimedia.org/T165233#3483134 (10Neil_P._Quinn_WMF) >>! In T165233#3292656, @Nuria wrote: > Ok, so we can plan on this data being available in September, correct? Until then we will continue taking snapshots... [23:23:37] 10DBA, 10Analytics, 10Contributors-Analysis, 10Chinese-Sites: Data Lake edit data missing for many wikis - https://phabricator.wikimedia.org/T165233#3483140 (10Neil_P._Quinn_WMF)