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

PDB migration error due to facts deduplication and null values

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: PDB 5.1.1
    • Fix Version/s: PDB 5.1.3
    • Component/s: None
    • Labels:
    • Template:
    • Team:
      Data Platform
    • Story Points:
      1
    • Sprint:
      Data Platform 2017-10-04, Data Platform 2017-10-18, Data Platform 2017-11-01
    • Method Found:
      Needs Assessment
    • Release Notes:
      Bug Fix
    • Release Notes Summary:
      Fixed a uniqueness bug in the recent fact data migration.
    • QA Risk Assessment:
      Needs Assessment

      Description

      NB: This used to be PDB-3686

      [4:14 PM] Russell Mull: there's two different ways that null is represented in the ops facts table
      [4:14 PM] Russell Mull: both have the correct null type
      [4:14 PM] Russell Mull: (4)
      [4:14 PM] Russell Mull: but one of them has the json string "null" as its value
      [4:14 PM] Russell Mull: and the other has the value set to sql null
      [4:15 PM] Russell Mull: when we recompute value hashes as part of the redupe migration, we unify the two
      [4:15 PM] Russell Mull: so they hash to the same thing
      [4:15 PM] Russell Mull: which is nearly always what we want; but in this case, because they're inhabiting two rows, it turns into a conflict

        Attachments

          Issue Links

            Activity

              jsd-sla-details-panel

                People

                • Assignee:
                  russell.mull Russell Mull
                  Reporter:
                  jeff.yarnell Jeff Yarnell
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  9 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: