User list returns "none" for some user names

[Zhongcheng Lao]

Some user names in the user list were reported as "none"
while in the DB these users have name set properly.

This only happens list_limit is not set to 0.

for num in `seq 1 100`;do openstack user create --domain default --password
$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 10 | head -n 1) $(cat
/dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 10 | head -n 1) |tee
/tmp/usercreate.txt ; done

# openstack user list

+----------------------------------+-------------+
| ID | Name |
+----------------------------------+-------------+
| ... | |
| dfa4796a26a247a891608b7422cd9a59 | None |
+----------------------------------+-------------+

# openstack user show dfa4796a26a247a891608b7422cd9a59
+---------------------+----------------------------------+
| Field | Value |
+---------------------+----------------------------------+
| domain_id | default |
| enabled | True |
| id | dfa4796a26a247a891608b7422cd9a59 |
| name | XIeLjEXK5B |
| options | {} |
| password_expires_at | None |
+---------------------+----------------------------------+

[Colleen Murphy (krinkle)]

I can't seem to reproduce this on devstack with MySQL/InnoDB, seems the select always returns results in order by ID. Can you share more information about your database configuration? What version of keystone are you using? Do you have any LDAP or federated users in addition to the SQL users?

[Lance Bragstad (lbragstad)]

Marking as incomplete until we get a little more information on how to reproduce this.

[OpenStack Infra (hudson-openstack)]

Change abandoned by "Gage Hugo <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/keystone/+/623928
Reason: Abandoning since there hasn't been any recent activity, if anyone wants to continue this work, please feel free to restore this or create a new change.