Open Stack

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 <zioproto at gmail.com> 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 <william.josefson at gmail.com>:
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20160908/5bc27a40/attachment.html>