Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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.

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 :)

No ideas???

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

260 views 2 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