Page MenuHomePhabricator

Remove wikiset restriction for non-existent global group
Closed, ResolvedPublic

Description

The global group Indic_bot was created and delted in 2011. Somehow it's restricting wiki set hasn't been deleted from the database.

MariaDB [centralauth_p]> select * from global_group_restrictions;
+--------------------+---------+
| ggr_group          | ggr_set |
+--------------------+---------+
| global-bot         |       2 |
| global-sysop       |       7 |
| Indic_Bots         |       8 |
| new-wikis-importer |      12 |
+--------------------+---------+
4 rows in set (0.00 sec)

MariaDB [centralauth_p]>

Event Timeline

Urbanecm triaged this task as Low priority.

Mentioned in SAL (#wikimedia-operations) [2021-05-17T08:28:36Z] <Urbanecm> wikiadmin@10.64.48.109(centralauth)> delete from global_group_restrictions where ggr_group="Indic_Bots"; # T282968

wikiadmin@10.64.48.109(centralauth)> select * from global_group_restrictions;
+--------------------+---------+
| ggr_group          | ggr_set |
+--------------------+---------+
| global-bot         |       2 |
| global-sysop       |       7 |
| Indic_Bots         |       8 |
| new-wikis-importer |      12 |
+--------------------+---------+
4 rows in set (0.00 sec)

wikiadmin@10.64.48.109(centralauth)> select * from global_group_restrictions where ggr_group="Indic_Bots";
+------------+---------+
| ggr_group  | ggr_set |
+------------+---------+
| Indic_Bots |       8 |
+------------+---------+
1 row in set (0.00 sec)

wikiadmin@10.64.48.109(centralauth)> begin;
Query OK, 0 rows affected (0.00 sec)

wikiadmin@10.64.48.109(centralauth)> delete from global_group_restrictions where ggr_group="Indic_Bots";
Query OK, 1 row affected (0.00 sec)

wikiadmin@10.64.48.109(centralauth)> select * from global_group_restrictions;
+--------------------+---------+
| ggr_group          | ggr_set |
+--------------------+---------+
| global-bot         |       2 |
| global-sysop       |       7 |
| new-wikis-importer |      12 |
+--------------------+---------+
3 rows in set (0.00 sec)

wikiadmin@10.64.48.109(centralauth)> commit;
Query OK, 0 rows affected (0.00 sec)