Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Where are changes to user properties stored in Jira database?

I am updating email for a user account and the change is getting reverted. I am unable to find anything about this in the logs or in the database.

I want to know if there is change history table for cwd_user table or is there a way to track the changes made to user properties or cwd_user table?

Any other inputs to track this are appreciated.

Thanks in advance!

2 answers

1 accepted

This is related to cache corruption. 

The actual values in the database are correct but the value display on Jira interface are different.

I got it resolved following the commands provided by atlassian support below.

-----------

The following command is recommended to be executed on each server node locally to clean up the Jira cache:

curl -v -X DELETE -u JiraUser:JiraPassword -k https://JiraURL/rest/internal/1.0/cache/app 

where JiraUser:JiraPassword must be your Jira administrator credentials and JiraURL must be the server IP and port of each node. Do not use Jira base url, as it can randomly pick a node.

It is strongly suggested running the commands during non-working hours, since this can be very expensive and take some node down during the execution.

0 votes

There's no record of change in embedded crowd.

How are you changing the email?

Using Jira admin interface.

Screen Shot 2020-10-21 at 5.57.20 PM.png

Ok, can you get access to the logs?  See what happens in <jira home>/log/atlassian-jira.log when you click "update" on that screen

Nothing related to the change in the logs.

I Just see the cache replication queue entries getting added to the logs.

Do you have a search term you want me to look for?

I'd want to look for "tuser", but if there are no errors in the log at that point, I wouldn't worry about it.

What type of user directory is it?  Internal?  External LDAP/Crowd/something?

We use Jira Internal Directory.

Yes, I do not see any errors in the logs during that time. Searching on username did not fetch any results either.

OK, I'm stuck, I've only ever seen that either throw errors into the logs, or happen with external user directories.

I think this one probably needs to go to Atlassian support!

Thank you @Nic Brough _Adaptavist_ !

I will contact Atlassian support.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.3.4
TAGS
Community showcase
Published in Trello

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

73 views 4 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you