Postgres versions released last Thursday June 20th <https://www.postgresql.org/about/news/1949/> contain a regression in the behavior of the ALTER TABLE statement that is causing this issue by preventing PuppetDB from initializing its database schema. A concise summary of the issue can be found in this message to the Postgres mailing list:
https://www.postgresql.org/message-id/20190621004554.GB1626%40paquier.xyz A patch has been merged to work around the issue and is currently pending release: https://tickets.puppetlabs.com/browse/PDB-4422 Until PuppetDB or Postgres release a new version, the best workaround is to use an older version of Postgres such as 9.6.13. -Charlie On Wednesday, June 26, 2019 at 7:39:48 AM UTC-7, Farko wrote: > > Hi all! > > Added the puppetdb module, runs through and gets stuck on boot with the > following error: > > 2019-06-26 14:20:21,638 INFO [p.p.s.migrate] Applying database migration > version 65 > > 2019-06-26 14:20:21,673 ERROR [p.p.s.migrate] Caught SQLException during > migration > > ... > > 2019-06-26 14:20:21,675 ERROR [p.p.s.migrate] Unravelled exception > org.postgresql.util.PSQLException: ERROR: relation > "resource_events_status_for_corrective_change_idx" already exists > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:360) > at > org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:1019) > > Tried dropping the puppetdb database, and restarting puppetdb, same error > occurs. > > puppetdb version: 5.2.8 > > Thank you! > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/86932f55-f2ee-494c-a6fa-eb7a287ec364%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
