Users list in administration fails with 500 status after upgrade to Stash 3.5

If there are users in the cwd_user table that have no matching user in the sta_normal_user table, the /admin/users page errors out.

Stash was upgraded from 2.9.4 to 3.5.0

Workaround

Determine which users are missing in the sta_normal_user table

select id, user_name, lower_user_name from cwd_user where lower_user_name not in (select name from sta_normal_user);

• Under Administration > User Directories, disable all remote directories
• For each of the missing users, go to /admin/users and create a user with the same username. This will create the user in the built-in user directory and will also create the user in the sta_normal_user table. Don't worry about the password or sending an email to the user, because next we'll...
• Delete the user that was just created. This will remove the user from the built-in user directory, but the user in sta_normal_user will be retained.
• Re-enable the user directories that were disabled in step 1