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

initial migration at first start fails puppetdb hangs.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: PDB 5.2.8, PDB 6.3.2
    • Fix Version/s: PDB 5.2.9, PDB 6.0.4, PDB 6.3.4
    • Component/s: PuppetDB
    • Environment:
    • Template:
    • Team:
      PuppetDB
    • Method Found:
      Needs Assessment
    • Release Notes:
      Bug Fix
    • Release Notes Summary:
      Hide
      Due to a bug in the most recent releases of PostgreSQL 9.4.23, 9.5.18, 9.6.14, 10.9, and 11.4 (Bug #15865 https://www.postgresql.org/message-id/15865-17940eacc8f8b081%40postgresql.org) a PuppetDB database migration would fail. PuppetDB's database migrations are now re-written to avoid triggering that bug (with no substantive change to what the migrations do).
      Show
      Due to a bug in the most recent releases of PostgreSQL 9.4.23, 9.5.18, 9.6.14, 10.9, and 11.4 (Bug #15865 https://www.postgresql.org/message-id/15865-17940eacc8f8b081%40postgresql.org) a PuppetDB database migration would fail. PuppetDB's database migrations are now re-written to avoid triggering that bug (with no substantive change to what the migrations do).
    • QA Risk Assessment:
      Needs Assessment

      Description

      installing puppetserver and hangs at puppetdb start.

      logs snip

      2019-06-25 17:23:53,655 INFO  [p.p.s.migrate] [4/8] Reconstructing facts to refer to fact_values...
      2019-06-25 17:23:53,659 INFO  [p.p.s.migrate] [5/8] Cleaning up duplicate null values...
      2019-06-25 17:23:53,662 INFO  [p.p.s.migrate] [6/8] Computing fact value hashes...
      2019-06-25 17:23:53,666 INFO  [p.p.s.migrate] [7/8] Indexing fact_values table...
      2019-06-25 17:23:53,682 INFO  [p.p.s.migrate] [8/8] Indexing facts table...
      2019-06-25 17:23:53,705 INFO  [p.p.s.migrate] Applied database migration version 64 in 70
      ms
      2019-06-25 17:23:53,706 INFO  [p.p.s.migrate] Applying database migration version 65
      2019-06-25 17:23:53,746 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.
              at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:133)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2004)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:360)
              at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:1019)

       

      full log avaliable if needed.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                austin.blatt Austin Blatt
                Reporter:
                evilbofh Felipe Garcia
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Zendesk Support