I might have spoken too soon. I'm getting some errors on deleting (when i delete a large number simultaneously, they work when issued serially).
Digging in on why, its a deadlock that exceeds the retriable limit.
: DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'INSERT INTO ipallocations (port_id, ip_address, subnet_id, network_id) VALUES (%(port_id)s, %(ip_address)s, %(subnet_id)s, %(network_id)s)'] [parameters: {'network_id': u'5e97298b-f175-493f-afc6-4492adeb3a9d', 'subnet_id': u'be0f3101-ff62-4ac0-901c-fc60bf561dd9', 'ip_address': '172.16.226.9', 'port_id': '0824d42b-3ed7-4dd5-a641-d7627530a638'}] : wrapped /usr/local/lib/python2.7/dist-packages/neutron/db/api.py:124
Deleting subnet cc57f513-40fe-4824-b9e8-a0b69e3f8e37 delete_subnet /usr/local/lib/python2.7/dist-packages/neutron/plugins/ml2/plugin.py:1062 : 2016-09-24 19:06:56.762 228 ERROR oslo_db.api [req-a671d942-fc21-4237-85b5-657f00c66bed - - - - -] DB exceeded retry limit.
I might have spoken too soon. I'm getting some errors on deleting (when i delete a large number simultaneously, they work when issued serially).
Digging in on why, its a deadlock that exceeds the retriable limit.
: DBDeadlock: (pymysql. err.InternalErr or) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'INSERT INTO ipallocations (port_id, ip_address, subnet_id, network_id) VALUES (%(port_id)s, %(ip_address)s, %(subnet_id)s, %(network_id)s)'] [parameters: {'network_id': u'5e97298b- f175-493f- afc6-4492adeb3a 9d', 'subnet_id': u'be0f3101- ff62-4ac0- 901c-fc60bf561d d9', 'ip_address': '172.16.226.9', 'port_id': '0824d42b- 3ed7-4dd5- a641-d7627530a6 38'}] lib/python2. 7/dist- packages/ neutron/ db/api. py:124
: wrapped /usr/local/
Deleting subnet cc57f513- 40fe-4824- b9e8-a0b69e3f8e 37 delete_subnet /usr/local/ lib/python2. 7/dist- packages/ neutron/ plugins/ ml2/plugin. py:1062 fc21-4237- 85b5-657f00c66b ed - - - - -] DB exceeded retry limit.
: 2016-09-24 19:06:56.762 228 ERROR oslo_db.api [req-a671d942-