Kirill Solomko f7652553e2 MT#58709 address update_sound_set_handle_parents() sp deadlocks ... * update_sound_set_handle_parents() procedure is redesigned to avoid "insert into select from" statements as they cause gap locks when run concurrently and access the same index rows. *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 6594 page no 6 n bits 56 index parent_id_idx of table `provisioning`.`voip_sound_sets` trx id 400852 lock mode S locks rec but not gap waiting the "insert into select from" statements are reworked: the "select from/with recursive" parts are now declared cursors and the data is inserted inside the opened cursor loop (if any). this way the selects are not causing exclusive gap locks. (cherry picked from commit 4017d3519c) Change-Id: I35ec28a33ecca42de898e67a2709eda4364e5f95		1 year ago
..
base	MT#33002 Move 15740.* scripts from base to diff folder	3 years ago
diff	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
init	…