I wrote about problems with nova quotas in OpenStack recently.
After some testing I’ve discovered an issue with the script I wrote to fix quotas. Database queries were case insesitive. If there are two users blah666 and BLAH666 usage for each of them will be calculated incorrectly as blah666’s usage + BLAH666 usage.
I’ve added binary collation to database queries in order to make them case sensitive and it looks like usage is calculated properly now.
You can find an updated script here.