Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

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
TAGS
Community showcase
Asked in Jira Service Management

JSM June ask me anything (AMA)

Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...

238 views 12 14
View question

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