Duplicate entry for key 'uk_token_id_hash' in crwod log

[pupie]

Hi,

I am wondering if anyone has noticed this error in crowd log. 

I am using latest crowd 2.7.2 and JIRA 6.3.6. I noticed that there are always some errors in crowd logs like:

2014-09-29 08:35:59,575 http-bio-8095-exec-21 WARN [engine.jdbc.spi.SqlExceptionHelper] SQL Error: 1062, SQLState: 23000
2014-09-29 08:35:59,575 http-bio-8095-exec-21 ERROR [engine.jdbc.spi.SqlExceptionHelper] Duplicate entry 'DExcfx0O9tpVuoIqjtqREw00' for key 'uk_token_id_hash'
2014-09-29 08:35:59,589 http-bio-8095-exec-21 ERROR [jdbc.batch.internal.BatchingBatch] HHH000315: Exception executing batch [could not perform addBatch]

so, what is wrong is my crowd and how to get rid of this error?

[Deleted user]

https://confluence.atlassian.com/jirakb/duplicated-entry-unique-constraint-violated-397808094.html

Hope the above document helps

[pupie]

i try to switch Token Storage to memory and error occurred. http://pastebin.com/Zub9B3wL

[Tiago Comasseto]

Hi, if you're running Crowd previous to version 2.7.2 it's possible that you're running into a bug as this one, in this case you may switch the token storage to in memory or upgrade Crowd to the latest version.

I hope it helps.

Cheers

[pupie]

i swither it to memory and error occurred. http://pastebin.com/Zub9B3wL

[pupie]

I am using crowd 2.7.2 build 626. the Authentication Token Storage is in database.

I tried to switch it to memory from web interface and error occurred can be seen from web interface and log.

http://pastebin.com/Zub9B3wL

[Tiago Comasseto]

Hi, since you're facing problem to switch the token storage via web interface, you can do it directly via database:

1. Shutdown crowd - ensure the pid is stopped
2. Perform a database backup
3. Connect to the database
4. Execute this sql:

   update cwd_property 
   set property_value='false'
   where property_name='database.token.storage.enabled';

5. Restart Crowd
6. Validate the session storage is now in-memory by Navigating to Administration > Session Config

[Caspar Krieger]

Would you please attach the full exception stack trace, e.g. on http://pastebin.com/ ?