How to effectively deactivate a Jira user with automation ?

[Eddy Fras]

I'm trying to deactivate some selected users but for an unknown reason that does not work.

I used the update SQL request I found here : https://community.atlassian.com/t5/Jira-questions/Bulk-User-Deactivation-in-Jira/qaq-p/313925

When I check the DB, active flag is set to 0.

# select user_name, display_name, active from cwd_user where user_name = 'test@external.com';
 user_name | display_name | active
-------------------+--------------+--------
 test@external.com | prenom nom | 0

But in the user management console, user is still active (not striked through) as shown in screenshot. 

What do I have to do to get my users really deactivated ?

Thanks,

Eddy

[Kenny Horan]

One possibility, Hibernate caches data so that row is likely cached in Jira.  Restarting Jira would flush it.

[Eddy Fras]

Thanks Kenny for your quick answer. Unfortunately, I can't restart Jira for now, I have some users playing with it :)

I'll see if your suggestion is the right one the next time I'll restart it.

Eddy