org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "reports_pkey" Detail: Key (hash)=(6cb10ac4b4be82870db2a709a346fb4a132325cb) already exists.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via JIRA by James Glenn, 1 year ago
ERROR: duplicate key value violates unique constraint "reports_pkey" Detail: Key (hash)=(6cb10ac4b4be82870db2a709a346fb4a132325cb) already exists.
via JIRA by James Glenn, 1 year ago
ERROR: duplicate key value violates unique constraint "reports_pkey" Detail: Key (hash)=(6cb10ac4b4be82870db2a709a346fb4a132325cb) already exists.
via Google Groups by Pablo Araujo, 5 months ago
ERROR: table "ht_item" does not exist
via XWiki.org JIRA by Dave Mangot, 1 year ago
ERROR: operator does not exist: boolean <> integer
via incubator-sqoop-user by Alexander C.H. Lorenz, 1 year ago
ERROR: relation "myschema.employee" does not exist Position: 17
via sqoop-user by Alexander C.H. Lorenz, 1 year ago
ERROR: relation "myschema.employee" does not exist Position: 17
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "reports_pkey" Detail: Key (hash)=(6cb10ac4b4be82870db2a709a346fb4a132325cb) 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 com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203)
at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__5838.invoke(internal.clj:337)
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invoke(core.clj:626)
at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at clojure.java.jdbc$insert_records$ins_v__5906.invoke(jdbc.clj:278)
at clojure.core$map$fn__4245.invoke(core.clj:2559)
at clojure.lang.LazySeq.sval(LazySeq.java:40)
at clojure.lang.LazySeq.seq(LazySeq.java:49)
at clojure.lang.RT.seq(RT.java:484)
at clojure.core$seq.invoke(core.clj:133)
at clojure.core$dorun.invoke(core.clj:2855)
at clojure.core$doall.invoke(core.clj:2871)
at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at com.puppetlabs.puppetdb.scf.storage$add_report_BANG__STAR_$fn__9641$fn__9645.invoke(storage.clj:1104)
at com.puppetlabs.puppetdb.scf.storage$add_report_BANG__STAR_$fn__9641.invoke(storage.clj:1094)
at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)
at com.puppetlabs.puppetdb.scf.storage$add_report_BANG__STAR_.invoke(storage.clj:1088)
at com.puppetlabs.puppetdb.scf.storage$eval9812$add_report_BANG___9813$fn__9814.invoke(storage.clj:1221)
at com.puppetlabs.puppetdb.scf.storage$eval9812$add_report_BANG___9813.invoke(storage.clj:1217)
at com.puppetlabs.puppetdb.command$store_report_STAR_$fn__13416.invoke(command.clj:413)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6256$fn__6257$fn__6258.invoke(jdbc.clj:290)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6256$fn__6257.invoke(jdbc.clj:290)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6256.invoke(jdbc.clj:287)
at com.puppetlabs.jdbc$eval6234$retry_sql_STAR___6235$fn__6236$fn__6237.invoke(jdbc.clj:259)
at com.puppetlabs.jdbc$eval6234$retry_sql_STAR___6235$fn__6236.invoke(jdbc.clj:258)
at com.puppetlabs.jdbc$eval6234$retry_sql_STAR___6235.invoke(jdbc.clj:250)
at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286)
at com.puppetlabs.puppetdb.command$store_report_STAR_.invoke(command.clj:411)
at com.puppetlabs.puppetdb.command$eval13444$fn__13447.invoke(command.clj:434)
at clojure.lang.MultiFn.invoke(MultiFn.java:231)
at com.puppetlabs.puppetdb.command$produce_message_handler$fn__13528.invoke(command.clj:647)
at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__13477$fn__13481.invoke(command.clj:554)
at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)
at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__13477.invoke(command.clj:553)
at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__13462$fn__13463.invoke(command.clj:507)
at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)
at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__13462.invoke(command.clj:506)
at com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__13472.invoke(command.clj:529)
at com.puppetlabs.puppetdb.command$wrap_with_meter$fn__13452.invoke(command.clj:467)
at com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__13486.invoke(command.clj:569)
at com.puppetlabs.mq$create_message_listener$reify__10371.onMessage(mq.clj:277)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

37 times, 6 days ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.