Page MenuHomePhabricator
Create Task
Maniphest T113525

[betalabs] enwiki - ref_src_wiki column is missing from v2 index
Closed, ResolvedPublic
Actions

Description

Split from T111084.

ref_src_wiki column in flow_wiki_ref is not included in v2 index in enwiki.

 [enwiki]> show index from flow_wiki_ref ;
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            1 | ref_src_namespace    | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            2 | ref_src_title        | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            3 | ref_type             | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            4 | ref_target_namespace | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            5 | ref_target_title     | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            6 | ref_src_object_type  | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            7 | ref_src_object_id    | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            1 | ref_src_namespace    | A         |          14 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            2 | ref_src_title        | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            3 | ref_src_object_type  | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            4 | ref_src_object_id    | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            5 | ref_type             | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            6 | ref_target_namespace | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            7 | ref_target_title     | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
14 rows in set (0.00 sec)

vs

[testwiki]> show index from flow_wiki_ref ;
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            1 | ref_src_wiki         | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            2 | ref_src_namespace    | A         |          26 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            3 | ref_src_title        | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            4 | ref_type             | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            5 | ref_target_namespace | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            6 | ref_target_title     | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            7 | ref_src_object_type  | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            8 | ref_src_object_id    | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            1 | ref_src_wiki         | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            2 | ref_src_namespace    | A         |          19 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            3 | ref_src_title        | A         |         296 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            4 | ref_src_object_type  | A         |         296 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            5 | ref_src_object_id    | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            6 | ref_type             | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            7 | ref_target_namespace | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            8 | ref_target_title     | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
16 rows in set (0.00 sec)

Related Objects

Event Timeline

Etonkovidova created this task.Sep 23 2015, 8:45 PM
Etonkovidova assigned this task to Catrope.
Etonkovidova raised the priority of this task from to Needs Triage.
Etonkovidova updated the task description. (Show Details)
Etonkovidova added a project: Collaboration-Team-Archive-2015-2016.
Etonkovidova subscribed.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 23 2015, 8:45 PM
Catrope closed this task as Resolved.Sep 23 2015, 10:00 PM
mysql> show index from flow_wiki_ref;
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            1 | ref_src_wiki         | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            2 | ref_src_namespace    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            3 | ref_src_title        | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            4 | ref_type             | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            5 | ref_target_namespace | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            6 | ref_target_title     | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            7 | ref_src_object_type  | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            8 | ref_src_object_id    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            1 | ref_src_wiki         | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            2 | ref_src_namespace    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            3 | ref_src_title        | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            4 | ref_src_object_type  | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            5 | ref_src_object_id    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            6 | ref_type             | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            7 | ref_target_namespace | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            8 | ref_target_title     | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
16 rows in set (0.00 sec)

mysql> show index from flow_ext_ref;
+--------------+------------+--------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table        | Non_unique | Key_name                 | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+--------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            1 | ref_src_wiki        | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            2 | ref_src_namespace   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            3 | ref_src_title       | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            4 | ref_type            | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            5 | ref_target          | A         |          91 |      255 | NULL   | YES  | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            6 | ref_src_object_type | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            7 | ref_src_object_id   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            1 | ref_src_wiki        | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            2 | ref_src_namespace   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            3 | ref_src_title       | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            4 | ref_src_object_type | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            5 | ref_src_object_id   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            6 | ref_type            | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            7 | ref_target          | A         |          91 |      255 | NULL   | YES  | BTREE      |         |               |
+--------------+------------+--------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
14 rows in set (0.01 sec)
SBisson moved this task from Untriaged to QA Review on the Collaboration-Team-Archive-2015-2016 board.Sep 24 2015, 11:02 AM
Etonkovidova mentioned this in T111084: Do backfill and final schema change for "Segregate Reference objects by source wiki.".Sep 24 2015, 4:52 PM
Etonkovidova moved this task from QA Review to Product Review on the Collaboration-Team-Archive-2015-2016 board.
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