Page MenuHomePhabricator

gu_home_db is NULL
Closed, InvalidPublic

Description

On CentralAuth after SUL finalisation, everybody should have a homewiki set, but i noticed it is missing in some cases on the replicated databases, e.g.

https://commons.wikimedia.org/wiki/Special:CentralAuth/Amitaharon10 has set hewiki as homewiki, but it is missing on replicas:

MariaDB [centralauth_p]> select * from globaluser WHERE gu_name ="Amitaharon10" limit 1;
+----------+--------------+------------+-------------------+------------+----------+------------------------+---------+-------------+-----------+-----------+-----------------+-----------------------+------------------------------+---------------+
| gu_id    | gu_name      | gu_enabled | gu_enabled_method | gu_home_db | gu_email | gu_email_authenticated | gu_salt | gu_password | gu_locked | gu_hidden | gu_registration | gu_password_reset_key | gu_password_reset_expiration | gu_auth_token |
+----------+--------------+------------+-------------------+------------+----------+------------------------+---------+-------------+-----------+-----------+-----------------+-----------------------+------------------------------+---------------+
| 55259039 | Amitaharon10 |            | NULL              | NULL       |     NULL |                   NULL |    NULL |        NULL |         0 |           | 20180823103352  |                  NULL |                         NULL |          NULL |
+----------+--------------+------------+-------------------+------------+----------+------------------------+---------+-------------+-----------+-----------+-----------------+-----------------------+------------------------------+---------------+
1 row in set (0.00 sec)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 26 2018, 10:23 AM
Krenair edited projects, added Data-Services; removed Cloud-Services.
Krenair added a subscriber: Krenair.
Rxy added a subscriber: Rxy.Aug 26 2018, 11:49 AM
Reedy closed this task as Invalid.Aug 26 2018, 10:45 PM
Reedy added a subscriber: Reedy.

Run in prod

MariaDB [centralauth]> select gu_home_db from globaluser WHERE gu_name ="Amitaharon10" limit 1;
+------------+
| gu_home_db |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

It's the same. The green + isn't the "home wiki"

Steinsplitter added a comment.EditedAug 27 2018, 11:20 AM

Run in prod

MariaDB [centralauth]> select gu_home_db from globaluser WHERE gu_name ="Amitaharon10" limit 1;
+------------+
| gu_home_db |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

It's the same. The green + isn't the "home wiki"

<s>Regression? Just new accounts seems affected, all new accounts lacking those. It is not documented as far i can see, so i don't know if it is a bug or it it was deprecated.</s>

Edit: Workaround/repalcement is via the localuser table, where lu_attached_method is IN ("primary", "new").