Jira (PDB-4424) Database migration 65 doesn't work on PostgreSQL

[Stefan Seidel (JIRA)]

Stefan Seidel created an issue

PuppetDB / PDB-4424 Database migration 65 doesn't work on PostgreSQL Issue Type: Bug Affects Versions: PDB 6.3.2, PDB 6.3.0, PDB 6.2.0, PDB 6.1.0 Assignee: Unassigned Components: PuppetDB Created: 2019/06/25 1:53 PM Environment: Debian Stretch, PuppetDB 6.1.0-6.3.3 (all tested) Priority: Normal Reporter: Stefan Seidel Cannot start PuppetDB on a newly created database: 2019-06-25T22:50:12.465+02:00 INFO [p.p.s.migrate] Applying database migration version 65 2019-06-25T22:50:12.505+02:00 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: ERROR: relation "resource_events_status_for_corrective_change_idx" already exists Call getNextException to see other errors in the ba tch. at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148) Add Comment

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