thanks Saverio. I checked, and project_user_quotas is an empty set. I cannot find the project_id in the table nova.quotas too. I'm not sure where the quotas are stored than, is there anywhere else I should look for quotas stored in the DB for a tenant?
I'm not sure if the error message is a red herring and actually the problem is elsewhere. the problem is I cannot reproduce it from the CLI when I create a volume with 'cinder create ...' thx, will On Thu, Sep 8, 2016 at 6:43 PM, Saverio Proto <[email protected]> wrote: > Hey, > once I had a very weird problem with quotas. Usually the quota is per > tenant/project. But somehow you can limit the quota per specific user. > > Please can you check in your nova database if this table is empty: > > project_user_quotas > > mysql> describe project_user_quotas; > +------------+--------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +------------+--------------+------+-----+---------+----------------+ > | id | int(11) | NO | PRI | NULL | auto_increment | > | created_at | datetime | YES | | NULL | | > | updated_at | datetime | YES | | NULL | | > | deleted_at | datetime | YES | | NULL | | > | deleted | int(11) | YES | | NULL | | > | user_id | varchar(255) | NO | MUL | NULL | | > | project_id | varchar(255) | NO | MUL | NULL | | > | resource | varchar(255) | NO | | NULL | | > | hard_limit | int(11) | YES | | NULL | | > +------------+--------------+------+-----+---------+----------------+ > > This introduces quota specific for a single user regardless of the > quota of the project, as far as I understand. > > In our case we had no idea of this table. One of our operator managed > to make a CLI command that entered a specific quota limit for a > specific user. > > Maybe you are also in this corner case ? > > Saverio > > 2016-09-08 12:11 GMT+02:00 William Josefsson <[email protected]>: > > Hi Saverio, > > > > I've been debugging cinder api.log and there are no errors. I believe it > is > > a horizon (?) issue. All my components are Liberty. > > > > $ openstack quota show <project id> shows volumes = 8. > > > > If the user and project are created through the dashboard I do not seem > the > > problem. It seems like some database value are not correctly populated > > > > Also if I create tenant+cli through CLI, and then Edit project quotas in > the > > Dashboard, and click Save. Then it works. > > > > I create my project and tenant as: > > > > $ openstack project create --domain default --description "test project" > > test-project > > $ openstack user create --domain default --password-prompt test-user > > $ openstack role add --project test-project --user test-user user > > > > > > It's really strange, but it seems to be a bug in the GUI, or some DB > fields > > not getting properly populated when I create my project. > > > > please advice. thx will >
_______________________________________________ OpenStack-operators mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
