readthefuckingmanual.net

[SOLVED] Recoverable error: Quota exceeded for resources: ['floatingip']

Error added: 2016-04-12T09:08:12Z

0 people waiting for the answer...

1 answers found.

mysql -D neutron -u neutron -p 
UPDATE quotausages q SET q.in_use = (SELECT COUNT(f.floating_ip_address) FROM floatingips f WHERE f.tenant_id=q.tenant_id) WHERE q.resource='floatingip' AND q.in_use != (SELECT COUNT(f.floating_ip_address) FROM floatingips f WHERE f.tenant_id=q.tenant_id);

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.

If you want to be notified via email when this is solved, enter your email address here: