Jira (PDB-510) ERROR: duplicate key value violates unique constraint "catalogs_pkey"

[Tyler Parsons (JIRA)]

Title: Message Title

Tyler Parsons commented on an issue   Re: ERROR: duplicate key value violates unique constraint "catalogs_pkey" Kenneth, The machine has plenty of disk space, and nothing concerning occurred while the package was updating or while the service started. The service did take some time to become operational (~6 minutes or so). 2014-03-06 07:50:20,706 INFO [Thread-4] [cli.services] Shutdown request received; puppetdb exiting. 2014-03-06 07:52:57,518 INFO [main] [cli.services] PuppetDB version 1.6.2 2014-03-06 07:52:58,578 WARN [main] [scf.migrate] Building resource parameters cache. This make take a few minutes, but faster resource queries are worth it. 2014-03-06 07:58:45,792 INFO [main] [cli.services] Starting broker 2014-03-06 07:58:46,958 WARN [main] [broker.BrokerService] Store limit is 100000 mb, whilst the data directory: /var/lib/puppetdb/mq/localhost/KahaDB only has 37711 mb of usable space 2014-03-06 07:58:46,958 ERROR [main] [broker.BrokerService] Temporary Store limit is 50000 mb, whilst the temporary data directory: /var/lib/puppetdb/mq/localhost/tmp_storage only has 37711 mb of usable space 2014-03-06 07:58:46,959 INFO [main] [cli.services] Starting 8 command processor threads 2014-03-06 07:58:46,975 INFO [main] [cli.services] Starting query server 2014-03-06 07:58:46,982 INFO [pool-3-thread-1] [cli.services] Starting database garbage collection 2014-03-06 07:58:47,010 INFO [clojure-agent-send-off-pool-11] [server.Server] jetty-7.x.y-SNAPSHOT 2014-03-06 07:58:47,079 INFO [clojure-agent-send-off-pool-11] [server.AbstractConnector] Started SelectChannelConnector@localhost:8080 2014-03-06 07:58:47,256 INFO [clojure-agent-send-off-pool-11] [ssl.SslContextFactory] Enabled Protocols [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2] of [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2] 2014-03-06 07:58:47,269 INFO [clojure-agent-send-off-pool-11] [server.AbstractConnector] Started SslSelectChannelConnector@***:8081 2014-03-06 07:59:48,869 INFO [pool-3-thread-1] [cli.services] Finished database garbage collection 2014-03-06 07:59:48,871 INFO [pool-3-thread-1] [cli.services] Starting sweep of stale reports (threshold: 14 days) 2014-03-06 07:59:48,919 INFO [pool-3-thread-1] [cli.services] Finished sweep of stale reports (threshold: 14 days) Thanks, ~Tyler Add Comment   PuppetDB / PDB-510 ERROR: duplicate key value violates unique constraint "catalogs_pkey" We receive these errors every few minutes. Our logs indicate that these error began to occurring once our puppetdb instance was upgraded from 1.5.2 -> 1.6.2. {code} 2014-03-12 15:33:03,107 ERROR [command-proc-82] [puppetdb.command] [7b979257-dda8-4d46-b8b2-242b88611523] [replace catalog] Retrying after attempt 12, due to: org.postgresql.util.PSQLEx... This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.