Simultaneous Authentication Attempts by A User Throws ConstraintViolationException

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Simultaneous authentication attempts by a user throws ConstraintViolationException:

2011-03-04 22:13:16,639 http-127.0.0.1-8096-9 ERROR [hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
:
:
Caused by: java.sql.BatchUpdateException: Duplicate entry 'V1h2OoiudimnxhnRbgPLNA00' for key 2
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2020)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 118 more

Cause

See CWD-998 - Getting issue details... STATUS .

Typically happens when users tried to login twice (eg. they experienced some sorts of slow login, thus they tried to login again).

Work Around

Store session in Memory: Session configuration.

 

Last modified on Aug 28, 2013

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.