Mathew Crane
2014-May-30 14:12 UTC
[Puppet Users] puppetdb '[replace catalog]' postgresql errors with index 'catalog_resources_pkey'
I am moving our environment from puppet 2.7.1 with puppet dashboard to puppet 3.5.1 with puppetdb 2.0. During testing on a separate host with the identical setup as our puppet CA, everything seems to be functioning properly: puppet agents are able to be added on the master and receive everything they should, and I'm able to query the pgsl db and API and view information and facts. However, I've noticed two concerning things in the logs below. I am by no means a pgsl expert, and after enabling debug logging I'm unable to tell why it's firing these alerts. Do I need to tune the db somehow, or is there something off in my configs? 1.) After inserting node information into catalog_resources, an error occurs in /var/log/puppetdb/puppetdb.log: 2014-05-30 08:20:15,328 ERROR [c.p.p.command] [...] [replace catalog] Retrying after attempt 6, due to: org.postgresql.util.PSQLException: ERROR: index row size 4296 exceeds maximum 2712 for index "catalog_resources_pkey" Hint: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing. 2.) Additionally, I am seeing a lot of deprecation warnings in /var/log/puppetdb/puppetdb.log, like below. I would think that puppet 3.5.1 with puppetdb 2.0 wouldn't fire these? Are they safe to ignore? '2014-05-30 08:39:36,021 WARN [c.p.p.command] command 'replace catalog' version 3 is deprecated, use the latest version' Here is my config on the test CA: /etc/puppet/puppet.conf: [main] logdir = /var/log/puppet rundir = /var/run/puppet ssldir = $vardir/ssl [agent] server = puppetca.fqdn environment = live classfile = $vardir/classes.txt localconfig = $vardir/localconfig pluginsync = true [master] environment = live certname = puppetca.fqdn dns_alt_names = puppetca ca_name = 'TEST CA' storeconfigs = true storeconfigs_backend = puppetdb reports = store,puppetdb ssl_client_header = SSL_CLIENT_S_DN ssl_client_verify_header = SSL_CLIENT_VERIFY pluginsync=true -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/78db99c9-74a9-46f8-ad91-a251d5922f08%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.