[05:05:55] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s1 - https://phabricator.wikimedia.org/T166204#3459262 (10Marostegui) db1051 is done: ``` root@neodymium:/home/marostegui# for i in `cat s1_tables`; do echo $i; mysql --skip-ssl -hdb1051 enwik... [05:06:07] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s1 - https://phabricator.wikimedia.org/T166204#3459263 (10Marostegui) [06:53:36] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s1 - https://phabricator.wikimedia.org/T166204#3459320 (10Marostegui) labsdb1003 is done: ``` [root@labsdb1003 06:53 /home/marostegui] # for i in `cat s1_tables`; do echo $i; mysql --skip-ssl... [06:53:47] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s1 - https://phabricator.wikimedia.org/T166204#3459321 (10Marostegui) [07:26:42] 10DBA, 10Cloud-Services, 10Toolforge: labsdb1001 and labsdb1003 short on available space - https://phabricator.wikimedia.org/T132431#3459377 (10Marostegui) [07:26:45] 10DBA, 10Cloud-Services, 10Toolforge: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#3459374 (10Marostegui) 05Open>03Resolved a:03kaldari Thanks @kaldari, this went down to 35G ``` # du -sh /srv/sqldata/p50380g50816__pop_stats/ 35G /... [08:12:27] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3459473 (10Marostegui) MariaDB backported this to 10.0: ``` Sergei Golubchik closed MDEV-13175. ----------------------------------- Fix Version/s: 10.0.3... [08:18:58] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3459476 (10jcrespo) "Given that there are two GA versions above 10.0, I don't think it makes sense to backport such a change." Maybe instead of upgrading to... [08:20:55] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3459478 (10Marostegui) Yeah, that answer from MariaDB was a bit unbelievable...I am happy that they thought about it twice after I replied. [08:28:59] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3459495 (10jcrespo) We should upgrade some s4 replicas, test that the fix works on 10.0.32, and schedule some read-only time for commons- a reboot+upgrade sh... [08:44:58] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3459526 (10Marostegui) >>! In T168661#3459495, @jcrespo wrote: > We should upgrade some s4 replicas, test that the fix works on 10.0.32, and schedule some re... [10:01:00] 10DBA: duplicate key problems - https://phabricator.wikimedia.org/T151029#3459739 (10jcrespo) mysqldump && TRUNCATE TABLE $table; ALTER TABLE $table ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 && reimport seems to be doing the trick- no errors on reimport. [15:24:20] 10DBA, 10RESTBase-API, 10Reading List Service, 10ArchCom-RfC (ArchCom-Approved), and 4 others: RfC: Reading List service - https://phabricator.wikimedia.org/T164990#3460750 (10Anomie) >>! In T164990#3458249, @Tgr wrote: > This is for syncing data that has changed between multiple devices. So it will be mor... [15:24:36] 10DBA: duplicate key problems - https://phabricator.wikimedia.org/T151029#3460752 (10jcrespo) 05Open>03Resolved This might happen again on other hosts- we should report further issues here. The above procedure seems to work. This is probably related to some internal format that is incompatible with some file... [15:24:46] 10Blocked-on-schema-change, 10DBA, 10Wikimedia-Site-requests, 10Wikisource, and 4 others: Schema change for page content language - https://phabricator.wikimedia.org/T69223#3460754 (10jcrespo) [16:17:29] 10DBA, 10Operations: Evaluate how hard would be to get aa(wikibooks|wiktionary) and howiki databases deleted - https://phabricator.wikimedia.org/T169928#3460902 (10MarcoAurelio) Maybe it's just me, but when it comes that a project is dead, absolutely dead, with no content and no chances of revival I feel delet... [16:21:29] 10DBA: Finish dbstore2002 migration to multi-instance - https://phabricator.wikimedia.org/T171321#3460914 (10jcrespo) [16:21:58] 10DBA: Finish dbstore2002 migration to multi-instance - https://phabricator.wikimedia.org/T171321#3460930 (10jcrespo) [17:40:38] 10DBA, 10Cloud-Services, 10Toolforge: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#3461351 (10Niharika) I don't think we need to keep those 35G worth of data anymore even. The bot is gone forever and that data is pretty outdated. I can't... [19:37:23] 10DBA, 10Cloud-Services, 10Toolforge: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#3461652 (10Marostegui) If you guys think it can be dropped...go ahead! :-)