Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-4424

Database migration 65 doesn't work on PostgreSQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: PDB 6.1.0, PDB 6.2.0, PDB 6.3.0, PDB 6.3.2
    • Fix Version/s: None
    • Component/s: PuppetDB
    • Labels:
      None
    • Environment:

      Debian Stretch, PuppetDB 6.1.0-6.3.3 (all tested)

    • Template:
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      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)
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                seidler Stefan Seidel
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Zendesk Support