Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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://folio-org.atlassian.net/wiki/display/REL/R1+2021+%28Iris%29+Release+Notes about the possible cleanup that is needed and the script

Environment

None

Potential Workaround

None

CSP Request Details

Approved at CPT at 7/12

CSP Approved

Yes

CSP Rejection Details

None

blocks

defines

is cloned by

relates to

Checklist

hide

TestRail: Results

Activity

Show:

Kateryna SenchenkoJuly 19, 2021 at 3:43 PM

Hi ,

I checked that there is no Snapshots with incorrect statuses left, closing this issue.

Oleksii PetrenkoJuly 16, 2021 at 5:34 PM

Deployed to Iris bugfest env. Please proceed with verification

Ann-Marie BreauxJuly 6, 2021 at 6:17 PM

Thanks, So we'll need to add a 0 point clone ticket, to count it as a Juniper bugfix also

Kateryna SenchenkoJuly 2, 2021 at 9:44 AM

Hi ,

I tested the added migration script on Rancher. Moving the ticket to Awaiting Release. Thank you!

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Development Team

Folijet Support

Parent

Fix versions

Release

R1 2021 Hot Fix #3

Affected Institution

Cornell

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created June 30, 2021 at 12:51 PM
Updated December 29, 2021 at 2:47 PM
Resolved July 2, 2021 at 9:45 AM
TestRail: Cases
TestRail: Runs

Flag notifications