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.