[06:26:00] 10DBA, 10Operations, 10Patch-For-Review, 10Wiki-Setup (Create): Create elections committee private wiki - https://phabricator.wikimedia.org/T174370#3561141 (10Marostegui) [06:26:03] 10DBA, 10Cloud-Services: Prepare and check storage layer for electcomwiki - https://phabricator.wikimedia.org/T174385#3561138 (10Marostegui) 05Open>03Resolved a:03Marostegui I have merged Reedy's patch (https://gerrit.wikimedia.org/r/374384) and restarted MySQL on both sanitarium db1095 and db1102 and th... [07:16:21] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3561197 (10Marostegui) >>! In T168661#3561196, @Stashbot wrote: > {nav icon=file, name=Mentioned in SAL (#wikimedia-operations), href=https://tools.wmflabs.o... [08:25:31] 10DBA, 10Analytics-Kanban, 10Patch-For-Review: Inconsistent default charset for analytics slaves - https://phabricator.wikimedia.org/T170952#3561268 (10elukey) ``` MariaDB [(none)]> show create database log; +----------+----------------------------------------------------------------+ | Database | Create Dat... [09:39:55] 10DBA, 10Analytics-Kanban, 10Patch-For-Review: Inconsistent default charset for analytics slaves - https://phabricator.wikimedia.org/T170952#3561391 (10jcrespo) Are you sure you want uft8 and not utf8mb4? You may be losing extended area characters (e.g. emojis). [09:41:23] 10DBA, 10Analytics-Kanban, 10Patch-For-Review: Inconsistent default charset for analytics slaves - https://phabricator.wikimedia.org/T170952#3561394 (10Marostegui) >>! In T170952#3561391, @jcrespo wrote: > Are you sure you want uft8 and not utf8mb4? You may be losing extended area characters (e.g. emojis).... [09:49:06] 10DBA, 10Analytics-Kanban, 10Patch-For-Review: Inconsistent default charset for analytics slaves - https://phabricator.wikimedia.org/T170952#3561399 (10elukey) Yep I made it equal to db1047, but I am open to suggestions :) [11:30:02] 10DBA, 10Operations, 10ops-eqiad: Decommission db1033 and db1028 - https://phabricator.wikimedia.org/T174076#3561656 (10jcrespo) [11:48:19] 10DBA, 10Operations, 10Scoring-platform-team, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3561691 (10Marostegui) How do you guys want to proceed with this in the end? Is it worth the risk? [15:03:24] 10DBA, 10Operations, 10ops-eqiad: BBU issues on db1055, RAID cache on WriteThrough - https://phabricator.wikimedia.org/T174265#3562203 (10Marostegui) The BBU has been replaced and looks good: ``` root@db1055:/home/marostegui# megacli -AdpBbuCmd -a0 BBU status for Adapter: 0 BatteryType: BBU Voltage: 3918... [15:30:17] 10DBA, 10Analytics-Kanban, 10Patch-For-Review: Inconsistent default charset for analytics slaves - https://phabricator.wikimedia.org/T170952#3448710 (10Ottomata) Hm, for now I think this is good, so that the slave matches the master. If we want everything to be a different charset, we should change it as a... [16:12:40] 10DBA, 10Operations, 10Scoring-platform-team, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3562459 (10chasemp) a:03madhuvishy [16:35:02] 10DBA, 10Operations, 10Scoring-platform-team, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3562523 (10madhuvishy) @Marostegui We talked about this today in our meeting, and think that since we don't have significant user traffic moved over from 1001... [16:38:10] 10DBA, 10Operations, 10Scoring-platform-team, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3562543 (10bd808) I vote we close this as "resolved" with a note that 1001/3 have not been rebooted because of the fear of catastrophic hardware failure and t... [16:54:13] 10DBA, 10Operations, 10Scoring-platform-team, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3562639 (10Marostegui) >>! In T168584#3562523, @madhuvishy wrote: > @Marostegui We talked about this today in our meeting, and think that since we don't have... [17:29:32] 10DBA, 10Operations, 10Scoring-platform-team, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3562860 (10madhuvishy) 05Open>03Resolved 1001/3 have not been rebooted because of the fear of catastrophic hardware failure and their impending decomm. [17:47:28] 10DBA, 10MediaWiki-Database: Give user_properties a primary key - https://phabricator.wikimedia.org/T146570#3562984 (10Reedy) [17:47:32] 10DBA, 10MediaWiki-Database, 10MW-1.30-release-notes (WMF-deploy-2017-05-09_(1.30.0-wmf.1)), 10Patch-For-Review, and 2 others: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3562985 (10Reedy) [17:47:56] 10DBA, 10MediaWiki-Database: Give user_properties a primary key - https://phabricator.wikimedia.org/T146570#2665149 (10Reedy) 05Open>03Resolved a:03Reedy [17:48:01] 10DBA, 10MediaWiki-Database, 10MW-1.30-release-notes (WMF-deploy-2017-05-09_(1.30.0-wmf.1)), 10Patch-For-Review, and 2 others: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3133031 (10Reedy) [17:50:19] 10DBA, 10MediaWiki-Database, 10MW-1.30-release-notes (WMF-deploy-2017-05-09_(1.30.0-wmf.1)), 10Patch-For-Review, and 2 others: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3563010 (10Reedy) So... After 1.30.0-wmf.16 is everywhere, ou... [21:26:22] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564135 (10Reedy) [21:26:33] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3136240 (10Reedy) [21:31:54] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564159 (10Reedy) [21:36:32] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564183 (10Reedy) hitcounter removed from core. externalinks now has `el_id int unsigned NOT NULL PRIMARY... [21:39:52] 10Blocked-on-schema-change, 10DBA: Drop now redundant indexes from pagelinks and templatelinks - https://phabricator.wikimedia.org/T174509#3564203 (10jcrespo) [21:40:48] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564219 (10jcrespo) Thank you very much @Reedy , I will create a separate task for deployment tracking- so... [21:44:06] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564227 (10Reedy) >>! In T17441#3564219, @jcrespo wrote: > @Reedy I understand that T162774 should be reso... [21:45:03] 10Blocked-on-schema-change, 10DBA, 10MW-1.28-release (WMF-deploy-2016-08-30_(1.28.0-wmf.17)), 10MW-1.28-release-notes, 10Patch-For-Review: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#3564234 (10Reedy) [21:45:07] 10DBA, 10MediaWiki-API, 10Patch-For-Review: FORCE INDEX on ApiQueryLinks on templatelinks and pagelinks - https://phabricator.wikimedia.org/T162774#3564230 (10Reedy) 05Open>03Resolved Tentatively closing this task as T172514 is now resolved https://github.com/wikimedia/mediawiki/commit/0f13fff1604778397... [21:46:33] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564257 (10Reedy) [21:50:31] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564294 (10jcrespo) > I suspect archive and oldimage should be left alone due to the other major db overha... [21:51:23] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564296 (10Reedy) [21:58:20] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564302 (10Reedy) Image does have img_name oldimage also has oi_name, but in this case, it's not unique,... [22:12:25] 10DBA, 10MediaWiki-Database, 10Patch-For-Review, 10PostgreSQL, 10Schema-change: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441#3564346 (10jcrespo) Oh, sorry, I confused image and oldimage, of course, silly me. [22:16:08] 10DBA, 10Wikimedia-Site-requests, 10Tracking: Database table cleanup (tracking) - https://phabricator.wikimedia.org/T18660#3564351 (10Reedy) [23:03:02] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#3564464 (10demon) [23:04:08] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#2775619 (10demon) [23:04:54] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#2776450 (10demon) [23:05:58] 10DBA, 10Analytics: Drop MoodBar tables from all wikis - https://phabricator.wikimedia.org/T153033#3564480 (10demon) Been about a month and a half. Bump?