Page MenuHomePhabricator
Create Task
Maniphest T161510

Run pt-table-checksum on es2
Closed, InvalidPublic
Actions

Description

There have been several crashes in the es2 servers for codfw and we are not 100% sure about its state, so we discussed about running pt-table-checksum
I have run pt-table-checksum on es2 chain for a few small wikis with no issues. Going to run it for the 200 smallest wikis now.

Related Objects

Event Timeline

• Marostegui created this task.Mar 27 2017, 12:46 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 27 2017, 12:46 PM
Stashbot subscribed.Mar 27 2017, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2017-03-27T12:47:01Z] <marostegui> Run pt-table-checksum for a couple of hundred small wikis in es2 - T161510

• Marostegui moved this task from Triage to In progress on the DBA board.Mar 27 2017, 12:47 PM
• Marostegui added a comment.Mar 27 2017, 4:59 PM

The first 700 wikis have been checksummed with no differences so far.

Stashbot added a comment.Mar 28 2017, 5:52 AM

Mentioned in SAL (#wikimedia-operations) [2017-03-28T05:52:07Z] <marostegui> Run pt-table-checksum on es2 - T161510

• Marostegui closed this task as Invalid.Mar 28 2017, 9:17 AM

Jaime had a revelation and realised that it is running ROW based replication and the check isn't doing anything but copying the master values, so there will never be any differences.

• Marostegui mentioned this in T162133: Replace some masters in eqiad while it is not active .Apr 5 2017, 8:48 AM
• Marostegui mentioned this in T200061: Recent duplicate entries on change_tag on sanitarium hosts.Jul 20 2018, 7:29 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL