org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[puppetdb.jar:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__6343.invoke(internal.clj:337) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156) ~[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) ~[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278) ~[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2559) ~[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40) ~[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49) ~[puppetdb.jar:na] at clojure.lang.RT.seq(RT.java:484) ~[puppetdb.jar:na] at clojure.core$seq.invoke(core.clj:133) ~[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2855) ~[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:423) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_record.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125$fn__10126.invoke(storage.clj:1173) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125.invoke(storage.clj:1170) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144$fn__10145.invoke(storage.clj:1183) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144.invoke(storage.clj:1175) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:380) ~[na:na]

JIRA | Wyatt Alt | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    This error is present in a single place in the logs from PE-7392 {code} 2014-11-13 13:29:25,411 INFO [c.p.p.command] [6190222a-6056-43e4-9eec-0636d87d1663] [replace catalog] dc202sessmdb-01.lhr4.dqs.booking.com 2014-11-13 13:29:25,423 ERROR [c.p.p.command] [bb0dfdd0-1df1-4b3b-bbd5-487bc115a410] [replace facts] Retrying after attempt 4, due to: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[puppetdb.jar:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__6343.invoke(internal.clj:337) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156) ~[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) ~[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278) ~[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2559) ~[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40) ~[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49) ~[puppetdb.jar:na] at clojure.lang.RT.seq(RT.java:484) ~[puppetdb.jar:na] at clojure.core$seq.invoke(core.clj:133) ~[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2855) ~[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:423) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_record.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125$fn__10126.invoke(storage.clj:1173) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125.invoke(storage.clj:1170) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144$fn__10145.invoke(storage.clj:1183) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144.invoke(storage.clj:1175) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:380) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290) ~[na:na] at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287) ~[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259) ~[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258) ~[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546.invoke(command.clj:379) ~[na:na] at clojure.lang.MultiFn.invoke(MultiFn.java:231) ~[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$produce_message_handler$fn__11715.invoke(command.clj:647) ~[na:na] at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664$fn__11668.invoke(command.clj:554) ~[na:na] at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91) ~[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664.invoke(command.clj:553) ~[na:na] at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649$fn__11650.invoke(command.clj:507) ~[na:na] at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91) ~[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649.invoke(command.clj:506) ~[na:na] at com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__11659.invoke(command.clj:529) [na:na] at com.puppetlabs.puppetdb.command$wrap_with_meter$fn__11639.invoke(command.clj:467) [na:na] at com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__11673.invoke(command.clj:569) [na:na] at com.puppetlabs.mq$create_message_listener$reify__10820.onMessage(mq.clj:270) [na:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263) [puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058) [puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050) [puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947) [puppetdb.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65] {code} I haven't seen it before; could be a consequence of their postgres setup.

    JIRA | 2 years ago | Wyatt Alt
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[puppetdb.jar:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__6343.invoke(internal.clj:337) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156) ~[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) ~[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278) ~[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2559) ~[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40) ~[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49) ~[puppetdb.jar:na] at clojure.lang.RT.seq(RT.java:484) ~[puppetdb.jar:na] at clojure.core$seq.invoke(core.clj:133) ~[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2855) ~[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:423) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_record.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125$fn__10126.invoke(storage.clj:1173) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125.invoke(storage.clj:1170) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144$fn__10145.invoke(storage.clj:1183) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144.invoke(storage.clj:1175) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:380) ~[na:na]
  2. 0

    This error is present in a single place in the logs from PE-7392 {code} 2014-11-13 13:29:25,411 INFO [c.p.p.command] [6190222a-6056-43e4-9eec-0636d87d1663] [replace catalog] dc202sessmdb-01.lhr4.dqs.booking.com 2014-11-13 13:29:25,423 ERROR [c.p.p.command] [bb0dfdd0-1df1-4b3b-bbd5-487bc115a410] [replace facts] Retrying after attempt 4, due to: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[puppetdb.jar:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__6343.invoke(internal.clj:337) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156) ~[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) ~[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278) ~[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2559) ~[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40) ~[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49) ~[puppetdb.jar:na] at clojure.lang.RT.seq(RT.java:484) ~[puppetdb.jar:na] at clojure.core$seq.invoke(core.clj:133) ~[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2855) ~[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:423) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_record.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125$fn__10126.invoke(storage.clj:1173) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125.invoke(storage.clj:1170) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144$fn__10145.invoke(storage.clj:1183) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144.invoke(storage.clj:1175) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:380) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290) ~[na:na] at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287) ~[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259) ~[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258) ~[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250) ~[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546.invoke(command.clj:379) ~[na:na] at clojure.lang.MultiFn.invoke(MultiFn.java:231) ~[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$produce_message_handler$fn__11715.invoke(command.clj:647) ~[na:na] at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664$fn__11668.invoke(command.clj:554) ~[na:na] at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91) ~[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664.invoke(command.clj:553) ~[na:na] at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649$fn__11650.invoke(command.clj:507) ~[na:na] at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91) ~[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649.invoke(command.clj:506) ~[na:na] at com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__11659.invoke(command.clj:529) [na:na] at com.puppetlabs.puppetdb.command$wrap_with_meter$fn__11639.invoke(command.clj:467) [na:na] at com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__11673.invoke(command.clj:569) [na:na] at com.puppetlabs.mq$create_message_listener$reify__10820.onMessage(mq.clj:270) [na:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325) [puppetdb.jar:na] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263) [puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058) [puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050) [puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947) [puppetdb.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65] {code} I haven't seen it before; could be a consequence of their postgres setup.

    JIRA | 2 years ago | Wyatt Alt
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[puppetdb.jar:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__6343.invoke(internal.clj:337) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156) ~[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) ~[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278) ~[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2559) ~[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40) ~[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49) ~[puppetdb.jar:na] at clojure.lang.RT.seq(RT.java:484) ~[puppetdb.jar:na] at clojure.core$seq.invoke(core.clj:133) ~[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2855) ~[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:423) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_record.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125$fn__10126.invoke(storage.clj:1173) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125.invoke(storage.clj:1170) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144$fn__10145.invoke(storage.clj:1183) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144.invoke(storage.clj:1175) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:380) ~[na:na]
  3. 0

    por que cuando hago una consulta jpql, netbeans me tira un error - Foros del Web

    forosdelweb.com | 1 year ago
    org.postgresql.util.PSQLException: ERROR: no están implementadas las referencias entre bases de datos: «buenagro.public.tbl_usuario» Position: 13 Error Code: 0 Call: INSERT INTO BUENAGRO.public.tbl_usuario ("cod_usuario", "clave", "email", "identificacion", "primer_apellido", "primer_nombre", "segundo_apellido", "segundo_nombre") VALUES (?, ?, ?, ?, ?, ?, ?, ?) bind => [8 parameters bound] Query: InsertObjectQuery(Dm.TblUsuario[ codUsuario=20 ]) at com.sun.faces.application.ActionListenerImpl.proce ssAction(ActionListenerImpl.java:118) at javax.faces.component.UICommand.broadcast(UIComman d.java:315) at javax.faces.component.UIViewRoot.broadcastEvents(U IViewRoot.java:790) at javax.faces.component.UIViewRoot.processApplicatio n(UIViewRoot.java:1282) at com.sun.faces.lifecycle.InvokeApplicationPhase.exe cute(InvokeApplicationPhase.java:81) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:1 01) at com.sun.faces.lifecycle.LifecycleImpl.execute(Life cycleImpl.java:198) at javax.faces.webapp.FacesServlet.service(FacesServl et.java:646) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilt er(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:136) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve. invoke(AbstractAccessLogValve.java:610) at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:526) at org.apache.coyote.http11.AbstractHttp11Processor.p rocess(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnect ionHandler.process(AbstractProtocol.java:655) at org.apache.coyote.http11.Http11NioProtocol$Http11C onnectionHandler.process(Http11NioProtocol.java:22 2) at org.apache.tomcat.util.net.NioEndpoint$SocketProce ssor.doRun(NioEndpoint.java:1566) at org.apache.tomcat.util.net.NioEndpoint$SocketProce ssor.run(NioEndpoint.java:1523) at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$Wrapping Runnable.run(TaskThread.java:61)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    updateString error in PostgreSQL7.4 with JDBC - PostgreSQL Database

    bytes.com | 1 year ago
    org.postgresql.util.PSQLException: Cannot update the result set because it is either before the start or after the end of the results. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.update Value(AbstractJdbc2ResultSet.java:1595) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.update String(AbstractJdbc2ResultSet.java:1193) at admin.ValidationRequest.doGet(ValidationRequest.ja va:43) at javax.servlet.http.HttpServlet.service(HttpServlet .java:740) at javax.servlet.http.HttpServlet.service(HttpServlet .java:853) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643) at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643) at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643) at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:163) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641) at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643) at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:199) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyo teHandler.java:324) at org.apache.jk.common.HandlerRequest.invoke(Handler Request.java:395) at org.apache.jk.common.ChannelSocket.invoke(ChannelS ocket.java:673) at org.apache.jk.common.ChannelSocket.processConnecti on(ChannelSocket.java:615) at org.apache.jk.common.SocketConnection.runIt(Channe lSocket.java:786) at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:683)
  6. 0

    Eclipse Community Forums: OSEE » Install problems

    eclipse.org | 7 months ago
    org.postgresql.util.PSQLException: ERROR: relation "osee_join_artifact" does not exist at org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:100) at org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:57) at org.eclipse.osee.framework.core.server.internal.task.CleanJo inTablesServerTask.run(CleanJoinTablesServerTask.java:56) at java.util.concurrent.Executors$RunnableAdapter.call(Executor s.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Future Task.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java: 150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.run(ScheduledThreadPoolExecutor.java:205) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Threa dPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo lExecutor.java:908)

    Root Cause Analysis

    1. org.postgresql.util.PSQLException

      ERROR: duplicate key value violates unique constraint "certnames_pkey" Detail: Key (name)=(dc202sessmdb-01.lhr4.dqs.booking.com) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[puppetdb.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[puppetdb.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[puppetdb.jar:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__6343.invoke(internal.clj:337) ~[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156) ~[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) ~[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278) ~[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2559) ~[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40) ~[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49) ~[puppetdb.jar:na] at clojure.lang.RT.seq(RT.java:484) ~[puppetdb.jar:na] at clojure.core$seq.invoke(core.clj:133) ~[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2855) ~[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) ~[na:na] at clojure.lang.RestFn.invoke(RestFn.java:423) ~[puppetdb.jar:na] at clojure.java.jdbc$insert_record.invoke(jdbc.clj:286) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125$fn__10126.invoke(storage.clj:1173) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10124$add_certname_BANG___10125.invoke(storage.clj:1170) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144$fn__10145.invoke(storage.clj:1183) ~[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10143$maybe_activate_node_BANG___10144.invoke(storage.clj:1175) ~[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:380) ~[na:na]

      at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke()
    2. com.puppetlabs
      jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke
      1. com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290)[na:na]
      1 frame
    3. notificationagent
      internal$transaction_STAR_.invoke
      1. clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204)[na:na]
      1 frame
    4. com.puppetlabs
      jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke
      1. com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290)[na:na]
      1 frame
    5. notificationagent
      internal$with_connection_STAR_.invoke
      1. clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186)[na:na]
      1 frame
    6. com.puppetlabs
      jdbc$with_transacted_connection_fn.invoke
      1. com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287)[na:na]
      2. com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259)[na:na]
      3. com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258)[na:na]
      4. com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250)[na:na]
      5. com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286)[na:na]
      5 frames
    7. com.puppetlabs.puppetdb
      command$eval11543$fn__11546.invoke
      1. com.puppetlabs.puppetdb.command$eval11543$fn__11546.invoke(command.clj:379)[na:na]
      1 frame
    8. Clojure
      MultiFn.invoke
      1. clojure.lang.MultiFn.invoke(MultiFn.java:231)[puppetdb.jar:na]
      1 frame
    9. com.puppetlabs.puppetdb
      Object$Callable$7da976d4.call
      1. com.puppetlabs.puppetdb.command$produce_message_handler$fn__11715.invoke(command.clj:647)[na:na]
      2. com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664$fn__11668.invoke(command.clj:554)[na:na]
      3. com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na]
      3 frames
    10. Apache Giraph Core
      Timer.time
      1. com.yammer.metrics.core.Timer.time(Timer.java:91)[puppetdb.jar:na]
      1 frame
    11. com.puppetlabs.puppetdb
      Object$Callable$7da976d4.call
      1. com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664.invoke(command.clj:553)[na:na]
      2. com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649$fn__11650.invoke(command.clj:507)[na:na]
      3. com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na]
      3 frames
    12. Apache Giraph Core
      Timer.time
      1. com.yammer.metrics.core.Timer.time(Timer.java:91)[puppetdb.jar:na]
      1 frame
    13. com.puppetlabs.puppetdb
      command$wrap_with_thread_name$fn__11673.invoke
      1. com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649.invoke(command.clj:506)[na:na]
      2. com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__11659.invoke(command.clj:529)[na:na]
      3. com.puppetlabs.puppetdb.command$wrap_with_meter$fn__11639.invoke(command.clj:467)[na:na]
      4. com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__11673.invoke(command.clj:569)[na:na]
      4 frames
    14. com.puppetlabs
      mq$create_message_listener$reify__10820.onMessage
      1. com.puppetlabs.mq$create_message_listener$reify__10820.onMessage(mq.clj:270)[na:na]
      1 frame
    15. Spring Framework
      DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run
      1. org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560)[puppetdb.jar:na]
      2. org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498)[puppetdb.jar:na]
      3. org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)[puppetdb.jar:na]
      4. org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)[puppetdb.jar:na]
      5. org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)[puppetdb.jar:na]
      6. org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)[puppetdb.jar:na]
      7. org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)[puppetdb.jar:na]
      8. org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)[puppetdb.jar:na]
      8 frames
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)[na:1.7.0_65]
      1 frame