Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-811

Populate publicationPeriod from dateOfPublication fields

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: TBD
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Template:

      Description

      This issue is for automating the manual migration task.

      When saving or updating an instance publicationPeriod gets initialized with the values from the dateOfPublication fields of the publication array of the instance (MODINVSTOR-724).

      When migrating mod-inventory-storage to a version from the range 21.0.0 to 21.0.6 the publicationPeriod of all existing instances got automatically populated during the migration (MODINVSTOR-724). This took several hours (5 hours, or 36 hours) if there are millions of instances to migrate (MODINVSTOR-774). This is too long because the system is down and cannot been used during migration. Therefore this time consuming migration has been disabled for mod-inventory-storage >= 21.0.7 (MODINVSTOR-806).

      SysOps can manually run an SQL script to migrate existing instances:

      https://github.com/folio-org/mod-inventory-storage/blob/master/src/main/resources/templates/db_scripts/populatePublicationPeriod.sql

      This issue is for automating this manual task. Goal is to run the migration without blocking the system, when a chunk of instances (for example 1000 instances) is migrated all other instances can still be used and edited.

      Open question: Is there a need for automating the migration or can SysOps adopt the migration script and share how they manually migrate?

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases