duplicate key value violation exception
Description
Environment
None
Activity
Show:
Former user 16 May 2018 at 00:18
We now ignore the constraint exception and move on. We track the MT engine usage.
Sean Flanigan 27 April 2018 at 01:24
I think this proves that our locking is not working
Yes, it certainly looks that way.
(single node cluster not real cluster)
Even worse.
Former user 26 April 2018 at 06:22
I think this proves that our locking is not working (single node cluster not real cluster)
Sean Flanigan 24 April 2018 at 06:18
Do you have the complete stack trace? That might be a concurrency problem (parallel requests in flight).
Completed
Details
Details
Assignee
Former user
Former user(Deactivated)Reporter
Former user
Former user(Deactivated)Sprint
None
Priority
unspecifiedMore fields
Time tracking
More fields
Time trackingCreated 24 April 2018 at 05:42
Updated 16 May 2018 at 00:18
Resolved 16 May 2018 at 00:17
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "textflow_documentid_contenthash_localeid_key" Detail: Key (documentid, contenthash, localeid)=(38, 1bb97da2c84e61b399dc324a5373939e, 1) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at sun.reflect.GeneratedMethodAccessor344.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:453) at com.sun.proxy.$Proxy188.executeUpdate(Unknown Source) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)