Evergreen

Error in Vandelay org unit matching on copy

  1. Series 3.7
  2. Bug #1848375
Bug #1848375 reported by Jeff Davis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
New
Undecided
Unassigned
3.7
New
Undecided
Unassigned

Bug Description

On some systems, the vandelay.auto_overlay_org_unit_copies database function can be extremely slow and/or loop indefinitely. I haven't been able to reproduce the error consistently, but there are some issues with the function's while loop, and addressing those issues seemed to make the problem go away on systems where there was a problem. Fix forthcoming.

Revision history for this message
Jeff Davis (jdavis-sitka) wrote :

Working branch user/jeffdavis/lp1848375_auto_overlay_org_unit_copies has the fix:

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/jeffdavis/lp1848375_auto_overlay_org_unit_copies

If we run out of scope_args, cardinality(scope_args) is NULL rather than 0, so we need to check for that. In addition, we now exit early once we have a match, rather than preparing another iteration unnecessarily.

Terran McCanna (tmccanna)
tags: added: cat-importexport database performance
tags: added: pullrequest
Michele Morgan (mmorgan)
Changed in evergreen:
milestone: none → 3.8.1
Evergreen Bug Maintenance (bugmaster)
Changed in evergreen:
milestone: 3.8.1 → none
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.