[01:59:42] jynus: did wl_id ever get added everywhere? [06:50:41] AaronSchulz, that requires a delicate process [08:57:49] https://phabricator.wikimedia.org/T130067 [10:17:30] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543347 (10matthiasmullie) Here’s a list of the remaining duplicates I’ve found: * https://pt.wikibooks.org/wiki/Topic:Pumrz1mwd02pbcql (duplicate of https://pt.wiki... [10:25:50] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543367 (10jcrespo) New backup just finished: ``` -rw-r--r-- 1 root root 76M Aug 11 10:20 ptwikibooks-s3-20160811T102044.sql.gz -rw-r--r-- 1 root root 1.4... [10:34:04] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543430 (10jcrespo) I can also confirm no such records exist on any of our servers: ``` $ while read host port; do mysql -h $host -P $port officewiki -e "SELECT *... [12:05:15] 10DBA, 06Operations, 13Patch-For-Review: Decomission old coredb machines (<=db1050) - https://phabricator.wikimedia.org/T134476#2543680 (10jcrespo) [12:25:56] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543731 (10He7d3r) Feel free to remove the duplicates from my talk page. [12:29:08] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543734 (10Trizek-WMF) (Not urgent) I'm curious about how the URLs are generated: why do each pair of duplicates have the same 6 characters? [12:30:08] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543736 (10Trizek-WMF) >>! In T119509#2541151, @matthiasmullie wrote: > @Trizek-WMF/@He7d3r : I believe we've already informed ptwikibooks about this process, right?... [12:31:19] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543739 (10matthiasmullie) >>! In T119509#2543734, @Trizek-WMF wrote: > (Not urgent) I'm curious about how the URLs are generated: why do each pair of duplicates hav... [12:34:03] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543749 (10He7d3r) Hmm.. I didn't send a new message after https://pt.wikibooks.org/wiki/Topic:T75gnaqn6o4gviux [13:14:43] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543813 (10Trizek-WMF) >>! In T119509#2543749, @He7d3r wrote: > Hmm.. I didn't send a new message after https://pt.wikibooks.org/wiki/Topic:T75gnaqn6o4gviux Ok. I'v... [13:51:52] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2185157 (10matthiasmullie) [13:53:49] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2543929 (10matthiasmullie) Discovered a minor issue with the next script. Should be fixed with https://gerrit.wikimedia.org/r/304205, which I'll try to get reviewed... [14:31:54] 10DBA, 06Operations, 07Availability: Setup automatic failover for misc database servers - https://phabricator.wikimedia.org/T141547#2544070 (10akosiaris) p:05Triage>03Normal [15:07:27] 10DBA, 06Labs, 10Labs-Infrastructure: labsdb* has no automatic failover solution - https://phabricator.wikimedia.org/T141097#2544182 (10jcrespo) [15:17:52] 10DBA, 06Operations, 10ops-codfw: Decom db2001-db2009 - https://phabricator.wikimedia.org/T125827#2544212 (10jcrespo) [15:18:27] 10DBA, 06Operations, 10ops-codfw: Decom db2001-db2009 - https://phabricator.wikimedia.org/T125827#2544216 (10jcrespo) [15:21:32] 10DBA, 06Operations, 10ops-codfw: Decom db2001-db2009 - https://phabricator.wikimedia.org/T125827#2544219 (10jcrespo) @Papaul ,@Robh These servers are ready to go; icinga/puppet/salt-wiped. DNS and tftboot are still active. I set on you the decision of its final destination. [15:25:21] 10DBA, 06Operations, 10ops-codfw: Decom db2001-db2009 - https://phabricator.wikimedia.org/T125827#2544236 (10RobH) a:03mark I'm re-assigning this to @mark for his approval to decommission db2001-db2009. All 9 of these systems had their warranties expire on 2014-11-10. These are old Dell PowerEdge R510 sy... [15:25:42] 10DBA, 06Operations, 10hardware-requests, 10ops-codfw: Decom db2001-db2009 - https://phabricator.wikimedia.org/T125827#2544238 (10RobH) [15:45:13] 10DBA, 10Continuous-Integration-Config, 10Datasets-General-or-Unknown, 06Release-Engineering-Team, and 3 others: Automatize the check and fix of object, schema and data drifts between production masters and slaves - https://phabricator.wikimedia.org/T104459#2544318 (10ArielGlenn) https://github.com/apergos... [16:33:30] 10DBA: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544418 (10aaron) [16:34:02] 10DBA: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544432 (10aaron) [16:36:17] 07Blocked-on-schema-change, 10DBA: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544437 (10jcrespo) [17:39:57] 10DBA, 10Wikimedia-Site-requests, 07Tracking: Database table cleanup (tracking) - https://phabricator.wikimedia.org/T18660#2544744 (10Danny_B) [17:39:59] 07Blocked-on-schema-change, 10DBA: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544743 (10Danny_B) [18:05:28] 10DBA, 10Wikimedia-Site-requests, 07Tracking: Database table cleanup (tracking) - https://phabricator.wikimedia.org/T18660#2544855 (10jcrespo) [18:05:30] 07Blocked-on-schema-change, 10DBA: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544854 (10jcrespo) [19:08:29] 10DBA, 10MediaWiki-ResourceLoader, 06Performance-Team, 07Wikimedia-log-errors: Deadlock found when trying to get lock; try restarting transaction - https://phabricator.wikimedia.org/T117089#2545071 (10Krinkle)