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.

Answer 2373 (100.0% helpful)

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:

Psst - want to help build a list of common error messages?
Put the following line in your /etc/[r]syslog.conf file:

*.emerg,*.alert,*.crit,*.err       @syslog.readthefuckingmanual.net