searchindex indexes are missing in production
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	Ladsgroup
	Apr 13 2020, 9:25 AM

Description

This showed up:

"searchindex si_text index-mismatch-code-extra": {
    "s1": [
        "db1083.eqiad.wmnet",
        "db1099.eqiad.wmnet"
    ],
    "s2": [
        "db1122.eqiad.wmnet",
        "db1129.eqiad.wmnet",
        "db1105.eqiad.wmnet",
        "db1090.eqiad.wmnet",
        "db1076.eqiad.wmnet",
        "db1103.eqiad.wmnet",
        "db1074.eqiad.wmnet"
    ],
    "s3": [
        "db1123.eqiad.wmnet",
        "db1075.eqiad.wmnet",
        "db1112.eqiad.wmnet",
        "db1078.eqiad.wmnet"
    ],
    "s5": [
        "db1100.eqiad.wmnet",
        "db1113.eqiad.wmnet",
        "db1096.eqiad.wmnet",
        "db1110.eqiad.wmnet",
        "db1082.eqiad.wmnet",
        "db1097.eqiad.wmnet",
        "db1130.eqiad.wmnet"
    ],
    "s6": [
        "db1131.eqiad.wmnet",
        "db1113.eqiad.wmnet",
        "db1088.eqiad.wmnet",
        "db1098.eqiad.wmnet",
        "db1085.eqiad.wmnet",
        "db1096.eqiad.wmnet",
        "db1093.eqiad.wmnet"
    ],
    "s7": [
        "db1086.eqiad.wmnet",
        "db1136.eqiad.wmnet",
        "db1101.eqiad.wmnet",
        "db1079.eqiad.wmnet",
        "db1094.eqiad.wmnet",
        "db1090.eqiad.wmnet",
        "db1098.eqiad.wmnet"
    ],
    "s8": [
        "db1109.eqiad.wmnet",
        "db1104.eqiad.wmnet",
        "db1101.eqiad.wmnet",
        "db1111.eqiad.wmnet",
        "db1087.eqiad.wmnet",
        "db1126.eqiad.wmnet",
        "db1099.eqiad.wmnet"
    ]
},
"searchindex si_title index-mismatch-code-extra": {
    "s1": [
        "db1083.eqiad.wmnet",
        "db1099.eqiad.wmnet"
    ],
    "s2": [
        "db1122.eqiad.wmnet",
        "db1129.eqiad.wmnet",
        "db1105.eqiad.wmnet",
        "db1090.eqiad.wmnet",
        "db1076.eqiad.wmnet",
        "db1103.eqiad.wmnet",
        "db1074.eqiad.wmnet"
    ],
    "s3": [
        "db1123.eqiad.wmnet",
        "db1075.eqiad.wmnet",
        "db1112.eqiad.wmnet",
        "db1078.eqiad.wmnet"
    ],
    "s5": [
        "db1100.eqiad.wmnet",
        "db1113.eqiad.wmnet",
        "db1096.eqiad.wmnet",
        "db1110.eqiad.wmnet",
        "db1082.eqiad.wmnet",
        "db1097.eqiad.wmnet",
        "db1130.eqiad.wmnet"
    ],
    "s6": [
        "db1131.eqiad.wmnet",
        "db1113.eqiad.wmnet",
        "db1088.eqiad.wmnet",
        "db1098.eqiad.wmnet",
        "db1085.eqiad.wmnet",
        "db1096.eqiad.wmnet",
        "db1093.eqiad.wmnet"
    ],
    "s7": [
        "db1086.eqiad.wmnet",
        "db1136.eqiad.wmnet",
        "db1101.eqiad.wmnet",
        "db1079.eqiad.wmnet",
        "db1094.eqiad.wmnet",
        "db1090.eqiad.wmnet",
        "db1098.eqiad.wmnet"
    ],
    "s8": [
        "db1109.eqiad.wmnet",
        "db1104.eqiad.wmnet",
        "db1101.eqiad.wmnet",
        "db1111.eqiad.wmnet",
        "db1087.eqiad.wmnet",
        "db1126.eqiad.wmnet",
        "db1099.eqiad.wmnet"
    ]
},

We don't use this table in production (we use elastic as the search backend) so the table should be easy and fixing this too!

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
		· · ·
Resolved	Ladsgroup	T104459 Detect object, schema and data drifts between mediawiki HEAD, production masters and replicas
Declined	None	T250058 searchindex indexes are missing in production
		· · ·

Event Timeline

Ladsgroup created this task.Apr 13 2020, 9:25 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 13 2020, 9:25 AM

I am thinking about declining this.
The tables in production are InnoDB and binary with binary columns, so we cannot create full text indexes there.
tables.sql shows the table being created as MyISAM (which we don't do in production) and utf8.
Can your script skip this table - it is very unlikely we'll change this in production.

Sure!

Ladsgroup mentioned this in T104459: Detect object, schema and data drifts between mediawiki HEAD, production masters and replicas.Apr 13 2020, 12:39 PM

Marostegui added a parent task: T104459: Detect object, schema and data drifts between mediawiki HEAD, production masters and replicas.May 4 2020, 7:07 AM

Ladsgroup mentioned this in T312538: Collect list of tickets done for fixing core drifts .Jul 7 2022, 12:59 PM

searchindex indexes are missing in productionClosed, DeclinedPublicActions

Description

Related ObjectsSearch...

Event Timeline

searchindex indexes are missing in production
Closed, DeclinedPublic
Actions

Related Objects
Search...