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

Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: PDB 6.5.0
    • Fix Version/s: PDB 5.2.10, PDB 6.3.5, PDB 6.7.1
    • Component/s: PuppetDB
    • Environment:
    • Template:
    • Team:
      PuppetDB
    • Method Found:
      Customer Feedback
    • Release Notes:
      Bug Fix
    • Release Notes Summary:
      PuppetDB migrations require the postgres database the setting `standard_conforming_strings` to be `true`. Before a Postgres exception would terminate startup, now we will verify that setting before checking if any migrations are necessary.
    • QA Risk Assessment:
      Needs Assessment

      Description

      On first start of puppetdb after install it is failing with error: 

      2019-09-18T13:31:10.415-04:00 INFO [p.p.s.migrate] Applying database migration version 43
      2019-09-18T13:31:10.456-04:00 ERROR [p.p.s.migrate] Caught SQLException during migration
      java.sql.BatchUpdateException: Batch entry 1 CREATE AGGREGATE sha1_agg (BYTEA)
      (
      sfunc = dual_sha1,
      stype = bytea,
      initcond = '\x00'
      ) was aborted: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Call getNextException to see other errors in the batch.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                austin.blatt Austin Blatt
                Reporter:
                skreien Scot Kreienkamp
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Zendesk Support