Open Stack

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