Migration Issue from Kiwi-Lotus

Description

When we try to migrate mod-notes from Kiwi(v2.13.2) to Lotus(v3.0.0), this particular query below takes over 3 hours - we were not able to figure out when the query ran to completion because there are absolutely no logs at the module level. The client has 300k+ note_data records in Kiwi.

 

Expected Results: 
Total Migration of all modules completes successfully within 2 hours 

Actual Results: 
This specific query takes over 3+ hours and we'll try our best to get the accurate time for it to complete for 300k+ records

We checked bugfest-lotus and it has < 1000 records in note_data table - so probably wasn't encountered there as an issue. 

 

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

Checklist

hide

TestRail: Results

Activity

Show:

Natalia Zaitseva May 13, 2022 at 2:50 PM

 closed based on Sobha comment

Natalia Zaitseva May 12, 2022 at 2:07 PM

deployed to lotus bugfest

Sobha Duvvuri May 9, 2022 at 11:43 PM

: I tested and it took ~8 mins - Please go ahead and release it - Thank you for the quick turnaround.

Viacheslav Kolesnyk May 9, 2022 at 6:35 PM

Sobha Duvvuri May 9, 2022 at 5:43 PM

: Perfect, what's the branch we should use to build and test mod-notes?

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Lotus (R1 2022) Hot Fix #1

RCA Group

Data related (ex. Can be detected with large dataset only)

Affected Institution

!!!ALL!!!

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created May 2, 2022 at 8:10 PM
Updated June 1, 2022 at 3:12 PM
Resolved May 10, 2022 at 2:41 PM
TestRail: Cases
TestRail: Runs