New user added to wrong group if actor.usr id and usrgroup sequences are out of sync

[Jeff Davis]

In theory, the default value for actor.usr.usrgroup should be the same as actor.usr.id. But the id and usrgroup columns use two different sequences for their default values, and those sequences can be out of sync. If that happens, new users will be incorrectly added to whatever group corresponds to the next usrgroup val, which is likely to be an entirely unrelated user.

[Chris Sharp (chrissharp123)]

I can't seem to find the particulars of why this happened to us, but several years ago the sequence of actor.usr.usrgroup got reset to a number far lower than actor.usr resulting in this issue. In our case, resetting the value of actor.usr_usrgroup_seq to something higher than actor.usr solved the issue for us.

[Jeff Davis (jdavis-sitka)]

My initial understanding was incorrect. User id and usrgroup are entirely unrelated values; there is no reason for usrgroup to be the same as user id. I am marking this bug as invalid.