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

PuppetDB crashes during startup migration with namespaced trgm indices

    XMLWordPrintable

    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

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support