mysql queries deadlock detected
2020-03-24 00:50:29.834 ERROR [kea-dhcp4.alloc-engine/16239] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:0c:01:02:03:0c], cid=[01:00:0c:01:02:03:0c], tid=0x8: error during attempt to allocate an IPv4 address: unable to execute for <INSERT INTO lease4(address, hwaddr, client_id, valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev, hostname, state, user_context) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>, reason: Deadlock found when trying to get lock; try restarting transaction (error code 1213)
2020-03-24 01:33:24.001 ERROR [kea-dhcp6.alloc-engine/22914] ALLOC_ENGINE_V6_ALLOC_ERROR duid=[00:01:00:01:26:0c:1f:e3:00:0c:01:02:03:10], tid=0x26: error during attempt to allocate an IPv6 address: unable to execute for <INSERT INTO lease6(address, duid, valid_lifetime, expire, subnet_id, pref_lifetime, lease_type, iaid, prefix_len, fqdn_fwd, fqdn_rev, hostname, hwaddr, hwtype, hwaddr_source, state, user_context) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>, reason: Deadlock found when trying to get lock; try restarting transaction (error code 1213)
I have got these 2 errors in total after running 50 tests for each type (v4/v6na/v6pd) for 10 sec with 4 x 20000 pkts/s..so this is pretty rare
Edited by Razvan Becheriu