Activity log for bug #1533687

Date Who What changed Old value New value Message
2016-01-13 14:06:41 Sergey Belous bug added bug
2016-01-13 14:07:58 Sergey Belous summary Quota info in bd for floatingip is not updated immediately Quota info in DB for floatingip is not updated immediately
2016-01-13 14:08:11 Sergey Belous description The records in quotausages table for floatingip are not updated immediately after delete some (or all) floatingips. For example, if we set quota for floatingip to 5, create 5 floatingips and remove all of them, after that we can't create new floatingip: The error "Quota exceeded for resources: ['floatingip']." occurs. And at this time in mysql db we can see following: mysql> select * from quotausages; +----------------------------------+------------+-------+--------+----------+ | tenant_id | resource | dirty | in_use | reserved | +----------------------------------+------------+-------+--------+----------+ | fae4b729e0d543199331d6be300074fc | floatingip | 0 | 5 | 0 | | fae4b729e0d543199331d6be300074fc | network | 0 | 1 | 0 | +----------------------------------+------------+-------+--------+----------+ Steps to reproduce: 1. $ neutron quota-update --floatingip 5 2. $ for i in $(seq 1 5); do neutron floatingip-create public; done 3. Try to create another one floatingip (should not be created): $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 4. $ for ip in $(neutron floatingip-list -f csv -c id --quote=none | grep -v id); do neutron floatingip-delete $ip done 5. Try to create another one floatingip: $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 6. Check quotas info in db: mysql> use neutron mysql> select * from quotausages; Full log here: http://paste.openstack.org/show/483767/ The records in quotausages table for floatingip are not updated immediately after delete some (or all) floatingips. For example, if we set quota for floatingip to 5, create 5 floatingips and remove all of them, after that we can't create new floatingip: The error "Quota exceeded for resources: ['floatingip']." occurs. And at this time in mysql db we can see following: mysql> select * from quotausages; +----------------------------------+------------+-------+--------+----------+ | tenant_id | resource | dirty | in_use | reserved | +----------------------------------+------------+-------+--------+----------+ | fae4b729e0d543199331d6be300074fc | floatingip | 0 | 5 | 0 | | fae4b729e0d543199331d6be300074fc | network | 0 | 1 | 0 | +----------------------------------+------------+-------+--------+----------+ Steps to reproduce: 1. $ neutron quota-update --floatingip 5 2. $ for i in $(seq 1 5); do neutron floatingip-create public; done 3. Try to create another one floatingip (should not be created): $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 4. $ for ip in $(neutron floatingip-list -f csv -c id --quote=none | grep -v id); do neutron floatingip-delete $ip done 5. Try to create another one floatingip: $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 6. Check quotas info in bd: mysql> use neutron mysql> select * from quotausages; Full log here: http://paste.openstack.org/show/483767/
2016-01-13 14:11:36 Sergey Belous description The records in quotausages table for floatingip are not updated immediately after delete some (or all) floatingips. For example, if we set quota for floatingip to 5, create 5 floatingips and remove all of them, after that we can't create new floatingip: The error "Quota exceeded for resources: ['floatingip']." occurs. And at this time in mysql db we can see following: mysql> select * from quotausages; +----------------------------------+------------+-------+--------+----------+ | tenant_id | resource | dirty | in_use | reserved | +----------------------------------+------------+-------+--------+----------+ | fae4b729e0d543199331d6be300074fc | floatingip | 0 | 5 | 0 | | fae4b729e0d543199331d6be300074fc | network | 0 | 1 | 0 | +----------------------------------+------------+-------+--------+----------+ Steps to reproduce: 1. $ neutron quota-update --floatingip 5 2. $ for i in $(seq 1 5); do neutron floatingip-create public; done 3. Try to create another one floatingip (should not be created): $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 4. $ for ip in $(neutron floatingip-list -f csv -c id --quote=none | grep -v id); do neutron floatingip-delete $ip done 5. Try to create another one floatingip: $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 6. Check quotas info in bd: mysql> use neutron mysql> select * from quotausages; Full log here: http://paste.openstack.org/show/483767/ The records in quotausages table for floatingip are not updated immediately after delete some (or all) floatingips. For example, if we set quota for floatingip to 5, create 5 floatingips and remove all of them, after that we can't create new floatingip: The error "Quota exceeded for resources: ['floatingip']." occurs. And at this time in mysql bd we can see following: mysql> select * from quotausages; +----------------------------------+------------+-------+--------+----------+ | tenant_id | resource | dirty | in_use | reserved | +----------------------------------+------------+-------+--------+----------+ | fae4b729e0d543199331d6be300074fc | floatingip | 0 | 5 | 0 | | fae4b729e0d543199331d6be300074fc | network | 0 | 1 | 0 | +----------------------------------+------------+-------+--------+----------+ Steps to reproduce: 1. $ neutron quota-update --floatingip 5 2. $ for i in $(seq 1 5); do neutron floatingip-create public; done 3. Try to create another one floatingip (should not be created): $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 4. $ for ip in $(neutron floatingip-list -f csv -c id --quote=none | grep -v id); do neutron floatingip-delete $ip done 5. Try to create another one floatingip: $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 6. Check quotas info in bd: mysql> use neutron mysql> select * from quotausages; Full log here: http://paste.openstack.org/show/483767/
2016-01-13 14:12:41 Sergey Belous description The records in quotausages table for floatingip are not updated immediately after delete some (or all) floatingips. For example, if we set quota for floatingip to 5, create 5 floatingips and remove all of them, after that we can't create new floatingip: The error "Quota exceeded for resources: ['floatingip']." occurs. And at this time in mysql bd we can see following: mysql> select * from quotausages; +----------------------------------+------------+-------+--------+----------+ | tenant_id | resource | dirty | in_use | reserved | +----------------------------------+------------+-------+--------+----------+ | fae4b729e0d543199331d6be300074fc | floatingip | 0 | 5 | 0 | | fae4b729e0d543199331d6be300074fc | network | 0 | 1 | 0 | +----------------------------------+------------+-------+--------+----------+ Steps to reproduce: 1. $ neutron quota-update --floatingip 5 2. $ for i in $(seq 1 5); do neutron floatingip-create public; done 3. Try to create another one floatingip (should not be created): $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 4. $ for ip in $(neutron floatingip-list -f csv -c id --quote=none | grep -v id); do neutron floatingip-delete $ip done 5. Try to create another one floatingip: $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 6. Check quotas info in bd: mysql> use neutron mysql> select * from quotausages; Full log here: http://paste.openstack.org/show/483767/ The records in quotausages table for floatingip are not updated immediately after delete some (or all) floatingips. For example, if we set quota for floatingip to 5, create 5 floatingips and remove all of them, after that we can't create new floatingip: The error "Quota exceeded for resources: ['floatingip']." occurs. And at this time in mysql db we can see following: mysql> select * from quotausages; +----------------------------------+------------+-------+--------+----------+ | tenant_id | resource | dirty | in_use | reserved | +----------------------------------+------------+-------+--------+----------+ | fae4b729e0d543199331d6be300074fc | floatingip | 0 | 5 | 0 | | fae4b729e0d543199331d6be300074fc | network | 0 | 1 | 0 | +----------------------------------+------------+-------+--------+----------+ Steps to reproduce: 1. $ neutron quota-update --floatingip 5 2. $ for i in $(seq 1 5); do neutron floatingip-create public; done 3. Try to create another one floatingip (should not be created): $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 4. $ for ip in $(neutron floatingip-list -f csv -c id --quote=none | grep -v id); do neutron floatingip-delete $ip done 5. Try to create another one floatingip: $ neutron floatingip-create public Quota exceeded for resources: ['floatingip']. 6. Check quotas info in db: mysql> use neutron mysql> select * from quotausages; Full log here: http://paste.openstack.org/show/483767/
2016-01-13 16:25:29 Sergey Belous neutron: assignee Sergey Belous (sbelous)
2016-01-13 16:33:31 Sergey Belous neutron: status New In Progress
2016-01-22 19:12:50 Richard Theis bug added subscriber Richard Theis
2016-01-29 23:14:43 OpenStack Infra neutron: status In Progress Fix Released
2016-02-01 16:26:45 OpenStack Infra tags in-stable-liberty