Uploaded image for project: 'Portal'
  1. Portal
  2. POR-2872

Pro parte usages need several nub ids assigned

        Details

        • Type: Bug Bug
        • Status: Resolved
        • Priority: Blocker Blocker
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: Checklistbank
        • Labels:
          None

          Description

          The intermediate neo dbs for the nub and indexed checklists contain a single neo4j node for a pro parte synonym that has multiple accepted parents. In the postgres db model these get expanded into individual name_usage records and need to have their own primary key.

          For indexed checklists thats no problem as the ids get assigned during inserts from the regular pg sequence.

          For nub usages the ids should all exist in advance to preserve stable ids over time. A single neo4j pro parte synonym must therefore have multiple ids assigned. Use the additional PROPARTE_SYNONYM relationship to store the usageKey to be read during imports!

            Gliffy Diagrams

            + Add Diagram

            Issue Links

            blocks

            Epic - A big user story that needs to be broken down. POR-2467 New backbone building algorithm

            • Major - Major loss of function.
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. POR-3003 Nub builds have usage keys from postgres sequence

            • Critical - Crashes, loss of data, severe memory leak.
            • Closed

              Activity

              Hide
              Permalink
              Markus Döring added a comment -

              https://github.com/gbif/checklistbank/commit/008fe6d6fae1ccf1421235a85c1ebd72ec7ce13a

              Show
              Markus Döring added a comment - https://github.com/gbif/checklistbank/commit/008fe6d6fae1ccf1421235a85c1ebd72ec7ce13a

                People

                • Assignee:
                  Markus Döring
                  Reporter:
                  Markus Döring
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: