puppetlabs / puppetlabs/puppetlabs-puppetdb
puppetdb fails to start after switching to v8.1.0
Open
Nobody has claimed this yet.
- Dominant language
- Puppet
- Stars
- 56
- Forks
- 231
- Avg merge
- 12d 2h
- Merged PRs (30d)
- 2
Description
Describe the Bug
Upgrading to module v8.1.0 renders puppetdb unoperational , service doesn't start
The following log entries are observed in puppetdb.log
2024-06-01T14:24:13.865Z INFO [p.p.c.services] PuppetDB version 8.5.1
2024-06-01T14:24:13.867Z INFO [p.p.c.services] Ensuring default database is up to date
2024-06-01T14:24:13.869Z INFO [c.z.h.HikariDataSource] PDBMigrationsPool: default - Starting...
2024-06-01T14:24:13.883Z INFO [c.z.h.HikariDataSource] PDBMigrationsPool: default - Start completed.
2024-06-01T14:24:16.900Z ERROR [p.p.c.services] Will retry database connection after temporary failure: java.sql.SQLTransientConnectionException: PDBMigrationsPool: default - Connection is not available, request timed out after 3014ms.
2024-06-01T14:24:19.900Z ERROR [p.p.c.services] Will retry database connection after temporary failure: java.sql.SQLTransientConnectionException: PDBMigrationsPool: default - Connection is not available, request timed out after 3000ms.
Reverting back to v8.0.1 restores functionality
Environment
postgresql14-libs-14.12-1PGDG.rhel9.x86_64
postgresql14-14.12-1PGDG.rhel9.x86_64
postgresql14-server-14.12-1PGDG.rhel9.x86_64
postgresql14-contrib-14.12-1PGDG.rhel9.x86_64
puppet8-release-1.0.0-8.el9.noarch
puppet-agent-8.6.0-1.el9.x86_64
puppetdb-termini-8.5.1-1.el9.noarch
puppetserver-8.6.0-1.el9.noarch
puppetdb-8.5.1-1.el9.noarch
AlmaLinux 9.4
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the failure in the listed AlmaLinux 9.4, PostgreSQL 14, PuppetDB 8.5.1 environment and compare module v8.1.0 with v8.0.1, using the puppetdb.log connection errors as the entry point. Done means PuppetDB starts successfully after upgrading to v8.1.0 without reverting.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100