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

PDB migration error due to facts deduplication and null values

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • PDB 5.1.1
    • PDB 5.1.3
    • PuppetDB
    • Data Platform
    • 1
    • Data Platform 2017-10-04, Data Platform 2017-10-18, Data Platform 2017-11-01
    • Needs Assessment
    • Bug Fix
    • Fixed a uniqueness bug in the recent fact data migration.
    • 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

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support