According to https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralAuth/+/769847 on production we have some localuser rows with lu_local_id=0 or lu_global_id=0.
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
Meh.
MariaDB [centralauth_p]> select * from localuser where lu_local_id=0; +---------+------------------------------+-----------------------+--------------------+-------------+--------------+ | lu_wiki | lu_name | lu_attached_timestamp | lu_attached_method | lu_local_id | lu_global_id | +---------+------------------------------+-----------------------+--------------------+-------------+--------------+ | arwiki | Haaelsalama | 20160721063747 | new | 0 | 47253103 | | arwiki | Hamo awad | 20160719143320 | new | 0 | 47238617 | | arwiki | Hany sb | 20160720130326 | new | 0 | 47246866 | | arwiki | Hollywood-Bollywood | 20160715224935 | new | 0 | 47209021 | | arwiki | Hussein Omer | 20160713184445 | new | 0 | 47190598 | | arwiki | Jon Qq11Ww22 | 20160717005916 | new | 0 | 47216945 | | arwiki | Lara Al-Qarra | 20160717052245 | new | 0 | 47218023 | | arwiki | Mohamed mahyo | 20160719180157 | new | 0 | 47240197 | | arwiki | Mohammad swaid | 20160719174859 | new | 0 | 47240112 | | arwiki | Nevx vx | 20160719193629 | new | 0 | 47240827 | | arwiki | Saeed AlZuhairi | 20160717213026 | new | 0 | 47223709 | | arwiki | Sedra janbai | 20160720233048 | new | 0 | 47251115 | | arwiki | Shimaa gmal | 20160717204515 | new | 0 | 47223468 | | arwiki | W2adam | 20160718144310 | new | 0 | 47229771 | | arwiki | محمد نور المحمد | 20160718145542 | new | 0 | 47229875 | | arwiki | نور مراد | 20160717210828 | new | 0 | 47223595 | | azbwiki | Pınar. Shaker | 20160717175145 | new | 0 | 47222401 | | azwiki | İngilab | 20160714220738 | new | 0 | 47200689 | | bgwiki | GoodGamerBG | 20160714104243 | new | 0 | 47196028 | | bgwiki | MariaStoicheva | 20160715184216 | new | 0 | 47207651 | | bgwiki | Zaynmalik1914 | 20160715171659 | new | 0 | 47207123 | | bnwiki | রকিবুল আলম | 20160716140616 | new | 0 | 47213401 | | bswiki | Karasupici | 20160718212927 | new | 0 | 47232599 | +---------+------------------------------+-----------------------+--------------------+-------------+--------------+ 23 rows in set (6 min 43.09 sec) MariaDB [centralauth_p]>
Comment Actions
The timestamp are all from before T142507: Have CentralAuth populate the local_user_id and global_user_id columns as new users are attached / https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralAuth/+/309553
The script PopulateLocalAndGlobalIds only works for NULL, not 0
Comment Actions
Per T292473: Centralauth localuser table has entries with a null lu_global_id there are also some lingering null values for lu_global_id.