Should I be concerned that the ID values in the app_user and cwd_user tables don't match?

[Albert Lukan]

I was pulling user data from our MS SQL database to identify an account in Jira Service Management that was causing us issues and realized that in the app_user and cwd_user tables, the IDs for the user don't always match. They do in the beginning, then are off by 1 or 2 for the same user as the count gets higher. 

This doesn't seem to have caused any impact and the user data looks correct when viewed in Power BI using the Power BI Connector, but I want to make sure this deviation won't cause some kind of issue down the line. 

Has anyone else encountered this? 

[Nic Brough -Adaptavist- · Accepted solution]

Yep, it's one of many reasons never to read a Jira database - it makes less sense than you might guess.

You are safe though, it is nothing to worry about.

[Albert Lukan]

Thanks for the quick response!  And yeah I had to stop exploring tables for my own sanity.

[Nic Brough -Adaptavist-]

I think the database gave me a nervous breakdown around 2007... ;-)

[Maxime Boyer]

The ID in the app_user table is the ApplicationUser.getId(). They must match the cwd_user table on lower_user_name.