[PuppetDB] Error 500 'Failed to execute '/pdb/cmd/v1....'

1,210 views
Skip to first unread message

Nir Fishler

unread,
Sep 30, 2022, 4:30:35 AM9/30/22
to Puppet Users
Hello,

puppetserver version: 7.8.0  (CentOS 7) | hostname:  puppet-staging-srv
puppet agent: 7.19
puppetdb: 7.11.0-1focal (Ubuntu 20.04) | hostname: puppet-staging-srv-db
Postgres: 12.12-0ubuntu0.20.04.1

Foreman is enabled on Puppetserver.
Postgres is configured to work with SSL.

Getting the below error from ANY VM on the network whenever I try to sync with Puppet master server.

Error message:
Error: Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: Failed to execute '/pdb/cmd/v1?checksum=a0d1b67028ed455a4d8b15fd5fc846ca54d4c0a6&version=5&certname=vm-ubuntu20&command=replace_facts&producer-timestamp=2022-09-30T07:47:13.621Z' on at least 1 of the following 'server_urls': https://puppet-staging-srv-db:8081
Warning: Not using cache on failed catalog
Error: Could not retrieve catalog; skipping run

However, When I remove the configuration files(puppetdb.conf , values from puppet.conf, routes.yaml) from the Puppet master $CONF dir, everything is back to normal and sync works.

Connection between Puppet master and puppetdb and vice vesra:
[root@puppet-staging-srv puppet] nc -zvw10 puppet-staging-srv-db 8081
Ncat: Version 7.50 ( https://nmap.org/ncat )
Ncat: Connected to 10.111.8.77:8081.

root@puppet-staging-srv-db:~# nc -zvw10 puppet-staging-srv 8140
Connection to puppet-staging-srv 8140 port [tcp/puppet] succeeded!

PuppetDB website is UP and shows zero data on 'Active Nodes' and most of the fields(see screenshot snap-1.png.)

Thanks in advanced!
snap-1.png

Martin Alfke

unread,
Oct 10, 2022, 4:03:05 AM10/10/22
to puppet...@googlegroups.com
Hi Nir,

Please check the puppetdb log file for further error investigation.
Usually this is located at /var/log/puppetlabs/puppetdb/puppetdb.log

Hth,
Martin


--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/af30e761-f765-4260-978e-b4817e42f3b8n%40googlegroups.com.
<snap-1.png>

Nir Fishler

unread,
Oct 31, 2022, 5:39:21 AM10/31/22
to Puppet Users
Hey Martin,

Thanks for your reply. 

There are three files underneath that directory:
  • puppetdb-access.log
  • puppetdb.log
  • puppetdb-status.log
but all seem to be empty - 0kb
what does that mean?

Martin Alfke

unread,
Oct 31, 2022, 6:14:31 AM10/31/22
to puppet...@googlegroups.com
How did you configure puppetdb and puppetserver?
On Open Source we usually recommend the puppetlabs-puppetdb module.


Nir Fishler

unread,
Nov 2, 2022, 3:18:14 AM11/2/22
to Puppet Users
I tried to configure it using two different methods;
  1. Installing PuppetDB via Puppet module
  2. Installing from packages
neither one of the above had given a complete success.

Martin Alfke

unread,
Nov 2, 2022, 9:58:17 AM11/2/22
to puppet...@googlegroups.com
Can you provide the code, you used with puppetdb module?

Nir Fishler

unread,
Nov 9, 2022, 5:00:34 AM11/9/22
to Puppet Users
Hey again,

I managed to gather some logs (puppetdb.log) attached.

Thanks.
puppetdb.log
Reply all
Reply to author
Forward
0 new messages