Github user serg38 commented on the issue:
https://github.com/apache/cloudstack/pull/1762
@rafaelweingartner Looks like the deadlocks 2 and 3 are the same. I
scanned our production log and since last December we had 6400 deadlocks. Out
of them close to 6000 were Deadlock 1
20 were Deadlock 2 and 700 of a different Deadlock 5. The other deadlocks
were in negligible numbers. I think if we figure out Deadlock 1 and Deadlock 5
this will be good start. I will try to find the source of transactions for
them. In production we run a commercial distribution based in most part on 4.7
branch of ACS.
Deadlock 5
*** (1) TRANSACTION:
TRANSACTION D518886F8, ACTIVE 2 sec fetching rows
mysql tables in use 4, locked 4
LOCK WAIT 24 lock struct(s), heap size 3112, 8 row lock(s), undo log
entries 17
MySQL thread id 29781, OS thread handle 0x7f9df36db700, query id 3625404021
ussclpdcsmgt012.autodesk.com 10.41.13.14 cloud Sorting result
SELECT user_ip_address.id, user_ip_address.account_id,
user_ip_address.domain_id, user_ip_address.public_ip_address,
user_ip_address.data_center_id, user_ip_address.source_n
at, user_ip_address.allocated, user_ip_address.vlan_db_id,
user_ip_address.one_to_one_nat, user_ip_address.vm_id, user_ip_address.state,
user_ip_address.mac_address, user_ip
_address.source_network_id, user_ip_address.network_id,
user_ip_address.uuid, user_ip_address.physical_network_id,
user_ip_address.is_system, user_ip_address.vpc_id, user_ip
_address.dnat_vmip, user_ip_address.is_portable, user_ip_address.display,
user_ip_address.removed, user_ip_address.created FROM user_ip_address INNER
JOIN vlan ON user_ip_a
ddress.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 6 AND
user_ip_address.allocated IS NULL AND user_ip_address.vlan_db_id IN
(32,33,36,37,41,61,62,91,92,93,9
4,106,107,108,109,11
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
*** (2) TRANSACTION:
TRANSACTION D5188582B, ACTIVE 17 sec updating or deleting, thread declared
inside InnoDB 499
mysql tables in use 1, locked 1
25 lock struct(s), heap size 3112, 13 row lock(s), undo log entries 18
MySQL thread id 29820, OS thread handle 0x7fa35a868700, query id 3625417999
ussclpdcsmgt013.autodesk.com 10.41.13.15 cloud Updating
UPDATE user_ip_address SET user_ip_address.source_nat=0,
user_ip_address.is_system=0, user_ip_address.account_id=3309,
user_ip_address.allocated='2016-03-25 15:36:39',
user_ip_address.state='Allocated', user_ip_address.domain_id=335 WHERE
user_ip_address.id = 3284
*** (2) HOLDS THE LOCK(S):
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
