Jira (PDB-4423) Cannot install PDB with puppetlabs-puppetdb module with newest version postgresql96-9.6.14-1PGDG.rhel7.x86_64

[Alexander Dubskiy (JIRA)]

Alexander Dubskiy created an issue

PuppetDB / PDB-4423 Cannot install PDB with puppetlabs-puppetdb module with newest version postgresql96-9.6.14-1PGDG.rhel7.x86_64 Issue Type: Bug Affects Versions: PDB 6.3.2, PDB 5.2.8 Assignee: Unassigned Components: PuppetDB Created: 2019/06/25 3:00 AM Environment: Fresh install of CentOS 7.6.1810 x86_64 Added repos: epel, puppet5-release-el-7 Installed and started puppetserver Installed modules: /etc/puppetlabs/code/modules ├── puppetlabs-apt (v7.0.1) ├── puppetlabs-concat (v6.0.0) ├── puppetlabs-firewall (v2.0.0) ├── puppetlabs-inifile (v3.0.0) ├── puppetlabs-postgresql (v6.1.0) ├── puppetlabs-puppetdb (v7.3.0) ├── puppetlabs-stdlib (v6.0.0) └── puppetlabs-translate (v1.2.0) Priority: Blocker Reporter: Alexander Dubskiy When installing PuppetDB using the command: puppet apply -e "include puppetdb" installation hangs at starting puppetdb service. In /var/log/puppetlabs/puppetdb/puppetdb.log: 2019-06-25 12:53:03,248 INFO [p.p.s.migrate] Applying database migration version 65 2019-06-25 12:53:03,282 ERROR [p.p.s.migrate] Caught SQLException during migration java.sql.BatchUpdateException: Batch entry 1 alter table resource_events alter column status type text, alter column property type text, alter column containing_class type text, alter column file type text was aborted. Call getNextException to see the cause. ... 2019-06-25 12:53:03,284 ERROR [p.p.s.migrate] Unravelled exception org.postgresql.util.PSQLException: ERROR: relation "resource_events_status_for_corrective_change_idx" already exists ...     This started happening with the new version 9.6.14-1PGDG.rhel7 of postgresql rpm made available recently via yum.postgresql.org/7/x86_64. When I first install previous version 9.6.13 installation goes without problems.   Add Comment

This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)

[Fredrik Larsson (JIRA)]

Fredrik Larsson commented on PDB-4423

Re: Cannot install PDB with puppetlabs-puppetdb module with newest version postgresql96-9.6.14-1PGDG.rhel7.x86_64 Duplicate of PDB-4422

Add Comment