Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-329

Create script to clean up Snapshot statuses in mod-source-record-storage (Iris Hotfix)

    XMLWordPrintable

Details

    • 1
    • Folijet Support
    • R1 2021 Hot Fix #3
    • Yes
    • Approved at CPT at 7/12
    • Cornell

    Description

      Problem summary: updating of some older records failed, because they were created by some older jobs that did not complete successfully. Such records were tied to an entity that stored metadata about the job, and the status of that metadata entity was incorrect due to some troubles with updating the status (it could have happened at the time that mod-source-record-storage was unavailable). As a result, newly imported records for update couldn't be saved in mod-source-record-storage with updated generation.

      Resolution:

      1. The issue can be resolved on the DB side of mod-source-record-storage - every Snapshot status other than COMMITTED should be set to ERROR in the snapshots_lb table. For future releases (Iris Hot Fix #3, Juniper Bugfix) Folijet will add a migration script to ensure that the data in mod-source-record-storage is correct and there are no invalid job/snapshot statuses.
      2. Add note to https://wiki.folio.org/display/REL/R1+2021+%28Iris%29+Release+Notes about the possible cleanup that is needed and the script

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MODSOURCE-330 Release v5.0.6 (R1 Iris Hot Fix #3)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            defines

            New Feature - New feature requests UXPROD-2851 NFR: Data Import (Batch Importer for Bib Acq) & PubSub R2 2021 Juniper Technical, NFR, & Misc bug work

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            is cloned by

            Task - A task that needs to be done. MODSOURCE-335 Create script to clean up Snapshot statuses in mod-source-record-storage (Juniper bugfix)

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODDATAIMP-478 After upgrade from Iris Hotfix 1 to Hotfix 2 -- observing errors on DI import

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-397 Import fails with "'idx_records_matched_id_gen', duplicate key value violates unique constraint" SRS logs JUNIPER HF

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-399 Import fails with "'idx_records_matched_id_gen', duplicate key value violates unique constraint" SRS logs KIWI BF

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-400 Import fails with "'idx_records_matched_id_gen', duplicate key value violates unique constraint" SRS logs LOTUS

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed
            mentioned in

            Page Loading...

            Activity

              People

                Kateryna Senchenko Kateryna Senchenko
                abreaux Ann-Marie Breaux
                Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases