duplicate key value violation exception

Description

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)

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

Assignee

Reporter

Sprint

Priority

More fields

Created 24 April 2018 at 05:42
Updated 16 May 2018 at 00:18
Resolved 16 May 2018 at 00:17

Flag notifications