Page MenuHomePhabricator

text table in db1144 drifts from core considerably
Closed, ResolvedPublic

Description

It seems T250066: text table still has old_* fields and indexes on some hosts is not applied to db1144. The automatic report says:

{
    "text inverse_timestamp field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_comment field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_minor_edit field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_namespace field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_timestamp field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_title field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_user field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    },
	    "text old_user_text field-mismatch-prod-extra": {
	        "s5": [
	            "db1144.eqiad.wmnet"
	        ]
	    }
}

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMon, Jun 29, 7:21 PM

Mentioned in SAL (#wikimedia-operations) [2020-06-29T19:43:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1144:3315 T256679', diff saved to https://phabricator.wikimedia.org/P11698 and previous config saved to /var/cache/conftool/dbconfig/20200629-194327-marostegui.json

Marostegui moved this task from Triage to In progress on the DBA board.

Thanks for reporting this - looks like this host slipped through the cracks with all the host moves we are doing lately. I have started the alter now there. Should be done by tomorrow.

It was faster than expected as dewiki was ok and the other wikis are very small:

# for i in `cat /home/marostegui/git/mediawiki-config/dblists/s5.dblist | grep -v "#" `; do echo $i; mysql.py -hdb1144:3315 $i -e "show create table text\G" | grep -i inverse ; done
cebwiki
dewiki
enwikivoyage
mgwiktionary
shwiki
srwiki

Mentioned in SAL (#wikimedia-operations) [2020-06-29T20:00:02Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repool db1144:3315 T256679', diff saved to https://phabricator.wikimedia.org/P11699 and previous config saved to /var/cache/conftool/dbconfig/20200629-200002-marostegui.json

Marostegui closed this task as Resolved.Mon, Jun 29, 8:00 PM

Can it be that it's still missing on some databases in s3 and we haven't caught it because it's 900 wikis? It would be great if you do a quick double check when you have time.

db1144 is in s5 (or that is what the report says) I checked all its wikis in s5 and they are now fixed.

Yeah I know but since dewiki was okay but wikis like cebwiki were not and they used to be in s3, that's why I'm saying :D