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

PuppetDB crashes during startup migration with namespaced trgm indices

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: PDB 2.3.8
    • Fix Version/s: PDB 3.2.5, PDB 4.0.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      PuppetDB 2.3.8-1puppetlabs1 on Ubuntu 14.04
      Running against PostgreSQL 9.5

    • Template:
    • Story Points:
      1
    • Sprint:
      PuppetDB 2016-03-23

      Description

      Our PuppetDB instance runs against a managed PostgreSQL service hosting multiple databases. This means that indices end up being created under the 'puppetdb' namespace rather than the 'public' one.

      With pg_trgm indices enabled, PuppetDB crashes at startup as it tries to create duplicate indices during the migration operation. This is because it ends up looking in the 'public' namespace by default.

      In storage-utils, the default namespace for testing whether an index exists is 'public', which is not necessarily correct for a given deployment.

      The result is a BatchUpdateException, which kills the PuppetDB application straight away.

        Attachments

          Activity

            jsd-sla-details-panel

              People

              • Assignee:
                Unassigned
                Reporter:
                njmoriarty Nick Moriarty
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: