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
..
accounting.json	MT#56542 Add sql and json schemes	2 years ago
accounting.sql	MT#56542 Add sql and json schemes	2 years ago
billing.json	MT#56542 Add sql and json schemes	2 years ago
billing.sql	MT#56542 Add sql and json schemes	2 years ago
carrier.json	MT#56542 Add sql and json schemes	2 years ago
carrier.sql	MT#56542 Add sql and json schemes	2 years ago
fileshare.json	MT#56542 Add sql and json schemes	2 years ago
fileshare.sql	MT#56542 Add sql and json schemes	2 years ago
kamailio.json	MT#56542 Add sql and json schemes	2 years ago
kamailio.sql	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
ldap.json	MT#56542 Add sql and json schemes	2 years ago
ldap.sql	MT#56542 Add sql and json schemes	2 years ago
ngcp.json	MT#57563 add ngcp.timezone version column, schemes update	2 years ago
ngcp.sql	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
prosody.json	MT#56542 Add sql and json schemes	2 years ago
prosody.sql	MT#56542 Add sql and json schemes	2 years ago
provisioning.json	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
provisioning.sql	MT#58709 address update_sound_set_handle_parents() sp deadlocks	1 year ago
sipstats.json	MT#56542 Add sql and json schemes	2 years ago
sipstats.sql	MT#56542 Add sql and json schemes	2 years ago
stats.json	MT#56542 Add sql and json schemes	2 years ago
stats.sql	MT#56542 Add sql and json schemes	2 years ago
syslog.json	MT#56542 Add sql and json schemes	2 years ago
syslog.sql	MT#56542 Add sql and json schemes	2 years ago