-
Type: Improvement
-
Status: Resolved
-
Priority: Critical
-
Resolution: Fixed
-
Affects Version/s: 3.18.0
-
Fix Version/s: 3.23.0
-
Component/s: Connect / Account Management
-
Team:NOS
-
Sprint:NOS 11.1.17 - 2019-09 1, NOS 11.1.18 - 2019-09 2, NOS 11.1.20 - 2019-10 2, NOS 11.1.19 - 2019-10 1, NOS 11.1.22 - 2019-11 2
-
Story Points:3
The current migration listener that triggers the migration could be improved:
- relying on a 24h Transaction is never a good idea, it creates locks on the table that will make other threads wait for modification
- we could be able to execute it as a batch of small execution, in order to better track completion
Goal of this ticket is to improve the current execution, by:
- removing usage of dedicated transactions handling
- rewriting the initial query to use a `queryAndFetch` (aka relying as less as possible on Adapter - to make work more efficient -) (relying on NXCONNECT-2160 could be a plus)
- extracting package migration logic to a Work
- queuing each package migration in a single-threaded queue
- is required by
-
NXS-5547 Avoid relying on field "restrictedToOrgs" for public packages
- Resolved