SQL Error, Duplicate entry and HHH000315 in atlassian-crowd.log

In production we have the following triple log entries:

2014-08-05 00:26:38,514 ajp-bio-8009-exec-12 WARN [engine.jdbc.spi.SqlExceptionHelper] SQL Error: 1062, SQLState: 23000
2014-08-05 00:26:38,515 ajp-bio-8009-exec-12 ERROR [engine.jdbc.spi.SqlExceptionHelper] Duplicate entry 'F0Ed288GGEXEw8iDZrzMVQ00' for key 'uk_token_id_hash'
2014-08-05 00:26:38,515 ajp-bio-8009-exec-12 ERROR [jdbc.batch.internal.BatchingBatch] HHH000315: Exception executing batch [could not perform addBatch]
2014-08-05 00:46:28,325 ajp-bio-8009-exec-11 WARN [engine.jdbc.spi.SqlExceptionHelper] SQL Error: 1062, SQLState: 23000
2014-08-05 00:46:28,326 ajp-bio-8009-exec-11 ERROR [engine.jdbc.spi.SqlExceptionHelper] Duplicate entry 'F0Ed288GGEXEw8iDZrzMVQ00' for key 'uk_token_id_hash'
2014-08-05 00:46:28,326 ajp-bio-8009-exec-11 ERROR [jdbc.batch.internal.BatchingBatch] HHH000315: Exception executing batch [could not perform addBatch]

As you can see, it occurs at different times. sometimes one time a day sometimes two or more times.

A look at the DB table cwd_token shows a valid token for one of our applications. Here is the row (name of application is replaced by xxxxxxxx):

id      directory_id entity_name random_number       identifier_hash          random_hash              created_date        last_accessed_date  last_accessed_time duration 
------- ------------ ----------- ------------------- ------------------------ ------------------------ ------------------- ------------------- ------------------ -------- 
1580324 -1           XXXXXXXXXXX 4671076784804601889 F0Ed288GGEXEw8iDZrzMVQ00 PAT0NGQA9ZjaUHkef0vuOA00 2014-08-05 08:11:43 2014-08-05 08:11:43 1407224594771      60

We are using latest Crowd-Version 2.7.2 Build 626.

We don't have any functional problems so far, but these log entries makes me wonder.

3 answers

No ideas???

Hi Jan, I just experienced the same error when setting domain attribute in Crowd setting from null to value '.srv' which is our internal DNS TLD for atlassian products. Do not know if it related to your problem tough.

Hi Mika,

if you mean the "SSO Domain" option in "General Options" of crowd adminstration: Yes, we have set this too. But we need to set it for cookie handling and security reasons.

Yes, that is what I mean. When I clear that setting and rebooted crowd: SQL problems disappeared and Crowd acted normally. No SSO tough, but authentication works from Jira / Confluence once again.

fyi: I am trying to get the SSO working between jira/confluence (all latest versions), but no luck yet :)

same problem with our setting: all latest versions: jira, confluence and crowd. some user got kicked out i.e. when they try to assign an issue - others when they do other actions. not really easy to find the root cause. JIRA shows me an incredible amount of user sessions and tomcat is spitting error on error.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Maggie Roney
Published Feb 27, 2018 in Crowd

The Crowd team is looking for feedback on Server & Data Center customers' identity strategies!

Do you own more than one Server or Data Center product? Do you have challenges provisioning users across your Atlassian products? Are you spending a lot of time integrating each Atlassian product wit...

576 views 6 13
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you