Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
hi all, I have verified this and it seems to be a bug in horizon quota related. The bug exist in Liberty, when running from Horizon master pointing at the same deploy it works perfectly fine. thanks will On Thu, Sep 8, 2016 at 7:21 PM, William Josefsson wrote: > 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 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 : >> > 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 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 OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
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 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 : > > 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 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 OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
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 : > 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 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 OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
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 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 OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
apologies again. so you said with cli everything works. do you have both horizon and cinder and keystone in Liberty ? or mixed versions ? to debug this I would go in the logs of cinder api to see the requests that returns not enough quota. I would compare the logs with the CLI case where everything works. Saverio Il 08 set 2016 9:07 AM, "Saverio Proto" ha scritto: > Sorry you are on Liberty Centos !! > > Did you try openstack quota show ? > > What do you see ? > > Then try to create a Volume from the CLI. Usually you get better errore > mesaages. > > Saverio > > Il 08 set 2016 9:05 AM, "Saverio Proto" ha scritto: > >> please tell us at least the version of openstack :) >> >> Saverio >> >> Il 07 set 2016 4:31 PM, "William Josefsson" >> ha scritto: >> >>> Hi, >>> >>> When I create projects with quotas configured, e.g. number volumes 8, >>> and try to provision a VM, I get: >>> >>> *The requested instance cannot be launched. Requested volume exceeds >>> quota: Available: 0, Requested: 1.* >>> >>> Does anyone know how to fix this? The project clearly has 8 volumes >>> configured in the Quotas so I'm not sure why this pops up during 'Launch an >>> instance'. >>> >>> If I use the same user, from CLI, it works to create volumes. From >>> Horizon it fails. >>> >>> I'm using a user created with user role on the project and am on >>> Liberty/CentOS7 >>> >>> It seems to me it is a bug in horizon, but I may be wrong. If I click >>> all the way to the project's quota's and edit, then click Save without any >>> changes, then it somehow works. There seems to be ACL gap in the GUI/DB? >>> >>> Please advice! thx will >>> >>> ___ >>> OpenStack-operators mailing list >>> OpenStack-operators@lists.openstack.org >>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators >>> >>> ___ OpenStack-operators mailing list OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
Sorry you are on Liberty Centos !! Did you try openstack quota show ? What do you see ? Then try to create a Volume from the CLI. Usually you get better errore mesaages. Saverio Il 08 set 2016 9:05 AM, "Saverio Proto" ha scritto: > please tell us at least the version of openstack :) > > Saverio > > Il 07 set 2016 4:31 PM, "William Josefsson" > ha scritto: > >> Hi, >> >> When I create projects with quotas configured, e.g. number volumes 8, and >> try to provision a VM, I get: >> >> *The requested instance cannot be launched. Requested volume exceeds >> quota: Available: 0, Requested: 1.* >> >> Does anyone know how to fix this? The project clearly has 8 volumes >> configured in the Quotas so I'm not sure why this pops up during 'Launch an >> instance'. >> >> If I use the same user, from CLI, it works to create volumes. From >> Horizon it fails. >> >> I'm using a user created with user role on the project and am on >> Liberty/CentOS7 >> >> It seems to me it is a bug in horizon, but I may be wrong. If I click all >> the way to the project's quota's and edit, then click Save without any >> changes, then it somehow works. There seems to be ACL gap in the GUI/DB? >> >> Please advice! thx will >> >> ___ >> OpenStack-operators mailing list >> OpenStack-operators@lists.openstack.org >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators >> >> ___ OpenStack-operators mailing list OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
Re: [Openstack-operators] User gets: Requested volume exceeds quota, with 8 volumes in Dashboard
please tell us at least the version of openstack :) Saverio Il 07 set 2016 4:31 PM, "William Josefsson" ha scritto: > Hi, > > When I create projects with quotas configured, e.g. number volumes 8, and > try to provision a VM, I get: > > *The requested instance cannot be launched. Requested volume exceeds > quota: Available: 0, Requested: 1.* > > Does anyone know how to fix this? The project clearly has 8 volumes > configured in the Quotas so I'm not sure why this pops up during 'Launch an > instance'. > > If I use the same user, from CLI, it works to create volumes. From Horizon > it fails. > > I'm using a user created with user role on the project and am on > Liberty/CentOS7 > > It seems to me it is a bug in horizon, but I may be wrong. If I click all > the way to the project's quota's and edit, then click Save without any > changes, then it somehow works. There seems to be ACL gap in the GUI/DB? > > Please advice! thx will > > ___ > OpenStack-operators mailing list > OpenStack-operators@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators > > ___ OpenStack-operators mailing list OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators