nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Where are changes to user properties stored in Jira database?

John Dorapalli

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!

Accepted answers

John Dorapalli

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.

All comments

Nic Brough -Adaptavist-

There's no record of change in embedded crowd.

How are you changing the email?

John Dorapalli

Using Jira admin interface.

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

Nic Brough -Adaptavist-

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

John Dorapalli

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?

John Dorapalli

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

user

user-property