text table in db1144 drifts from core considerably
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Jun 29 2020, 7:21 PM

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"
	        ]
	    }
}

Related Objects
Search...

View Standalone Graph

This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Status	Assigned	Task
		· · ·
Open	None	T104459 Automate the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves
Resolved	Marostegui	T256679 text table in db1144 drifts from core considerably
		· · ·

Event Timeline

Ladsgroup created this task.Jun 29 2020, 7:21 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 29 2020, 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

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.Jun 29 2020, 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

text table in db1144 drifts from core considerablyClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

text table in db1144 drifts from core considerably
Closed, ResolvedPublic
Actions

Related Objects
Search...