Page MenuHomePhabricator

searchindex indexes are missing in production
Closed, DeclinedPublic

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

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.

Event Timeline

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.

Ladsgroup closed this task as Declined.Apr 13 2020, 10:01 AM

Sure!