Bug 37035 - Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled
Summary: Merging authorities triggers rebuilding holds for all affected records when R...
Status: Failed QA
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low major
Assignee: Kyle M Hall (khall)
QA Contact: Emily Lamancusa (emlam)
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-05 14:53 UTC by Kyle M Hall (khall)
Modified: 2024-11-14 16:15 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled (1.53 KB, patch)
2024-06-05 14:56 UTC, Kyle M Hall (khall)
Details | Diff | Splinter Review
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled (1.57 KB, patch)
2024-06-05 14:59 UTC, Kyle M Hall (khall)
Details | Diff | Splinter Review
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled (1.64 KB, patch)
2024-06-05 15:35 UTC, Matt Blenkinsop
Details | Diff | Splinter Review
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled (1.70 KB, patch)
2024-06-12 13:58 UTC, Emily Lamancusa (emlam)
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall (khall) 2024-06-05 14:53:06 UTC
If RealTimeHoldsQueue is on, merging authorities triggers a update_holds_queue_for_biblios background job for each affected record. This can result in thousands of unnecessary queued jobs since this change will not affect hold-ability. In a large catalog this can be a crippling number of background jobs that will delay more important jobs.
Comment 1 Kyle M Hall (khall) 2024-06-05 14:56:17 UTC
Created attachment 167444 [details] [review]
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled

If RealTimeHoldsQueue is on, merging authorities triggers a update_holds_queue_for_biblios background job for each affected record. This can result in thousands of unnecessary queued jobs since this change will not affect hold-ability. In a large catalog this can be a crippling number of background jobs that will delay more important jobs.

Test Plan:
1) Enable RealTimeHoldsQueue
2) Merge authorities with merge_authorities.pl
3) Note a update_holds_queue_for_biblios background job is queued for each record touched
4) Apply this match
5) Merge authorities again
6) Note that no update_holds_queue_for_biblios jobs were queued
Comment 2 Kyle M Hall (khall) 2024-06-05 14:59:15 UTC
Created attachment 167445 [details] [review]
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled

If RealTimeHoldsQueue is on, merging authorities triggers a update_holds_queue_for_biblios background job for each affected record. This can result in thousands of unnecessary queued jobs since this change will not affect hold-ability. In a large catalog this can be a crippling number of background jobs that will delay more important jobs.

Test Plan:
1) Enable RealTimeHoldsQueue
2) Merge authorities with merge_authorities.pl
3) Note a update_holds_queue_for_biblios background job is queued for each record touched
4) Apply this match
5) Merge authorities again
6) Note that no update_holds_queue_for_biblios jobs were queued
Comment 3 Matt Blenkinsop 2024-06-05 15:35:20 UTC
Created attachment 167456 [details] [review]
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled

If RealTimeHoldsQueue is on, merging authorities triggers a update_holds_queue_for_biblios background job for each affected record. This can result in thousands of unnecessary queued jobs since this change will not affect hold-ability. In a large catalog this can be a crippling number of background jobs that will delay more important jobs.

Test Plan:
1) Enable RealTimeHoldsQueue
2) Merge authorities with merge_authorities.pl
3) Note a update_holds_queue_for_biblios background job is queued for each record touched
4) Apply this match
5) Merge authorities again
6) Note that no update_holds_queue_for_biblios jobs were queued

Signed-off-by: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Comment 4 Emily Lamancusa (emlam) 2024-06-12 13:49:07 UTC
Small, logical change. Code looks good and QA tool passes. Passing QA
Comment 5 Emily Lamancusa (emlam) 2024-06-12 13:58:49 UTC
Created attachment 167662 [details] [review]
Bug 37035: Merging authorities triggers rebuilding holds for all affected records when RealTimeHoldsQueue is enabled

If RealTimeHoldsQueue is on, merging authorities triggers a update_holds_queue_for_biblios background job for each affected record. This can result in thousands of unnecessary queued jobs since this change will not affect hold-ability. In a large catalog this can be a crippling number of background jobs that will delay more important jobs.

Test Plan:
1) Enable RealTimeHoldsQueue
2) Merge authorities with merge_authorities.pl
3) Note a update_holds_queue_for_biblios background job is queued for each record touched
4) Apply this match
5) Merge authorities again
6) Note that no update_holds_queue_for_biblios jobs were queued

Signed-off-by: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov>
Comment 6 Martin Renvoize (ashimema) 2024-06-13 12:32:05 UTC
Any chance of a unit test here Kyle?  Prevent a future regression and all that ;P