Simultaneous Authentication Attempts by A User Throws ConstraintViolationException

Still need help?

The Atlassian Community is here for you.

Ask the community


Simultaneous authentication attempts by a user throws ConstraintViolationException:

2011-03-04 22:13:16,639 http- 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(
Caused by: java.sql.BatchUpdateException: Duplicate entry 'V1h2OoiudimnxhnRbgPLNA00' for key 2
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(
at com.mysql.jdbc.PreparedStatement.executeBatch(
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(
at org.hibernate.jdbc.AbstractBatcher.executeBatch(
... 118 more


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?

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