You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

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
build_utils	MT#56542 Add tools to prepare sql and json dumps	2 years ago
db_scripts	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
debian	Release new version 11.3.2.0+0~mr11.3.2.0	2 years ago
schema	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
.gitreview	MT#7505 Add .gitreview file for db-schema	11 years ago
.mailmap	TT#91650 Add a .mailmap file to correct author information	5 years ago
last_file	TT#15855 Fix shellcheck warnings for repo to mark it as clean	8 years ago
next_id	TT#29623 Remove _not_replicated from the DB statement ID	7 years ago
ngcp-update-db-schema	MT#56542 Add support of custom location of db files	2 years ago